Hi guys, was adding some new content to my TV Series yesterday and one show seems to have got stuck since I can’t even delete it from Plex, when I try to remove the item it gives me the error “There was a problem deleting this item.”.
I did remove it from the hard drive but still there and scan fails.
Looking at the console I can see the following errors repeating:
SQLITE3:(nil), 11, database corruption at line 65066 of [bf8c1b2b7a]
Thread: Uncaught exception running async task which was spawned by thread 0x14ddac521700: sqlite3_statement_backend::loadOne: database disk image is malformed
SQLITE3:(nil), 11, statement aborts at 9: [select statistics_bandwidth.id as ‘statistics_bandwidth_id’, statistics_bandwidth.account_id as ‘statistics_bandwidth_account_id’, statistics_bandwidth.device_id as 'statistics_bandwidt
I am running this on a docker container on UnRaid, is there anyway I can repair this?? Did not want to redo the whole thing again!
Many thanks, I did have a look at the backup files and I see it was backing up the com.plexapp.plugins.library.db until June, which might be when I upgraded Unraid or Plex!
The latest backups are of file com.plexapp.plugins.library.blobs.db instead!
I did try and restore a previous backup of com.plexapp.plugins.library.blobs.db but that makes no difference.
What is the two files for? and why is it only backing up the blobs.db file?
That would mean you have had corruption since the last backup. The primary database is com.plexapp.plugins.library.db ,blob is for holding image data. If you can’t repair the current db then you would have to roll back to the June copy.
