[Tile-serving] [openstreetmap/osm2pgsql] Dropped ways on particular diff (#735)

[Paul Norman]

I turned on `PGSQL_DEBUG` and did an import with just first of the two nodes removed (log-2.txt) and the building created and just the second of the two removed (log-3.txt) and the building not created.

```diff
--- log-2b.txt	2017-04-12 12:12:17.635790955 -0700
+++ log-3b.txt	2017-04-12 12:12:23.403929622 -0700
@@ -63,7 +63,7 @@
 Executing: COPY planet_osm_rels FROM STDIN;
 
 
-Reading in file: changes-2391119-reduced-2.osc
+Reading in file: changes-2391119-reduced-3.osc
 Using XML parser.
 ExecPrepared: delete_node
 ExecPrepared: delete_node
@@ -182,25 +182,13 @@
 Executing: COPY buildings (osm_id,"name","names","building","levels","height","way_area",way) FROM STDIN
 
 Going over pending ways...
-	3 ways are pending
+	1 ways are pending
 
 Using 1 helper-processes
 ExecPrepared: get_way
-Executing: DELETE FROM buildings WHERE osm_id = 312476311
+Executing: DELETE FROM buildings WHERE osm_id = 85486005
 ExecPrepared: rels_using_way
-ExecPrepared: get_way
-Executing: DELETE FROM buildings WHERE osm_id = 127018391
-ExecPrepared: rels_using_way
-Executing: COPY buildings (osm_id,"name","names","building","levels","height","way_area",way) FROM STDIN
-ExecPrepared: get_way
-buildings>>> 127018391	Riverway Clubhouse	\N	yes	\N	\N	4179.95	0103000020110F00000100000011000000AEE1B17F2F1D6AC16F708F5512115841705539672D1D6AC19A3AF30F0E11584190D1D83E2C1D6AC1A5E2305610115841A53BD1882B1D6AC1BAA962E20E115841B3BB581D291D6AC1223C1DA21311584194F23643271D6AC192AE12DC0F115841C65F655E251D6AC1F073D99213115841E5288738271D6AC11F71E458171158419238E171271D6AC1A94896E816115841E1FF4328281D6AC171DE645C18115841FA4ABBE3231D6AC1FD6E03BC2011584139D733FC251D6AC12320A20125115841CE8BCF16281D6AC10DD215E120115841F6ED2E78291D6AC14C3DCEB12311584137F52A072E1D6AC17996FCBE1A1158411093CBA52C1D6AC1E3F344EE17115841AEE1B17F2F1D6AC16F708F5512115841
-
-Executing: DELETE FROM buildings WHERE osm_id = 127018391
-ExecPrepared: rels_using_way
-Executing: COPY buildings (osm_id,"name","names","building","levels","height","way_area",way) FROM STDIN
-
Finished processing 3 ways in 0 s
-
-buildings>>> 127018391	Riverway Clubhouse	\N	yes	\N	\N	4179.95	0103000020110F00000100000011000000AEE1B17F2F1D6AC16F708F5512115841705539672D1D6AC19A3AF30F0E11584190D1D83E2C1D6AC1A5E2305610115841A53BD1882B1D6AC1BAA962E20E115841B3BB581D291D6AC1223C1DA21311584194F23643271D6AC192AE12DC0F115841C65F655E251D6AC1F073D99213115841E5288738271D6AC11F71E458171158419238E171271D6AC1A94896E816115841E1FF4328281D6AC171DE645C18115841FA4ABBE3231D6AC1FD6E03BC2011584139D733FC251D6AC12320A20125115841CE8BCF16281D6AC10DD215E120115841F6ED2E78291D6AC14C3DCEB12311584137F52A072E1D6AC17996FCBE1A1158411093CBA52C1D6AC1E3F344EE17115841AEE1B17F2F1D6AC16F708F5512115841
+
Finished processing 1 ways in 0 s
 
 Committing transaction for buildings
 Executing: COMMIT
@@ -217,11 +205,11 @@
 Executing: COMMIT
 WARNING:  there is no transaction in progress
 Completed buildings
-Stopping table: planet_osm_nodes
-Stopped table: planet_osm_nodes in 0s
 Stopping table: planet_osm_ways
-Stopped table: planet_osm_ways in 0s
+Stopping table: planet_osm_nodes
 Stopping table: planet_osm_rels
+Stopped table: planet_osm_ways in 0s
+Stopped table: planet_osm_nodes in 0s
 Stopped table: planet_osm_rels in 0s
 node cache: stored: 17(100.00%), storage efficiency: 0.21% (dense blocks: 1, sparse nodes: 5), hit rate: 100.00%
```

The deleted block starting with `get_way` is the unexpected difference, the difference with 312476311 and 85486005 is expected.

So it looks like it isn't being put into pending in one case.

-- 
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/735#issuecomment-293679656
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20170412/a2d1ddff/attachment.html>