<html><head></head><body><div class="ydp9fe83ea4yahoo-style-wrap" style="font-family: verdana, helvetica, sans-serif; font-size: 13px;"><div><div dir="ltr" data-setdir="false">I corrected the layer from (-) to (-1). Such values should probably be spotted by the API and rejected as errors.<br></div><div><br></div><div class="ydp9fe83ea4signature"><span style="font-style:italic;color:rgb(0, 0, 191);font-weight:bold;"> <br><font style="background-color: inherit;" face="garamond, new york, times, serif">Pierre </font><br></span></div></div>
<div><br></div><div><br></div>
</div><div id="ydp2977b645yahoo_quoted_4160210658" class="ydp2977b645yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
Le vendredi 8 novembre 2019 11 h 11 min 03 s UTC−5, Bart Smienk <b@rtsmienk.nl> a écrit :
</div>
<div><br></div>
<div><br></div>
<div><div dir="ltr">Hi,<br></div><div dir="ltr"><br></div><div dir="ltr">I've found out my OSM Tile Server has stopped updating and osm2pgsql <br></div><div dir="ltr">(v1.2) gives off the following error:<br></div><div dir="ltr"><br></div><div dir="ltr">DB writer thread failed due to ERROR: result COPY_END for <br></div><div dir="ltr">planet_osm_line failed: ERROR: invalid input syntax for integer: "-"<br></div><div dir="ltr">CONTEXT: COPY planet_osm_line, line 1437, column layer: "-"<br></div><div dir="ltr"><br></div><div dir="ltr">Looking through its changefile, the following entry can be found:<br></div><div dir="ltr"><br></div><div dir="ltr"> <way id="742619958" version="1" timestamp="2019-11-06T15:32:03Z" <br></div><div dir="ltr">uid="978786" user="padvinder" changeset="76711047"><br></div><div dir="ltr"> <nd ref="6952022619"/><br></div><div dir="ltr"> <nd ref="6952022612"/><br></div><div dir="ltr"> <tag k="layer" v="-"/><br></div><div dir="ltr"> <tag k="tunnel" v="culvert"/><br></div><div dir="ltr"> <tag k="waterway" v="drain"/><br></div><div dir="ltr"> </way><br></div><div dir="ltr"><br></div><div dir="ltr">This seems to be malformed, as the layer should've never been "-", as <br></div><div dir="ltr">this is not a valid integer.<br></div><div dir="ltr">You can see this for yourself at: <br></div><div dir="ltr"><a href="https://planet.openstreetmap.org/replication/minute/003/747/729.osc.gz" rel="nofollow" target="_blank">https://planet.openstreetmap.org/replication/minute/003/747/729.osc.gz</a><br></div><div dir="ltr">Also more information on the layer key is over here: <br></div><div dir="ltr"><a href="https://wiki.openstreetmap.org/wiki/Key:layer" rel="nofollow" target="_blank">https://wiki.openstreetmap.org/wiki/Key:layer</a><br></div><div dir="ltr"><br></div><div dir="ltr">Not sure where to make the actual bug report, so I'm mailing the dev <br></div><div dir="ltr">mailgroup, does anyone of you know where this issue should be posted so <br></div><div dir="ltr">this issue won't present itself again in future replication files?<br></div><div dir="ltr"><br></div><div dir="ltr">Let me know.<br></div><div dir="ltr"><br></div><div dir="ltr">Kind regards,<br></div><div dir="ltr">Bart Smienk<br></div><div dir="ltr"><br></div><div dir="ltr">_______________________________________________<br></div><div dir="ltr">dev mailing list<br></div><div dir="ltr"><a href="mailto:dev@openstreetmap.org" rel="nofollow" target="_blank">dev@openstreetmap.org</a><br></div><div dir="ltr"><a href="https://lists.openstreetmap.org/listinfo/dev" rel="nofollow" target="_blank">https://lists.openstreetmap.org/listinfo/dev</a><br></div></div>
</div>
</div></body></html>