[Geocoding] [OpenStreetMap] #5329: Button Search can't work on Web Interface

Thu Jul 9 07:43:11 UTC 2015

#5329: Button Search can't work on Web Interface
----------------------------------------+-------------------------------
  Reporter:  sylvain.ballaud.externe@…  |      Owner:  geocoding@…
      Type:  defect                     |     Status:  new
  Priority:  blocker                    |  Milestone:
 Component:  nominatim                  |    Version:
Resolution:                             |   Keywords:  nominatim, search
----------------------------------------+-------------------------------

Comment (by sylvain.ballaud.externe@…):

 Thank for the answer. I restart the PostgreSQL and Apache servers.

 When i check the status of the server through the PHP page, the server
 display "OK".

 When i look the apache logs, i have this :

 {{{
 [Thu Jul 09 08:42:51 2015] [error] [client xxx.xxx.xxx.xxx] File does not
 exist: /var/www/html/nominatim/favicon.ico
 [Thu Jul 09 08:42:51 2015] [error] [client xxx.xxx.xxx.xxx] File does not
 exist: /var/www/html/nominatim/favicon.ico
 [Thu Jul 09 08:42:51 2015] [error] [client xxx.xxx.xxx.xxx] File does not
 exist: /var/www/html/nominatim/favicon.ico
 [Thu Jul 09 08:43:13 2015] [error] [client xxx.xxx.xxx.xxx] PHP Warning:
 date(): It is not safe to rely on the system's timezone settings. You are
 *required* to use the date.timezone setting or the
 date_default_timezone_set() function. In case you used any of those
 methods and you are still getting this warning, you most likely misspelled
 the timezone identifier. We selected 'Europe/Berlin' for 'CEST/2.0/DST'
 instead in /soft/nominatim/lib/log.php on line 12
 [Thu Jul 09 08:43:13 2015] [error] [client xxx.xxx.xxx.xxx] PHP Warning:
 date(): It is not safe to rely on the system's timezone settings. You are
 *required* to use the date.timezone setting or the
 date_default_timezone_set() function. In case you used any of those
 methods and you are still getting this warning, you most likely misspelled
 the timezone identifier. We selected 'Europe/Berlin' for 'CEST/2.0/DST'
 instead in /soft/nominatim/lib/log.php on line 58
 }}}

 I don't think it's very serious. The postgreSQL logs is not very verbose :

 {{{
 LOG:  received fast shutdown request
 LOG:  aborting any active transactions
 LOG:  autovacuum launcher shutting down
 LOG:  shutting down
 LOG:  database system is shut down
 LOG:  database system was shut down at 2015-07-09 08:53:16 CEST
 LOG:  database system is ready to accept connections
 LOG:  autovacuum launcher started
 }}}

 But when i imported the PBF file, i have more errors on the database :

 {{{
 FATAL:  database "nominatim" does not exist
 WARNING:  => is deprecated as an operator name
 DETAIL:  This name may be disallowed altogether in future versions of
 PostgreSQL.
 ERROR:  role "mqmgr" does not exist
 STATEMENT:  ALTER TABLE public.us_postcode OWNER TO mqmgr;
 ERROR:  relation "query_log" does not exist at character 13
 STATEMENT:  insert into query_log values ('2015-07-07
 10:35:01.6937','','10.68.3.204')
 ERROR:  relation "new_query_log" does not exist at character 13
 STATEMENT:  insert into new_query_log
 (type,starttime,query,ipaddress,useragent,language,format) values
 ('search','2015-07-07 10:35:01.6937','','10.68.3.204','Mozilla/5.0
 (Windows NT 6.1; WOW64; rv:32.0) Gecko/20100101 Firefox/32.0','short_name
 :en-US,short_name:en,name:en-US,name:en,place_name:en-
 US,place_name:en,official_name:en-
 US,official_name:en,short_name,name,place_name,official_name,ref,type','')
 ERROR:  relation "import_status" does not exist at character 90
 STATEMENT:  select TO_CHAR(lastimportdate - '2
 minutes'::interval,'YYYY/MM/DD HH24:MI')||' GMT' from import_status limit
 1
 ERROR:  relation "query_log" does not exist at character 8
 STATEMENT:  update query_log set endtime = '2015-07-07 10:35:01.6982',
 results = 0 where starttime = '2015-07-07 10:35:01.6937' and ipaddress =
 '10.68.3.204' and query = ''
 ERROR:  relation "new_query_log" does not exist at character 8
 STATEMENT:  update new_query_log set endtime = '2015-07-07 10:35:01.6982',
 results = 0 where starttime = '2015-07-07 10:35:01.6937' and ipaddress =
 '10.68.3.204' and query = ''

 LOG:  unexpected EOF on client connection
 ERROR:  index "idx_placex_sector" does not exist
 STATEMENT:  drop index idx_placex_sector;
 ERROR:  sequence "seq_postcodes" does not exist
 STATEMENT:  DROP SEQUENCE seq_postcodes;
 ERROR:  table "import_polygon_error" does not exist
 STATEMENT:  drop table import_polygon_error;
 ERROR:  table "import_polygon_delete" does not exist
 STATEMENT:  drop table import_polygon_delete;
 ERROR:  sequence "file" does not exist
 STATEMENT:  drop sequence file;
 ERROR:  index "idx_osm_id" does not exist
 STATEMENT:  DROP INDEX public.idx_osm_id;

 ERROR:  constraint "pagelinks_pkey" of relation "wikipedia_article" does
 not exist
 STATEMENT:  ALTER TABLE ONLY public.wikipedia_article DROP CONSTRAINT
 pagelinks_pkey;

 ERROR:  role "brian" does not exist
 STATEMENT:  ALTER TABLE public.wikipedia_article OWNER TO brian;

 ERROR:  index "idx_wikipedia_redirect_from_title" does not exist
 STATEMENT:  DROP INDEX public.idx_wikipedia_redirect_from_title;

 ERROR:  role "brian" does not exist
 STATEMENT:  ALTER TABLE public.wikipedia_redirect OWNER TO brian;

 LOG:  sending cancel to blocking autovacuum PID 6075
 DETAIL:  Process 9234 waits for AccessExclusiveLock on relation 160000 of
 database 152621.
 STATEMENT:  DROP INDEX IF EXISTS idx_placex_rank_search;
 ERROR:  canceling autovacuum task
 CONTEXT:  automatic vacuum of table "nominatim.public.placex"
 }}}

 However, the import was a success.

 Regards.

--
Ticket URL: <https://trac.openstreetmap.org/ticket/5329#comment:2>
OpenStreetMap <http://www.openstreetmap.org/>
OpenStreetMap is a free editable map of the whole world