expaso/hassos-addon-timescaledb

Automatic updater is broken - missing libraries

Closed this issue · 6 comments

Here is the relevant error segment, as the addon attempts to upgrade my databases:

Your installation references loadable libraries that are missing from the
new installation.  You can add these libraries to the new installation,
or remove the functions using them from the old installation.  A list of
problem libraries is in the file:
    loadable_libraries.txt
Failure, exiting
[12:04:20] ERROR: PostgreSQL could not upgrade! Please inspect any errors in the lines above!
[12:04:20] ERROR: Upgrade was not succesfull.

I don't know how to get that file out of the addon, but with a little direction I could dig it out

Hi @derekw023 ,

Can you please check that you have all timescale-databases listed in the "timescale-enabled" section of the addon configuration?

image

This is my whole config:
image

I have 2 other databases I created with psql commands, but I never put them in the timescale_enabled array, so timescale extensions should not be enabled on them

Hi @derekw023 ,

Yould you please try to add those to this list?
I will launch an update soon which will auto-detect this, but for now it should get you past the upgrade process.

I added my other databases to that list and the update passed without issue! I'll leave it up to you to close this issue or leave it around to track for the next update. Thanks!

This (adding dsmrreader database to timescaled_enabled) before running the updateworked for me, after searching for a solution for months... thanks!

Hi @cyberjunky ! I am glad it worked!

This solution was the github issue all along #16 (comment)

If you ever run into trouble again, you can also reach me on Discord: https://discord.gg/SSdEdbAZ
I will be glad to help you out!