[Geocoding] Nominatim update failure: insert_rel failed

[Sarah Hoffmann]

Hi,

for those of you running a Nominatim 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 necessary, you can recover your server as follows:

 * remove nominatim/data/osmosischange.osc
 * download http://planet.osm.org/replication/minute/002/354/889.state.txt
   and place it into nominatim/settings/state.txt
	 (nominatim/build/settings/state.txt for master)
 * set 'maxInterval' in settings/configuration.txt temporarily to 7200
 * restart updates

The other option is to edit nominatim/data/osmosischange.osc directly and
remove relation 7066589. You should be able to continue updates as usual
afterwards.

Kind regards

Sarah