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

[Paul Norman]

> command
```
osm2pgsql --create --slim --drop --flat-nodes flat.bin --cache 14000 --number-processes 6 --hstore --database $DB_NAME $PBF_FILE
```
> 
> config: FreeBSD 10.2, PostgreSQL 9.3.9, PostGIS 2.1.7, osm2pgsql 0.87.2, default ZFS

Just to confirm, you didn't set `$PGHOST` or anything? A theory had been that the cause was TCP/IP timeout related, but this is using local sockets, so that seems to rule it out.

As a virtually identical import line works fine on my FreeBSD box, it's hard to help. 

Is this repeatable?

How long had osm2pgsql been running when it errored?

What was the osm2pgsql output when it errored?

How many hardware threads does your system have, or what CPU?

How much RAM?

-----

Re-ordering the log by PID, I get this

```
[998]: [4-1] ERROR:  unexpected EOF on client connection with an open transaction
[998]: [4-3] STATEMENT:  COPY planet_osm_point (<columnlist>) FROM STDIN
[998]: [4-2] CONTEXT:  COPY planet_osm_point, line 76244780
[998]: [6-1] FATAL:  terminating connection because protocol sync was lost

[999]: [4-1] ERROR:  unexpected EOF on client connection with an open transaction
[999]: [4-2] CONTEXT:  COPY planet_osm_line, line 36811394
[999]: [4-3] STATEMENT:  COPY planet_osm_line (<columnlist>) FROM STDIN
[999]: [6-1] FATAL:  terminating connection because protocol sync was lost

[1000]: [3-1] ERROR:  unexpected EOF on client connection with an open transaction
[1000]: [3-2] CONTEXT:  COPY planet_osm_polygon, line 1
[1000]: [3-3] STATEMENT:  COPY planet_osm_polygon (<columnlist>) FROM STDIN
[1000]: [5-1] FATAL:  terminating connection because protocol sync was lost

[1001]: [4-1] ERROR:  unexpected EOF on client connection with an open transaction
[1001]: [4-2] CONTEXT:  COPY planet_osm_roads, line 3524268
[1001]: [4-3] STATEMENT:  COPY planet_osm_roads (<columnlist>) FROM STDIN
[1001]: [6-1] FATAL:  terminating connection because protocol sync was lost

[1002]: [3-1] ERROR:  unexpected EOF on client connection with an open transaction
[1002]: [3-2] CONTEXT:  COPY planet_osm_nodes, line 1
[1002]: [3-3] STATEMENT:  COPY planet_osm_nodes FROM STDIN;
[1002]: [3-4]   
[1002]: [5-1] FATAL:  terminating connection because protocol sync was lost

[1003]: [4-1] ERROR:  unexpected EOF on client connection with an open transaction
[1003]: [4-2] CONTEXT:  COPY planet_osm_ways, line 82155938
[1003]: [4-3] STATEMENT:  COPY planet_osm_ways FROM STDIN;
[1003]: [4-4]   
[1003]: [6-1] FATAL:  terminating connection because protocol sync was lost

[1004]: [3-1] ERROR:  unexpected EOF on client connection with an open transaction
[1004]: [3-2] CONTEXT:  COPY planet_osm_rels, line 1
[1004]: [3-3] STATEMENT:  COPY planet_osm_rels FROM STDIN;
[1004]: [3-4]   
[1004]: [5-1] FATAL:  terminating connection because protocol sync was lost
```

Still nothing that helps me identify the problem.



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