I have had a look through some of the Plex log files, and whilst I’m not overly familiar with the structure and content, I did come across this in the Plex Server log file:
Nov 15, 2024 13:16:35.484 [5016] ERROR - SQLITE3:0x872f21dc, 11, database corruption at line 84326 of [a29f994989]
Nov 15, 2024 13:16:35.484 [5016] ERROR - SQLITE3:0x872f21dc, 11, statement aborts at 22: [SELECT DISTINCT di.`id` FROM directories di LEFT JOIN media_parts AS pt ON di.`id`=pt.`directory_id` LEFT JOIN media_items AS mi ON pt.`media_item_id`=mi.`id` WHERE mi.`section_location_id`=:C1] database disk image is malformed
Nov 15, 2024 13:16:35.485 [5016] WARN - Caught exception while scanning TV: Unknown exception
Nov 15, 2024 13:16:35.697 [5016] INFO - Notification: Library scan complete - Extra information may still be downloading from the Internet
I have disabled the Eds-FS2\TV share on the new storage box, to prevent Plex adding thousands of TV shows to this one unknown show.
I wonder if this is what is preventing the scan from running?
Unfortunately I had no other choice, as I’m also unable to remove the extra folder from the library.
If I try to remove the folder, I see these entries:
Nov 15, 2024 13:20:20.824 [7348] INFO - Request: [10.0.0.234:55934 (Allowed Network (Subnet))] PUT /library/sections/2?name=TV&type=show&agent=tv.plex.agents.series&scanner=Plex%20TV%20Series&language=en-US&importFromiTunes=&enableAutoPhotoTags=&location=%5C%5CEds-FS%5CTV (7 live) #6dc06 TLS GZIP Signed-in Token (Eds89) (Microsoft Edge)
Nov 15, 2024 13:20:21.915 [1364] WARN - [Req#6ec5a] QueryParser: Invalid field 'contentDirectoryID' found, ignoring.
Nov 15, 2024 13:20:21.916 [1364] WARN - [Req#6ec5a] QueryParser: Invalid field 'pinnedContentDirectoryID' found, ignoring.
Nov 15, 2024 13:20:23.125 [7348] ERROR - [Req#6dc06] SQLITE3:0x872f21dc, 779, index corruption at line 94622 of [a29f994989]
Nov 15, 2024 13:20:23.125 [7348] ERROR - [Req#6dc06] SQLITE3:0x872f21dc, 779, statement aborts at 26: [delete from media_parts where media_item_id=?] database disk image is malformed
Nov 15, 2024 13:20:23.125 [7348] ERROR - [Req#6dc06] Exception inside transaction (inside=1) (D:\gha\plex-media-server\plex-media-server\Library\MediaItem.cpp:911): sqlite3_statement_backend::loadOne: database disk image is malformed
Nov 15, 2024 13:20:23.154 [7348] ERROR - [Req#6dc06] Exception inside transaction (inside=1) (D:\gha\plex-media-server\plex-media-server\Library\Scanner\SectionLocation.cpp:52): sqlite3_statement_backend::loadOne: database disk image is malformed
Nov 15, 2024 13:20:23.154 [7348] ERROR - [Req#6dc06] Exception inside transaction (inside=1) (D:\gha\plex-media-server\plex-media-server\Library\LibrarySectionEndpointHandler.cpp:358): sqlite3_statement_backend::loadOne: database disk image is malformed
Nov 15, 2024 13:20:23.156 [7348] ERROR - Got exception from request handler: sqlite3_statement_backend::loadOne: database disk image is malformed
Nov 15, 2024 13:20:23.156 [5728] INFO - Completed: [10.0.0.234:55934] 500 PUT /library/sections/2?name=TV&type=show&agent=tv.plex.agents.series&scanner=Plex%20TV%20Series&language=en-US&importFromiTunes=&enableAutoPhotoTags=&location=%5C%5CEds-FS%5CTV (9 live) #6dc06 TLS GZIP 2331ms 530 bytes (pipelined: 1)
I do have a backup of the VM from a few days ago, before I started doing any migrations, so is it likely I will need to restore from backup?
Thanks
Eds