So the server updates haven't worked for me in over a year

Server Version#:1.29.0.6209-9fa696df6-x86_64
Player Version#:

Logs:
Plex Media Server Logs_2022-09-15_12-38-36.zip (1.4 MB)

I’ve been stuck with the 32 bit windows(10) version 1.23.2.4656-85f0adf5b-x86 as the last working version for me for some reason. Every update following, including uninstall/reinstall of 64 bit version, have failed to keep the server running. Installs seem to go ok, then library isn’t recognized and server fails. If I uninstall, reboot, and reinstall the 1.23 version, then all works well. Am I missing something?

Sep 15, 2022 12:37:19.699 [8044] ERROR - Exception inside transaction (inside=1) (E:\jenkins\server\4163899823\Library\DatabaseMigrations.cpp:295): sqlite3_statement_backend::loadOne: database disk image is malformed
Sep 15, 2022 12:37:19.706 [8044] ERROR - Exception thrown during migrations, aborting: sqlite3_statement_backend::loadOne: database disk image is malformed

Your database is bad. Try repairing it. https://support.plex.tv/articles/repair-a-corrupted-database/

Integrity check says ok. Tried vacuum. Nothing else seemed to help recover. In the lovely process of re-adding my libraries after deleting the database. Hopefully all works after. I’m just a little confused on how it all works fine on the 1.23 version and not this one.

During version upgrades the database is upgraded too, depending on the type of damage you have it can continue to function, but because of the nature of the database upgrades be incompatible with those needed changes for the upgrade. Most of the time database corruption is discovered during an update.

Check to see the dates of your database backups. if it detected corruption it might not have made new backups, so there may be an old good DB still available you may be able to use to restore a database backup

So far 1.29 is working after deleting the database and starting over. Thanks for the advice. It didn’t take all that long to get things going again. I’ll make sure i start making periodic db backups.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.