Nominatim refresh --wiki-data Issues

Help and support
1

I have already imported a full planet DB. I am now trying to refresh my Linux Nominatim installation DB to include wiki data. I have downloaded the correct files and run “nominatim refresh –wiki-data –secondary-importance –importance –verbose”. I know it takes some time to import all the importance data to the DB. Every time I try and do this the refresh sticks at “Update importance values for database”. I don’t know what is going on behind the scenes but it is continuing to stay at this step. Any help here would be greatly appreciated.

image

2

what is in the next line of CLI?

3

Usual help channel is osm-search/Nominatim · Discussions · GitHub

Is this the latest Nominatim (5.1) importing CSV files? (used to be *.sql files in older versions)

Check which queries are running in Postgresql. Maybe the query is blocked by another update. You should see a table wikimedia_importancewith about 18 million rows. Nominatim/src/nominatim_db/tools/refresh.py at master · osm-search/Nominatim · GitHub

4

Please note that refreshing wikipedia importances is more or less broken in the current release, see https://github.com/osm-search/Nominatim/issues/3755 for details. This will be fixed in the next release coming out soonish.

1 Like
5

There is not a next line. It stops there. Has been about a day stopped there.

6

Yes I am using Nominatim 5.1. It looks like wikimedia_importance IS populated with 18 million rows. But when searching my nominatim UI is till not using the correct importance values. I have confirmed that the wikimedia_importance table is populated correctly. It is just that my installation doesn’t seem to want to use those values.

7

Something odd i noticed is that when I go into the details of a search it does use the correct importance,

image
image807×136 3.92 KB

But when I run a search and check the API request it has the wrong importance.

Any idea why this might be?

9

Ok thank you. In order to fix this now would I need to do a brand new full import with the importance included in the import?

10

The documentation isn’t kidding when it says that it may take a very, very long time.

Reimport with importance files in place or wait for the release and then rerun the update. The former is likely faster, even if the release come out tomorrow.

1 Like