I’ve suddenly noticed that movies added to my system are no longer being picked up by the automatic or manual “scan library files”. for example, I’ve attached my logfiles, and although the movie “Bloodshot” is found it is not added and doesn’t appear in the web client.
In Plex Media Server.log: Aug 03, 2020 19:28:12.349 [0x7f421ab7d700] ERROR - SQLITE3:(nil), 11, database corruption at line 79051 of [bf8c1b2b7a]
This repeats 700+ times in Plex Media Server.log.
Aug 03, 2020 15:46:03.542 [0x7f41d6e6b700] ERROR - SQLITE3:(nil), 1, statement aborts at 1: [COMMIT] cannot commit - no transaction is active
Aug 03, 2020 15:46:03.542 [0x7f41d6e6b700] ERROR - Failed to commit transaction (../Library/MetadataItem.cpp:1020) (tries=4): Cannot commit transaction. cannot commit - no transaction is active
Options:
Try to repair.
Restore from backup.
Delete it & start over.
To repair, you’ll need to SSH into your Synology (FAQ 14 ). See Repair A Corrupt Database , Linux section, for the instructions you’ll have to issue. My DS918+ has sqlite3 installed, so you may not have to install it on your system (the article says it is not installed on Linux systems).
Deleting the database is almost like starting over. You files are safe, but you’ll have to re-create libraries, re-share them if you share with others, etc. See the Repair A Corrupt Database article. Look for the text in the blue box, about the fifth paragraph.