Server Version#:
Player Version#:
Hello,
Plex Media Server Databases_2018-07-11_15-15-16.zip (22 Bytes)
Plex Media Server Logs_2022-06-19_21-59-06.zip (3.6 MB)
Can you help me ?
Following the update on June 19, 2022, my server plex installed on windows 11 no longer recognizes any of my libraries. I uninstalled and reinstalled plex server windows without that being able to solve this problem.
What do you think I should do?
Thanking you for your help
The database in your Plex Media Server is corrupted.
Jun 19, 2022 21:57:28.591 [15716] ERROR - SQLITE3:0xaf9e14de, 11, database corruption at line 88814 of [1b256d97b5]
Jun 19, 2022 21:57:28.591 [15716] ERROR - SQLITE3:0xaf9e14de, 11, statement aborts at 45: [update media_parts set created_at = iif(typeof(created_at) in ('integer', 'real'), created_at, strftime('%s', created_at, 'utc')), updated_at = iif(typeof(updated_at) in ('integer', 'r
Jun 19, 2022 21:57:28.592 [15716] ERROR - Exception inside transaction (inside=1) (E:\jenkins\server\3579777303\Library\DatabaseMigrations.cpp:254): sqlite3_statement_backend::loadOne: database disk image is malformed
Jun 19, 2022 21:57:28.594 [15716] ERROR - Exception thrown during migrations, aborting: sqlite3_statement_backend::loadOne: database disk image is malformed
You’ve three options:
The repair process is covered in Repair a Corrupted Database .
To restore from a backup, see Restore a Database Backed Up via ‘Scheduled Tasks’ .
It is not possible to tell when the corruption occurred. The backup copies of the database may also be corrupt. After loading a backup and restarting Plex, check the Plex Media Server.log file for SQLITE3 errors (any log entry with ERROR - SQLITE3).
If repairing or restoring does not work, the last option is to delete the database and start over. This will not touch your media files. You will have to re-create your libraries, re-share them with any other users, etc.
From the Repair a Corrupted Database support article:
Note : You can also simply delete the com.plexapp.plugins.library.db database file while the Plex Media Server is not running. Restarting the server will then restore your server to a nearly-fresh install state. (i.e. You will lose your existing libraries and need to recreate them , but you won’t be affecting your content itself.)
Typo fixed.
FYI, there is a typo in the Repair a Corrupted Database document.
PRAGMA integrity_check should be PRAGMA integrity_check;
VACUUM should be VACUUM;
REINDEX should be REINDEX;
The commands won’t execute without the semicolon at the end.
Thank you for your advice
