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

[Simon Nuttall]

On the wrong mailing list

http://lists.openstreetmap.org/pipermail/osmosis-dev/2013-August/001601.html

I asked and Sarah replied, with more points from me below:

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.

I've updated our nominatim installation script at
https://github.com/cyclestreets/nominatim-install

to recomplie after a git update, so if the above is right that should
have fixed the problem.

>
> The other significant DB schema changes was:
> https://github.com/twain47/Nominatim/pull/45#issuecomment-16157763
> (needed after 23d303124e)
>
> Sarah