[Tile-serving] [osm2pgsql] OSM2PGSQL Crashes on Windows Server 2008 (#117)

Fri Jan 24 11:10:07 UTC 2014

The PG Logs show the following errors:
2014-01-23 18:48:30 EST LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.

2014-01-23 18:48:30 EST LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.

2014-01-23 18:48:30 EST LOG:  unexpected EOF on client connection with an open transaction
2014-01-23 18:48:30 EST LOG:  unexpected EOF on client connection with an open transaction
2014-01-23 18:48:30 EST LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.

2014-01-23 18:48:30 EST LOG:  unexpected EOF on client connection with an open transaction
2014-01-23 18:48:30 EST LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.

2014-01-23 18:48:30 EST CONTEXT:  COPY planet_osm_rels, line 9854
2014-01-23 18:48:30 EST STATEMENT:  COPY planet_osm_rels FROM STDIN;

2014-01-23 18:48:30 EST LOG:  incomplete message from client
2014-01-23 18:48:30 EST CONTEXT:  COPY planet_osm_rels, line 9854
2014-01-23 18:48:30 EST STATEMENT:  COPY planet_osm_rels FROM STDIN;

2014-01-23 18:48:30 EST LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.

2014-01-23 18:48:30 EST CONTEXT:  COPY planet_osm_point, line 4677742
2014-01-23 18:48:30 EST STATEMENT:  COPY planet_osm_point (osm_id,"access","admin_level","aerialway","aeroway","amenity","area","barrier","bicycle","brand","bridge","boundary","building","capital","construction","covered","culvert","cutting","denomination","disused","ele","embankment","foot","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","tunnel","water","waterway","wetland","width","wood","z_order",way) FROM STDIN
2014-01-23 18:48:30 EST LOG:  incomplete message from client
2014-01-23 18:48:30 EST CONTEXT:  COPY planet_osm_point, line 4677742
2014-01-23 18:48:30 EST STATEMENT:  COPY planet_osm_point (osm_id,"access","admin_level","aerialway","aeroway","amenity","area","barrier","bicycle","brand","bridge","boundary","building","capital","construction","covered","culvert","cutting","denomination","disused","ele","embankment","foot","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","tunnel","water","waterway","wetland","width","wood","z_order",way) FROM STDIN
2014-01-23 18:48:30 EST ERROR:  unexpected EOF on client connection with an open transaction
2014-01-23 18:48:30 EST CONTEXT:  COPY planet_osm_rels, line 9854
2014-01-23 18:48:30 EST STATEMENT:  COPY planet_osm_rels FROM STDIN;

2014-01-23 18:48:30 EST ERROR:  unexpected EOF on client connection with an open transaction
2014-01-23 18:48:30 EST CONTEXT:  COPY planet_osm_point, line 4677742
2014-01-23 18:48:30 EST STATEMENT:  COPY planet_osm_point (osm_id,"access","admin_level","aerialway","aeroway","amenity","area","barrier","bicycle","brand","bridge","boundary","building","capital","construction","covered","culvert","cutting","denomination","disused","ele","embankment","foot","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","tunnel","water","waterway","wetland","width","wood","z_order",way) FROM STDIN
2014-01-23 18:48:30 EST LOG:  could not send data to client: No connection could be made because the target machine actively refused it.

2014-01-23 18:48:30 EST STATEMENT:  COPY planet_osm_rels FROM STDIN;

2014-01-23 18:48:30 EST LOG:  could not send data to client: No connection could be made because the target machine actively refused it.

2014-01-23 18:48:30 EST STATEMENT:  COPY planet_osm_point (osm_id,"access","admin_level","aerialway","aeroway","amenity","area","barrier","bicycle","brand","bridge","boundary","building","capital","construction","covered","culvert","cutting","denomination","disused","ele","embankment","foot","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","tunnel","water","waterway","wetland","width","wood","z_order",way) FROM STDIN
2014-01-23 18:48:31 EST FATAL:  connection to client lost
2014-01-23 18:48:32 EST FATAL:  connection to client lost

This seems to happen with any large (> 1gb) pbf file.  I haven't tested straight OSM (uncompressed) of bz2 files.  Is anyone else getting this?

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