i cant delete library

General Discussions
1

i stated having problems with my tv library so i added a new tv library but now it will not let me delete the original. i have renamed it “old” but i can’t delete it or delete folders. any suggestion on how to attach logs. i downloaded them but it won’t let me attach

2

What do you mean by you can’t delete folders? Are you doing that with Windows Explorer?

3

DB corruption?

4

@beckfield said:
What do you mean by you can’t delete folders? Are you doing that with Windows Explorer?

No I mean under plex where you tell it to look for content. It says your changes can not be saved. And it will not let me delete the tv show catagory either.

5

@Wpcrumbley said:
No I mean under plex where you tell it to look for content. It says your changes can not be saved. And it will not let me delete the tv show catagory either.
Ah, ok. I’m afraid I don’t have much more to offer, but Otto’s on it, and he’s much more knowledgeable.

6

@OttoKerner said:
DB corruption?
https://forums.plex.tv/discussion/comment/1464290/#Comment_1464290

thanks. but when i try to attach all the files are greyed out and won’t let me attach

7

@OttoKerner said:
DB corruption?
https://forums.plex.tv/discussion/comment/1464290/#Comment_1464290
here are the files

8

If I’m reading the logs correctly it looks like my database is curupted. I see the instructions on how to fix but is there an easier way to only save watched status then just re add everything?

9

I don’t see any sign of corruption in your logs.

I do however see a lot of plugins which may cause trouble.
Pleaase remove all channels and plugins which are not functional anymore.
Particularly ss-plex and bittorrent

Remove some Sync jobs as well.
Restart your server afterwards and let it run a few minutes without doing anything in Plex.

Then perform a database optimiziation.

10

@OttoKerner said:
I don’t see any sign of corruption in your logs.

I do however see a lot of plugins which may cause trouble.
Pleaase remove all channels and plugins which are not functional anymore.
Particularly ss-plex and bittorrent

Remove some Sync jobs as well.
Restart your server afterwards and let it run a few minutes without doing anything in Plex.

Then perform a database optimiziation.

I ran other logs and it said corruption. I removed the sync jobs, and the channels but still won’t delete.

11

@Wpcrumbley said:
I ran other logs and it said corruption. I removed the sync jobs, and the channels but still won’t delete.

I looked at all 6 Plex Media Server.logs . None of them had the word corrupt in it.
I don’t know what else to try - sorry!

12

@OttoKerner said:

@Wpcrumbley said:
I ran other logs and it said corruption. I removed the sync jobs, and the channels but still won’t delete.

I looked at all 6 Plex Media Server.logs . None of them had the word corrupt in it.
I don’t know what else to try - sorry!

this one shows corruption. how bad does it look

13

@Wpcrumbley said:
this one shows corruption. how bad does it look

could you tell me, which of the 92 log files in there did you look at?
because I can’t find any mention of a corrupt database.

14

@OttoKerner said:

@Wpcrumbley said:
this one shows corruption. how bad does it look

could you tell me, which of the 92 log files in there did you look at?
because I can’t find any mention of a corrupt database.
i looked at the plex media server.log and used the find feature for the word error:

Jun 26, 2017 15:28:25.159 [0x700008a19000] ERROR - SQLITE3:0x700007ed6130, 11, database corruption at line 59437 of [fc49f556e4]
Jun 26, 2017 15:28:25.159 [0x700008a19000] ERROR - SQLITE3:0x700007ed6130, 11, database corruption at line 59479 of [fc49f556e4]
Jun 26, 2017 15:28:25.159 [0x700008a19000] ERROR - SQLITE3:0x700007ed6130, 11, statement aborts at 41: [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
Jun 26, 2017 15:28:25.161 [0x700008a19000] ERROR - Exception inside transaction (inside=1) (…/Library/Scanner/SectionLocation.cpp:58): sqlite3_statement_backend::loadRS: database disk image is malformed
Jun 26, 2017 15:28:25.162 [0x700008a19000] ERROR - Exception inside transaction (inside=1) (…/Library/LibraryRequestHandler.cpp:3067): sqlite3_statement_backend::loadRS: database disk image is malformed
Jun 26, 2017 15:28:25.164 [0x700008a19000] ERROR - Soci Exception handled: sqlite3_statement_backend::loadRS: database disk image is malformed

15

Blimey!
My search feature in my editor seems to be broken. Sorry!

You are absolutely right, that is a clear sign of a broken database.
If you have shutdown Plex before attempting the repair (this is important!)
and the repair process still fails, then this database is FUBAR, unfortunately.

You can try an additional repair attempt with one of the older automated database backups.
But if these fail as well, then I’m afraid you can only throw away all your Plex data and start afresh.