procurement_refresh_runs: 29
This data as json
| rowid | run_id | schedule_rule | scheduled_for_utc | started_utc | finished_utc | status | fence_verdict | fence_records_json | window_verdict | script_version | source_observed_utc | next_expected_utc | requests_made | rows_written_json | tables_touched | corpus_edition_start | corpus_edition_end | manifest_mtime | notes | error | is_dry_run | run_mode |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29 | 2026-11-21T02:29:53Z | weekly, Wednesday 10:40 America/St_Thomas | 2026-11-18T14:40:00Z | 2026-11-21T02:29:53Z | 2026-11-21T02:36:27Z | ok | clear for a run that makes no request: no chain heartbeat is running or hung, and no run artifact this job writes is another session's uncommitted work. GVIBuy is busy (pid 36576: powershell.exe -NoProfile -ExecutionPolicy Bypass -File "C:\Digital Investigation\tools\usvi-harvest\gvibuy_slow_bids.ps1") and would have blocked a fetching run | [{"name": "publish_run", "state": "done", "pid": 47256, "alive": null, "quiet_s": 55980, "note": "complete"}, {"name": "refresh_all", "state": "done", "pid": 16188, "alive": null, "quiet_s": 67595, "note": "complete"}, {"name": "build_index", "state": "done", "pid": 151476, "alive": null, "quiet_s": 68395, "note": "1 built, 5 current"}, {"name": "launch_publish", "state": "no heartbeat"}, {"name": "launch_index", "state": "no heartbeat"}, {"name": "runs-tree", "state": "clear", "paths": [], "note": "clear: this run writes no file into the git working tree (the harvest step, which does, is not in this run's step list)"}, {"name": "gvibuy-host", "state": "busy", "pid": "36576", "cmdline": "powershell.exe -NoProfile -ExecutionPolicy Bypass -File \"C:\\Digital Investigation\\tools\\usvi-harvest\\gvibuy_slow_bids.ps1\""}] | allowed: schedule clock 2026-11-20 22:29 AST / machine clock 2026-11-20 22:29 Atlantic Standard Time — every one outside 01:00-05:00 | procurement_weekly.py:ed20a38b334e procurement_weekly.ps1:a7d77d2e9d8a load_gvibuy.py:62dfff0653fc load_gvibuy_detail.py:55229032be6a load_gvibuy_bid_detail.py:61a2f3db4d56 build_procurement_vendors.py:aa0c21b932bb build_procurement_edges.py:bc8696ee0622 build_dpp_links.py:60939432eff0 sweep_identifier_mentions.py:7fd5963d97de build_coverage_cells.py:fd75c00c3a6e load_gvibuy_mirror.py:7c413298c27c | 2026-11-19T00:46:33+00:00 | 2026-11-25T14:40:00Z | {"dry_run": false, "made_network_request": false, "run_mode": "load-only", "steps": [{"rc": 0, "seconds": 0.6, "step": "load-gvibuy"}, {"rc": 0, "seconds": 0.5, "step": "load-detail"}, {"rc": 0, "seconds": 0.5, "step": "load-bid-detail"}, {"rc": 0, "seconds": 19.7, "step": "vendor-ladder"}, {"rc": 0, "seconds": 129.2, "step": "edges"}, {"rc": 0, "seconds": 1.2, "step": "dpp-links"}, {"rc": 0, "seconds": 91.8, "step": "mention-sweep"}, {"rc": 0, "seconds": 21.2, "step": "coverage-cells"}, {"rc": 0, "seconds": 129.1, "step": "load-mirror"}], "table_rows": {"gvibuy_attachments_staged": 8930, "gvibuy_bid_amendments": 394, "gvibuy_bid_detail": 144, "gvibuy_bid_items": 2898, "gvibuy_bid_po_ref": 314, "gvibuy_bid_required_attachments": 4, "gvibuy_bids": 2689, "gvibuy_blankets": 854, "gvibuy_changes": 10898, "gvibuy_list_census": 15, "gvibuy_mirror_pages": 17758, "gvibuy_observations": 11943, "gvibuy_po_header_detail": 4391, "gvibuy_po_items": 22957, "gvibuy_po_types": 15943, "gvibuy_purchase_orders": 4393, "gvibuy_status_histories": 7081, "gvibuy_status_history_steps": 40359, "gvibuy_vendor_addresses": 3806, "gvibuy_vendor_blankets": 371, "gvibuy_vendor_profiles": 3559, "gvibuy_vendors": 3559, "gvibuy_walks": 50, "procurement_coverage_cells": 83, "procurement_dpp_documents": 2418, "procurement_dpp_gvibuy": 45, "procurement_edges": 11228, "procurement_exclusions": 21, "procurement_identifier_mention_status": 7085, "procurement_identifier_mentions": 711, "procurement_identifier_unlisted": 178, "procurement_po_classification": 4393, "procurement_refresh_runs": 29, "procurement_vendor_payments": 928, "procurement_vendor_strings": 2337}} | gvibuy_vendors, gvibuy_purchase_orders, gvibuy_bids, gvibuy_blankets, gvibuy_po_types, gvibuy_bid_po_ref, gvibuy_po_header_detail, gvibuy_po_items, gvibuy_observations, gvibuy_changes, gvibuy_walks, gvibuy_list_census, gvibuy_bid_detail, gvibuy_bid_items, gvibuy_bid_amendments, gvibuy_bid_required_attachments, gvibuy_attachments_staged, procurement_po_classification, procurement_vendor_strings, procurement_vendor_payments, procurement_edges, procurement_coverage_cells, procurement_exclusions, procurement_dpp_gvibuy, procurement_dpp_documents, procurement_identifier_mentions, procurement_identifier_mention_status, procurement_identifier_unlisted, procurement_refresh_runs, gvibuy_mirror_pages, gvibuy_status_histories, gvibuy_status_history_steps, gvibuy_vendor_profiles, gvibuy_vendor_addresses, gvibuy_vendor_blankets | b8d319229cc6 | b8d319229cc6 | 2026-11-20T07:06:02Z | trigger=manual; run_mode=load-only; timezone: fixed offset -04:00 (no tzdata on this interpreter; the USVI observes no daylight saving); requests_made is NULL: the fetcher reports rows and pages, not requests, and this job does not estimate a number nobody measured; LOAD-ONLY: this run DID rebuild the derived procurement tables from the harvest CSVs already on disk (load_gvibuy --derived-only, then the vendor ladder, the edges, the DPP links, the mention sweep and the coverage cells), so it moved data in the warehouse and the surface may date its data from it. It did NOT make a single network request, did NOT read GVIBuy, and did NOT touch the four list tables or their fetched_at: source_observed_utc on this row (2026-11-19T00:46:33+00:00) is the instant the earlier harvest read GVIBuy and is not this run's clock. Run mode load-only exists because the GVIBuy fence allows one session on that host and the detail crawl held it; the fence was not weakened to get this run. | 0 | load-only |