search

mediagis / nominatim-docker

100% working container for Nominatim
Creative Commons Zero v1.0 Universal
1.07k stars 437 forks source link

Nominatim Replication Error #466

Closed cormanttech closed 10 months ago

cormanttech commented 1 year ago

Hi All,

We encountered an error every time we do the "nominatim replication" command to update our Nominatim. Below is the error message:

ERROR: DB copy thread failed: database error: server closed the connection unexpectedly this probably means the server terminated abnormally before or while processing the request

Nominatim

Thank you!

stouch commented 1 year ago

You should give more information, about your docker run command, the setup/instance/machine you use, the full logs, etc.

cormanttech commented 11 months ago

Hi,

We have established the Nominatim server on an AWS EC2 instance running Ubuntu 20.04. I adhered to the installation steps outlined in the following link: https://nominatim.org/release-docs/latest/admin/Installation/ to configure our instance.

Initially, our OpenStreetMap (OSM) setup was functioning smoothly, and we successfully used the 'Nominatim Replication' method for updates. However, we have recently encountered an unexpected error.

The PostgreSQL logs reveal the following:

image

mtmail commented 11 months ago

The "invalid record length" can be ignored https://dba.stackexchange.com/questions/256740/invalid-record-length-at-1a2-8f240298-wanted-24-got-0 The "redo starts ... redo done" looks good.

Why the postgresql server stopped (crashed?) might be further up the postgresql logfile or other system logfiles. That's all unrelated to Nominatim, a postgresql forum might be better answering those.