Database error after scanning libraries

Plex Media Server NAS & Devices
,
1

Server Version#: 1.16.6.1592
Player Version#: 3.108.2

Hi,

Since August 25th i have been struggling with database corruption. I can restore a database that looks fine after running the sqlite commands, i will then run a scan of my libraries, it will work for some files then i get those errors. Metadata get missing, i can not tag movies, tv shows anymore.

I Have tried to repair the database but this command always return ok

sqlite3 com.plexapp.plugins.library.db "PRAGMA integrity_check"

The docker container in running on unraid but not the last version with the sqlite errors. I did try to move the plex data to a single drive, then to the cache drive and i always get the same result.

Any help is welcome :slight_smile:

Thanks

Aug 31, 2019 12:20:46.734 [0x148bd9d6c700] ERROR - SQLITE3:(nil), 1, statement aborts at 1: [COMMIT] cannot commit -no transaction is active
Aug 31, 2019 12:20:46.734 [0x148bd9d6c700] ERROR - Failed to commit transaction (…/Library/MetadataItem.cpp:961) (tries=8): Cannot commit transaction. cannot commit - no transaction is active
Aug 31, 2019 12:20:47.718 [0x148bd9d6c700] ERROR - SQLITE3:(nil), 1, statement aborts at 1: [COMMIT] cannot commit -no transaction is active
Aug 31, 2019 12:20:47.718 [0x148bd9d6c700] ERROR - Failed to commit transaction (…/Library/MetadataItem.cpp:961) (tries=9): Cannot commit transaction. cannot commit - no transaction is active
Aug 31, 2019 12:20:48.686 [0x148bd9d6c700] ERROR - SQLITE3:(nil), 1, statement aborts at 1: [COMMIT] cannot commit -no transaction is active
Aug 31, 2019 12:20:48.687 [0x148bd9d6c700] ERROR - Failed to commit transaction (…/Library/MetadataItem.cpp:961) (tries=10): Cannot commit transaction. cannot commit - no transaction is active
Aug 31, 2019 12:20:48.687 [0x148bd9d6c700] ERROR - Exception inside transaction (inside=1) (…/Library/MetadataItem.cpp:961): Cannot commit transaction. cannot commit - no transaction is active
Aug 31, 2019 12:20:48.687 [0x148bd9d6c700] ERROR - SQLITE3:(nil), 1, statement aborts at 1: [ROLLBACK] cannot rollback - no transaction is active
Aug 31, 2019 12:20:48.687 [0x148bd9d6c700] ERROR - Failed to roll back transaction (…/Library/MetadataItem.cpp:959): Cannot rollback transaction. cannot rollback - no transaction is active
Aug 31, 2019 12:20:48.687 [0x148bd9d6c700] ERROR - Exception loading item ‘Long Shot’ from bundle: Cannot commit transaction. cannot commit - no transaction is active

2

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.