<p>I use the <code>/openstreetmap-tiles-update-expire</code> script and the failing command line is:<br>
<code>osm2pgsql -a --slim -e13-20 -d gis --number-processes 4 --cache 4000 -o /var/lib/mod_tile/dirty_tiles.19534 /var/lib/mod_tile/changes.osc.gz</code></p>
<p>.style file:<br>
I use the <code>default</code> map, so from the output of <code>locate .style</code> I think it's the <code>/usr/local/share/osm2pgsql/default.style</code>-File.</p>
<pre><code>/home/compass/src/openstreetmap-carto/openstreetmap-carto.style
/home/compass/src/osm2pgsql/default.style
/home/compass/src/osm2pgsql/empty.style
/home/compass/src/osm2pgsql/multi.style.json
/home/compass/src/osm2pgsql/tests/hstore-match-only.style
/home/compass/src/osm2pgsql/tests/test_output_multi_line_trivial.style.json
/home/compass/src/osm2pgsql/tests/test_output_multi_poly_trivial.style.json
/usr/local/share/osm2pgsql/default.style
/usr/local/share/osm2pgsql/empty.style
</code></pre>
<p><code>cat /usr/local/share/osm2pgsql/default.style</code>:</p>
<pre><code># OsmType  Tag          DataType     Flags
node,way   access       text         linear
node,way   addr:housename      text  linear
node,way   addr:housenumber    text  linear
node,way   addr:interpolation  text  linear
node,way   admin_level  text         linear
node,way   aerialway    text         linear
node,way   aeroway      text         polygon
node,way   amenity      text         polygon
node,way   area         text         polygon # hard coded support for area=1/yes => polygon is in osm2pgsql
node,way   barrier      text         linear
node,way   bicycle      text         linear
node,way   brand        text         linear
node,way   bridge       text         linear
node,way   boundary     text         linear
node,way   building     text         polygon
node       capital      text         linear
node,way   construction text         linear
node,way   covered      text         linear
node,way   culvert      text         linear
node,way   cutting      text         linear
node,way   denomination text         linear
node,way   disused      text         linear
node       ele          text         linear
node,way   embankment   text         linear
node,way   foot         text         linear
node,way   generator:source    text  linear
node,way   harbour      text         polygon
node,way   highway      text         linear
node,way   historic     text         polygon
node,way   horse        text         linear
node,way   intermittent text         linear
node,way   junction     text         linear
node,way   landuse      text         polygon
node,way   layer        text         linear
node,way   leisure      text         polygon
node,way   lock         text         linear
node,way   man_made     text         polygon
node,way   military     text         polygon
node,way   motorcar     text         linear
node,way   name         text         linear
node,way   natural      text         polygon  # natural=coastline tags are discarded by a hard coded rule in osm2pgsql
node,way   office       text         polygon
node,way   oneway       text         linear
node,way   operator     text         linear
node,way   place        text         polygon
node,way   population   text         linear
node,way   power        text         polygon
node,way   power_source text         linear
node,way   public_transport text     polygon
node,way   railway      text         linear
node,way   ref          text         linear
node,way   religion     text         linear
node,way   route        text         linear
node,way   service      text         linear
node,way   shop         text         polygon
node,way   sport        text         polygon
node,way   surface      text         linear
node,way   toll         text         linear
node,way   tourism      text         polygon
node,way   tower:type   text         linear
way        tracktype    text         linear
node,way   tunnel       text         linear
node,way   water        text         polygon
node,way   waterway     text         polygon
node,way   wetland      text         polygon
node,way   width        text         linear
node,way   wood         text         linear
node,way   z_order      int4         linear # This is calculated during import
way        way_area     real         linear # This is calculated during import

# Area tags
# We don't make columns for these tags, but objects with them are areas.
# Mainly for use with hstore
way         abandoned:aeroway       text    polygon,nocolumn
way         abandoned:amenity       text    polygon,nocolumn
way         abandoned:building      text    polygon,nocolumn
way         abandoned:landuse       text    polygon,nocolumn
way         abandoned:power         text    polygon,nocolumn
way         area:highway            text    polygon,nocolumn

# Deleted tags
# These are tags that are generally regarded as useless for most rendering.
# Most of them are from imports or intended as internal information for mappers
# Some of them are automatically deleted by editors.
# If you want some of them, perhaps for a debugging layer, just delete the lines.

# These tags are used by mappers to keep track of data.
# They aren't very useful for rendering.
node,way    note                    text    delete
node,way    note:*                  text    delete
node,way    source                  text    delete
node,way    source_ref              text    delete
node,way    source:*                text    delete
node,way    attribution             text    delete
node,way    comment                 text    delete
node,way    fixme                   text    delete

# Tags generally dropped by editors, not otherwise covered
node,way    created_by              text    delete
node,way    odbl                    text    delete
node,way    odbl:note               text    delete
node,way    SK53_bulk:load          text    delete

