[Tile-serving] [openstreetmap/osm2pgsql] --append is not working properly (data is deleted when it shouldn't) (#938)

[crnm21]

Hi lonvia,

thanks for reopening this.
Looking for the old missing polygons does not help as I cannot declare the exact diff update when it happened.

So I've just set up a test server again that will log all operations and diffs, so it will take some days until I may find new missing polygons but will have the data at hand to find the reason for lost polygons.

This is the initial import command line I'm using:

`sudo -u ${tileuser} osm2pgsql --slim -d ${dbname} --number-processes 8 --hstore --flat-nodes=/path/to/flatnodes.bin -C 64000 --style /path/to/openstreetmap-carto-4.24.1/openstreetmap-carto.style --tag-transform-script /path/to/openstreetmap-carto-4.24.1/openstreetmap-carto.lua /path/to/planet-200113.osm.pbf`

The import went thru without problems. I'm not using multi-geometry.

This following command line will be used for updates (date for first import, timestamp of planet-20113.osm.pbf is "2020-01-13T00:59:59Z", I'm going back one day.)

`osmupdate --day 2020-01-12T00:00:00Z $tmpfile && sudo -u ${tileuser} osm2pgsql --append --slim -d ${dbname} --number-processes 6 -C 64000 --hstore --flat-nodes=/path/to/flatnodes.bin --style /path/to/openstreetmap-carto-4.24.1/openstreetmap-carto.style --tag-transform-script /path/to/openstreetmap-carto-4.24.1/openstreetmap-carto.lua -e 6-19 -o $expirefile $tmpfile`

I'm using the normal openstreetmap-carto mapnik standard style in Version 4.24.1., so the Lua script can be found at [https://github.com/gravitystorm/openstreetmap-carto/blob/master/scripts/lua/openstreetmap-carto.lua](https://github.com/gravitystorm/openstreetmap-carto/blob/master/scripts/lua/openstreetmap-carto.lua). LuaJIT is not used.




-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/938#issuecomment-578797201
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20200127/f0485313/attachment.htm>