I’m unable to delete an entire library from my server. I’ve seen others post about the same issue, but haven’t found a thread that includes a solution or steps that I haven’t tried.
Steps to delete library:
Open server
Expand options menu for library
Select “Delete”
Check box to confirm deletion
Select delete button
Wait for spinning indicator to stop; dialog window to close
Result: no change
Completed troubleshooting steps:
run “optimize database” option
restart PMS
restart computer running PMS
Additional attempts to delete the library following troubleshooting have not yielded any results. I am successfully been able to delete other libraries in this server.
Please disable ‘verbose’ logging. It doesn’t help. In fact, it hinders longer-term diagnosis.
Your database is damaged
Aug 21, 2018 15:29:36.617 [0x70000912e000] ERROR - SQLITE3:0x700008774590, 11, database corruption at line 59437 of [fc49f556e4]
Aug 21, 2018 15:29:36.617 [0x70000912e000] ERROR - SQLITE3:0x700008774590, 11, database corruption at line 59479 of [fc49f556e4]
Aug 21, 2018 15:29:36.617 [0x70000912e000] ERROR - SQLITE3:0x700008774590, 11, statement aborts at 18: [delete from taggings where id in (select taggings.id from taggings join metadata_items on metadata_items.id=taggings.metadata_item_id where metadata_items.library_section_id=?)] databa
Aug 21, 2018 15:29:36.683 [0x70000912e000] ERROR - Exception inside transaction (inside=1) (../Library/Scanner/LibrarySection.cpp:314): sqlite3_statement_backend::loadOne: database disk image is malformed
Aug 21, 2018 15:29:36.808 [0x70000912e000] ERROR - Thread: Uncaught exception running async task which was spawned by thread 0x70000866f000: sqlite3_statement_backend::loadOne: database disk image is malformed
