NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

Below is the stalled process

$ osm2pgsql -a --slim -e10-15 -d gis --flat-nodes /var/data/flat_nodes.bin --cache 2000 --number-processes 8 -G --hstore --tag-transform-script /home/postgresql/osm/openstreetmap-carto/openstreetmap-carto.lua --style /home/postgresql/osm/openstreetmap-carto/openstreetmap-carto.style --multi-geometry -o /var/lib/mod_tile/dirty_tiles.19005 /var/lib/mod_tile/changes.osc.gz

$ /usr/local/bin/osm2pgsql --version
osm2pgsql version 0.96.0 (64 bit id space)
Compiled using the following library versions:
Libosmium 2.14.2
Lua 5.2.4

============================================================================

osm2pgsql stalled at below line since two days. Please help.

$ tail osm2pgsql.log
Large polygon (97346 x 61883 metres, OSM ID -956714) - only expiring perimeter
Large polygon (97346 x 61883 metres, OSM ID -956714) - only expiring perimeter
Large polygon (52394 x 48081 metres, OSM ID -961523) - only expiring perimeter
Large polygon (52394 x 48081 metres, OSM ID -961523) - only expiring perimeter
Large polygon (50878 x 50663 metres, OSM ID -968952) - only expiring perimeter
Large polygon (50878 x 50663 metres, OSM ID -968952) - only expiring perimeter
Large polygon (118902 x 77508 metres, OSM ID -971999) - only expiring perimeter
Large polygon (24708 x 28965 metres, OSM ID -971999) - only expiring perimeter
Large polygon (81901 x 54346 metres, OSM ID -971999) - only expiring perimeter
Large polygon (99888 x 62677 metres, OSM ID -971999) - only expiring perimeter

asked 22 Jun '20, 14:13

augustusj's gravatar image

augustusj
46679
accept rate: 0%

edited 24 Jun '20, 06:24

What were you using it to do? It looks like it's expiring tiles, but much more information is needed before anyone can take a guess about what the problem might be.

(22 Jun '20, 14:20) SomeoneElse ♦

This is triggered through a crontab task which runs everyday and updates the Tile server. It has been running fine since many months but suddenly it stalled.

(22 Jun '20, 14:22) augustusj

Is it safe to upgrade osm2pgsql ? I had setup this server around 2 years back.

(22 Jun '20, 14:34) augustusj

Which command, with which options, was run via crontab? How much data were you trying to process? What tile zoom levels were you trying to expire?

To answer the other question, a later version of the same branch of osm2pgsql should be compatible with previous versions (apart from caveats around, say, old-style multipolygons). If you're consuming "normal" OSM data it shouldn't be a problem.

(22 Jun '20, 15:22) SomeoneElse ♦

Below is the stalled process:

$ osm2pgsql -a --slim -e10-15 -d gis --flat-nodes /var/data/flat_nodes.bin --cache 2000 --number-processes 8 -G --hstore --tag-transform-script /home/postgresql/osm/openstreetmap-carto/openstreetmap-carto.lua --style /home/postgresql/osm/openstreetmap-carto/openstreetmap-carto.style --multi-geometry -o /var/lib/mod_tile/dirty_tiles.19005 /var/lib/mod_tile/changes.osc.gz

More details:
maxInterval = 259200
baseUrl=https://planet.openstreetmap.org/replication/minute

(24 Jun '20, 06:36) augustusj

Likely a problem with osm2pgsql's handling of complex multipolygons. If you can, upgrade to osm2pgsql 1.2 and the latest osmium version for building it, that should solve the issue.

permanent link

answered 22 Jun '20, 14:20

Frederik%20Ramm's gravatar image

Frederik Ramm ♦
82.5k927201273
accept rate: 23%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×710
×263

question asked: 22 Jun '20, 14:13

question was seen: 1,045 times

last updated: 24 Jun '20, 06:37

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum