Closed CartONG-staff closed 2 years ago
I did a new test today with the OSM exports of the day and therefore different diff files and I have a similar error, the problem does not come from an error in a diff file.
Hi @CartONG-staff, could you share your config file to help debug it ?
Hi @francois2metz , I found the origin of the error, in fact the error was in the trigger function (the NEW variable was used instead of OLD, which resulted in a null insert in my update monitoring table) which blocked the update transaction. Once the trigger is corrected, the update is done correctly.
Context
I created a postgis database from several .pbf files filtered by a geographic area
./imposm import -config /home/debian/imposm/imposm_files/config.json -read /home/debian/imposm/osm_original_files/moldova-latest.osm.pbf -write -limitto /home/debian/imposm/hcr_files/perimeter.geojson -diff -optimize
./imposm import -appendcache -config /home/debian/imposm/imposm_files/config.json -read /home/debian/imposm/osm_original_files/turkey-latest.osm.pbf -write -limitto /home/debian/imposm/hcr_files/perimeter.geojson -diff -optimize
./imposm import -appendcache -config /home/debian/imposm/imposm_files/config.json -read /home/debian/imposm/osm_original_files/papua-new-guinea-latest.osm.pbf -write -limitto /home/debian/imposm/hcr_files/perimeter.geojson -diff -optimize
./imposm import -appendcache -config /home/debian/imposm/imposm_files/config.json -read /home/debian/imposm/osm_original_files/africa-latest.osm.pbf -write -limitto /home/debian/imposm/hcr_files/perimeter.geojson -diff -optimize
./imposm import -appendcache -config /home/debian/imposm/imposm_files/config.json -read /home/debian/imposm/osm_original_files/asia-latest.osm.pbf -write -limitto /home/debian/imposm/hcr_files/perimeter.geojson -diff -optimize
./imposm import -config /home/debian/imposm/imposm_files/config.json -deployproduction
The database was created without errors, I added triggers on the tables to follow the updates and then I launched the run command as a service to launch the updates with these parameters on my config.json
/home/debian/imposm/imposm_exec/imposm run -config /home/debian/imposm/imposm_files/config.json -expiretiles-dir /home/debian/imposm/expiretiles/ -limitto /home/debian/imposm/perimeter.geojson
Expected Behavior
Recover diff files and perform updates
Actual Behavior
The diff files are retrieved and processed but I get an error message when importing into postgis and the operation restarts again and again.
Your Environment