Hi @Atomatth . Per your comment in this thread I will return to my original post here.
As an update, I have upgraded my plexmediaserver software in case it would help. I’m still seeing the same issues from a client POV, but looks like the messages are changing slightly from my earlier posts, as shown below:
plexmediaserver process status:
[jake@plex ~]$ sudo systemctl status plexmediaserver
● plexmediaserver.service - Plex Media Server
Loaded: loaded (/usr/lib/systemd/system/plexmediaserver.service; enabled; vendor preset: disabled)
Active: active (running) since Tue 2021-08-31 05:43:18 PDT; 4h 18min ago
Process: 8426 ExecStartPre=/bin/sh -c /usr/bin/test -d “${PLEX_MEDIA_SERVER_APPLICATION_SUPPORT_DIR}” || /bin/mkdir -p “${PLEX_MEDIA_SERVER_APPLICATION_SUPPORT_DIR}” (code=exited, status=0/SUCCESS)
Main PID: 8429 (Plex Media Serv)
CGroup: /system.slice/plexmediaserver.service
├─8429 /usr/lib/plexmediaserver/Plex Media Server
├─8471 Plex Plug-in [com.plexapp.system] /usr/lib/plexmediaserver/Resources/Plug-ins-1a38e63c6/Framework.b… ├─8515 /usr/lib/plexmediaserver/Plex Tuner Service /usr/lib/plexmediaserver/Resources/Tuner/Private /usr/l… ├─8545 Plex Plug-in [com.plexapp.plugins.WebTools] /usr/lib/plexmediaserver/Resources/Plug-ins-1a38e63c6/F… ├─8547 Plex Plug-in [com.plexapp.agents.subzero] /usr/lib/plexmediaserver/Resources/Plug-ins-1a38e63c6/Fra… ├─9248 Plex EAE Service
└─9397 /usr/lib/plexmediaserver/Plex Transcoder -codec:0 h264 -codec:1 ac3 -ss 4671 -noaccurate_seek -■■■■…
Aug 31 09:50:10 plex sh[8429]: Sqlite3: Sleeping for 200ms to retry busy DB.
Aug 31 09:50:10 plex sh[8429]: Sqlite3: Sleeping for 200ms to retry busy DB.
Aug 31 09:50:10 plex sh[8429]: Sqlite3: Sleeping for 200ms to retry busy DB.
Aug 31 09:50:10 plex sh[8429]: Sqlite3: Sleeping for 200ms to retry busy DB.
Also, the slow query messages are still there, but now giving an actual number of what it’s trying to retrieve, vs. the previous 0 results.
[jake@plex Logs]$ grep -i slow *.log
Plex Media Server.log:Aug 31, 2021 09:49:14.283 [0x7f054a8aab38] WARN - SLOW QUERY: It took 320.000000 ms to retrieve 15 items.
Plex Media Server.log:Aug 31, 2021 09:49:14.359 [0x7f054ab56b38] WARN - SLOW QUERY: It took 520.000000 ms to retrieve 12 items.
Plex Media Server.log:Aug 31, 2021 09:49:14.662 [0x7f0549d30b38] WARN - SLOW QUERY: It took 400.000000 ms to retrieve 84 items.
Plex Media Server.log:Aug 31, 2021 09:49:16.277 [0x7f054bf8bb38] WARN - SLOW QUERY: It took 210.000000 ms to retrieve 50 items.
Plex Media Server.log:Aug 31, 2021 09:49:17.043 [0x7f054984fb38] WARN - SLOW QUERY: It took 810.000000 ms to retrieve 1 items.
Plex Media Server.log:Aug 31, 2021 09:49:17.044 [0x7f05499a9b38] WARN - SLOW QUERY: It took 810.000000 ms to retrieve 1 items.
Plex Media Server.log:Aug 31, 2021 09:51:05.550 [0x7f054be30b38] WARN - SLOW QUERY: It took 240.000000 ms to retrieve 12 items.
Also, as an FYI, my database file is much larger than most others that I’ve seen in the threads. Likely related, but I’m not sure I mentioned this earlier so I apologize:
[jake@plex Databases]$ ls -alh com.plexapp.plugins.library.db
-rw-r–r-- 1 plex plex 6.7G Aug 31 10:05 com.plexapp.plugins.library.db
Current plex version: plexmediaserver-1.24.1.4931-1a38e63c6.x86_64
OS: CentOS 7
Updated logs: Plex Media Server Logs_2021-08-31_10-12-19.zip (4.6 MB)
Thank you for your help + anyone else who can assist!
