[Tile-serving] [osm2pgsql] osm2pgsql Segmentation fault (#294)

Thu Feb 19 23:20:46 UTC 2015

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

---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/294
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20150219/749c37b4/attachment-0001.html>