Later versions of Plex losing Movie Library

Plex Media Server
16

@tlef805 The database is corrupt.

Jul 18, 2022 06:14:11.311 [0x7fb67fbc3b38] ERROR - [DatabaseFixups] SQLITE3:0x80000001, 267, statement aborts at 163: [update metadata_items set extra_data=? where metadata_type=? and library_section_id=? and id=?] database disk image is malformed
Jul 18, 2022 06:14:11.312 [0x7fb67fbc3b38] ERROR - [DatabaseFixups] Exception inside transaction (inside=1) (/data/jenkins/server/3540783331/Library/MetadataCollection.cpp:479): sqlite3_statement_backend::loadOne: database disk image is malformed
Jul 18, 2022 06:14:11.312 [0x7fb67fbc3b38] ERROR - [DatabaseFixups] Fixup 29DatabaseFixupsSyncCollections threw an exception: sqlite3_statement_backend::loadOne: database disk image is malformed

You have three options:

  1. Repair.
  2. Restore from a backup.
  3. Delete and start over.

The database is located in /PlexMediaServer/AppData/Plex Media Server/Plug-in Support/Databases (Where is the Plex Media Server data directory located?).

Repair a Corrupted Database has instructions on how to repair the database.

If the repair is unsuccessful, you can try restoring from a backup. Choose a backup from before the problem started, otherwise it may also be corrupt. You can use the procedures in the repair article to check for corruption and attempt repair if needed. See Restore a Database Backed Up via ‘Scheduled Tasks’ and Synology FAQ #17: Recover from a corrupt database for details.

If repair or restoration does not work, then you can delete the database. You will have to re-create your libraries. Your media is not touched. See the Repair article for additional info.

1 Like