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
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
