Broken docker image

[itsnotv]

The following latest images have libssl error at startup.

timescale/timescaledb:latest-pg14 timescale/timescaledb:2.9.0-pg14

timescaledb  | 2022-12-15 18:45:35.806 UTC [22] ERROR:  could not load library "/usr/local/lib/postgresql/timescaledb-2.8.0.so": Error loading shared library libssl.so.1.1: No such file or directory (needed by /usr/local/lib/postgresql/timescaledb-2.8.0.so)
timescaledb  | 2022-12-15 18:45:35.807 UTC [1] LOG:  background worker "TimescaleDB Background Worker Scheduler" (PID 22) exited with exit code 1

Downgrading to timescale/timescaledb:2.8.1-pg14 works.

[swiffer]

yep, same here - upgrading the docker container itself worked fine for me but cannot query the server:

SQLSTATE[58P01]: Undefined file: 7 ERROR: could not load library "/usr/local/lib/postgresql/timescaledb-2.6.0.so": Error loading shared library libssl.so.1.1: No such file or directory (needed by /usr/local/lib/postgresql/timescaledb-2.6.0.so)

[swiffer]

https://github.com/timescale/timescaledb-docker/commit/786d165c9c16df7527d4554a2e2c58392005b73f

this seems to not work anymore in v2.x era - also the line 31 is missing a -1 near end of the line:

https://github.com/timescale/timescaledb-docker/commit/786d165c9c16df7527d4554a2e2c58392005b73f#diff-dd2c0eb6ea5cfc6c4bd4eac30934e2d5746747af48fef6da689e85b752f39557R31

87b2548c48d2:/# ls -la /usr/local/lib/postgresql/timescaledb timescaledb-2.5.0.so timescaledb-2.6.1.so timescaledb-2.8.0.so timescaledb-tsl-2.5.1.so timescaledb-tsl-2.7.0.so timescaledb-tsl-2.8.1.so timescaledb-2.5.1.so timescaledb-2.7.0.so timescaledb-2.8.1.so timescaledb-tsl-2.5.2.so timescaledb-tsl-2.7.1.so timescaledb-tsl-2.9.0.so timescaledb-2.5.2.so timescaledb-2.7.1.so timescaledb-2.9.0.so timescaledb-tsl-2.6.0.so timescaledb-tsl-2.7.2.so timescaledb.so timescaledb-2.6.0.so timescaledb-2.7.2.so timescaledb-tsl-2.5.0.so timescaledb-tsl-2.6.1.so timescaledb-tsl-2.8.0.so

[ms1752]

Same issue with the timescale/timescaledb:latest-pg12 image (sha256 of bd126034e2ba22b77e0309847666d8a3691d4726fbf012d182cb022ae52d29d5):

2022-12-16 00:17:56.167 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)

[reinierpost]

We are getting the same error message onlatest-pg13 a.k.a. 2.9.0-pg13. 2.8.1-pg13 is fine. PostgreSQL starts up fine, the error only appears when issuing a query.

What does your release process for images look like?

[etricky]

I'm also having the same issue with the timescale/timescaledb:latest-pg14 after the latest docker image update. 2022-12-18 15:47:28.431 UTC [35] ERROR: could not load library "/usr/local/lib/postgresql/timescaledb-2.5.1.so": Error loading shared library libssl.so.1.1: No such file or directory (needed by /usr/local/lib/postgresql/timescaledb-2.5.1.so)

[cmvarmour]

same issue

[Eyald6]

Also same issue for latest-pg12

[swiffer]

latest-pg15 works - however i think PostgreSQL 15 support has been removed from the 2.9.0 Release notes

[g-langlois]

I have a very similar issue with 2.9.0-pg13. However in my case, it is happening when attempting to downgrade to 2.8.1 via ALTER EXTENSION timescaledb UPDATE TO '2.8.1;

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)

The image 2.8.1-pg13 is ok. I can work around it by installing myself the missing library into the container. apk add libssl1.1

[svenklemm]

Thank you for the bugreport, the 2.9.0 docker images should be fixed now and allow using previous timescaledb versions.