[Tile-serving] [openstreetmap/osm2pgsql] osm2pgsql fails with large relations (Issue #1607)

Sarah Hoffmann notifications at github.com
Fri Jan 14 10:55:07 UTC 2022


Someone has recently created a relation with more than 200k members: https://www.openstreetmap.org/relation/13671879 (now deleted) This causes osm2pgsql to fail with the following message:

```ERROR: DB copy thread failed: Ending COPY mode for 'planet_osm_rels' failed: ERROR:  value "218678" is out of range for type smallint
CONTEXT:  COPY planet_osm_rels, line 121, column way_off: "218678"
```

osm2pgsql should reject all relations that have more than 10k (50k? 100k?) members and not try to process them.

If you run into this bug: make sure to download a diff range large enough that it includes the deletion of the relation that followed about 40min later.

-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/1607
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/osm2pgsql/issues/1607 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20220114/9210b8c9/attachment.htm>


More information about the Tile-serving mailing list