Replication / catch-up Processing: Node(3800k 111.8k/s) stuck forever #601
Description
Describe the bug
Processing of replication catch-up is stuck in our Nominatim 4.4 container (we didn't upgrade its database/catch-up since 1 year).
When we started the upgrade, it stayed stuck for dozen of hours (forever actually) on this log :
2025-02-16 15:44:38: Using project directory: /nominatim
2025-02-16 15:45:26 osm2pgsql version 1.11.0
2025-02-16 15:45:26 Database version: 14.11 (Ubuntu 14.11-0ubuntu0.22.04.1)
2025-02-16 15:45:26 PostGIS version: 3.2
2025-02-16 15:45:26 No properties found in database from previous import.
Processing: Node(3800k 111.8k/s) Way(0k 0.00k/s) Relation(0 0.0/s)
Solution
Thanks to this thread osm-search/Nominatim#3445 (comment), I've been able to fix it with :
Starting the docker container without the catch-up enabled (UPDATE_MODE=none), and then I entered in the instance to run :
docker exec -it nominatim sudo -u nominatim /bin/bash
NOMINATIM_REPLICATION_MAX_DIFF=10000 nohup nominatim replication --project-dir /nominatim --catch-up &It fixed the issue (for now, at least, the processing is going further.. :
nominatim@7c212aa8874d:/app$ tail -f /home/nominatim/nohup.out
2025-02-16 16:03:21: Using project directory: /nominatim
2025-02-16 16:21:57 osm2pgsql version 1.11.0
2025-02-16 16:21:57 Database version: 14.11 (Ubuntu 14.11-0ubuntu0.22.04.1)
2025-02-16 16:21:57 PostGIS version: 3.2
2025-02-16 16:21:57 No properties found in database from previous import.
Processing: Node(78720k 33.4k/s) Way(0k 0.00k/s) Relation(0 0.0/s)
🙌