Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error 124 while import-sql with planet extract #1582

Open
armingheorghina opened this issue Sep 21, 2023 · 1 comment
Open

Error 124 while import-sql with planet extract #1582

armingheorghina opened this issue Sep 21, 2023 · 1 comment

Comments

@armingheorghina
Copy link

Hello,

I am trying to generate mbtiles for a planet extract and I am running in this issue at make import-sql.

\psql:/sql/parallel/housenumber.sql:64:psql:/sql/parallel/poi.sql:182: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
psql:/sql/parallel/poi.sql:182: fatal: connection to server was lost
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
psql:/sql/parallel/housenumber.sql:64: fatal: connection to server was lost
psql:/sql/parallel/transportation__transportation_name.sql:400: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
psql:/sql/parallel/transportation__transportation_name.sql:400: fatal: connection to server was lost
xargs: sh: exited with status 255; aborting
ERROR: 124
make: *** [Makefile:453: import-sql] Error 124

I am using the latest version of openmaptiles and generating on a country based works as expected, the issue appears while trying to generate on a planet pbf.

What am I missing ? Is the issue related to memory ?

@TomPohys
Copy link
Member

TomPohys commented Nov 10, 2023

Hi, the server went down (This probably means the server terminated abnormally). Did you try https://pgtune.leopard.in.ua and adjust the PostgreSQL settings? You can also set the pgdata into current folder by adjust the docker-compose file for more easy config update.

- pgdata:/var/lib/postgresql/data 
+ ./pgdata:/var/lib/postgresql/data 

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants