[Tile-serving] [osm2pgsql] Import failing whilst processing relations (#329)

[WCGL]

Hi,

I've now had two attempts at importing a planet-latest.osm.pbf and both have failed at exactly the same point, the last output from osm2pgsql was;

> Processing: Node(2715748k 150.5k/s) Way(272021k 0.49k/s) Relation(613030 6.25/s)

the only clue I have to the problem is the content of the Postgres database log which has the following;

>2015-04-10 08:27:28 BST LOG:  could not receive data from client: No connection could be made >because the target machine actively refused it.
	
>2015-04-10 08:27:28 BST CONTEXT:  COPY planet_osm_polygon, line 2
>2015-04-10 08:27:28 BST STATEMENT:  COPY planet_osm_polygon (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","office","oneway","operator","place","population","power","power_source","public_transport","railway","ref","religion","route","service","shop","sport","surface","toll","tourism","tower:type","tracktype","tunnel","water","waterway","wetland","width","wood","z_order","way_area",tags,way) FROM STDIN
2015-04-10 08:27:28 BST LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.

	
>2015-04-10 08:27:28 BST CONTEXT:  COPY planet_osm_line, line 3
>2015-04-10 08:27:28 BST 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","office","oneway","operator","place","population","power","power_source","public_transport","railway","ref","religion","route","service","shop","sport","surface","toll","tourism","tower:type","tracktype","tunnel","water","waterway","wetland","width","wood","z_order","way_area",tags,way) FROM STDIN
>2015-04-10 08:27:28 BST LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.

	
>2015-04-10 08:27:28 BST CONTEXT:  COPY planet_osm_point, line 69718201
>2015-04-10 08:27:28 BST 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","office","oneway","operator","place","poi","population","power","power_source","public_transport","railway","ref","religion","route","service","shop","sport","surface","toll","tourism","tower:type","tunnel","water","waterway","wetland","width","wood","z_order",tags,way) FROM STDIN
>2015-04-10 08:27:28 BST LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.

this goes on a bit but eventually ends with;

> 2015-04-10 08:27:32 BST FATAL:  terminating connection because protocol sync was lost

I have osm2pgsql and my Postgres database server running on the same PC, so I don't really understand how a communication failure can be the cause.

I launched the script with the following command;

> osm2pgsql -s -C 1500 --number-processes 6 -H localhost -G -k -c OpenStreetMap/planet-latest.osm.pbf -S /Styles/openstreetmap-carto.style -U postgres

Does anyone have a clue as to what is going on here?



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