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

I ran an import of the full planet file in slim mode. It seems to have successfully imported the data, but then it crashed when going over pending ways. The log before the crash looks like this:

Node stats: total(3545099707), max(4418326239) in 4387s
Way stats: total(369751285), max(444345685) in 192701s
Relation stats: total(4509999), max(6610383) in 264005s
Committing transaction for planet_osm_point
Committing transaction for planet_osm_line
Committing transaction for planet_osm_polygon
Committing transaction for planet_osm_roads

Going over pending ways...
Maximum node in persistent node cache: 4418699263

Is it possible to resume the import for the remaining steps?

asked 24 Oct '16, 09:48

johnNM's gravatar image

johnNM
11112
accept rate: 0%

edited 24 Oct '16, 09:49

What platform and version?

https://www.google.co.uk/search?q="Maximum+node+in+persistent+node+cache"

suggests that you might be using an old non-64-bit-aware version, and you may need to upgrade.

(24 Oct '16, 09:57) SomeoneElse ♦

Thank you @SomeoneElse. Apologies for not including additional info. My specs are as follows:

Ubuntu 14.04 LTS 700GB disk 30GB RAM

I used the following command:

sudo -u offlineuser osm2pgsql --create-d gis --slim --flat-nodes ~/osm/flat_nodes.bin -C 14000 --number-processes 4 --style ~/osm/openstreetmap-carto/openstreetmap-carto.style --multi-geometry /home/offlineserver/planet-latest.osm.pbf

(24 Oct '16, 10:24) johnNM

What does "osm2pgsql -h -v | grep -i version" say?

(24 Oct '16, 10:44) SomeoneElse ♦

osm2pgsql SVN version 0.85.0 (64bit id space)

(24 Oct '16, 11:36) johnNM

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:

×196
×167
×56

question asked: 24 Oct '16, 09:48

question was seen: 1,918 times

last updated: 24 Oct '16, 11:36

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