[Tile-serving] [openstreetmap/osm2pgsql] get_wkb failed: ERROR: prepared statement "get_wkb" does not exist (#924)

[Goncalo Oliveira]

I'm seeing this with version 1.9.2 with PostGIS 3.3.

```
osm2pgsql version 1.9.2
Build: Release
Compiled using the following library versions:
Libosmium 2.19.0
Proj [API 6] 9.3.0
Lua 5.1.4 (LuaJIT 2.1.0-beta3)
```

Arguments used: `--create --slim -C 2048 -v --hstore-all`

The logs

```
2023-09-11 14:30:26  osm2pgsql version 1.9.2
2023-09-11 14:30:26  [00] Database version: 15.4
2023-09-11 14:30:26  [00] PostGIS version: 3.3
2023-09-11 14:30:27  [00] Found properties table 'osm2pgsql_properties': false.
2023-09-11 14:30:27  [00] Storing properties to table '"public"."osm2pgsql_properties"'.
2023-09-11 14:30:27  [00]   Storing attributes='false'
2023-09-11 14:30:27  [00]   Storing db_format='1'
2023-09-11 14:30:27  [00]   Storing flat_node_file=''
2023-09-11 14:30:27  [00]   Storing output='pgsql'
2023-09-11 14:30:27  [00]   Storing prefix='planet_osm'
2023-09-11 14:30:27  [00]   Storing style='/opt/homebrew/Cellar/osm2pgsql/1.9.2/share/osm2pgsql/default.style'
2023-09-11 14:30:27  [00]   Storing updatable='true'
2023-09-11 14:30:28  [00]   Storing version='1.9.2'
2023-09-11 14:30:28  [00] Reading file: data.osm.pbf
2023-09-11 14:30:28  [00] Started pool with 4 threads.
2023-09-11 14:30:28  [00] Mid: pgsql, cache=2048, db_format=1
2023-09-11 14:30:28  [00] Setting up table 'planet_osm_nodes'
NOTICE:  table "planet_osm_nodes" does not exist, skipping
2023-09-11 14:30:28  [00] Setting up table 'planet_osm_ways'
NOTICE:  table "planet_osm_ways" does not exist, skipping
2023-09-11 14:30:28  [00] Setting up table 'planet_osm_rels'
NOTICE:  table "planet_osm_rels" does not exist, skipping
2023-09-11 14:30:29  [00] Using projection SRS 3857 (Spherical Mercator)
2023-09-11 14:30:29  [00] Using built-in tag transformations
2023-09-11 14:30:29  [00] Middle 'pgsql' options:
2023-09-11 14:30:29  [00]   nodes: true
2023-09-11 14:30:29  [00]   untagged_nodes: true
2023-09-11 14:30:29  [00]   db_format: 1
2023-09-11 14:30:29  [00]   use_flat_node_file: false
2023-09-11 14:30:29  [00]   way_node_index_id_shift: 5
2023-09-11 14:30:29  [00]   with_attributes: false
2023-09-11 14:30:30  [00] Setting up table 'planet_osm_point'
NOTICE:  table "planet_osm_point" does not exist, skipping
NOTICE:  table "planet_osm_point_tmp" does not exist, skipping
2023-09-11 14:30:31  [00] Setting up table 'planet_osm_line'
NOTICE:  table "planet_osm_line" does not exist, skipping
NOTICE:  table "planet_osm_line_tmp" does not exist, skipping
2023-09-11 14:30:31  [00] ERROR: Database error: ERROR:  prepared statement "get_wkb" already exists
```

Postgres is hosted with [neon](https://neon.tech/).



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

Message ID: <openstreetmap/osm2pgsql/issues/924/1713899786 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20230911/2a770fe8/attachment.htm>