[Tile-serving] [openstreetmap/osm2pgsql] Osmosis --append command do nothing (#943)

[YuriiNskyi]

My working environment is `Ubuntu 18.04 LTS`.

I have successfully populated my database with initial Andorra's data.

Now I want to merge [latest update for Andorra](http://download.geofabrik.de/europe/andorra-updates/000/002/238.osc.gz).

Here's the script:

```
osm2pgsql --append -s -C 300 -G --hstore --style openstreetmap-carto.style --tag-transform-script openstreetmap-carto.lua -d gis -H localhost -U postgres -W /home/tileserver/osmosisworkingdir/238.osc.gz
```

Here's the output from script:

>Using lua based tag processing pipeline with script openstreetmap-carto.lua
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
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=300MB, maxblocks=4800*65536, allocation method=11
Mid: pgsql, cache=300
Setting up table: planet_osm_nodes
Setting up table: planet_osm_ways
Setting up table: planet_osm_rels

Reading in file: /home/tileserver/osmosisworkingdir/238Simplified.osc
Using XML parser.
  parse time: 0s
Node stats: total(1), max(1202464300) in 0s
Way stats: total(0), max(0) in 0s
Relation stats: total(0), max(0) in 0s
Committing transaction for planet_osm_point
Committing transaction for planet_osm_line
Committing transaction for planet_osm_polygon
Committing transaction for planet_osm_roads
Setting up table: planet_osm_nodes
Setting up table: planet_osm_ways
Setting up table: planet_osm_rels
Using lua based tag processing pipeline with script openstreetmap-carto.lua

Going over pending ways...
	1 ways are pending

Using 1 helper-processes
Finished processing 1 ways in 0 s

Committing transaction for planet_osm_point
Committing transaction for planet_osm_line
Committing transaction for planet_osm_polygon
Committing transaction for planet_osm_roads

Going over pending relations...
	20 relations are pending

Using 1 helper-processes
Finished processing 20 relations in 1 s

20 Pending relations took 1s at a rate of 20.00/s
Committing transaction for planet_osm_point
WARNING:  there is no transaction in progress
Committing transaction for planet_osm_line
WARNING:  there is no transaction in progress
Committing transaction for planet_osm_polygon
WARNING:  there is no transaction in progress
Committing transaction for planet_osm_roads
WARNING:  there is no transaction in progress
Stopping table: planet_osm_rels
Stopped table: planet_osm_rels in 0s
Completed planet_osm_roads
Completed planet_osm_polygon
Stopping table: planet_osm_ways
Stopped table: planet_osm_ways in 0s
Completed planet_osm_line
Completed planet_osm_point
Stopping table: planet_osm_nodes
Stopped table: planet_osm_nodes in 0s
node cache: stored: 1(100.00%), storage efficiency: 0.01% (dense blocks: 1, sparse nodes: 0), hit rate: 0.13%
Osm2pgsql took 1s overall

So, there is committing transaction for `planet_osm_point`, but, actually... where is that modification?

I expect these changes: point with id `1202464300` and tags `"ele"=>"2689", "name:ca"=>"Pic dels Tres Comtes", "name:fr"=>"Pic des Trois Comtes"` must have appended tags: `"name"=>"Pic dels Tres Comtes","natural"=>"peak"`.


-- 
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/943
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20190809/88f30255/attachment.html>