[Geocoding] Nominatim on Raspberry Pi (was: Nominatim release 2.2 announcement)
Matthew Grech
matthewgrech1 at gmail.com
Sat Jul 19 08:18:11 UTC 2014
Sarah,
I have also setup osmosis updates on the pi now that the import is working,
and the log is attached. It seems that the update is working as expected,
can you have a look?
Many thanks,
Matthew
On Sat, Jul 19, 2014 at 9:40 AM, Matthew Grech <matthewgrech1 at gmail.com>
wrote:
> Dear Sarah,
>
> Thanks for your reply. After a fresh installation of the raspberry pi, and
> with completely updated raspian packages, the import has been performed OK!
>
> I will continue to work and update you later on.
>
> Have a nice day.
>
> Matthew
>
>
> On Fri, Jul 18, 2014 at 10:30 PM, Sarah Hoffmann <sarah.hoffmann at sosm.ch>
> wrote:
>
>> On Fri, Jul 18, 2014 at 10:40:37AM +0200, Matthew Grech wrote:
>> > Dear Sarah,
>> >
>> > I am performing some further tests on this, and have noticed that the
>> below
>> > Noticesare brought up during the osm2pgsql import:
>> >
>> > Using projection SRS 4326 (Latlong)
>> > NOTICE: table "place" does not exist, skipping
>> > NOTICE: type "keyvalue" does not exist, skipping
>> > NOTICE: type "wordscore" does not exist, skipping
>> > NOTICE: type "stringlanguagetype" does not exist, skipping
>> > NOTICE: type "keyvaluetype" does not exist, skipping
>> > NOTICE: function get_connected_ways(pg_catalog.int4[]) does not exist,
>> > skipping
>> >
>> > Should I be concerned, especially the notice about the place table?
>>
>> Those are normal and can be savely ignored. What happens is that osm2pgsql
>> tries to delete any old tables that might still be in your database,
>> realises
>> that they are not there and skips the deletion command while emitting
>> that notice.
>>
>> Sarah
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/geocoding/attachments/20140719/5beeb4bb/attachment-0001.html>
-------------- next part --------------
root at pi:/usr/local/src/nominatim/Nominatim-2.2.0# ./utils/setup.php --osmosis-init
WARNING: resetting threads to 1
19-Jul-2014 08:05:36 org.openstreetmap.osmosis.core.Osmosis run
INFO: Osmosis Version 0.43.1
19-Jul-2014 08:05:43 org.openstreetmap.osmosis.core.Osmosis run
INFO: Preparing pipeline.
19-Jul-2014 08:05:43 org.openstreetmap.osmosis.core.Osmosis run
INFO: Launching pipeline execution.
19-Jul-2014 08:05:43 org.openstreetmap.osmosis.core.Osmosis run
INFO: Pipeline executing, waiting for completion.
19-Jul-2014 08:05:43 org.openstreetmap.osmosis.core.Osmosis run
INFO: Pipeline complete.
19-Jul-2014 08:05:43 org.openstreetmap.osmosis.core.Osmosis run
INFO: Total execution time: 6796 milliseconds.
Getting state file: http://download.geofabrik.de/europe/malta-updates//000/000/495.state.txt
Updating DB status
root at pi:/usr/local/src/nominatim/Nominatim-2.2.0# ./utils/setup.php --create-functions --enable-diff-updates
WARNING: resetting threads to 1
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
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
root at pi:/usr/local/src/nominatim/Nominatim-2.2.0#
root at pi:/usr/local/src/nominatim/Nominatim-2.2.0#
root at pi:/usr/local/src/nominatim/Nominatim-2.2.0#
root at pi:/usr/local/src/nominatim/Nominatim-2.2.0# ./utils/update.php --import-osmosis-all --no-npi
WARNING: resetting cache memory to 287
2014-07-19 08:08:50 Replication Delay is 86400
/usr/local/src/osmosis/bin/osmosis --read-replication-interval workingDirectory=/usr/local/src/nominatim/Nominatim-2.2.0/settings --simplify-change --write-xml-change /usr/local/src/nominatim/Nominatim-2.2.0/data/osmosischange.osc
19-Jul-2014 08:08:53 org.openstreetmap.osmosis.core.Osmosis run
INFO: Osmosis Version 0.43.1
19-Jul-2014 08:08:59 org.openstreetmap.osmosis.core.Osmosis run
INFO: Preparing pipeline.
19-Jul-2014 08:09:00 org.openstreetmap.osmosis.core.Osmosis run
INFO: Launching pipeline execution.
19-Jul-2014 08:09:00 org.openstreetmap.osmosis.core.Osmosis run
INFO: Pipeline executing, waiting for completion.
19-Jul-2014 08:09:03 org.openstreetmap.osmosis.core.Osmosis run
INFO: Pipeline complete.
19-Jul-2014 08:09:03 org.openstreetmap.osmosis.core.Osmosis run
INFO: Total execution time: 9972 milliseconds.
string(121) "INSERT INTO import_osmosis_log values ('2014-07-18T20:22:02Z',8246,'2014-07-19 08:08:50','2014-07-19 08:09:03','osmosis')"
2014-07-19 08:09:03 Completed osmosis step for 2014-07-18T20:22:02Z in 0.22 minutes
/usr/local/src/nominatim/Nominatim-2.2.0/osm2pgsql/osm2pgsql -klas -C 287 -O gazetteer -d nominatim -P 5432 /usr/local/src/nominatim/Nominatim-2.2.0/data/osmosischange.osc
osm2pgsql SVN version 0.85.0 (64bit id space)
Using projection SRS 4326 (Latlong)
Allocating memory for sparse node cache
Node-cache: cache=287MB, maxblocks=0*36736, allocation method=1
Mid: pgsql, scale=10000000 cache=287
Setting up table: planet_osm_nodes
Setting up table: planet_osm_ways
Setting up table: planet_osm_rels
Reading in file: /usr/local/src/nominatim/Nominatim-2.2.0/data/osmosischange.osc
Processing: Node(0k 0.0k/s) Way(0k 0.01k/s) Relation(0 0.00/s) parse time: 1s
Node stats: total(11), max(2836278529) in 1s
Way stats: total(14), max(284776087) in 0s
Relation stats: total(0), max(0) in 0s
node cache: stored: 3(100.00%), storage efficiency: 50.00% (dense blocks: 0, sparse nodes: 43375496), hit rate: 0.00%
Stopping table: planet_osm_ways
Stopping table: planet_osm_rels
Stopping table: planet_osm_nodes
Stopped table: planet_osm_rels in 0s
Stopped table: planet_osm_nodes in 0s
Stopped table: planet_osm_ways in 0s
Osm2pgsql took 3s overall
string(123) "INSERT INTO import_osmosis_log values ('2014-07-18T20:22:02Z',8246,'2014-07-19 08:09:03','2014-07-19 08:09:06','osm2pgsql')"
2014-07-19 08:09:06 Completed osm2pgsql step for 2014-07-18T20:22:02Z in 0.05 minutes
/usr/local/src/nominatim/Nominatim-2.2.0/nominatim/nominatim -i -d nominatim -P 5432 -t 1
nominatim version 2.2
Starting indexing rank (0 to 30) using 1 threads
Starting rank 0
Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 1
Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 2
Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 3
Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 4
Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 5
Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 6
Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 7
Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 8
Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 9
Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 10
Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 11
Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 12
Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 13
Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 14
Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 15
Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 16
Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 17
Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 18
Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 19
Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 20
Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 21
Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 22
Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 23
Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 24
Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 25
Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 26
Done 1 in 1 @ 1.000000 per second - Rank 26 ETA (seconds): 4.000000
Slow place_id 114163
Done 5 in 3 @ 1.666667 per second - ETA (seconds): 0.000000
Done 5 in 3 @ 1.666667 per second - FINISHED
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
Slow place_id 153967
Done 5 in 2 @ 2.500000 per second - ETA (seconds): 0.000000
Done 5 in 2 @ 2.500000 per second - FINISHED
string(119) "INSERT INTO import_osmosis_log values ('2014-07-18T20:22:02Z',8246,'2014-07-19 08:09:06','2014-07-19 08:09:11','index')"
2014-07-19 08:09:11 Completed index step for 2014-07-18T20:22:02Z in 0.08 minutes
2014-07-19 08:09:11 Completed all for 2014-07-18T20:22:02Z in 0.35 minutes
2014-07-19 08:09:11 Sleeping 43971 seconds
More information about the Geocoding
mailing list