[OSM-dev] Issue with way id 742619958 / changeset 76711047 from 2019-11-06T15:32:03Z (Invalid layer value)

[Maarten Deen]

On 2019-11-08 17:04, Bart Smienk wrote:
> Hi,
> 
> I've found out my OSM Tile Server has stopped updating and osm2pgsql
> (v1.2) gives off the following error:
> 
> DB writer thread failed due to ERROR: result COPY_END for
> planet_osm_line failed: ERROR:  invalid input syntax for integer: "-"
> CONTEXT:  COPY planet_osm_line, line 1437, column layer: "-"
> 
> Looking through its changefile, the following entry can be found:
> 
>     <way id="742619958" version="1" timestamp="2019-11-06T15:32:03Z"
> uid="978786" user="padvinder" changeset="76711047">
>       <nd ref="6952022619"/>
>       <nd ref="6952022612"/>
>       <tag k="layer" v="-"/>
>       <tag k="tunnel" v="culvert"/>
>       <tag k="waterway" v="drain"/>
>     </way>
> 
> This seems to be malformed, as the layer should've never been "-", as
> this is not a valid integer.
> You can see this for yourself at:
> https://planet.openstreetmap.org/replication/minute/003/747/729.osc.gz
> Also more information on the layer key is over here:
> https://wiki.openstreetmap.org/wiki/Key:layer
> 
> Not sure where to make the actual bug report, so I'm mailing the dev
> mailgroup, does anyone of you know where this issue should be posted
> so this issue won't present itself again in future replication files?

The changeset data gives Go Map!! as editor which can be found on 
GitHub: https://github.com/bryceco/GoMap

But as you can see on taginfo there are lots of non-integer values in 
OSM.
https://taginfo.openstreetmap.org/keys/?key=layer#values
So the tile server software should also do some checking and error 
handling if it requires an integer. I'm surprised that osm2pgsql 
apparently has a check on key/value pairs and sees this as an error.

Regards,
Maarten