PMS Not Responding (Database locked?)

Plex Media Server Logs_2021-07-22_21-22-54.zip (1.4 MB)

For the past few weeks, my PMS has had to have the container rebooted once or twice a day. Today, the log is filled with:
WARN - Waited one whole second for a busy database.
ERROR - Thread: Uncaught exception running async task which was spawned by thread 0x14b2fff74b38: sqlite3_statement_backend::loadOne: database is locked

And it is not responding at all.

I don’t know unraid but –

  1. Database is badly fragmented if that CPU can’t plow through it.
Jul 22, 2021 21:17:19.282 [0x14b2fd076b38] WARN - SLOW QUERY: It took 340.000000 ms to retrieve 0 items.

Recommend:

  1. Restart
  2. Empty Trash
  3. Clean Bundles
  4. Optimize Database
  5. restart again
  6. Settings - Scheduled Tasks.
  7. Make certain it’s set to perform these steps when the server is running.

I am on unRAID as well and I get a constant stream of slow queries and busy database when I am on the 1.23 versions. I’ve even upgraded hardware such as new cpu, ssd, etc and still slow query and busy database.

The busy db messages goes away if I downgrade to 1.22 but Plex still deadlocks on me almost nightly. I’ve pretty much done the db optimization and clean bundles on a daily basis for a few months now and it hasn’t helped.

More details in this thread:. Plex Deadlocking with to many hung connections issues for last 4 months. (This ended up giving me anxiety attacks!) (Edited title for clarification) - #101 by AHickle

  1. Done
  2. Done
  3. Done
  4. Done, took 2~3 hours
  5. Done
  6. Done
  7. All things are and have always been scheduled.

Same issues. Flood of Sleeping for 200ms as soon as I start the server. Plex unusable from any client. Have to click on a item and go back multiple times to get it open, to get it to play, etc.

Windows thread but they said they are working on it.

https://forums.plex.tv/t/dead-in-the-water-after-version-1-23-6-4810-update-windows-10/730786/21

1 Like

Do you use Overseerr, Petio, or Ombi? Or anything else that accesses the Plex DB?

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