Server Version#: Unraid version is 6.6.6
Player Version#:PLEX 1.14.1.5488 in docker linuxserver.io).
I have just started to use Plex on a Unraid server, and for the past few weeks I have been having issues that every few mins I loss connection with my PLEX and they word ’ Buffering ’ is shown. at first I through that the server was still doing background tasks like house keeping and optimise the database
so I left it,
when I had a deeper look, I can see that the reference ’ Sqlite3: Sleeping for 200ms to retry busy DB ‘ is shown every time there is two operations going on, which in turn killed the connection.
Looking at the resources the Avg CPU is only 12%
CPU cores avg 20%
Memory 10%
I have done some reading and I have re-install Plex, formatted the Cache, install a small film collection, but each time I am still getting the error and last night I moved the Trancodering to from the Cache drive to RAM.
Sidenote. I also discovered that the library discover is having issues what it hangs at random times and I have to restart the docker.
I have installed the Plex Docker on the UNraid as default, the hardware I have installed it on is:
First thing I’d try is optimizing the database and make sure that completes successfully (check logs to be sure). If your database is corrupt, it might be unable to optimize.
I’m assuming your database is on pretty fast storage, but that, plus library size play into the equation.
Some server log snippets might show more precisely perf issues, but that would be my guess (slow storage and/or DB in need of optimization).
here is my log file.
I like to report that if there is nothing else running then, it plays the films, music, tv shoes with no issues, but if there is something else running then it just buffers and dies.
Sidenote: last night I was watching a few films and TV Shows, and I discovered that ever few hours I had to restart my Plex Docker. which then allowed my Samsung TV to play the choose video.
so I am thinking that my Hardware is ok, but something is wrong with my Plex installation or the TV.
how can I test the TV side of things ?
It looks like many of the DB warnings are during the addition of new content to a library (maybe, or at least a refresh?) That is certainly a time of heavier use, especially if exacerbated by slow filesystem.
That’s the exact opposite conclusion I was drawing
If you have to restart the server, it sounds like there’s something potentially leaking (something similar sounding over here. See if you can check memory consumption of the processes inside Docker and see if any look like they’re growing.
this is interesting. yesterday I did some testing and I was able to stream 3 Web Plex Players with no issues, yes the RAM increases but once I finished playing and closed the Webpage, the ram returned back down to the lower 20%.
but when I watch a few films via the Tv, which is also a Samsung WebTV I discover that the just increases and didn’t decrease’s after I had turned off the TV and when to bed. in the end I had to turn of the Plex services to get the ram back down to the low 20%.
I’m having the same issue (player hangs indefinitely + Sqlite3: Sleeping for 200ms to retry busy DB) using plexinc/pms-docker:plexpass, currently v. 1.15.1.791 and had the same issue with prior versions. I’ve regularly optimized the db in the GUI. Host has 192gb RAM, with plenty available for plex, and this occurs even when I’m the only one watching anything; video resumes working if it is stopped and restarted.
I’m happy to test an image that uses postgres/mysql if it turns out to be a db hangup.
This has been happening to me now for about 2 months and the only way to resolve is systemctl restart plexmediaserver (in ubuntu/linux).
The only thing I have changed is moved from an SSD drive (128GB) to a 1T 3.5 7200 rpm drive and my conclusion is that the hard drive is going to sleep. I never had this issue on the SSD drive…
Any suggestions? Cron job to restart every hour possibly?
Suggestions: Spam Plex devs until they run Plex off a proper database and not this sql junk.
Don’t be ridiculous, nothing wrong with SQLite at all, it’s a good DB, issues here are with usage, and optimisation. I’m going to try moving mine back to SSD after migration docker and NFS volumes
It is a terrible DB to use for Plex. I use NVME raid0 and run into issues due to:
Limited concurrency : Although multiple processes can access and query an SQLite database at the same time, only one process can make changes to the database at any given time. This means SQLite supports greater concurrency than most other embedded database management systems, but not as much as client/server RDBMSs like MySQL or PostgreSQL.
For real Plex? Come on now, this is a paid product, let’s get with the times, or perhaps come out with different versions of Plex, one for smaller libraries backed by Sqlite, as it is now and one for libraries that have many thousands of files that uses MariaDB, PostgreSQL, hell, even MongoDB might handle data more efficiently than Sqlite.
Having the same error (Sqlite3: Sleeping for 200ms to retry busy DB). Tried everything. Even setting up a complete new server, but it has the same errors with my files. I know that there is this discussion about a proper database server since years and nothing is happening.
I would be happy if you dont force me to drop plex
sorry im french , but i’ll try to explan my trouble about Sqlite3: Sleeping for 200ms to retry busy DB
i was on Version: 6.6.0-rc4 with plexinc/pms-docker and after a update i have a Sqlite3: Sleeping for 200ms to retry busy DB trouble .
i make a update to new os 6.7.2 and update plex docker and i have always the Sqlite3 trouble . i try with new one 6.7.3 and same thing with the problem
i try to modifie the database delet for make a new one , and delet all plex item on my disk and usb key !!! to restart a new fresh plex installation ! i try 3 plex docker , always have a Sqlite3 trouble .
plex work for a short time this is make nothing on plex usage , but after a long time my docker show my plex online but nothing are accessible to play .
i need to reboot plex docker to play something
I realy need help to resolve this problem please !!
I don’t know about dockers but I that error is a symptom. It’s best to look for the cause. Please provide the entire Plex log so I can see what is going on.
