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

[Gabriel]

On 07/16/2012 11:13 PM, Gabriel Rossetti wrote:
> When I saw your msg I though: "darn I hope that is not it!", but it 
> looks like it is readable. I realized while doing that that I am low 
> on disk space though, that may be the issue. If it is I think the 
> error should be a bit more explicit. Let me try to free up some more 
> space and try again.
>
> Gabriel
>
> On 07/15/2012 10:01 PM, Brian Quinion wrote:
>> On 15 July 2012 20:43, Gabriel Rossetti 
>> <gabriel.rossetti at swissopt.ch> wrote:
>>> Yes, I am using the latest version, I followed those instructions. I 
>>> had
>>> added it (the osm2pgsql binary line) myself in the local.php file, 
>>> it does
>>> the same thing if I comment it out. Here is the command line I am using
>>> (logged in as the postgres user):
>>>
>>> ./utils/setup.php --osm-file switzerland.osm --all
>> Looking at the output I'm wondering if the user you are running the
>> above command as definitely has read access to the switzerland.osm
>> file.  Could you check?
>>
>> -- 
>>   Brian
>
>

Ok, I freed up space (about 15GB) and tried again, I get this now :

SET
SET
SET
SET
SET
SET
CREATE TABLE
ALTER TABLE
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
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=123MB, maxblocks=15745*8192, allocation method=11
Mid: pgsql, scale=10000000 cache=123
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
Segmentation fault (core dumped)
ERROR: DB Error: no such table
DB Error: no such table


I tried copying it to /tmp and changing the permissions to 777 (just in 
case) and tried again; it still doesn't work...

Thanks,
Gabriel