[Tile-serving] [openstreetmap/osm2pgsql] ERROR: planet_osm_nodes - error on COPY: SSL SYSCALL error: EOF detected (Issue #1688)

Ihar Kouhanau notifications at github.com
Tue Jun 28 12:54:21 UTC 2022


## What version of osm2pgsql are you using?
osm2pgsql version 1.6.0

## What operating system and PostgreSQL/PostGIS version are you using?
Database version: 12.10
PostGIS version: 3.1

<!-- Also what Linux distribution if applicable, OS version? -->
Ubuntu 20.04.4 LTS (GNU/Linux 5.13.0-1022-aws x86_64)

## Tell us something about your system

<!-- How much RAM do you have, how many CPUs, bare metal or cloud setup? -->
RAM 32 GB
CPU 8


## What did you do exactly?

I run command in docker container (remote database)
sudo -u renderer osm2pgsql -r pbf -d 'dbname=gis host=host port=5432 user=postgres password=password' --create --slim -G --hstore --tag-transform-script /home/renderer/src/openstreetmap-carto/openstreetmap-carto.lua --number-processes 4 -S /home/renderer/src/openstreetmap-carto/openstreetmap-carto.style /home/renderer/data/regions.pbf -C 16000


## What did you expect to happen?
Importing data

## What did happen instead?
It works some period of time but eventually I get error: planet_osm_nodes - error on COPY: SSL SYSCALL error: EOF detected
![osm2](https://user-images.githubusercontent.com/23447665/176182625-8d07630c-9cae-4261-9df8-1560e1cab2a2.png)
It works good for small files but when I import a big file to remote database it fails


<!-- Please describe what happened and why you think this is wrong. Please include
(or link to, if it is too verbose) the log output. -->


## What did you do to try analyzing the problem?

<!-- Describe what steps you already did to try analyzing the problem before
reporting. -->



-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/1688
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/osm2pgsql/issues/1688 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20220628/79ae6516/attachment.htm>


More information about the Tile-serving mailing list