Server Version#: 1.20.5.3600(File removed)
Player Version#:
Hi guys
I hope you can help me with this issue I have with Plex. What I am trying to do is remove a TV series (The Simpsons) from my Plex Database, I have managed to remove the entire series from my plex but it is still showing that the there is one file still there but it is phisically not there anymore as i have moved the entire series to another location until i can put it back in properly. I have done the whole Plex Dance thing a lot,
when i try to delete the series, i get the message ‘there was a problem deleting this item’ (all other episodes have removed correctly apart from S08E12 Mountain Madness), when i check my pc that file is not in the original location and it is driving me nuts trying to figure out what is going on.
Hopefully i have explained what i am trying to do. I have supplied my log files from Plex, so here’s hoping, one of you experts might be able to help me.#
The database is corrupted on your Plex Media Server. See log entries below from Plex Media Server.log.
You can try to repair it, restore from a backup, or delete & re-add your libraries (your media is not deleted).
See support article for details:
Nov 18, 2020 14:00:13.540 [8432] ERROR - SQLITE3:0xbc9d53c5, 11, database corruption at line 85694 of [bf8c1b2b7a]
Nov 18, 2020 14:00:13.540 [8432] ERROR - SQLITE3:0xbc9d53c5, 11, statement aborts at 80: [select media_items.id as 'media_items_id', media_items.library_section_id as 'media_items_library_section_id', media_items.section_location_id as 'media_items_section_location_id', med
Nov 18, 2020 14:00:13.543 [8432] ERROR - Soci Exception handled: sqlite3_statement_backend::loadRS: database disk image is malformed
Thanks for getting back to me on this, it is much appreciated.
I have done the repair a corrupt database earlier on today, everything was going as it should when following the instructions, but when i get to step six of repair the database ’ sqlite3 com.plexapp.plugins.library.db < dump.sql ', I get 0KB file and when i try to start the pms it says the database is corrupt and shuts down.
I’ve never had to repair a corrupt db, so I’ll be of little help. Hopefully others can jump in to assist.
I did notice a couple of things:
First: If I follow things correctly, Step 6 loads the contents of dump.sql into com.plexapp.plugins.library.db.
If dump.sql (the input) is 0KB, then com.plexapp.plugins.library.db (the output) will also be 0KB.
Second: Note that dump.sql is created in Step 4. What is the size of com.plexapp.plugins.library.db (the input file) before you run Step 4. If it is empty, then the output will be empty as well.
FWIW, it may be easier to load a backup version, if available. You’ll be missing any library additions since the backup date, but a library scan will pick them up.
After you load the backup, restart Plex Server, scan to pick up additions, etc, then check the Plex Media Server.log file for error messages with “database corruption at line xxx” type messages.
the output file from the dump was over 700mb, so when i did step six, i was expecting to for that amount to be put back in the new file from step six.
but on that note, I have bit the bullet and I am in the process of adding all my tv shows in again to a new side group, then i will remove the old one from my library, then i will empty trash and do the clean database and then take a backup of that.
I am much appreciated for the amount help and advice I have been getting on this.
Do not continue to work with a corrupt database! It will cause trouble and/or data loss in the future.
Go back to one of the backup copies of the database, even if you lose the playback history of a few days due to that.
