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

[Jason Huntley]

Yep, exactly the error I receive. I posted this on stackexchange a while
back in regards to it:

http://gis.stackexchange.com/questions/69585/osm2pgsql-loses-connection-at-end-of-import-for-large-pbf-north-america-latest

I'm beginning to wonder if the connection remains idle for too long or
osm2pgsql isn't commiting and closing connections correctly. I'll try to
sleuth through the code later today.


On Fri, Jan 24, 2014 at 6:10 AM, anothergisblog <notifications at github.com>wrote:

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

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