This happened about 2 years ago. I thought osm2pgsql had been patched to ignore relations with that many members. I'm not sure which version it's in (osm2pgsql changelog implies no releases in almost 10 years 😉).

https://github.com/openstreetmap/osm2pgsql/issues/713
https://github.com/openstreetmap/osm2pgsql/pull/716

https://blog.geofabrik.de/?p=403

On 11/02/2019 11:41, wambac...@posteo.de wrote:
Hi,

there is a relation https://openstreetmap.org/relation/2632934, which currently has *42698 members*. Processing this rel with osm2pgsql fails, because this value is bigger than 32737 (small int).

Reading in file: /osm/db/planet3/diffs/2019/02/11/2019-02-11T10:33:01.osc
Using XML parser.
node cache: stored: 1591(100.00%), storage efficiency: 17.37% (dense blocks: 1, sparse nodes: 484), hit rate: 28.31% Osm2pgsql failed due to ERROR: insert_rel failed: FEHLER:  Wert »42698« ist außerhalb des gültigen Bereichs für Typ smallint
(7)
Arguments were: 2632934, 4616, 42698, {6116226169,......

Is this a general or an osmosis problem? I'm running still osmosis 0.45.

OSC: https://planet.openstreetmap.org/replication/minute/003/362/071.osc.gz

State:

#Mon Feb 11 09:32:04 UTC 2019
sequenceNumber=3362071
txnMaxQueried=1978118272
txnActiveList=1978118258
txnReadyList=
txnMax=1978118272
timestamp=2019-02-11T09\:32\:02Z

Regards
walter



--
My projects:

Admin Boundaries of the World <https://wambachers-osm.website/boundaries>
Missing Boundaries <https://wambachers-osm.website/index.php/projekte/internationale-administrative-grenzen/missing-boundaries>
Emergency Map <https://wambachers-osm.website/emergency>
Postal Code Map (Germany only) <https://wambachers-osm.website/plz>
Fools (QA for zipcodes in Germany) <https://wambachers-osm.website/fools>
Postcode Boundaries of Germany <https://wambachers-osm.website/pcoundaries>

_______________________________________________
talk mailing list
talk@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk



_______________________________________________
talk mailing list
talk@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk

Reply via email to