Dead in the Water after Version 1.23.6.4810 Update - Database Locked

Plex Media Server
42

Thank you!

1 Like
43

Message with old and new logs sent.

1 Like
44

Just chiming in that Iā€™m having the same database issue on Unraid. Iā€™ve restored 3 different / older database backups and just get ā€œSqlite3: Sleeping for 200ms to retry busy DB.ā€ in Unraid logs and ā€œFailed to begin transaction (ā€¦/Plugins/PluginDatabaseState.cpp:110) (tries=2): Cannot begin transaction. database is lockedā€ in the console.

Version 1.23.6.4810

1 Like
45

Should have them, shout if you need moreā€¦ FYI, its still ā€œupdating libraryā€ apparentlyā€¦

46

Hey folks

The ā€˜fixā€™ we implemented in the above build does technically work, but takes ages to apply on startup. Thanks for all your logs, they helped us to pinpoint it. The shared databases will help us to test a subsequent fix.

The plan:

  • Iā€™m making a new 1.23.5 / 1.23.6 which should work around the issue. This is the safest approach for ā€˜last thing on a Fridayā€™!
  • On Monday we will dig into the root cause, and come up with a long term solution.

Hold tight, a build should land in this thread within an hour or so (depending on our CI speed!)

7 Likes
47

Just wanted to add that Iā€™m seeing the exact same behaviour on the Synology NAS version (Intel 64-bit) - hoping the upcoming build we be available for that platform as well.

1 Like
48

Canā€™t wait to give this a try this evening, wonā€™t be able to test it again anytime soon lest the locals try to roast me over an open pit. :laughing:

3 Likes
49

I have the same issue. Plex starts for about 1 minute then crashes. Hopefully there will be a fix soon. I appreciate any help!

I downgraded, remover temp files, did a repair in setup, still no fix.

Once I did the downgrade it seems to start up but doesnt play anything. Just the buffer symbol on the screen.

I been running plex for 8 years and never had this problem. I would hate to have to start over again.

2 Likes
50

It would probably be wise to hang tight for the new build. You donā€™t want to end up making matters worse by continuing to try things.

3 Likes
51

Hi, please is this making my crippled Plex instance working again, so we can watch some tonight? Is there a light at the end of the tunnel to today?

1 Like
52

Please try this build (backup your database first!)

Desktop Platforms

1 Like
53

Praise be! It seems to workā€¦ though I am notified an update is available

1 Like
54

Yeahā€¦ the buggy 1.23.6

Once I get an extra confirmation Iā€™ll roll out the hotfixes.

3 Likes
55

Tested local and remote and all seems good with no weird errors in the logs. Iā€™m on Windows FYI. Thanks for sorting so quickly, saved a fair few film nights Iā€™m sure!!

1 Like
56

I keep getting these errors when I try to start Plex:

Jul 23, 2021 09:34:45.002 [16520] ERROR - SQLITE3:0x6f86d135, 779, index corruption at line 91877 of [1b256d97b5]
Jul 23, 2021 09:34:45.002 [16520] ERROR - SQLITE3:0x6f86d135, 779, statement aborts at 23: [update external_metadata_sources set online=0] database disk image is malformed
Jul 23, 2021 09:34:45.002 [16520] ERROR - Error: Unable to set up server: sqlite3_statement_backend::loadOne: database disk image is malformed (class soci::soci_error)

I tried doing a repair and that didnā€™t seem to help. Am I missing something?

57

That seems like you have a bad database. Do you have an old backup you can restore from?

58

Fingers crossed. Everything looks good and is functional so far. Thanks for the attention on this one!

59

Fair point. I had to go back a few weeks but I found a good one. All seems to be well. Thanks for the quick help!

60

Nothing for Syno at this point though?

61

Working for me. Win10.