[Talk-ca] Map rendering errors

[Paul Norman]

On 11/1/2015 5:27 AM, Bruno Remy wrote:
>
> By the evidence, this is a database problem in osm2pgsql 
> <http://wiki.openstreetmap.org/wiki/Databases_and_data_access_APIs#Osm2pgsql> 
> schema , witch is used by Mapnik's rendering process.
> The most probable hypothesis is : some old nodes and old ways still 
> exists in 'OldNode' and 'OldWay' tables, with the "visible" status as 
> 'true' instead of 'false'.
> See the shema for reference:
> http://wiki.openstreetmap.org/w/images/c/cd/RailsPortModels.png
>
> My suggested solution:
> Create a brand new collection of nodes with the position of "all 
> fantom nodes", and sending'them to the Tech tem of OSM. They'll be 
> able to run a query into the
> 'OldNode' and 'OldWay' tables and switch the "visible" status from 
> 'true' to 'false'.

Don't do this. The rendering database doesn't have OldNode or OldWay 
tables or a visible status. For that matter, the master apidb database 
doesn't have those tables either, it has ways and currentways tables.

This is normally where I'd give a solution, but I don't have one. It's 
an osm2pgsql bug, not a DB bug, but without a reproducible testcase and 
verification that the bug happens on recent versions, it becomes a 
significant effort to get anywhere.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk-ca/attachments/20151102/5c5d6e73/attachment.html>