Dead in the Water after Version 1.23.6.4810 Update - Database Locked

Plex Media Server
22

Having same issues.

23

Was driving me nuts last night. Had something similar happen a year ago and couldnā€™t remember how I fixed itā€¦ remembered this morning: uninstall and install a version thatā€™s a year old. Fixed it. Will upgrade once there is a fix.

24

I am also having this issue. thought i broke something with a reboot today :frowning: sorry its affecting others, comforting to know the update is the cause.

25

unraid container rolled back to plex version:1.23.4.4805-186bae04e-ls61 is now working

26

Plex needs a rollback feature

3 Likes
27

Would anyone mind taking this build for a spin? Please back up your database first!

Desktop Platforms

[BUILDS REMOVED]

28

Testing nowā€¦ wish me luck

29

On Windows 10, currently sat at ā€œUpdating library, please waitā€¦ā€ for around 5 minutesā€¦ no progress barā€¦

Almost 10 mins now, just sat, do I wait or kill the process and try and reload?

Edit: Am going to call time of death on it I think, doesnā€™t seem happyā€¦

30

Donā€™t you love when they ask you to try something and then donā€™t monitorā€¦

2 Likes
31

Making the same attempt, now.

32

Getting the same thing and trying the version posted:

Jul 23, 2021 13:46:12.030 [0x7fedbe73cb38] INFO - Plex Media Server v1.23.5.4858-90c20601c - Ubuntu PC x86_64 - build: linux-x86_64 debian - GMT 00:00
Jul 23, 2021 13:46:12.030 [0x7fedbe73cb38] INFO - Linux version: 20.04.2 LTS (Focal Fossa), language: en-US
Jul 23, 2021 13:46:12.030 [0x7fedbe73cb38] INFO - Processor       Intel(R) Xeon(R) CPU E3-1245 V2 @ 3.40GHz
Jul 23, 2021 13:46:12.030 [0x7fedbe73cb38] INFO - Compiler is - Clang 11.0.1 (https://plex.tv e0c29d5827bc4eaaa2ceb882cbeed224b0960173)
Jul 23, 2021 13:46:12.030 [0x7fedbe73cb38] INFO - /usr/lib/plexmediaserver/Plex Media Server
Jul 23, 2021 13:46:12.041 [0x7fedbe7e5d30] INFO - SQLITE3:0x80000001, 283, recovered 378 frames from WAL file /var/lib/plexmediaserver/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db-wal

Server still not available via web or apps and port 32400 does not appear available via netstat -tnlp

33

Having the same issue on the newest beta server, on unraid. Rolling backā€¦

34

It appears that this build has caused a ā€œTPK.ā€ Itā€™s running as a task, but I am unable to access the server via the web interface.

(TPK = Total Party Kill in D&D terms for those wondering)

35

Well, thatā€™s disappointing! Letā€™s try something else.

Could I get a copy of your latest logs zip (all the log files, not just a snippet)? And ideally a DM with your database.

36

I am seeing the DB locking issue as well -

Jul 23, 2021 07:07:17.487 [6632] WARN - Waited one whole second for a busy database.
Jul 23, 2021 07:07:18.850 [23376] WARN - Waited one whole second for a busy database.
Jul 23, 2021 07:07:19.073 [6632] ERROR - Failed to begin transaction (..\Statistics\StatisticsManager.cpp:249) (tries=9): Cannot begin transaction. database is locked
Jul 23, 2021 07:07:20.642 [23376] ERROR - Thread: Uncaught exception running async task which was spawned by thread 14088: sqlite3_statement_backend::loadOne: database is locked
Jul 23, 2021 07:07:20.926 [6632] WARN - Waited one whole second for a busy database.
Jul 23, 2021 07:07:22.510 [6632] ERROR - Failed to begin transaction (..\Statistics\StatisticsManager.cpp:249) (tries=10): Cannot begin transaction. database is locked
Jul 23, 2021 07:07:22.510 [6632] ERROR - Thread: Uncaught exception running async task which was spawned by thread 26316: Cannot begin transaction. database is locked
1 Like
37

Can you confirm the specific files you want me to send and I can. Do you want Plex Media Server.log and one of the .db files from Plug-in Support?

1 Like
38

Sorry, yes!

  • Everything inside the logs directory
  • The com.plexapp.plugins.library.db file from inside the Plugin-Support/Databases directory
39

Unfortunately, with a failure to launch, Iā€™m not sure I can get you logs. Do you want the current DB, or the one I created as a backup?

40

The logs are in the folders outlined in this support article (under the manual heading):

Both databases would be great. Though the current DB is more useful.

41

Just uploading them to Google Drive as think the zips are too large for here, will PM you links

1 Like