[Tile-serving] [openstreetmap/osm2pgsql] '-' potentially parsed wrongly as an int type (#988)

[Sarah Hoffmann]

This was reported via the dev mailinglist:


> 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

Needs confirmation via an additional test in `tests/test-output-pgsql-int4.cpp` and potential fixing.

-- 
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/988
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20191120/0fbbf5b6/attachment.html>