<p>Hello,<br>
I completed the planet import to pgsql with planet file from 19.7.2018. Now I'm inserting the updates.<br>
I get the error:</p>
<pre><code>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"
</code></pre>
<p>My state.txt contains:</p>
<pre><code>compass@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
</code></pre>
<p>I reduced the <code>maxInterval =</code> to 1 in the <code>configuration.txt</code> to determine the exact sequenceNumber that causes the error.<br>
The changes.osc.gz contains only one occurrence of keyword <code>covered</code></p>
<pre><code> <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>
</code></pre>
<p>Should I just delete this <code><way</code> section?</p>
<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/openstreetmap/osm2pgsql/issues/859">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AD2-7qvqIIf_FkhNWsF9cSBEjcVVgTFxks5uMspPgaJpZM4Vr95X">mute the thread</a>.<img src="https://github.com/notifications/beacon/AD2-7tJKHlnoA5RCtYz1tKrIRCrKx3IYks5uMspPgaJpZM4Vr95X.gif" height="1" width="1" alt="" /></p>
<script type="application/json" data-scope="inboxmarkup">{"api_version":"1.0","publisher":{"api_key":"05dde50f1d1a384dd78767c55493e4bb","name":"GitHub"},"entity":{"external_key":"github/openstreetmap/osm2pgsql","title":"openstreetmap/osm2pgsql","subtitle":"GitHub repository","main_image_url":"https://assets-cdn.github.com/images/email/message_cards/header.png","avatar_image_url":"https://assets-cdn.github.com/images/email/message_cards/avatar.png","action":{"name":"Open in GitHub","url":"https://github.com/openstreetmap/osm2pgsql"}},"updates":{"snippets":[{"icon":"DESCRIPTION","message":"Import of changes fails due to invalid input syntax for integer: \"covered\" (#859)"}],"action":{"name":"View Issue","url":"https://github.com/openstreetmap/osm2pgsql/issues/859"}}}</script>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/openstreetmap/osm2pgsql/issues/859",
"url": "https://github.com/openstreetmap/osm2pgsql/issues/859",
"name": "View Issue"
},
"description": "View this Issue on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
},
{
"@type": "MessageCard",
"@context": "http://schema.org/extensions",
"hideOriginalBody": "false",
"originator": "AF6C5A86-E920-430C-9C59-A73278B5EFEB",
"title": "Import of changes fails due to invalid input syntax for integer: \"covered\" (#859)",
"sections": [
{
"text": "",
"activityTitle": "**Ralf Wilke DH3WR**",
"activityImage": "https://assets-cdn.github.com/images/email/message_cards/avatar.png",
"activitySubtitle": "@dh3wr",
"facts": [
{
"name": "Repository: ",
"value": "openstreetmap/osm2pgsql"
},
{
"name": "Issue #: ",
"value": 859
}
]
}
],
"potentialAction": [
{
"name": "Add a comment",
"@type": "ActionCard",
"inputs": [
{
"isMultiLine": true,
"@type": "TextInput",
"id": "IssueComment",
"isRequired": false
}
],
"actions": [
{
"name": "Comment",
"@type": "HttpPOST",
"target": "https://api.github.com",
"body": "{\n\"commandName\": \"IssueComment\",\n\"repositoryFullName\": \"openstreetmap/osm2pgsql\",\n\"issueId\": 859,\n\"IssueComment\": \"{{IssueComment.value}}\"\n}"
}
]
},
{
"name": "Close issue",
"@type": "HttpPOST",
"target": "https://api.github.com",
"body": "{\n\"commandName\": \"IssueClose\",\n\"repositoryFullName\": \"openstreetmap/osm2pgsql\",\n\"issueId\": 859\n}"
},
{
"targets": [
{
"os": "default",
"uri": "https://github.com/openstreetmap/osm2pgsql/issues/859"
}
],
"@type": "OpenUri",
"name": "View on GitHub"
},
{
"name": "Unsubscribe",
"@type": "HttpPOST",
"target": "https://api.github.com",
"body": "{\n\"commandName\": \"MuteNotification\",\n\"threadId\": 363847255\n}"
}
],
"themeColor": "26292E"
}
]</script>