"Database corruption" after update

[mavrc]

Server Version#:v.1.41.2.9200 - 1.41.3.9276
I just tried to update Plex on my QNAP, and it behaved strangely - as in, showed as running in the App Center but wasn’t. (as in, no “Plex” in ps aux.) I tried updating to the current beta, thinking maybe there was something weird going on with the stable release, but it behaved the same way. Logs indicate PMS is starting but failing during startup,

Attached is the latest log:
Plex Media Server.log (4.9 KB)

It looks like Crash Reporter is uploading the crash logs, so I’m hoping those go somewhere useful? The pertinent bit from the log looks like:

Dec 06, 2024 20:35:13.887 [140405092457104] DEBUG - Opening 2 database sessions to library (com.plexapp.plugins.library.blobs), SQLite 3.39.4, threadsafe=1
Dec 06, 2024 20:35:13.888 [140405092457104] ERROR - SQLITE3:0x80000001, 1, SQL logic error in "PRAGMA cache_size=1"
Dec 06, 2024 20:35:13.889 [140405092457104] ERROR - Database corruption: sqlite3_statement_backend::prepare: SQL logic error for SQL: PRAGMA cache_size=1
Dec 06, 2024 20:35:13.889 [140405092457104] ERROR - Error: Unable to set up server: sqlite3_statement_backend::prepare: SQL logic error for SQL: PRAGMA cache_size=1 (N4soci10soci_errorE)

I’m pretty adept at Linux, generally, but the Plex library structure is a total enigma to me and I don’t want to start fooling around with sqlite without knowing what I should be doing with it. I don’t see a lot of data on here about how to repair a broken database. Any suggestions?

[mavrc]

Well, after some additional review, and using the miraculous database repair tool from @ChuckPa, my system is running again. I’m not quite sure what it did, because it didn’t seem to think anything was wrong - but running it in auto mode certainly did fix something, because after the run it started up seemingly without issue.

So, I’m not going to ask any questions & do a better job keeping my database backed up. Thanks Chuck.