Yep, exactly the error I receive. I posted this on stackexchange a while
<br>
back in regards to it:
<br>
<br>
http://gis.stackexchange.com/questions/69585/osm2pgsql-loses-connection-at-end-of-import-for-large-pbf-north-america-latest
<br>
<br>
I'm beginning to wonder if the connection remains idle for too long or
<br>
osm2pgsql isn't commiting and closing connections correctly. I'll try to
<br>
sleuth through the code later today.
<br>
<br>
<br>
On Fri, Jan 24, 2014 at 6:10 AM, anothergisblog <notifications@github.com>wrote:
<br>
<br>
> The PG Logs show the following errors:
<br>
> 2014-01-23 18:48:30 EST LOG: could not receive data from client: No
<br>
> connection could be made because the target machine actively refused it.
<br>
>
<br>
> 2014-01-23 18:48:30 EST LOG: could not receive data from client: No
<br>
> connection could be made because the target machine actively refused it.
<br>
>
<br>
> 2014-01-23 18:48:30 EST LOG: unexpected EOF on client connection with an
<br>
> open transaction
<br>
> 2014-01-23 18:48:30 EST LOG: unexpected EOF on client connection with an
<br>
> open transaction
<br>
> 2014-01-23 18:48:30 EST LOG: could not receive data from client: No
<br>
> connection could be made because the target machine actively refused it.
<br>
>
<br>
> 2014-01-23 18:48:30 EST LOG: unexpected EOF on client connection with an
<br>
> open transaction
<br>
> 2014-01-23 18:48:30 EST LOG: could not receive data from client: No
<br>
> connection could be made because the target machine actively refused it.
<br>
>
<br>
> 2014-01-23 18:48:30 EST LOG: unexpected EOF on client connection with an
<br>
> open transaction
<br>
> 2014-01-23 18:48:30 EST LOG: could not receive data from client: No
<br>
> connection could be made because the target machine actively refused it.
<br>
>
<br>
> 2014-01-23 18:48:30 EST LOG: unexpected EOF on client connection with an
<br>
> open transaction
<br>
> 2014-01-23 18:48:30 EST LOG: could not receive data from client: No
<br>
> connection could be made because the target machine actively refused it.
<br>
>
<br>
> 2014-01-23 18:48:30 EST CONTEXT: COPY planet_osm_rels, line 9854
<br>
> 2014-01-23 18:48:30 EST STATEMENT: COPY planet_osm_rels FROM STDIN;
<br>
>
<br>
> 2014-01-23 18:48:30 EST LOG: incomplete message from client
<br>
> 2014-01-23 18:48:30 EST CONTEXT: COPY planet_osm_rels, line 9854
<br>
> 2014-01-23 18:48:30 EST STATEMENT: COPY planet_osm_rels FROM STDIN;
<br>
>
<br>
> 2014-01-23 18:48:30 EST LOG: could not receive data from client: No
<br>
> connection could be made because the target machine actively refused it.
<br>
>
<br>
> 2014-01-23 18:48:30 EST CONTEXT: COPY planet_osm_point, line 4677742
<br>
> 2014-01-23 18:48:30 EST STATEMENT: COPY planet_osm_point
<br>
> (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)
<br>
> FROM STDIN
<br>
> 2014-01-23 18:48:30 EST LOG: incomplete message from client
<br>
> 2014-01-23 18:48:30 EST CONTEXT: COPY planet_osm_point, line 4677742
<br>
> 2014-01-23 18:48:30 EST STATEMENT: COPY planet_osm_point
<br>
> (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)
<br>
> FROM STDIN
<br>
> 2014-01-23 18:48:30 EST ERROR: unexpected EOF on client connection with an
<br>
> open transaction
<br>
> 2014-01-23 18:48:30 EST CONTEXT: COPY planet_osm_rels, line 9854
<br>
> 2014-01-23 18:48:30 EST STATEMENT: COPY planet_osm_rels FROM STDIN;
<br>
>
<br>
> 2014-01-23 18:48:30 EST ERROR: unexpected EOF on client connection with an
<br>
> open transaction
<br>
> 2014-01-23 18:48:30 EST CONTEXT: COPY planet_osm_point, line 4677742
<br>
> 2014-01-23 18:48:30 EST STATEMENT: COPY planet_osm_point
<br>
> (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)
<br>
> FROM STDIN
<br>
> 2014-01-23 18:48:30 EST LOG: could not send data to client: No connection
<br>
> could be made because the target machine actively refused it.
<br>
>
<br>
> 2014-01-23 18:48:30 EST STATEMENT: COPY planet_osm_rels FROM STDIN;
<br>
>
<br>
> 2014-01-23 18:48:30 EST LOG: could not send data to client: No connection
<br>
> could be made because the target machine actively refused it.
<br>
>
<br>
> 2014-01-23 18:48:30 EST STATEMENT: COPY planet_osm_point
<br>
> (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)
<br>
> FROM STDIN
<br>
> 2014-01-23 18:48:31 EST FATAL: connection to client lost
<br>
> 2014-01-23 18:48:32 EST FATAL: connection to client lost
<br>
>
<br>
> This seems to happen with any large (> 1gb) pbf file. I haven't tested
<br>
> straight OSM (uncompressed) of bz2 files. Is anyone else getting this?
<br>
>
<br>
> —
<br>
> Reply to this email directly or view it on GitHub<https://github.com/openstreetmap/osm2pgsql/issues/117#issuecomment-33214649>
<br>
> .
<br>
>
<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br>Reply to this email directly or <a href='https://github.com/openstreetmap/osm2pgsql/issues/117#issuecomment-33227226'>view it on GitHub</a>.<img src='https://github.com/notifications/beacon/4046574__eyJzY29wZSI6Ik5ld3NpZXM6QmVhY29uIiwiZXhwaXJlcyI6MTcwNjEwNzEwMiwiZGF0YSI6eyJpZCI6MjQxMTIxNDJ9fQ==--780d716dc0fbcfe1494588c8c6e5cafa64c242fd.gif' height='1' width='1'></p>