This is a static archive of our old OpenStreetMap Help Site. Please post any new questions and answers at community.osm.org.

osm2pgsql’s import with Nominatim is terminated unexpectedly.

0

Hi guys! I try to upload a large pbf file(Netherland) from Geofabrik into Nominatim db (with small area import works fine). What I'm doing:

1)Start this script: ./utils/setup.php --osm-file maps/netherlands-latest.osm.pbf --all --osm2pgsql-cache 6000 2>&1 | tee /opt/Nominatim/setup.log

2) I'm waiting until proceess terminates unexpectedly. here pg_log file: http://pastebin.com/auzWXxbP Also I get errors in setup.log

CREATE INDEX planet_osm_ways_nodes ON planet_osm_ways USING gin (nodes) WITH (FASTUPDATE=OFF); failed: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.

Error occurred, cleaning up ERROR: Error executing external command: /opt/Nominatim/osm2pgsql/osm2pgsql -lsc -O gazetteer --hstore -C 6000 -P 5432 -d nominatim /opt/Nominatim/maps/netherlands-latest.osm.pbf Error executing external command: /opt/Nominatim/osm2pgsql/osm2pgsql -lsc -O gazetteer --hstore -C 6000 -P 5432 -d nominatim /opt/Nominatim/maps/netherlands-latest.osm.pbf ~

What am I doing wrong? is that hardware issue (mem 8Gb) or something else? Any ideas will be appreciated.

Update: pg_log: http://pastebin.com/CGSAchit it is crashed on "Failed process was running: CREATE INDEX planet_osm_ways_nodes ON planet_osm_ways USING gin (nodes) WITH (FASTUPDATE=OFF);" and I don't know what's going wrong with it.

asked 17 Jul '15, 10:34

Silentium's gravatar image

Silentium
9224
accept rate: 0%

edited 17 Jul '15, 13:03

Source code available on GitHub .