[Geocoding] empty search_name tables

[Carlos Alberto Castaño Moraga]

Hi Sarah,

Thank you very much for your answer. Here is the output of the things I had
to check:

A) run ./utils/setup.php --create-functions

I think there is no error. Here you can find the output.

Functions
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
NOTICE:  drop cascades to function get_addressdata(bigint)
DROP TYPE
CREATE TYPE
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
NOTICE:  drop cascades to function get_wikipedia_match(hstore,character
varying)
DROP TYPE
CREATE TYPE
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
Helper functions for postgis >= 2.0
CREATE FUNCTION
Setup finished.

B)  Triggers installed (psql nominatim and the '\d placex')

Triggers:
    placex_before_delete AFTER DELETE ON placex FOR EACH ROW EXECUTE
PROCEDURE placex_delete()
    placex_before_insert BEFORE INSERT ON placex FOR EACH ROW EXECUTE
PROCEDURE placex_insert()
    placex_before_update BEFORE UPDATE ON placex FOR EACH ROW EXECUTE
PROCEDURE placex_update()

C) check the number of items to be indexed:
  SELECT count(*) FROM placex WHERE indexed_status > 0;

 count
--------
 111900
(1 row)

I think everything is OK. What would be the next step??

Best Regards!



2015-03-14 15:09 GMT+01:00 Sarah Hoffmann <lonvia at denofr.de>:

> 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
> > >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/geocoding/attachments/20150317/80a18044/attachment.html>