I am trying to update only one country (Brazil), but when I follow the instructions and modify the local.php url to http://download.geofabrik.de/south-america/brazil-updates/ I get an error when I run

 ./utils/setup.php --osmosis-init
 ./utils/setup.php --create-functions --enable-diff-updates
 ./utils/update.php --import-osmosis-all --no-npi

Allocating dense node cache in one big chunk
Allocating memory for sparse node cache
Sharing dense sparse
Node-cache: cache=2000MB, maxblocks=256000*8192, allocation method=11
Mid: pgsql, scale=10000000 cache=2000
Setting up table: planet_osm_nodes
Setting up table: planet_osm_ways
Setting up table: planet_osm_rels

Reading in file: /home/osm/Nominatim-2.5.0/data/osmosischange.osc
Using XML parser.
Processing: Node(112k 2.6k/s) Way(7k 0.87k/s) Relation(160 40.00/s)node cache: stored: 109400(100.00%), storage efficiency: 53.83% (dense blocks: 53, sparse nodes: 74475), hit rate: 24.99%
Osm2pgsql failed due to ERROR: insert_rel failed: ERROR:  value "37945" is out of range for type smallint

I need to update only Brazil.

asked 16 Mar, 18:38

Paulo%20G%C3%BAbio's gravatar image

Paulo Gúbio
accept rate: 0%

edited 16 Mar, 19:08

There was bad (well too much) data inserted into OpenStreetMap which makes osm2pgsql fail which affected lots of users of Nominatim who do hourly/minutely update. I think those with daily updates were not affected. Have a look at https://lists.openstreetmap.org/pipermail/geocoding/2017-March/001859.html

permanent link

answered 16 Mar, 22:16

mtmail's gravatar image

accept rate: 23%

Yes, that looks like the same osm2pgsql error that I saw when updating a rendering DB.

(16 Mar, 22:24) SomeoneElse ♦
Your answer
toggle preview

Follow this question

By Email:

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



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:


question asked: 16 Mar, 18:38

question was seen: 81 times

last updated: 16 Mar, 22:24

powered by OSQA