<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">On 07/20/2012 08:45 PM, datendelphin
wrote:<br>
</div>
<blockquote cite="mid:5009A738.7060607@osm.datendelphin.net"
type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
On 18.07.2012 00:17, Gabriel Rossetti wrote:
<blockquote cite="mid:5005E48E.4030205@swissopt.ch" type="cite"><big><small><font
face="Courier New">/opt/Nominatim/osm2pgsql/osm2pgsql -lsc
-O gazetteer --hstore -C 84 -d nominatim
/home/ubuntu/tmp/switzerland.osm.bz2<br>
Using projection SRS 4326 (Latlong)<br>
NOTICE: table "place" does not exist, skipping<br>
NOTICE: type "keyvalue" does not exist, skipping<br>
NOTICE: type "wordscore" does not exist, skipping<br>
NOTICE: type "stringlanguagetype" does not exist,
skipping<br>
NOTICE: type "keyvaluetype" does not exist, skipping<br>
NOTICE: function get_connected_ways(pg_catalog.int4[])
does not exist, skipping<br>
Allocating memory for dense node cache<br>
Allocating dense node cache in one big chunk<br>
Allocating memory for sparse node cache<br>
Sharing dense sparse<br>
Node-cache: cache=84MB, maxblocks=10753*8192, allocation
method=11<br>
Mid: pgsql, scale=10000000 cache=84<br>
Setting up table: planet_osm_nodes<br>
NOTICE: table "planet_osm_nodes" does not exist, skipping<br>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit
index "planet_osm_nodes_pkey" for table "planet_osm_nodes"<br>
Setting up table: planet_osm_ways<br>
NOTICE: table "planet_osm_ways" does not exist, skipping<br>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit
index "planet_osm_ways_pkey" for table "planet_osm_ways"<br>
Setting up table: planet_osm_rels<br>
NOTICE: table "planet_osm_rels" does not exist, skipping<br>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit
index "planet_osm_rels_pkey" for table "planet_osm_rels"<br>
<br>
Reading in file: /home/ubuntu/tmp/switzerland.osm.bz2<br>
Segmentation fault (core dumped)<br>
ERROR: DB Error: no such table<br>
DB Error: no such table</font></small></big></blockquote>
Hi<br>
<br>
So the problem above arises from a failed allocation. Osm2pgsql
allocates 1GB of memory (hard coded, see node-ram-cache.c:390)
which is not checked if the allocation succeeded.<br>
<br>
So that means for you: this ec2 instance has just too few memory
(only 600MB in total in the micro incarnation). There is the
osm2pgsql option --cache-strategy sparse, with which it works. But
that is not supported with the setup.php script (you could easily
add this option in setup.php on line 129, if you want to use it on
the tiny ec2)<br>
<br>
And I certainly can not recommend running nominatim on Amazons
cloud computing. Nominatim is too demanding with I/O and caching
and all to run on that infrastructure.<br>
<br>
Hope that explains it for you, even if it won't help you too much.<br>
<br>
Datendelphin<br>
<br>
<br>
</blockquote>
<br>
Hi Datendelphin,<br>
<br>
Thanks for looking into this. I see, I was using the Tiny version of
their VMs since they are free, so that I can test and dev on them
without being charged an arm and a leg. I will take into account
what you said and see if I can find something else, is there any
cloud service you would recommend for this? Again, than you for
looking into this and finding the issue.<br>
<br>
Thanks,<br>
Gabriel<br>
</body>
</html>