home / portal / procurement_refresh_runs

procurement_refresh_runs: 20

Every run of the weekly procurement refresh, including the runs that refused to start. Every 'last refreshed' and 'next expected' on the procurement pages is read from this table through vw_procurement_freshness.

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
20 2026-10-28T14:40:01Z weekly, Wednesday 10:40 America/St_Thomas 2026-10-28T14:40:00Z 2026-10-28T14:40:01Z 2026-10-28T14:56:00Z failed clear: no chain heartbeat is running or hung, nothing else on this machine is talking to GVIBuy, and no run artifact this job writes is another session's uncommitted work [{"name": "publish_run", "state": "failed", "pid": 15724, "alive": null, "quiet_s": 26377, "note": "failed at step 1: rebuild every index, page and sitemap"}, {"name": "refresh_all", "state": "failed", "pid": 3684, "alive": null, "quiet_s": 26377, "note": "failed at step 22: prerendered document pages"}, {"name": "build_index", "state": "done", "pid": 17900, "alive": null, "quiet_s": 26773, "note": "1 built, 5 current"}, {"name": "launch_publish", "state": "no heartbeat"}, {"name": "launch_index", "state": "no heartbeat"}, {"name": "runs-tree", "state": "clear", "paths": [{"path": "tools/usvi-harvest/runs/gvibuy-20261028-vendors.csv", "state": "absent"}, {"path": "tools/usvi-harvest/runs/gvibuy-20261028-purchase_orders.csv", "state": "absent"}, {"path": "tools/usvi-harvest/runs/gvibuy-20261028-bids.csv", "state": "absent"}, {"path": "tools/usvi-harvest/runs/gvibuy-20261028-blankets.csv", "state": "absent"}, {"path": "tools/usvi-harvest/runs/gvibuy-20261028-po_types.csv", "state": "absent"}], "note": "clear: of the 5 run artifacts this job rewrites, none is a tracked file carrying another session's changes"}] allowed: schedule clock 2026-10-28 10:40 AST / machine clock 2026-10-28 10:40 Atlantic Standard Time — every one outside 01:00-05:00 procurement_weekly.py:a09dcba9407e procurement_weekly.ps1:a7d77d2e9d8a fetch_gvibuy.py:08bff7b8932a load_gvibuy.py:bd90ece9fa7e build_procurement_vendors.py:b00402b47424 build_procurement_edges.py:a452a6e0cb15 build_dpp_links.py:60939432eff0 sweep_identifier_mentions.py:7fd5963d97de build_coverage_cells.py:19f36bda4b67 2026-10-28T14:55:56+00:00 2026-11-04T14:40:00Z   {"dry_run": false, "made_network_request": true, "run_mode": "full", "steps": [{"rc": 0, "seconds": 955.1, "step": "harvest-lists"}, {"rc": 0, "seconds": 0.9, "step": "load-gvibuy"}, {"rc": 1, "seconds": 2.8, "step": "vendor-ladder"}], "table_rows": {"gvibuy_attachments_staged": 3985, "gvibuy_bid_po_ref": 299, "gvibuy_bids": 2578, "gvibuy_blankets": 452, "gvibuy_po_header_detail": 1911, "gvibuy_po_items": 12342, "gvibuy_po_types": 11247, "gvibuy_purchase_orders": 4023, "gvibuy_vendors": 3495, "procurement_coverage_cells": 78, "procurement_dpp_documents": 2418, "procurement_dpp_gvibuy": 45, "procurement_edges": 5073, "procurement_exclusions": 21, "procurement_identifier_mention_status": 3395, "procurement_identifier_mentions": 625, "procurement_identifier_unlisted": 206, "procurement_po_classification": 4023, "procurement_refresh_runs": 20, "procurement_vendor_payments": 925, "procurement_vendor_strings": 2310}} gvibuy_vendors, gvibuy_purchase_orders, gvibuy_bids, gvibuy_blankets, gvibuy_po_types, gvibuy_bid_po_ref, gvibuy_po_header_detail, gvibuy_po_items, 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 a7e8061ae5de a7e8061ae5de 2026-10-28T07:04:49Z trigger=scheduled; run_mode=full; 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 step vendor-ladder exited 1 0 full
Powered by Datasette · Queries took 31.359ms