search

gregrs-uk / fhodot

Food hygiene open data OpenStreetMap tool
https://gregrs.dev.openstreetmap.org/fhodot/
GNU General Public License v3.0
9 stars 3 forks source link

OSM data not updating #28

Closed gregrs-uk closed 1 week ago

gregrs-uk commented 2 weeks ago

Need to look into errors with import

yesterday

[2024-09-22T04:08:48Z] 0:04:31 [step] Finished: Imposm in 4m30.957672025s
psql:/home/gregrs/fhodot/import/osm/post_import.sql:44: ERROR:  value "13012821017433" is out of range for type integer

and today

[2024-09-23T04:06:25Z] 0:02:24 [step] Starting: Writing OSM data
[2024-09-23T04:06:25Z] 0:02:24 SQL Error: pq: cannot drop table import.osm because other objects depend on it in query SELECT DropGeometryTable('import', 'osm');
gregrs-uk commented 1 week ago

First error caused by a very long fhrs:id incorrectly entered by an OSM editor who messaged me.

gregrs-uk commented 1 week ago

Manually dropped import.* tables to fix second error. Data should now be updating normally.