search

osm2pgsql-dev / osm2pgsql

OpenStreetMap data to PostgreSQL converter
https://osm2pgsql.org
GNU General Public License v2.0
1.51k stars 474 forks source link

osm2pgsql Segmentation fault #294

Closed EraSiuS closed 9 years ago

EraSiuS commented 9 years ago

Hi,

I'm trying since some days to add openstreetmap in psql. And there no way, always "segmentation fault" I try many solution for this problem, and nothing still works for me.

I'm trying to import a little file osm directly from OSM website by "exporting bound map". The file is 400Ko. I tryied with other osm source and always same error.

root /home/postgres # osm2pgsql -V osm2pgsql SVN version 0.80.0 (64bit id space)

osm2pgsql error :

root /home/postgres # osm2pgsql --slim -U postgres -W --cache 128 --create --database osm3 /home/admin/map_bound.osm osm2pgsql SVN version 0.80.0 (64bit id space)

Password: Using projection SRS 900913 (Spherical Mercator) Setting up table: planet_osm_point NOTICE: table "planet_osm_point" does not exist, skipping NOTICE: table "planet_osm_point_tmp" does not exist, skipping Setting up table: planet_osm_line NOTICE: table "planet_osm_line" does not exist, skipping NOTICE: table "planet_osm_line_tmp" does not exist, skipping Setting up table: planet_osm_polygon NOTICE: table "planet_osm_polygon" does not exist, skipping NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping Setting up table: planet_osm_roads NOTICE: table "planet_osm_roads" does not exist, skipping NOTICE: table "planet_osm_roads_tmp" does not exist, skipping 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=128MB, maxblocks=16385*8192, allocation method=11 Mid: pgsql, scale=100 cache=128 Setting up table: planet_osm_nodes NOTICE: table "planet_osm_nodes" does not exist, skipping NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_nodes_pkey" for table "planet_osm_nodes" Setting up table: planet_osm_ways NOTICE: table "planet_osm_ways" does not exist, skipping NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_ways_pkey" for table "planet_osm_ways" Setting up table: planet_osm_rels NOTICE: table "planet_osm_rels" does not exist, skipping NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_rels_pkey" for table "planet_osm_rels"

Reading in file: /home/admin/map_bound.osm Segmentation fault

psql log :

2015-02-19 23:01:07 UTC ERROR: unexpected message type 0x58 during COPY from stdin 2015-02-19 23:01:07 UTC CONTEXT: COPY planet_osm_point, line 1 2015-02-19 23:01:07 UTC STATEMENT: COPY planet_osm_point (osm_id,"access","addr:housename","addr:housenumber","addr:interpolation","admin_level","aerialway","aeroway","amenity","area","barrier","bicycle","brand","bridge","boundary","building","capital","construction","covered","culvert","cutting","denomination","disused","ele","embankment","foot","generator:source","harbour","highway","historic","horse","intermittent","junction","landuse","layer","leisure","lock","man_made","military","motorcar","name","natural","oneway","operator","poi","population","power","power_source","place","railway","ref","religion","route","service","shop","sport","surface","toll","tourism","tower:type","tunnel","water","waterway","wetland","width","wood","z_order",way) FROM STDIN 2015-02-19 23:01:07 UTC LOG: could not send data to client: Broken pipe 2015-02-19 23:01:07 UTC STATEMENT: COPY planet_osm_point (osm_id,"access","addr:housename","addr:housenumber","addr:interpolation","admin_level","aerialway","aeroway","amenity","area","barrier","bicycle","brand","bridge","boundary","building","capital","construction","covered","culvert","cutting","denomination","disused","ele","embankment","foot","generator:source","harbour","highway","historic","horse","intermittent","junction","landuse","layer","leisure","lock","man_made","military","motorcar","name","natural","oneway","operator","poi","population","power","power_source","place","railway","ref","religion","route","service","shop","sport","surface","toll","tourism","tower:type","tunnel","water","waterway","wetland","width","wood","z_order",way) FROM STDIN 2015-02-19 23:01:07 UTC LOG: unexpected EOF on client connection 2015-02-19 23:01:07 UTC ERROR: unexpected message type 0x58 during COPY from stdin 2015-02-19 23:01:07 UTC CONTEXT: COPY planet_osm_line, line 1 2015-02-19 23:01:07 UTC STATEMENT: COPY planet_osm_line (osm_id,"access","addr:housename","addr:housenumber","addr:interpolation","admin_level","aerialway","aeroway","amenity","area","barrier","bicycle","brand","bridge","boundary","building","construction","covered","culvert","cutting","denomination","disused","embankment","foot","generator:source","harbour","highway","historic","horse","intermittent","junction","landuse","layer","leisure","lock","man_made","military","motorcar","name","natural","oneway","operator","population","power","power_source","place","railway","ref","religion","route","service","shop","sport","surface","toll","tourism","tower:type","tracktype","tunnel","water","waterway","wetland","width","wood","z_order","way_area",way) FROM STDIN