# Lots of import tags
# TIGER (US)
node,way    tiger:*                 text    delete

# NHD (US)
# NHD has been converted every way imaginable
node,way    NHD:*                   text    delete
node,way    nhd:*                   text    delete

# GNIS (US)
node,way    gnis:*                  text    delete

# Geobase (CA)
node,way    geobase:*               text    delete
# NHN (CA)
node,way    accuracy:meters         text    delete
node,way    sub_sea:type            text    delete
node,way    waterway:type           text    delete

# KSJ2 (JA)
# See also note:ja and source_ref above
node,way    KSJ2:*                  text    delete
# Yahoo/ALPS (JA)
node,way    yh:*                    text    delete

# osak (DK)
node,way    osak:*                  text    delete

# kms (DK)
node,way    kms:*                   text    delete

# ngbe (ES)
# See also note:es and source:file above
node,way    ngbe:*                  text    delete

# naptan (UK)
node,way    naptan:*                text    delete

# Corine (CLC) (Europe)
node,way    CLC:*                   text    delete

# misc
node,way    3dshapes:ggmodelk       text    delete
node,way    AND_nosr_r              text    delete
node,way    import                  text    delete
node,way    it:fvg:*                text    delete
</code></pre>

<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#issuecomment-409883929">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AD2-7v4L1DysFLsVB6jkVsDu93SwQ27Tks5uMta5gaJpZM4Vr95X">mute the thread</a>.<img src="https://github.com/notifications/beacon/AD2-7vpf6Tfw7QthObwCbgKCV9oHiKouks5uMta5gaJpZM4Vr95X.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":"PERSON","message":"@dh3wr in #859: I use the ``/openstreetmap-tiles-update-expire`` script and the failing command line is:\r\n`` osm2pgsql -a --slim -e13-20 -d gis --number-processes 4 --cache 4000 -o /var/lib/mod_tile/dirty_tiles.19534 /var/lib/mod_tile/changes.osc.gz``\r\n\r\n.style file: \r\nI use the ``default`` map, so from the output of ``locate .style`` I think it's the ``/usr/local/share/osm2pgsql/default.style``-File.\r\n````\r\n/home/compass/src/openstreetmap-carto/openstreetmap-carto.style\r\n/home/compass/src/osm2pgsql/default.style\r\n/home/compass/src/osm2pgsql/empty.style\r\n/home/compass/src/osm2pgsql/multi.style.json\r\n/home/compass/src/osm2pgsql/tests/hstore-match-only.style\r\n/home/compass/src/osm2pgsql/tests/test_output_multi_line_trivial.style.json\r\n/home/compass/src/osm2pgsql/tests/test_output_multi_poly_trivial.style.json\r\n/usr/local/share/osm2pgsql/default.style\r\n/usr/local/share/osm2pgsql/empty.style\r\n````\r\n``cat /usr/local/share/osm2pgsql/default.style``:\r\n````\r\n# OsmType  Tag          DataType     Flags\r\nnode,way   access       text         linear\r\nnode,way   addr:housename      text  linear\r\nnode,way   addr:housenumber    text  linear\r\nnode,way   addr:interpolation  text  linear\r\nnode,way   admin_level  text         linear\r\nnode,way   aerialway    text         linear\r\nnode,way   aeroway      text         polygon\r\nnode,way   amenity      text         polygon\r\nnode,way   area         text         polygon # hard coded support for area=1/yes =\u003e polygon is in osm2pgsql\r\nnode,way   barrier      text         linear\r\nnode,way   bicycle      text         linear\r\nnode,way   brand        text         linear\r\nnode,way   bridge       text         linear\r\nnode,way   boundary     text         linear\r\nnode,way   building     text         polygon\r\nnode       capital      text         linear\r\nnode,way   construction text         linear\r\nnode,way   covered      text         linear\r\nnode,way   culvert      text         linear\r\nnode,way   cutting      text         linear\r\nnode,way   denomination text         linear\r\nnode,way   disused      text         linear\r\nnode       ele          text         linear\r\nnode,way   embankment   text         linear\r\nnode,way   foot         text         linear\r\nnode,way   generator:source    text  linear\r\nnode,way   harbour      text         polygon\r\nnode,way   highway      text         linear\r\nnode,way   historic     text         polygon\r\nnode,way   horse        text         linear\r\nnode,way   intermittent text         linear\r\nnode,way   junction     text         linear\r\nnode,way   landuse      text         polygon\r\nnode,way   layer        text         linear\r\nnode,way   leisure      text         polygon\r\nnode,way   lock         text         linear\r\nnode,way   man_made     text         polygon\r\nnode,way   military     text         polygon\r\nnode,way   motorcar     text         linear\r\nnode,way   name         text         linear\r\nnode,way   natural      text         polygon  # natural=coastline tags are discarded by a hard coded rule in osm2pgsql\r\nnode,way   office       text         polygon\r\nnode,way   oneway       text         linear\r\nnode,way   operator     text         linear\r\nnode,way   place        text         polygon\r\nnode,way   population   text         linear\r\nnode,way   power        text         polygon\r\nnode,way   power_source text         linear\r\nnode,way   public_transport text     polygon\r\nnode,way   railway      text         linear\r\nnode,way   ref          text         linear\r\nnode,way   religion     text         linear\r\nnode,way   route        text         linear\r\nnode,way   service      text         linear\r\nnode,way   shop         text         polygon\r\nnode,way   sport        text         polygon\r\nnode,way   surface      text         linear\r\nnode,way   toll         text         linear\r\nnode,way   tourism      text         polygon\r\nnode,way   tower:type   text         linear\r\nway        tracktype    text         linear\r\nnode,way   tunnel       text         linear\r\nnode,way   water        text         polygon\r\nnode,way   waterway     text         polygon\r\nnode,way   wetland      text         polygon\r\nnode,way   width        text         linear\r\nnode,way   wood         text         linear\r\nnode,way   z_order      int4         linear # This is calculated during import\r\nway        way_area     real         linear # This is calculated during import\r\n\r\n# Area tags\r\n# We don't make columns for these tags, but objects with them are areas.\r\n# Mainly for use with hstore\r\nway         abandoned:aeroway       text    polygon,nocolumn\r\nway         abandoned:amenity       text    polygon,nocolumn\r\nway         abandoned:building      text    polygon,nocolumn\r\nway         abandoned:landuse       text    polygon,nocolumn\r\nway         abandoned:power         text    polygon,nocolumn\r\nway         area:highway            text    polygon,nocolumn\r\n\r\n# Deleted tags\r\n# These are tags that are generally regarded as useless for most rendering.\r\n# Most of them are from imports or intended as internal information for mappers\r\n# Some of them are automatically deleted by editors.\r\n# If you want some of them, perhaps for a debugging layer, just delete the lines.\r\n\r\n# These tags are used by mappers to keep track of data.\r\n# They aren't very useful for rendering.\r\nnode,way    note                    text    delete\r\nnode,way    note:*                  text    delete\r\nnode,way    source                  text    delete\r\nnode,way    source_ref              text    delete\r\nnode,way    source:*                text    delete\r\nnode,way    attribution             text    delete\r\nnode,way    comment                 text    delete\r\nnode,way    fixme                   text    delete\r\n\r\n# Tags generally dropped by editors, not otherwise covered\r\nnode,way    created_by              text    delete\r\nnode,way    odbl                    text    delete\r\nnode,way    odbl:note               text    delete\r\nnode,way    SK53_bulk:load          text    delete\r\n\r\n# Lots of import tags\r\n# TIGER (US)\r\nnode,way    tiger:*                 text    delete\r\n\r\n# NHD (US)\r\n# NHD has been converted every way imaginable\r\nnode,way    NHD:*                   text    delete\r\nnode,way    nhd:*                   text    delete\r\n\r\n# GNIS (US)\r\nnode,way    gnis:*                  text    delete\r\n\r\n# Geobase (CA)\r\nnode,way    geobase:*               text    delete\r\n# NHN (CA)\r\nnode,way    accuracy:meters         text    delete\r\nnode,way    sub_sea:type            text    delete\r\nnode,way    waterway:type           text    delete\r\n\r\n# KSJ2 (JA)\r\n# See also note:ja and source_ref above\r\nnode,way    KSJ2:*                  text    delete\r\n# Yahoo/ALPS (JA)\r\nnode,way    yh:*                    text    delete\r\n\r\n# osak (DK)\r\nnode,way    osak:*                  text    delete\r\n\r\n# kms (DK)\r\nnode,way    kms:*                   text    delete\r\n\r\n# ngbe (ES)\r\n# See also note:es and source:file above\r\nnode,way    ngbe:*                  text    delete\r\n\r\n# naptan (UK)\r\nnode,way    naptan:*                text    delete\r\n\r\n# Corine (CLC) (Europe)\r\nnode,way    CLC:*                   text    delete\r\n\r\n# misc\r\nnode,way    3dshapes:ggmodelk       text    delete\r\nnode,way    AND_nosr_r              text    delete\r\nnode,way    import                  text    delete\r\nnode,way    it:fvg:*                text    delete\r\n````\r\n"}],"action":{"name":"View Issue","url":"https://github.com/openstreetmap/osm2pgsql/issues/859#issuecomment-409883929"}}}</script>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/openstreetmap/osm2pgsql/issues/859#issuecomment-409883929",
"url": "https://github.com/openstreetmap/osm2pgsql/issues/859#issuecomment-409883929",
"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": "Re: [openstreetmap/osm2pgsql] 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": [

]
}
],
"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#issuecomment-409883929"
}
],
"@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>