home / portal / procurement_refresh_runs

procurement_refresh_runs: 2

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
2 2026-09-02T20:53:04Z weekly, Wednesday 10:40 America/St_Thomas 2026-09-02T14:40:00Z 2026-09-02T20:53:04Z 2026-09-02T20:53:04Z refused-fence refused: another process on this machine is already talking to GVIBuy (pid 8068: "C:\Users\Claude-server\AppData\Local\Programs\Python\Python314\python.exe" fetch_gvibuy_detail.py --type po --sleep 4.0) — the standing limit on that host is one session at a time [{"name": "publish_run", "state": "failed", "pid": 2924, "alive": null, "quiet_s": 48701, "note": "failed at step 4: push the per-document records"}, {"name": "refresh_all", "state": "done", "pid": 12972, "alive": null, "quiet_s": 48823, "note": "complete"}, {"name": "build_index", "state": "done", "pid": 6112, "alive": null, "quiet_s": 48855, "note": "1 built, 5 current"}, {"name": "launch_publish", "state": "no heartbeat"}, {"name": "launch_index", "state": "no heartbeat"}] allowed: real clock 2026-09-02 16:53 AST is outside 01:00-05:00 procurement_weekly.py:f88afd2eaa41 procurement_weekly.ps1:a7d77d2e9d8a fetch_gvibuy.py:08bff7b8932a load_gvibuy.py:bd90ece9fa7e build_procurement_vendors.py:d82d063491f8 build_procurement_edges.py:1f29d876448f build_dpp_links.py:6791d3ae4fd6 sweep_identifier_mentions.py:7fd5963d97de build_coverage_cells.py:0853959d3f15       {} gvibuy_vendors, gvibuy_purchase_orders, gvibuy_bids, gvibuy_blankets, gvibuy_po_types, gvibuy_bid_po_ref, gvibuy_po_header_detail, gvibuy_po_items, gvibuy_bid_detail, gvibuy_bid_quotes, 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     2026-09-02T07:03:00Z trigger=manual; refused: another process on this machine is already talking to GVIBuy (pid 8068: "C:\Users\Claude-server\AppData\Local\Programs\Python\Python314\python.exe" fetch_gvibuy_detail.py --type po --sleep 4.0) — the standing limit on that host is one session at a time      
Powered by Datasette · Queries took 1.63ms