..... (cuting file, too much long)

2015-02-19 23:01:49 UTC LOG: could not send data to client: Broken pipe 2015-02-19 23:01:49 UTC STATEMENT: COPY planet_osm_roads (osm_id,"access","addr:housename","addr:housenumber","addr:interpolation","admin_level","aerialway","aeroway","amenity","area","barrier","bicycle","brand","bridge","boundary","building","construction","covered","culvert","cutting","denomination","disused","embankment","foot","generator:source","harbour","highway","historic","horse","intermittent","junction","landuse","layer","leisure","lock","man_made","military","motorcar","name","natural","oneway","operator","population","power","power_source","place","railway","ref","religion","route","service","shop","sport","surface","toll","tourism","tower:type","tracktype","tunnel","water","waterway","wetland","width","wood","z_order","way_area",way) FROM STDIN 2015-02-19 23:01:49 UTC LOG: unexpected EOF on client connection 2015-02-19 23:01:49 UTC ERROR: unexpected EOF on client connection 2015-02-19 23:01:49 UTC CONTEXT: COPY planet_osm_nodes, line 1 2015-02-19 23:01:49 UTC STATEMENT: COPY planet_osm_nodes FROM STDIN;

2015-02-19 23:01:49 UTC LOG: could not send data to client: Broken pipe 2015-02-19 23:01:49 UTC STATEMENT: COPY planet_osm_nodes FROM STDIN;

2015-02-19 23:01:49 UTC LOG: unexpected EOF on client connection 2015-02-19 23:01:49 UTC ERROR: unexpected EOF on client connection 2015-02-19 23:01:49 UTC CONTEXT: COPY planet_osm_ways, line 1 2015-02-19 23:01:49 UTC STATEMENT: COPY planet_osm_ways FROM STDIN;

2015-02-19 23:01:49 UTC LOG: could not send data to client: Broken pipe 2015-02-19 23:01:49 UTC STATEMENT: COPY planet_osm_ways FROM STDIN;

2015-02-19 23:01:49 UTC LOG: unexpected EOF on client connection 2015-02-19 23:01:49 UTC ERROR: unexpected EOF on client connection 2015-02-19 23:01:49 UTC CONTEXT: COPY planet_osm_rels, line 1 2015-02-19 23:01:49 UTC STATEMENT: COPY planet_osm_rels FROM STDIN;

2015-02-19 23:01:49 UTC LOG: could not send data to client: Broken pipe 2015-02-19 23:01:49 UTC STATEMENT: COPY planet_osm_rels FROM STDIN;

2015-02-19 23:01:49 UTC LOG: unexpected EOF on client connection

Thanks

pnorman commented 9 years ago

0.80.0 is old enough and will not work with 64 bit node IDs. Please try with a more recent version, at a minimum 0.82.0