Server Version#: 1.15.5.994
Player Version#: not sure, server doesn’t currently start
Everything was working fine this morning and last night, then all of sudden none of my libraries with video files in them would displaying. Giving the “Unexpected error loading dashboard” message.
So I did:
- Restarted Plex
- Restarted Server
Still nothing, then found Sqlite3 errors in the logs:
May 02, 2019 12:28:31.967 [0x7f1c4effd700] WARN - HTTP error requesting GET /media/providers?X-Plex-Token=xxxxxxxxxxxxxxxxxxxx (0, No error) (<url> malformed)
May 02, 2019 12:28:31.967 [0x7f1c4effd700] ERROR - Error issuing curl_easy_perform(handle): 3
May 02, 2019 12:28:31.967 [0x7f1c4effd700] WARN - HTTP error requesting GET /media/providers?X-Plex-Token=xxxxxxxxxxxxxxxxxxxx (0, No error) (<url> malformed)
May 02, 2019 12:28:31.967 [0x7f1c4effd700] ERROR - Error issuing curl_easy_perform(handle): 3
May 02, 2019 12:28:31.967 [0x7f1c4effd700] WARN - HTTP error requesting GET /media/providers?X-Plex-Token=xxxxxxxxxxxxxxxxxxxx (0, No error) (<url> malformed)
May 02, 2019 12:28:31.967 [0x7f1c4effd700] ERROR - Error issuing curl_easy_perform(handle): 3
May 02, 2019 12:28:31.967 [0x7f1c4effd700] WARN - HTTP error requesting GET /media/providers?X-Plex-Token=xxxxxxxxxxxxxxxxxxxx (0, No error) (<url> malformed)
May 02, 2019 12:28:31.968 [0x7f1c4effd700] ERROR - Error issuing curl_easy_perform(handle): 3
May 02, 2019 12:28:31.968 [0x7f1c4effd700] WARN - HTTP error requesting GET /media/providers?X-Plex-Token=xxxxxxxxxxxxxxxxxxxx (0, No error) (<url> malformed)
May 02, 2019 12:28:55.877 [0x7f1bedffb700] INFO - AutoUpdate: no updates available
May 02, 2019 12:29:00.843 [0x7f1beeffd700] ERROR - SQLITE3:(nil), 11, database corruption at line 79051 of [bf8c1b2b7a]
May 02, 2019 12:29:00.843 [0x7f1beeffd700] ERROR - SQLITE3:(nil), 11, statement aborts at 10: [select parents.parent_id,count(*) from metadata_items as parents join metadata_items as leaves on leaves.parent_id=parents.id where parents.metadata_type = 3 group by parents.parent_id
May 02, 2019 12:29:00.844 [0x7f1beeffd700] ERROR - Soci Exception handled: sqlite3_statement_backend::loadRS: database disk image is malformed
May 02, 2019 12:29:06.617 [0x7f1bef7fe700] INFO - AutoUpdate: no updates available
May 02, 2019 12:29:32.805 [0x7f1c6ffff700] ERROR - LPE: unknown item 70703.
May 02, 2019 12:29:32.805 [0x7f1c6ffff700] ERROR - Sync: failed to generate query for path library://daca36b1-9aad-4b83-9ffb-81def4b4f044/item/%2Flibrary%2Fmetadata%2F70703 in sync item 32538213
May 02, 2019 12:29:32.805 [0x7f1c6ffff700] ERROR - Sync: skipping items for sync list 26407623, sync item 32538213: unable to generate sync set query
May 02, 2019 12:29:00.844 [0x7f1beeffd700] ERROR - Soci Exception handled: sqlite3_statement_backend::loadRS: database disk image is malformed
So did a DB Check and then a DB Repair, but that was a no go
So now trying to use one of the DB backs, and now i am getting errors in the logs about Sqlite3 not being able to write to a read-only database.
May 02, 2019 13:10:13.394 [0x7f9bf0ff9700] ERROR - Failed to begin transaction (../Plugins/PluginDatabaseState.cpp:112) (tries=9): Cannot begin transaction. attempt to write a readonly database
May 02, 2019 13:10:14.038 [0x7f9bf0ff9700] ERROR - SQLITE3:(nil), 8, statement aborts at 1: [BEGIN IMMEDIATE] attempt to write a readonly database
May 02, 2019 13:10:14.038 [0x7f9bf0ff9700] ERROR - Failed to begin transaction (../Plugins/PluginDatabaseState.cpp:112) (tries=10): Cannot begin transaction. attempt to write a readonly database
May 02, 2019 13:10:14.039 [0x7f9bf0ff9700] ERROR - Caught exception starting plugin /usr/lib/plexmediaserver/Resources/Plug-ins-4610c6e8d/System.bundle (Cannot begin transaction. attempt to write a readonly database)
May 02, 2019 13:10:14.040 [0x7f9c2d2b2740] ERROR - SQLITE3:(nil), 8, statement aborts at 26: [update external_metadata_sources set online=0] attempt to write a readonly database
May 02, 2019 13:10:14.040 [0x7f9c2d2b2740] ERROR - Error: Unable to set up server: sqlite3_statement_backend::loadOne: attempt to write a readonly database (N4soci10soci_errorE)
File and directory permissions are the same as they were before -rw-r----r
At the moment i am a bit stuck on what to do next to get things back up and running
