[Tile-serving] [openstreetmap/osm2pgsql] SQL command failed: ERROR: relation "pend_ways" does not exist after append (#1000)

tyomik-mnemonic notifications at github.com
Mon Nov 25 14:56:27 UTC 2019


Hi! 

I trying to append latest osm data to existing DB, using this:

`osm2pgsql -append -s --cache 14000 --proj 3857 -H  my.local -d osm -U osm -W -P 5432  russia-latest.osm.pbf
`
There is result (I didn't find `pend_ways` somewhere in osm2pgsql code):

```
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=14000MB, maxblocks=224000*65536, allocation method=11
Mid: pgsql, cache=14000
SQL command failed: ERROR:  relation "pend_ways" does not exist
LINE 1: PREPARE mark_ways_by_node(int8) AS select id from pend_ways ...
                                                          ^

Full query: PREPARE mark_ways_by_node(int8) AS select id from pend_ways WHERE nodes && ARRAY[$1];
PREPARE mark_ways_by_rel(int8) AS select id from pend_ways WHERE id IN (SELECT unnest(parts[way_off+1:rel_off]) FROM pend_rels WHERE id = $1);

node cache: stored: 0(-nan%), storage efficiency: -nan% (dense blocks: 0, sparse nodes: 0), hit rate: -nan%
```
What is this? I use osm2pgsql 1.2.0 (64 bit id space) on manjaro linux.

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


More information about the Tile-serving mailing list