<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
On 11/1/2015 5:27 AM, Bruno Remy wrote:<br>
<blockquote
cite="mid:CAND7SNZLufx2RX1hp1fC6R6pjh8Psc=saGjzfy9tyBdmMwFvow@mail.gmail.com"
type="cite">
<div><br>
</div>
<div>By the evidence, this is a database problem in <a
moz-do-not-send="true"
href="http://wiki.openstreetmap.org/wiki/Databases_and_data_access_APIs#Osm2pgsql">osm2pgsql</a>
schema , witch is used by Mapnik's rendering process.<br>
</div>
<div>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'.<br>
</div>
<div>See the shema for reference:<br>
<a moz-do-not-send="true"
href="http://wiki.openstreetmap.org/w/images/c/cd/RailsPortModels.png">http://wiki.openstreetmap.org/w/images/c/cd/RailsPortModels.png</a><br>
<br>
</div>
<div>My suggested solution:<br>
</div>
<div>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 <br>
</div>
<div> 'OldNode' and 'OldWay' tables and switch the "visible"
status from 'true' to 'false'.<br>
</div>
</blockquote>
<br>
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.<br>
<br>
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.<br>
</body>
</html>