[Geocoding] Nominatim

[Sarah Hoffmann]

On Thu, Feb 27, 2014 at 07:27:31PM +0000, Simon Nuttall wrote:
> 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

This looks like somebody else has killed postgres. You can pick up
the import where it stopped with

./utils/setup.php --index --create-search-indices

> 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

You might want to change your script so that it stops when one of the
processes fails.

Sarah