[Tile-serving] [openstreetmap/osm2pgsql] Osm2pgsql failed due to ERROR: get_node_list failed: ERROR: relation "planet_osm_nodes" does not exist at character 59 (Issue #1690)

[raphael10-collab]

<!-- Please don't use screenshots. Copy and paste the *text* output here if that's needed for context. -->

## What version of osm2pgsql are you using?

<!-- Paste output of `osm2pgsql --version` here. Please use the [latest
release](https://osm2pgsql.org/releases/) of osm2pgsql if at all
possible. -->

    raphy at pc:~$ osm2pgsql --version
    osm2pgsql version 1.2.1 (64 bit id space)
    
    Compiled using the following library versions:
    Libosmium 2.15.4
    Lua 5.2.4



## What operating system and PostgreSQL/PostGIS version are you using?

<!-- Also what Linux distribution if applicable, OS version? -->

Ubuntu 20.04 Desktop


## Tell us something about your system

<!-- How much RAM do you have, how many CPUs, bare metal or cloud setup? -->
    32 Gb RAM
    8 CPUs

## What did you do exactly?

<!-- Please provide the command(s) you used including all options etc. Include
links to input files. -->


    raphy at pc:~$ osm2pgsql -d gis --create --slim  -G --hstore --tag-transform-script ./OSM/openstreetmap-carto/openstreetmap-carto.lua \
    > -C 5000 --number-processes 6 \
    > -S ./OSM/openstreetmap-carto/openstreetmap-carto.style ./OSM/data/europe-latest.osm.pbf 
    > -S ./OSM/openstreetmap-carto/openstreetmap-carto.style ./OSM/data/europe-latest.osm.pbf 
    osm2pgsql version 1.2.1 (64 bit id space)
    
    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=5000MB, maxblocks=80000*65536, allocation method=11
    Mid: pgsql, cache=5000
    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 ./OSM/openstreetmap-carto/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
    
    Reading in file: ./OSM/data/europe-latest.osm.pbf
    Using PBF parser.
    Processing: Node(2990243k 364.2k/s) Way(3702k 1.79k/s) Relation(0 0.00/s)node cache: stored: 462265405(15.46%), storage efficiency: 70.54% (dense blocks: 41824, sparse nodes: 156372353), hit rate: 36.70%
    Osm2pgsql failed due to ERROR: get_node_list failed: ERROR:  relation "planet_osm_nodes" does not exist at character 59
    (7)
    Arguments were: {1734096827,1734096831}, 


## What did you expect to happen?

<!-- Describe in detail what you expected the above would do. -->


## What did happen instead?

<!-- Please describe what happened and why you think this is wrong. Please include
(or link to, if it is too verbose) the log output. -->


## What did you do to try analyzing the problem?

    raphy at pc:/var/log/postgresql$ tail postgresql-12-main.log 
    2022-07-07 17:20:26.725 CEST [970] HINT:  Consider increasing the configuration parameter "max_wal_size".
    2022-07-07 17:20:55.580 CEST [970] LOG:  checkpoints are occurring too frequently (29 seconds apart)
    2022-07-07 17:20:55.580 CEST [970] HINT:  Consider increasing the configuration parameter "max_wal_size".
    2022-07-07 17:21:22.338 CEST [970] LOG:  checkpoints are occurring too frequently (27 seconds apart)
    2022-07-07 17:21:22.338 CEST [970] HINT:  Consider increasing the configuration parameter "max_wal_size".
    2022-07-07 17:21:49.906 CEST [970] LOG:  checkpoints are occurring too frequently (27 seconds apart)
    2022-07-07 17:21:49.906 CEST [970] HINT:  Consider increasing the configuration parameter "max_wal_size".
    2022-07-07 17:56:37.165 CEST [76850] raphy at gis ERROR:  relation "planet_osm_nodes" does not exist at character 59
    2022-07-07 17:56:37.165 CEST [76850] raphy at gis STATEMENT:  PREPARE get_node_list(int8[]) AS SELECT id, lat, lon FROM planet_osm_nodes WHERE id = ANY($1::int8[]);


<!-- Describe what steps you already did to try analyzing the problem before
reporting. -->


-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/1690
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/osm2pgsql/issues/1690 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20220707/33bb38cd/attachment.htm>