This is a static archive of our old OpenStreetMap Help Site. Please post any new questions and answers at community.osm.org.

setup.log seems stuck on rank 30..

0

Hi guys and thanks in advance. I have a 8 gb RAM centos 6.6 machine. I'm trying to install nominatim and indexing european map.. I follow the simple instructions oon wiki guide and, until yesterday, everything seems going fine..

But yesterday when I do tail -f on log file I saw:

Done 54357951 in 1416077 @ 38.386295 per second - Rank 30 ETA (seconds): 136114.046875
Done 54358077 in 1416078 @ 38.386356 per second - Rank 30 ETA (seconds): 136110.546875
Done 54358206 in 1416078 @ 38.386448 per second - Rank 30 ETA (seconds): 136106.859375

After some hours (and after a day) I repeat the tail -f and same output appear, last row is the same:

Done 54358206 in 1416078 @ 38.386448 per second - Rank 30 ETA (seconds): 136106.859375

and no progress is been done..

In the other log file (I redirected the output to two file) I can see:

.....................................................................................
Reanalysing database...
ANALYZE
Please download osmosis.
If it is already installed, check the path in your local settings (settings/local.php) file.
ANALYZE
ANALYZE

What does it mean?? Please say me thats everything goes fine... I started this indexing process approx a month ago..


Are you sure?? because the log show the line below:

Done 54358206 in 1416078 @ 38.386448 per second - Rank 30 ETA (seconds): 136106.859375

as last line from 3 days...

If I launch the ps auxw|grep postgres I can see some postgres process (for example vacuum, write ecc..) but if I launch ps -aux | more I can't see no process about nominatim or about the original map import command nohup ./utils/setup.php --osm-file <planet file> --all --osm2pgsql-cache 18000 2>>err.log 1>>setup.log &

The output of select * from pg_stat_activity is:

postgres=# select * from pg_stat_activity;
datid | datname  |  pid  | usesysid | usename  | application_name | client_addr
| client_hostname | client_port |         backend_start         |          xact
_start           |          query_start          |         state_change
| waiting | state  | backend_xid | backend_xmin |              query

-------+----------+-------+----------+----------+------------------+------------
-+-----------------+-------------+-------------------------------+--------------
-----------------+-------------------------------+------------------------------
-+---------+--------+-------------+--------------+------------------------------
---
13003 | postgres | 14967 |       10 | postgres | psql             |
|                 |          -1 | 2016-03-09 12:25:49.719568+01 | 2016-03-09 12
:26:01.184549+01 | 2016-03-09 12:26:01.184549+01 | 2016-03-09 12:26:01.184556+01
| f       | active |             |     80287794 | select * from pg_stat_activit
y;
(1 row)

Do you really think is everything ok??

Thanks a lot Mark

asked 08 Mar '16, 10:13

newbies's gravatar image

newbies
11224
accept rate: 0%

edited 09 Mar '16, 11:29


One Answer:

4

Everything is fine. The database still needs to create some indexes most likely (ps auxw|grep postgres will show a couple busy PostgreSQL processes).

answered 08 Mar '16, 14:01

Frederik%20Ramm's gravatar image

Frederik Ramm ♦
82.5k927201273
accept rate: 23%

1

Still having the same last line with the same ETA after a day seems strange, doesn't it?

(08 Mar '16, 14:20) scai ♦

Source code available on GitHub .