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

[Gabriel Rossetti]

On 07/17/2012 11:45 PM, Gabriel Rossetti wrote:
> 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

I even just tried cloning Nominatim and building it again, same 
error...I then tried downloading the osm data in the pbf format (I have 
a machine with an older version on Nominatim that didn't work with the 
pbf file but did with the bz2 one, that is why I directly tried the bz2 
version this time) but it does the same thing...

Thanks,
Gabriel

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/geocoding/attachments/20120718/b057bebe/attachment.html>