timescale / timescaledb-docker

Release Docker builds of TimescaleDB
Apache License 2.0
286 stars 126 forks source link

Missing `libssl.so.1.1` needed by `timescaledb-2.8.1.so` in `timescale/timescaledb:2.15.2-pg14` (trying to upgrade) #260

Open jedwards1211 opened 2 weeks ago

jedwards1211 commented 2 weeks ago

I think #200 has reoccurred...

I'm trying to upgrade from timescale/timescaledb:2.8.1-pg14 to timescale/timescaledb:2.15.2-pg14 (and thereafter to 2.15.2-pg16) but it's missing and old libssl.so.1.1 version needed by timescaledb-2.8.1.so:

postgres             | 2024-06-18 18:46:18.647 UTC [27] LOG:  TimescaleDB background worker launcher connected to shared catalogs
postgres             | 2024-06-18 18:46:18.674 UTC [30] ERROR:  could not load library "/usr/local/lib/postgresql/timescaledb-2.8.1.so": Error loading shared library libssl.so.1.1: No such file or directory (needed by /usr/local/lib/postgresql/timescaledb-2.8.1.so)

I assume since timescaledb-2.8.1.so is present in the image it's supposed to be possible to run it, so this must be a bug in the image.

libssl.so.1.1 is present in 2.15.0-pg14 and 2.15.1-pg14, but not 2.15.2-pg14.

SharkWipf commented 1 week ago

Can confirm I'm also getting this, for latest-pg14 which should be 2.15.2-pg14, but not for 2.15.1-pg14 which runs fine.

ToonSpinTUe commented 1 day ago

I have the same issue with latest but not with 2.15.2-pg13.

This problem was introduced in commit 20e456c324d25fc64f7d6db99351ec011b652cef which casually removes Postgres 13 support - perhaps that's why libssl was removed in that commit. Perhaps Postgres 14 also requires libssl?