(Solved) PMS Stopped Working, Crash Logs in Docker

[quinnjudge]

Server Version#: 1.15.6.1079
Player Version#: n/a

I have Plex Media Server installed inside Docker on my UnRAID server. A number of my clients started experiencing issues, so I took a look at the server - the Docker log is spitting out crash report messages repeatedly:

terminate called after throwing an instance of 'soci::soci_error'
what(): sqlite3_statement_backend::loadRS: database disk image is malformed
****** PLEX MEDIA SERVER CRASHED, CRASH REPORT WRITTEN: /config/Library/Application Support/Plex Media Server/Crash Reports/1.15.6.1079-78232c603/PLEX MEDIA SERVER/667a8407-3df8-effd-32cd776a-16ad22b1.dmp
Starting Plex Media Server.

Not sure what happened or changed, the rest of the server seems to be perfectly happy. I am unable to see any of my media on any players, and even the DVR configuration in the server seems to be reset…can whatever this corruption is be fixed???

Thanks!Plex Media Server Logs_2019-05-24_14-13-08.zip (1.8 MB)

[quinnjudge]

It appears I was able to resolve the issue by restoring a backup of the database from 2 days ago, but…any idea why it happened?

[jcollie]

It’s because SQLite isn’t a great database engine. If the server isn’t shut down just so and there’s a very good chance that the database will corrupt itself. SQLite is also not very tolerant of network file systems. Until Plex offers the ability to connect to a different database engine (PostgreSQL would be my choice) this will be a problem. However the Plex developers have pretty much refused to do so because using SQLite is the “non-techie” friendly option.

[quinnjudge]

Thanks for the info!