[Tile-serving] [openstreetmap/osm2pgsql] pgsql-mid fails on relations with more than 32767 members (#713)

Sarah Hoffmann notifications at github.com
Sun Mar 12 22:08:58 UTC 2017


pgsql-mid stores the member offset for relations in the planet_osm_rels table as smallints (way_off, rell_off columns). That means that the number of members it can safely handle is restricted to 32767. However, the limit is nowhere checked. Trying to import a larger relation leads to the error:

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

This happened recently with relation 7066589.

osm2pgsql should drop relations that are too large early in the processing. What would a reasonable upper limit be?

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/713
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20170312/4d796f81/attachment.html>


More information about the Tile-serving mailing list