`logs/launchd-weekly.out`

57 lines
──────────────────────────────────────────────────────────────────
[weekly] starting at 2026-05-04T04:02:47-07:00
──────────────────────────────────────────────────────────────────
[weekly] pre-pull: 38292 facilities
[ingest] downloading https://www.arcgis.com/sharing/rest/content/items/4f31c9a99e444a40a3806e3bbe7b5fdd/data
[ingest] downloaded 9.4 MB → /Users/stevestudio2/Projects/restaurant-directory/data/la-eh-inventory.csv
[ingest] parsed 41,307 rows
[ingest] DONE — inserted=0 updated=0 unchanged=41307 failed=0
[inspections] downloading https://www.arcgis.com/sharing/rest/content/items/19b6607ac82c4512b10811870975dbdc/data
[inspections] downloaded 23.6 MB
[inspections] parsed 103,474 rows
[inspections] 38,292 known facilities
[inspections] DONE — inserted=0 updated=92846 orphaned=10628 failed=0
[weekly] post-pull: 38292 facilities · 38292 NEW this week · 0 UPDATED
[weekly] syncing to Kamatera…
NOTICE:  truncate cascades to table "inspection"
NOTICE:  truncate cascades to table "facility_enrichment"
NOTICE:  truncate cascades to table "facility_mockup"
NOTICE:  truncate cascades to table "facility_claim"
NOTICE:  truncate cascades to table "violation"
 set_config 
------------
 
(1 row)

ERROR:  duplicate key value violates unique constraint "ingest_run_pkey"
DETAIL:  Key (id)=(fafc9aba-8c93-4a46-8043-85403eee4186) already exists.
CONTEXT:  COPY ingest_run, line 1
[weekly] backgrounding cuisine enrichment for new facilities…
[weekly] email sent to steveabramsdesigns@gmail.com
[weekly] DONE at 2026-05-04T04:03:21-07:00
──────────────────────────────────────────────────────────────────
[weekly] starting at 2026-05-11T04:00:06-07:00
──────────────────────────────────────────────────────────────────
[weekly] pre-pull: 38292 facilities
[ingest] downloading https://www.arcgis.com/sharing/rest/content/items/4f31c9a99e444a40a3806e3bbe7b5fdd/data
[ingest] downloaded 9.4 MB → /Users/stevestudio2/Projects/restaurant-directory/data/la-eh-inventory.csv
[ingest] parsed 41,307 rows
[ingest] DONE — inserted=0 updated=0 unchanged=41307 failed=0
[weekly] post-pull: 38292 facilities · 0 NEW this week · 1512 UPDATED
[weekly] syncing to Kamatera…
NOTICE:  truncate cascades to table "inspection"
NOTICE:  truncate cascades to table "facility_enrichment"
NOTICE:  truncate cascades to table "facility_mockup"
NOTICE:  truncate cascades to table "facility_claim"
NOTICE:  truncate cascades to table "violation"
 set_config 
------------
 
(1 row)

ERROR:  duplicate key value violates unique constraint "ingest_run_pkey"
DETAIL:  Key (id)=(fafc9aba-8c93-4a46-8043-85403eee4186) already exists.
CONTEXT:  COPY ingest_run, line 1
[weekly] email FAILED
[weekly] DONE at 2026-05-11T04:04:03-07:00