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

[WCGL]

Sorry, I'm pretty new to this process and Postgres.

1. I have not tried a smaller file, although I did manage to import this one on another system but using osmosis.  However that machine was far below spec and I have since abandoned it.

2. I've pasted the whole Postgres log below;

3. I wasn't aware there was a different connection method, is that likely to be cause of my problem?

>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.

	
>2015-04-10 08:27:28 BST LOG:  incomplete message from client
>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:  unexpected EOF on client connection with an open transaction
>2015-04-10 08:27:28 BST LOG:  incomplete message from client
>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 LOG:  incomplete message from client
>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:  unexpected EOF on client connection with an open transaction
>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 LOG:  unexpected EOF on client connection with an open transaction
>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_rels, line 612689
>2015-04-10 08:27:28 BST STATEMENT:  COPY planet_osm_rels FROM STDIN;
	
>2015-04-10 08:27:28 BST LOG:  incomplete message from client
>2015-04-10 08:27:28 BST CONTEXT:  COPY planet_osm_rels, line 612689
>2015-04-10 08:27:28 BST STATEMENT:  COPY planet_osm_rels FROM STDIN;
	
>2015-04-10 08:27:28 BST ERROR:  unexpected EOF on client connection with an open transaction
>2015-04-10 08:27:28 BST CONTEXT:  COPY planet_osm_rels, line 612689
>2015-04-10 08:27:28 BST STATEMENT:  COPY planet_osm_rels FROM STDIN;
	
>2015-04-10 08:27:28 BST ERROR:  unexpected EOF on client connection with an open transaction
>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 send data to client: No connection could be made because the target machine actively refused it.

	
>2015-04-10 08:27:28 BST STATEMENT:  COPY planet_osm_rels FROM STDIN;
	
>2015-04-10 08:27:28 BST LOG:  could not send data to client: No connection could be made because the target machine actively refused it.

	
>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 ERROR:  unexpected EOF on client connection with an open transaction
>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 send data to client: No connection could be made because the target machine actively refused it.

	
>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 ERROR:  unexpected EOF on client connection with an open transaction
>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 send data to client: No connection could be made because the target machine actively refused it.

	
>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:29 BST FATAL:  terminating connection because protocol sync was lost
>2015-04-10 08:27:29 BST FATAL:  terminating connection because protocol sync was lost
>2015-04-10 08:27:29 BST FATAL:  terminating connection because protocol sync was lost
>2015-04-10 08:27:32 BST FATAL:  terminating connection because protocol sync was lost



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