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
11●2●2●4
accept rate:
0%