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

index “idx_word_word_id” already exists

-1

Hi guys.. I try to resume the process but after some log like:

Starting rank 28
 Done 0 in 0 @ 0.000000 per second - FINISHED

Starting rank 29
 Done 0 in 0 @ 0.000000 per second - FINISHED

Starting rank 30
 Done 0 in 0 @ 0.000000 per second - FINISHED

I got this error:

ERRORE:  la relazione "idx_word_word_id" esiste già
ERROR: pgsql returned with error code (3)

What can I do?? maybe change product? Thanks a lot

I dropped that index and now I have similar error:

ERRORE:  la relazione "idx_search_name_nameaddress_vector" esiste già
ERROR: pgsql returned with error code (3)

It is the second index I found on sql folder (under nominatim path) inside file indices.src.sql. What I have to do?? I have to remove all index on that list??

Please I'am so close

Thanks anyway Giacomo

nominatim

asked 23 Nov '15, 16:02

giacomo-keybiz
33●10●10●13
accept rate: 0%

edited 23 Nov '15, 18:14

One Answer:

Obviously half the indexes have already been created before your previous importing attempt failed. To finish creating the other indices run:

./utils/setup.php --create-search-indices --ignore-errors

and ignore the errors printed by postgres.

answered 24 Nov '15, 16:38

lonvia
6.2k●2●57●89
accept rate: 40%

Thanks a lot man.. Unfortunately I have read your post too late and I drop all index (already created) I found on indices.src.sql. I hope I'm not wrong..

Thanks again Giacomo

(24 Nov '15, 18:08) giacomo-keybiz