Server Version#: 1.26.0.5715
Player Version#:
As with many other users, after an update, the plex service crashes after being (re-)started. DB appears to be corrupted and I’ve attempted to repair it [ LINK ] (see below), but it still crashes after restart. Note that you can access it locally (for about 3 seconds before it stops responding and refreshing the page (x.x.x.x:32400/web/index.html#!) results in Connection Refused.
What would my next attempt be? Am I in a wipe Plex/re-install territory now?
Apr 22, 2022 20:56:44.633 [0x7fe569dedb38] INFO - /usr/lib/plexmediaserver/Plex Media Server
Apr 22, 2022 20:56:44.635 [0x7fe56d44e0c8] INFO - SQLITE3:0x80000001, 283, recovered 927 frames from WAL file /var/lib/plex/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db-wal
Apr 22, 2022 20:56:46.964 [0x7fe56d44e0c8] ERROR - SQLITE3:0x80000001, 779, index corruption at line 91877 of [1b256d97b5]
Apr 22, 2022 20:56:46.964 [0x7fe56d44e0c8] ERROR - SQLITE3:0x80000001, 779, statement aborts at 247: [update metadata_items set originally_available_at = iif(typeof(originally_available_at) in ('integer', 'real'), originally_ava>
Apr 22, 2022 20:56:46.997 [0x7fe56d44e0c8] ERROR - Exception inside transaction (inside=1) (/data/jenkins/server/3529576666/Library/DatabaseMigrations.cpp:237): sqlite3_statement_backend::loadOne: database disk image is malformed
Apr 22, 2022 20:56:47.005 [0x7fe56d44e0c8] ERROR - Exception thrown during migrations, aborting: sqlite3_statement_backend::loadOne: database disk image is malformed
Apr 22, 2022 20:56:48.608 [0x7fe56d44e0c8] INFO - SQLITE3:0x80000001, 283, recovered 1552758 frames from WAL file /var/lib/plex/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.blobs.db-wal
Apr 22, 2022 20:56:48.620 [0x7fe56d44e0c8] INFO - [CERT/OCSP] Successfully retrieved response from cache.
Next step is to try the Repair a Database link mentioned above…
- Stop Plex Service
sudo systemctl stop plexmediaserver
- Back Up DB
cd "/var/lib/plex/Plex Media Server/Plug-in Support/Databases"
cp com.plexapp.plugins.library.db com.plexapp.plugins.library.db.original
- Check for Corruption
-- "/usr/lib/plexmediaserver/Plex SQLite" com.plexapp.plugins.library.db "PRAGMA integrity_check"
This resulted in a page of Row X missing from index and wrong # of entries in index etc…
- Attempt to repair DB
"/usr/lib/plexmediaserver/Plex SQLite" com.plexapp.plugins.library.db ".output recover.out" ".recover"
This takes all of 15 seconds, for a large file full of DB (Re-)Creation Syntax.
Restart Service and check x.x.x.x:32400/web/index.html#!/. It loads, but with no library. I try to refresh the page 30 seconds later and it returns to Connection Refused and the service has crashed.
Apr 22 21:39:12 SERVER01 systemd[1]: Started Plex Media Server.
Apr 22 21:39:16 SERVER01 plexmediaserver[21859]: libc++abi: terminating with uncaught exception of type std::bad_cast: std::bad_cast
Apr 22 21:39:16 SERVER01 plexmediaserver[21859]: ****** PLEX MEDIA SERVER CRASHED, CRASH REPORT WRITTEN: /var/lib/plex/Plex Media Server/Crash Reports/1.26.0.5715-8cf78dab3/PLEX MEDIA SERVER/8eeee57b-347b-46bd-834894a1-96f10461.d>
Apr 22 21:39:16 SERVER01 systemd[1]: plexmediaserver.service: Main process exited, code=dumped, status=6/ABRT
There are no files in the mentioned crash location…