[Geocoding] [osmosis-dev] (no subject)

[Sarah Hoffmann]

On Wed, Aug 28, 2013 at 11:30:55AM +0100, Simon Nuttall wrote:
> On 25 August 2013 23:15, Sarah Hoffmann <lonvia at denofr.de> wrote:
> > Hi,
> >
> > are you sure that you got the right mailing list?
> >
> > On Sun, Aug 25, 2013 at 09:11:54PM +0100, Simon Nuttall wrote:
> >> I've hit this issue about 48 hours into processing a Europe - wide
> >> nominatim. Is there a way of proceeding?
> >
> > It seems to be just an update, simply run it again. --import-osmosis-all
> > will try to reapply the change automatically when restarted after you've
> > fixed the underlying problem.
> >
> >> 25-Aug-2013 19:45:34 org.openstreetmap.osmosis.core.Osmosis run
> >> INFO: Total execution time: 39209229 milliseconds.
> >> Completed for 2013-06-29T19:59:05Z in 1361.3 minutes
> >> /home/nominatim/Nominatim/osm2pgsql/osm2pgsql -klas -C 2000 -O
> >> gazetteer -d nominatim
> >> /home/nominatim/Nominatim/data/osmosischange.osc
> >> Using projection SRS 4326 (Latlong)
> >> Allocating memory for dense node cache
> >> Allocating dense node cache in one big chunk
> >> Allocating memory for sparse node cache
> >> Sharing dense sparse
> >> Node-cache: cache=2000MB, maxblocks=256001*8192, allocation method=11
> >> Mid: pgsql, scale=10000000 cache=2000
> >> Setting up table: planet_osm_nodes
> >> Setting up table: planet_osm_ways
> >> Setting up table: planet_osm_rels
> >>
> >> Reading in file: /home/nominatim/Nominatim/data/osmosischange.osc
> >> COPY_END for place failed: ERROR:  column "addr_place" of relation
> >> "placex" does not exist
> >> LINE 2:       street, addr_place, isin, postcode, country_code, extr...
> >
> > This looks like you have updated your Nominatim version without migrating
> > the database. There have been some changes in the DB schema recently.
> > The migration for the addr_place column is described here:
> > https://github.com/twain47/Nominatim/pull/54#issuecomment-17277092
> > (needed after ddc46acd26)
> 
> Ah right. My installation was in fact a re-installation, but I had
> deleted the nominatim database, so I thought that was enough.
> 
> Where in the installation does the schema actually come from?
> 
> Is it built by the code that comes from this section?
> 
>  cd Nominatim
>  ./autogen.sh
>  ./configure
>  make
> 
> If so then that explains why I hadn't got the latest schema, if not
> then I must have done something else wrong.

The column in question is created by osm2pgsql which does not get
automatically updated to the latest version after 'git pull', you
need to do a 'git submodule update' before compiling.

Sarah