[Geocoding] Nominatim

[Simon Nuttall]

After almost four weeks of running a nominatim installation it has
crashed for the first time.

I'm wondering how to get it going again.

This is the output...

  Done 29075197 in 677886 @ 42.890980 per second - Rank 30 ETA
(seconds): 1350258.875000
  Done 29075229 in 677886 @ 42.891029 per second - Rank 30 ETA
(seconds): 1350256.625000
  Done 29075301 in 677887 @ 42.891071 per second - Rank 30 ETA
(seconds): 1350253.625000
index_placex: UPDATE failed: FATAL:  terminating connection due to
administrator command
CONTEXT:  SQL statement "SELECT min(word_id), max(search_name_count)
FROM word WHERE word_token = lookup_token and class is null and type
is null"
PL/pgSQL function "getorcreate_word_id" line 8 at SQL statement
PL/pgSQL function "make_keywords" line 32 at assignment
PL/pgSQL function "placex_update" line 123 at assignment
FATAL:  terminating connection due to administrator command
CONTEXT:  SQL statement "SELECT min(word_id), max(search_name_count)
FROM word WHERE word_token = lookup_token and class is null and type
is null"
PL/pgSQL function "getorcreate_word_id" line 8 at SQL statement
PL/pgSQL function "make_keywords" line 32 at assignment
PL/pgSQL function "placex_update" line 123 at assignment
ERROR: Error executing external command:
/home/nominatim/Nominatim/nominatim/nominatim -i -d nominatim -P 5432
-t 2 -r 26
psql: server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
root at nominatim:~/src/nominatim-install#



I'm also logging some other output, which shows:
....................................................................................................................................................................................................................................................
Reanalysing database...
ANALYZE
Getting state file:
http://planet.openstreetmap.org/replication/minute/000/710/509.state.txt
Updating DB status
ANALYZE
ANALYZE
Error executing external command:
/home/nominatim/Nominatim/nominatim/nominatim -i -d nominatim -P 5432
-t 2 -r 26
#       Done Import and index OSM data Tue Feb 25 06:37:40 GMT 2014
#       Starting special phrases Tue Feb 25 06:37:41 GMT 2014
select getorcreate_country(make_standard_name('uk'), 'gb');
select getorcreate_country(make_standard_name('united states'), 'us');
select count(*) from (select
getorcreate_country(make_standard_name(country_code), country_code)
from country_name where country_code is not null) as x;
select count(*) from (select
getorcreate_country(make_standard_name(get_name_by_language(country_name.name,ARRAY['name'])),
country_code) from country_name where
get_name_by_language(country_name.name, ARRAY['name']) is not null) as
x;
select count(*) from (select
getorcreate_country(make_standard_name(get_name_by_language(country_name.name,ARRAY['name:af'])),
country_code) from country_name where
get_name_by_language(country_name.name, ARRAY['name:af']) is not null)
as x;
:
:
:
select count(*) from (select
getorcreate_country(make_standard_name(get_name_by_language(country_name.name,ARRAY['name:pt'])),
country_code) from country_name where
get_name_by_language(country_name.name, ARRAY['name:pt']) is not null)
as x;
select count(*) from (select
getorcreate_country(make_standard_name(get_name_by_language(country_name.name,ARRAY['name:ru'])),
country_code) from country_name where
get_name_by_language(country_name.name, ARRAY['name:ru']) is not null)
as x;
select count(*) from (select
getorcreate_country(make_standard_name(get_name_by_language(country_name.name,ARRAY['name:sk'])),
country_code) from country_name where
get_name_by_language(country_name.name, ARRAY['name:sk']) is not null)
as x;
select count(*) from (select
getorcreate_country(make_standard_name(get_name_by_language(country_name.name,ARRAY['name:sv'])),
country_code) from country_name where
get_name_by_language(country_name.name, ARRAY['name:sv']) is not null)
as x;
select count(*) from (select
getorcreate_country(make_standard_name(get_name_by_language(country_name.name,ARRAY['name:uk'])),
country_code) from country_name where
get_name_by_language(country_name.name, ARRAY['name:uk']) is not null)
as x;
select count(*) from (select
getorcreate_country(make_standard_name(get_name_by_language(country_name.name,ARRAY['name:vi'])),
country_code) from country_name where
get_name_by_language(country_name.name, ARRAY['name:vi']) is not null)
as x;



-- 
Simon Nuttall

Route Master, CycleStreets.net