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

I have successfully installed nominatim ver 3.0.1 on centOs 7.3. Set CONST_Pyosmium_Binary, CONST_Replication_Url, CONST_Replication_Update_Interval and CONST_Replication_Recheck_Interval. When I am trying to update manually via command ./utils/update.php --init-updates I am getting error:

PHP Warning: pg_query(): Query failed: ERROR: column "none" does not exist LINE 1: ...quence_id, indexed) VALUES('2017-08-21T20:34:32Z' ,None, true... in <nominatim home="">/Nominatim/build/utils/update.php on line 87 ERROR: Could not enter sequence into database. Could not enter sequence into database.

How to deal with it?

And two more little questions: 1) How to know datetime of my last update? 2) When database will be updated if I have CONST_Replication_Update_Interval = 86400? Is nominatim trying to update after system startup or since 86400 from startup or since wich event?

Thanks for your attention.

asked 28 Aug '17, 13:46

gsv91's gravatar image

gsv91
31335
accept rate: 0%


For some reason, pyosmium could not correctly connect to the server with the update. It should return a proper error message in that case. If you see this message about 'None' then you have found a bug in the update code. Please report it over on github.

Nominatim determines the appropriate date where to start the updates from the data you imported. If the initialisation runs through, it reports it at the end of the process. The date is also reported after each update start. Furthermore, you can check the current status anytime in the import_status table in your database.

The update interval is computed from the last time the database was updated. You can safely shut down your system for a while and it will pick up exactly where it left.

permanent link

answered 28 Aug '17, 20:44

lonvia's gravatar image

lonvia
6.2k25789
accept rate: 40%

My import_status table is empty. With what it can be connected?

(29 Aug '17, 09:23) gsv91
1

import_status was truncated by the init-updates command before it errored out. It will be filled appropriately again once init-updates has run successfully.

(29 Aug '17, 19:40) lonvia

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
×199

question asked: 28 Aug '17, 13:46

question was seen: 1,889 times

last updated: 29 Aug '17, 19:40

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