[Geocoding] Nominatim data import error: ERROR: DB Error: no such table

[Gabriel Rossetti]

On 07/15/2012 10:07 PM, datendelphin wrote:
> Hi
>
> Please insert
>
>   echo $osm2pgsql."\n";
>
> on line 132 in setup.php, just before passthru($osm2pgsql);
> Then we can see the commandline for osm2pgsql that is constructed.
>

Hi,

I tried that, here is what I get:

/opt/Nominatim/osm2pgsql/osm2pgsql -lsc -O gazetteer --hstore -C 217 -d 
nominatim /tmp/switzerland.osm

The whole output is:

SET
SET
SET
SET
CREATE TABLE
ALTER TABLE
Import
/opt/Nominatim/osm2pgsql/osm2pgsql -lsc -O gazetteer --hstore -C 217 -d 
nominatim /tmp/switzerland.osm
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
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=217MB, maxblocks=27777*8192, allocation method=11
Mid: pgsql, scale=10000000 cache=217
Setting up table: planet_osm_nodes
NOTICE:  table "planet_osm_nodes" does not exist, skipping
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"planet_osm_nodes_pkey" for table "planet_osm_nodes"
Setting up table: planet_osm_ways
NOTICE:  table "planet_osm_ways" does not exist, skipping
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"planet_osm_ways_pkey" for table "planet_osm_ways"
Setting up table: planet_osm_rels
NOTICE:  table "planet_osm_rels" does not exist, skipping
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"planet_osm_rels_pkey" for table "planet_osm_rels"

Reading in file: /tmp/switzerland.osm
Segmentation fault (core dumped)
ERROR: DB Error: no such table
DB Error: no such table

Thanks,
Gabriel
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/geocoding/attachments/20120717/1100a1e3/attachment.html>