NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

Hi,

i'm doing a setup.php -all for a full planet.pbf, after all steps without errors(aparently) when i exec --index option appears this errors:

what's the meaning of these errors?


Starting rank 25 Done 19 in 0 @ 19.000000 per second - ETA (seconds): 2187.684326

Done 210 in 1 @ 210.000000 per second - ETA (seconds): 197.023804

Done 258 in 1 @ 258.000000 per second - ETA (seconds): 160.182175

index_placex: UPDATE failed: ERROR: relation "planet_osm_rels" does not exist

LINE 1: select * from planet_osm_rels where parts @> ARRAY[NEW.osm_i... ^ QUERY: select * from planet_osm_rels where parts @> ARRAY[NEW.osm_id::integer] and members @> ARRAY['n'||NEW.osm_id]

CONTEXT: PL/pgSQL function "placex_update" line 112 at FOR over SELECT rows

index_placex: UPDATE failed: ERROR: relation "planet_osm_rels" does not exist

LINE 1: select * from planet_osm_rels where parts @> ARRAY[NEW.osm_i...

.... ... .... same error

asked 03 Mar '12, 02:27

luup2k's gravatar image

luup2k
26113
accept rate: 0%

edited 03 Mar '12, 09:00

Frederik%20Ramm's gravatar image

Frederik Ramm ♦
82.5k927201273

i'm using setup.php script


passthru($osm2pgsql.' -lsc -O gazetteer -C 9000 --hstore -d '.$aDSNInfo['database'].' '.$aCMDResult['osm-file']);


additional: i'm testing with other small country ( belgium.osm.pbf ) and with this country i have other fail... but too in index proceseing and related with planet_osm_ tables


QUERY: select nodes from planet_osm_ways where id = wayid
CONTEXT: PL/pgSQL function "create_interpolation" line 26 at SQL statement
PL/pgSQL function "placex_update" line 57 at assignment
Done 4 in 50 @ 0.080000 per second - Rank 28 ETA (seconds): 28425.000000
index_placex: UPDATE failed: ERROR: relation "planet_osm_ways" does not exist
LINE 1: select nodes from planet_osm_ways where id = wayid


(03 Mar '12, 09:59) luup2k

These kind of installation problems should better be discussed on one of the developer mailing lists. For Nominatim, you can use either the geocoding mailing list or the more general dev list.

permanent link

answered 09 Mar '12, 22:39

lonvia's gravatar image

lonvia
6.2k25789
accept rate: 40%

I politely disagree. If you can figure out, it should be here so when other people have the same error, they can google it.

(01 May '12, 23:25) rafamvc

I had the same problem. It turns out I was using osm2pgsql provided by my distro and not the one from SVN. Is this your case as well?

permanent link

answered 02 May '12, 18:58

Norm1's gravatar image

Norm1
126458
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×689
×61
×23

question asked: 03 Mar '12, 02:27

question was seen: 5,785 times

last updated: 02 May '12, 18:58

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum