[Geocoding] empty search_name tables

[Sarah Hoffmann]

On Fri, Mar 13, 2015 at 01:30:21PM +0100, Carlos Alberto Castaño Moraga wrote:
> Sarah,
> 
> Here is the number of rows we have. All the tables that do not appear have
> 0 rows
> 
>          relname          | n_live_tup
> --------------------------+------------
>  planet_osm_nodes         |    1422241
>  planet_osm_ways          |     170652
>  place                             |     125748
>  placex                           |     111900
>  word                             |      48307

Those are the interesting numbers and they look about right. That means
that the final indexing step is not doing what it is supposed to. Please
also check the following:

- run ./utils/setup/php --create-functions and make sure no error is
  reported, in particular no error about missing library functions
- check that placex has three triggers installed (psql nominatim and
	the '\d placex')
- check the number of items to be indexed:
  SELECT count(*) FROM placex WHERE indexed_status > 0;

Sarah
 
> 2015-03-13 11:32 GMT+01:00 Sarah Hoffmann <lonvia at denofr.de>:
> 
> > Hi Carlos,
> >
> > On Fri, Mar 13, 2015 at 09:23:27AM +0100, Carlos Alberto Castaño Moraga
> > wrote:
> > > I use postgres 9.4, postgis 9.1, Nominatim 2.3.1 from git on a Solaris
> > x86
> > > server that runs an apache2 with php5. I have donwloaded the luxembourg
> > pbf
> > > file from geofabrik website, without any preprocessing. For the
> > > installation, I use the following command:
> > >
> > > ./utils/setup.php --osm-file louxembourg.osm.pbf --all
> > >
> > > and it finishes ok.
> > >
> > > I have been reading some posts through google and I think that something
> > is
> > > not working when the indices are created. I get the following output:
> > >
> > > (...)
> > >
> > > Starting rank 27
> > >   Done 0 in 0 @ 0.000000 per second - FINISHED
> > >
> > > 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 have checked the postgres logs and so on, but I don't see any error or
> > > any clue. The only hint I have is that search_names tables and
> > > location_area, location_road and so on are empty, but I don't know why.
> > >
> > > Could you please help us to discover what I am missing?
> >
> > The final tables in your database have no data. From the output it is not
> > yet clear where the data gets lost. Could you check the row count for the
> > following tables: planet_osm_ways, place, placex
> >
> > Sarah
> >