|
Can anyone help I set up a tile server, and imported the british-isles-latest.osm.pbf 10th Aug 2019, then starting doing the hour updates. It was working fine until it got to the following update 3624820, and then gave the error below Any one help me. Allocating memory for dense node cache Allocating dense node cache in one big chunk Allocating memory for sparse node cache Sharing dense sparse Node-cache: cache=800MB, maxblocks=12800*65536, allocation method=11 Mid: pgsql, cache=800 Using built-in tag processing pipeline Using projection SRS 3857 (Spherical Mercator) Setting up table: planet_osm_point Setting up table: planet_osm_line Setting up table: planet_osm_polygon Setting up table: planet_osm_roads Reading in file: /var/lib/mod_tile/changes.osc.gz Using XML parser. Processing: Node(1k 0.7k/s) Way(2k 1.35k/s) Relation(10 10.00/s) parse time: 4s Node stats: total(1373), max(6705113729) in 2s Way stats: total(2701), max(713278169) in 2s Relation stats: total(139), max(9912327) in 0s DB writer thread failed due to ERROR: result COPY_END for planet_osm_point failed: ERROR: invalid input syntax for integer: "0,1" CONTEXT: COPY planet_osm_point, line 9, column layer: "0,1" |
NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- 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: 20 Aug '19, 15:05
question was seen: 1,949 times
last updated: 27 Aug '19, 09:11
Related questions
NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum
Further to this error, I have located the lines that result in the error.
Can anyone explain what might be wrong?
DEBUG Worker thred - COPY -COPY planet_osm_point(osm_id,"access","addr:housename","addr:housenumber","addr:interpolation","admin_level","aerialway","aeroway","amenity","area","barrier","bicycle","brand","bridge","boundary","building","capital","construction","covered","culvert","cutting","denomination","disused","ele","embankment","foot","generator:source","harbour","highway","historic","horse","intermittent","junction","landuse","layer","leisure","lock","man_made","military","motorcar","name","natural","office","oneway","operator","place","population","power","power_source","public_transport","railway","ref","religion","route","service","shop","sport","surface","toll","tourism","tower:type","tunnel","water","waterway","wetland","width","wood","z_order",way) FROM STDIN Write Complete
DEBUG Worker thred - SYNC - DEBUG db_copy_thread_t::db_copy_thread_t DB writer thread failed due to ERROR: result COPY_END for planet_osm_point failed: ERROR: invalid input syntax for integer: "0,1" CONTEXT: COPY planet_osm_point, line 9, column layer: "0,1"