Opened 4 years ago

Closed 4 years ago

#5328 closed defect (fixed)

Error during initial import of the data

Reported by: sylvain.ballaud.externe@… Owned by: geocoding@…
Priority: blocker Milestone:
Component: nominatim Version:
Keywords: Cc: sylvain.ballaud.externe@…

Description

Hi,

I installed Nominatim 2.4 on a Red Hat Enterprise Linux 6.6. I also installed PostgreSQL 8.4.20 and PostGIS 1.5.3-1. The version of Apache is 2.2.15 and PHP is 5.3.3.

My problem is when i try to import data (for example a sub region in France called Ile-de-France on http://download.geofabrik.de/), I have this error when i launched it with the user postgres :

-bash-4.1$ /soft/nominatim/utils/setup.php --osm-file /soft/nominatim/data/ile-de-france-latest.osm.pbf --all 2>&1 | tee setup.log
..............................
CREATE TABLE
ERROR:  syntax error at or near ")"
LINE 1: create type wikipedia_article_match as ()
                                                ^
ERROR: pgsql returned with error code (3)
pgsql returned with error code (3)

When i commented the line "create type wikipedia_article_match as ()" on the setup.php file or when i changed this line with "create type wikipedia_article_match", the import continued but I have a other error :

WARNING:  nonstandard use of escape in a string literal
LINE 1: SELECT   $1  ~ '^\d+$'
                       ^
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
QUERY:  SELECT   $1  ~ '^\d+$'
CONTEXT:  SQL statement in PL/PgSQL function "create_interpolation" near line 27
ERROR:  syntax error at or near "$1"
LINE 1: insert into placex (place_id,  $1 , osm_type, osm_id, class,...
                                       ^
QUERY:  insert into placex (place_id,  $1 , osm_type, osm_id, class, type, admin_level, housenumber, postcode,  $2 , parent_place_id, rank_address, rank_search, indexed_status, indexed_date,  $3 , calculated_country_code, centroid, geometry) values (nextval('seq_place'),  $1 , 'W',  $4 , 'place', 'address',  $5 ,  $6 , coalesce( $7 ,  $8 ),  $9 ,  $10 , 30, 30, 0, now(),  $3 ,  $2 ,  $11 ,  $11 )
CONTEXT:  SQL statement in PL/PgSQL function "create_interpolation" near line 104
ERROR: pgsql returned with error code (3)
pgsql returned with error code (3)

IS-it a problem about a version of one composant ?

Thanks for help.

Change History (1)

comment:1 Changed 4 years ago by Sarah Hoffmann

Resolution: fixed
Status: newclosed

Postgres 8.4 is no longer supported, please use at least 9.0, preferably 9.3 or 9.4.

For CentOS/RedHat, there are detailed installation instructions at: http://wiki.openstreetmap.org/wiki/Nominatim/Installation/CentOS

Note: See TracTickets for help on using tickets.