[OSM-dev] osm2pgsql update failure: insert_rel failed

Sarah Hoffmann lonvia at denofr.de
Sun Mar 12 23:32:17 UTC 2017


Hi,

for those of you running an osm2pgsql-based rendering server
with minutely updates, this is just to let you know that there have been
some issues with a particularly ill-advised import a few hours ago.
The import (changeset 46795156) has created a relation with 37945 members.
When importing this relation with osm2pgsql, it will
cause an overflow and osm2pgsql will fail with the following message:

 Osm2pgsql failed due to ERROR: insert_rel failed: ERROR:  value "37945" is out of range for type smallint

We are aware of this issue and will fix the problem as soon as possible.
You can follow progress here: https://github.com/openstreetmap/osm2pgsql/issues/713

The changeset in question has been reverted by now.
If you run into the error above, you should be able to recover
your server by rewinding your state.txt to
http://planet.osm.org/replication/minute/002/354/889.state.txt
and making sure that osmosis downloads updates for at least two hours.
You can also edit the offending change file and remove relation 7066589. 

Kind regards

Sarah



More information about the dev mailing list