[Tile-serving] [openstreetmap/osm2pgsql] Import of changes fails due to invalid input syntax for integer: "covered" (#859)

[Ralf Wilke DH3WR]

Hello,
I completed the planet import to pgsql with planet file from 19.7.2018. Now I'm inserting the updates.
I get the error:
````
osm2pgsql version 0.96.0 (64 bit id space)

Using built-in tag processing pipeline
Using projection SRS 3857 (Spherical Mercator)
Setting up table: planet_osm_point
Setting up table: planet_osm_line
Setting up table: planet_osm_polygon
Setting up table: planet_osm_roads
Allocating memory for dense node cache
Allocating dense node cache in one big chunk
Allocating memory for sparse node cache
Sharing dense sparse
Node-cache: cache=4000MB, maxblocks=64000*65536, allocation method=11
Mid: pgsql, cache=4000
Setting up table: planet_osm_nodes
Setting up table: planet_osm_ways
Setting up table: planet_osm_rels

Reading in file: /var/lib/mod_tile/changes.osc.gz
Using XML parser.
node cache: stored: 1827(100.00%), storage efficiency: 19.65% (dense blocks: 1, sparse nodes: 554), hit rate: 11.62%
Osm2pgsql failed due to ERROR: result COPY_END for planet_osm_line failed: ERROR:  invalid input syntax for integer: "covered"
CONTEXT:  COPY planet_osm_line, line 1, column layer: "covered"
````

My state.txt contains:
````
compass at c2com:/var/lib/mod_tile/.osmosis$ cat state.txt
#Thu Aug 02 10:31:46 CEST 2018
sequenceNumber=3063391
timestamp=2018-07-18T08\:50\:02Z
````

I reduced the ``maxInterval = `` to 1 in the ``configuration.txt`` to determine the exact sequenceNumber that causes the error.
The changes.osc.gz contains only one occurrence of keyword ``covered``
````
    <way id="362659385" version="4" timestamp="2018-07-18T08:50:09Z" uid="50624" user="David Crochet" changeset="60827219">
      <nd ref="3669232046"/>
      <nd ref="3669232050"/>
      <tag k="layer" v="covered"/>
      <tag k="oneway" v="yes"/>
      <tag k="service" v="parking_aisle"/>
    </way>
````

Should I just delete this ``<way`` section?


-- 
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/859
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20180802/37cd23d9/attachment.html>