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"

asked 20 Aug, 15:05

Karl_G's gravatar image

Karl_G
11112
accept rate: 0%

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"

(27 Aug, 09:11) Karl_G
Be the first one to answer this question!
toggle preview

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:

×232
×167
×1

question asked: 20 Aug, 15:05

question was seen: 844 times

last updated: 27 Aug, 09:11

powered by OSQA