Stuck at + echo 'Warming finished' Warming finished.

[myrainbowandsky]

I have been waiting for 2 days. What happened?

INFO:  "location_road_94": scanned 1646 of 1646 pages, containing 57764 live rows and 0 dead rows; 30000 rows in sample, 57764 estimated total rows
INFO:  analyzing "public.location_road_95"
INFO:  "location_road_95": scanned 2067 of 2067 pages, containing 30187 live rows and 0 dead rows; 30000 rows in sample, 30187 estimated total rows
INFO:  analyzing "public.location_road_96"
INFO:  "location_road_96": scanned 62 of 62 pages, containing 1044 live rows and 0 dead rows; 1044 rows in sample, 1044 estimated total rows
INFO:  analyzing "public.location_road_97"
INFO:  "location_road_97": scanned 371 of 371 pages, containing 3534 live rows and 0 dead rows; 3534 rows in sample, 3534 estimated total rows
INFO:  analyzing "public.location_road_98"
INFO:  "location_road_98": scanned 444 of 444 pages, containing 7497 live rows and 0 dead rows; 7497 rows in sample, 7497 estimated total rows
INFO:  analyzing "public.location_road_99"
INFO:  "location_road_99": scanned 689 of 689 pages, containing 11101 live rows and 0 dead rows; 11101 rows in sample, 11101 estimated total rows
ANALYZE
+ sudo service postgresql stop
 * Stopping PostgreSQL 14 database server                                                                                                                                                                                                [ OK ]
+ rm /etc/postgresql/14/main/conf.d/postgres-import.conf
+ echo 'Deleting downloaded dumps in /nominatim'
Deleting downloaded dumps in /nominatim
+ rm -f '/nominatim/*sql.gz'
+ rm -f '/nominatim/*csv.gz'
+ rm -f /nominatim/tiger-nominatim-preprocessed.csv.tar.gz
+ '[' '' '!=' '' ']'
+ touch /var/lib/postgresql/14/main/import-finished
+ service postgresql start
 * Starting PostgreSQL 14 database server                                                                                                                                                                                                [ OK ]
+ cd /nominatim
+ sudo -E -u nominatim nominatim refresh --website --functions
2022-11-21 12:08:07: Using project directory: /nominatim
2022-11-21 12:08:07: Create functions
2022-11-21 12:08:14: Setting up website directory at /nominatim/website
+ service apache2 start
 * Starting Apache httpd web server apache2                                                                                                                                                                                               AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.17.0.2. Set the 'ServerName' directive globally to suppress this message
 * 
+ '[' '' '!=' '' ']'
+ tailpid=49391
+ echo 'Warm database caches for search and reverse queries'
+ tail -Fv /var/log/postgresql/postgresql-14-main.log /var/log/apache2/access.log /var/log/apache2/error.log /var/log/replication.log
Warm database caches for search and reverse queries
+ sudo -E -u nominatim nominatim admin --warm
==> /var/log/postgresql/postgresql-14-main.log <==
2022-11-21 12:08:03.998 UTC [44] LOG:  aborting any active transactions
2022-11-21 12:08:04.007 UTC [44] LOG:  background worker "logical replication launcher" (PID 51) exited with exit code 1
2022-11-21 12:08:04.129 UTC [46] LOG:  shutting down
2022-11-21 12:08:04.750 UTC [44] LOG:  database system is shut down
2022-11-21 12:08:05.307 UTC [49323] LOG:  starting PostgreSQL 14.5 (Ubuntu 14.5-0ubuntu0.22.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.2.0-19ubuntu1) 11.2.0, 64-bit
2022-11-21 12:08:05.323 UTC [49323] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2022-11-21 12:08:05.323 UTC [49323] LOG:  listening on IPv6 address "::", port 5432
2022-11-21 12:08:05.364 UTC [49323] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2022-11-21 12:08:05.435 UTC [49324] LOG:  database system was shut down at 2022-11-21 12:08:04 UTC
2022-11-21 12:08:05.473 UTC [49323] LOG:  database system is ready to accept connections

==> /var/log/apache2/access.log <==

==> /var/log/apache2/error.log <==
[Mon Nov 21 12:08:14.739657 2022] [mpm_prefork:notice] [pid 49377] AH00163: Apache/2.4.52 (Ubuntu) configured -- resuming normal operations
[Mon Nov 21 12:08:14.739735 2022] [core:notice] [pid 49377] AH00094: Command line: '/usr/sbin/apache2'
tail: cannot open '/var/log/replication.log' for reading: No such file or directory
2022-11-21 12:08:15: Using project directory: /nominatim
2022-11-21 12:08:15: Warming database caches
+ echo 'Warming finished'
Warming finished
+ wait

[psclwsr]

I have the same issue. For deployment testing i just imported Luxembourg (~36MB) and the process is just stuck here.

[philipkozeny]

It's not stuck, the import is done and you can start using it. Did you test if you get any geocoding results? Thats just debug output from different files (see ==> /var/log/... <===)

[philipkozeny]

#400

I have added the info that the container is ready after warmup ... :)