[OSM-talk] This happened before | Re: Relation #2632934 is "killing" differential update

[Rory McCann]

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, wambacher at 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 at openstreetmap.org
> https://lists.openstreetmap.org/listinfo/talk
>