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

[Gabriel Rossetti]

On 07/17/2012 09:05 AM, Sarah Hoffmann wrote:
> On Tue, Jul 17, 2012 at 08:03:01AM +0200, Gabriel Rossetti wrote:
>> On 07/17/2012 07:59 AM, Datendelphin wrote:
>>>> Hi,
>>>>
>>>> I tried that, here is what I get:
>>>>
>>>> /opt/Nominatim/osm2pgsql/osm2pgsql -lsc -O gazetteer --hstore -C
>>>> 217 -d nominatim /tmp/switzerland.osm
>>> Hi
>>>
>>> Looks good, and I see finally osm2pgsql runs! (in your previous
>>> reports, it failed because of command line. What was it?)
>>>
>>> With the segmentation fault, I can't reproduce that. Which file ar
>>> you using?
>>> http://download.geofabrik.de/osm/europe/switzerland.osm.bz2?
>>>
>>> datendelphin
>> Hi, ok. I was running:
>>
>> ./utils/setup.php --osm-file switzerland.osm --all
>>
>> Yes, that is the file.
> It's possible your osm file is somehow broken. Can you download it
> again and try with the newer version. And I'm not sure if you are
> unpacking the file first. There is no need for that. Just use the
> packed osm.bz2 as is.
>
> If it still doesn't work, there might be a compilation problem with
> osm2pgsql. Please rerun ./configure in /opt/Nominatim and attach the
> complete output of that.
>
> Sarah

I tried downloading it twice, the second time I tried without 
decompressing it (although if it was broken it wouldn't decompress would 
it?) and it didn't work either:

...
SET
SET
SET
CREATE TABLE
ALTER TABLE
Import
/opt/Nominatim/osm2pgsql/osm2pgsql -lsc -O gazetteer --hstore -C 84 -d 
nominatim /home/ubuntu/tmp/switzerland.osm.bz2
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=84MB, maxblocks=10753*8192, allocation method=11
Mid: pgsql, scale=10000000 cache=84
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: /home/ubuntu/tmp/switzerland.osm.bz2
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/ede0632c/attachment.html>