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


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

permanent link

answered 08 Mar '16, 14:01

Frederik%20Ramm's gravatar image

Frederik Ramm ♦
71.3k846451113
accept rate: 24%

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 ♦
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×558
×4

question asked: 08 Mar '16, 10:13

question was seen: 1,269 times

last updated: 09 Mar '16, 11:29

powered by OSQA