[Tile-serving] [osm2pgsql-dev/osm2pgsql] TLS issues with osm2pgsql-replication (Discussion #2273)

[Goncalo Oliveira]

Think I'm running into a different issue now... connecting through the connection pool, I'm getting a prepared statement error.

```bash
$ osm2pgsql-replication update --once -v
2024-12-10 11:19:55 [INFO]: Using replication service 'https://download.geofabrik.de/europe/united-kingdom-updates'.
2024-12-10 11:19:55 [DEBUG]: Starting new HTTPS connection (1): download.geofabrik.de:443
2024-12-10 11:19:55 [DEBUG]: https://download.geofabrik.de:443 "GET /europe/united-kingdom-updates/state.txt HTTP/1.1" 200 123
2024-12-10 11:19:55 [DEBUG]: Applying 1 sequence(s) (383 → 382), covering 6 hour(s) 23 minute(s) 20 second(s) (23000 sec) of changes (2024-12-09T14:57:21Z → 2024-12-09T21:20:41Z)
2024-12-10 11:19:55 [DEBUG]: Calling osm2pgsql with: /usr/bin/osm2pgsql --append --slim --prefix planet_osm /tmp/tmpwtpd0we7/osm2pgsql_diff.osc.gz
2024-12-10 11:19:55 [DEBUG]: Importing from sequence 382
2024-12-10 11:19:55 [DEBUG]: Starting new HTTPS connection (1): download.geofabrik.de:443
2024-12-10 11:19:55 [DEBUG]: https://download.geofabrik.de:443 "GET /europe/united-kingdom-updates/state.txt HTTP/1.1" 200 123
2024-12-10 11:19:55 [DEBUG]: Starting new HTTPS connection (1): download.geofabrik.de:443
2024-12-10 11:19:55 [DEBUG]: https://download.geofabrik.de:443 "GET /europe/united-kingdom-updates/000/000/383.osc.gz HTTP/1.1" 200 2905953
2024-12-10 11:19:56 [DEBUG]: Downloaded change 383. (498670 kB available in download buffer)
2024-12-10 11:19:57  osm2pgsql version 2.0.1
2024-12-10 11:19:57  Database version: 17.2
2024-12-10 11:19:57  PostGIS version: 3.5
2024-12-10 11:19:57  Loading properties from table '"public"."osm2pgsql_properties"'.
2024-12-10 11:19:57  Not using flat node file (same as on import).
2024-12-10 11:19:57  Using output 'flex' (same as on import).
2024-12-10 11:19:57  Using style file '/data/geocoder.lua' (same as on import).
2024-12-10 11:19:57  Storing properties to table '"public"."osm2pgsql_properties"'.
2024-12-10 11:19:59  Storing properties to table '"public"."osm2pgsql_properties"'.
2024-12-10 11:19:59  ERROR: Database error: ERROR:  prepared statement "set_property" already exist

2024-12-10 11:19:59 [CRITICAL]: Exception during execution: Command '['/usr/bin/osm2pgsql', '--append', '--slim', '--prefix', 'planet_osm', '/tmp/tmpwtpd0we7/osm2pgsql_diff.osc.gz']' returned non-zero exit status 1.
```

I tried deleting the "set_property" prepared statement manually, but the problem doesn't go away... Unsure if this could be related to #878.

I'll do further tests and reach out to Neon to see if I can gather more information, as it might not be an `osm2pgsql` issue.

-- 
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2273#discussioncomment-11519550
You are receiving this because you are subscribed to this thread.

Message ID: <osm2pgsql-dev/osm2pgsql/repo-discussions/2273/comments/11519550 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20241210/e0c6f64a/attachment-0001.htm>