[Req#46c8/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x7f97147a18, 17, statement

Plex Media Server
,
1

Could I please get some help with the error in the subject line. My database in good working order and has been checked and fixed in @ChuckPa tool.

I think this is the issue but I run on raid (SHR). I wouldn’t know how to fix it. - plex-fix-db.sh · GitHub

from this reddit post - Reddit - Dive into anything

any help would be appreciated!

Server Version#:1.32.5.7318-7000
Plex Media Server Logs_2023-07-12_15-26-57.zip (7.9 MB)

Player Version#:
<If providing server logs please do NOT turn on verbose logging, only debug logging should be enabled>

2

No idea what tool you’re referencing is doing.

What I can offer you is this:

3

That’s the tool i was referencing. It doesn’t fix the issue.

4

Is there any other help available? like troubleshooting help? Problem solving help? All associated with PMS of course.

Thanks

5

The tool you linked is not mine plex-fix-db.sh (this isn’t mine)

Looking through your logs, I see this:

Jul 12, 2023 15:26:05.536 [547508502752] INFO - [Req#453/Database optimization/com.plexapp.plugins.library.db] SQLITE3:0x7f87058a18, 17, statement aborts at 58: [select * from metadata_items limit 1] database schema has changed

This happens when “Optimize Databases” has been selected (PMS is running) before PMS finishes the upgrade process (I see you are running 1.32.57318 – which is new)

The error isn’t really an error. It’s telling us it’s refusing to optimize the databases because the DB’s are still changing.

Here is where it’s changing:

Jul 12, 2023 15:24:25.205 [547508502752] DEBUG - [Req#453/Database optimization/com.plexapp.plugins.library.db/DatabaseFixups] Running database fix-ups completed in 2.6 seconds.
Jul 12, 2023 15:24:25.205 [547508502752] DEBUG - [Req#453/Database optimization/com.plexapp.plugins.library.db] Captured session 0.
Jul 12, 2023 15:24:25.205 [547508502752] DEBUG - [Req#453/Database optimization/com.plexapp.plugins.library.db] Captured session 1.
Jul 12, 2023 15:24:25.205 [547508502752] DEBUG - [Req#453/Database optimization/com.plexapp.plugins.library.db] Captured session 2.
Jul 12, 2023 15:24:25.205 [547508502752] DEBUG - [Req#453/Database optimization/com.plexapp.plugins.library.db] Captured session 3.
Jul 12, 2023 15:24:25.205 [547508502752] DEBUG - [Req#453/Database optimization/com.plexapp.plugins.library.db] Captured session 4.
Jul 12, 2023 15:24:25.205 [547508502752] DEBUG - [Req#453/Database optimization/com.plexapp.plugins.library.db] Captured session 5.
Jul 12, 2023 15:24:25.205 [547508502752] DEBUG - [Req#453/Database optimization/com.plexapp.plugins.library.db] Captured session 6.
Jul 12, 2023 15:24:25.205 [547508502752] DEBUG - [Req#453/Database optimization/com.plexapp.plugins.library.db] Captured session 7.
Jul 12, 2023 15:24:25.205 [547508502752] DEBUG - [Req#453/Database optimization/com.plexapp.plugins.library.db] Captured session 8.
Jul 12, 2023 15:24:25.205 [547508502752] DEBUG - [Req#453/Database optimization/com.plexapp.plugins.library.db] Captured session 9.
Jul 12, 2023 15:24:25.205 [547508502752] DEBUG - [Req#453/Database optimization/com.plexapp.plugins.library.db] Captured session 10.
Jul 12, 2023 15:24:25.205 [547508502752] DEBUG - [Req#453/Database optimization/com.plexapp.plugins.library.db] Captured session 11.
Jul 12, 2023 15:24:25.205 [547508502752] DEBUG - [Req#453/Database optimization/com.plexapp.plugins.library.db] Captured session 12.
Jul 12, 2023 15:24:25.205 [547508502752] DEBUG - [Req#453/Database optimization/com.plexapp.plugins.library.db] Captured session 13.
Jul 12, 2023 15:24:25.205 [547508502752] DEBUG - [Req#453/Database optimization/com.plexapp.plugins.library.db] Captured session 14.
Jul 12, 2023 15:24:25.205 [547508502752] DEBUG - [Req#453/Database optimization/com.plexapp.plugins.library.db] Captured session 15.
Jul 12, 2023 15:24:25.205 [547508502752] DEBUG - [Req#453/Database optimization/com.plexapp.plugins.library.db] Captured session 16.
Jul 12, 2023 15:24:25.205 [547508502752] DEBUG - [Req#453/Database optimization/com.plexapp.plugins.library.db] Captured session 17.
Jul 12, 2023 15:24:25.205 [547508502752] DEBUG - [Req#453/Database optimization/com.plexapp.plugins.library.db] Captured session 18.
Jul 12, 2023 15:24:25.205 [547508502752] DEBUG - [Req#453/Database optimization/com.plexapp.plugins.library.db] Captured session 19.
Jul 12, 2023 15:24:25.205 [547508502752] DEBUG - [Req#453/Database optimization/com.plexapp.plugins.library.db] Rebuilding full text search tables.
Jul 12, 2023 15:24:25.206 [547508502752] DEBUG - [Req#453/Database optimization/com.plexapp.plugins.library.db] Activity: updated activity ca8f460c-4a23-45a9-98ee-0d452cb263ce - completed 40.0% - Optimizing database
Jul 12, 2023 15:24:36.726 [547593236704] DEBUG - BPQ: [Starting] -> [Processing]

Right before you grabbed the ZIP file, it did finish optimizing the DB…

Jul 12, 2023 15:26:06.286 [547593236704] DEBUG - PlayQueue: 0 generated IDs compressed down to a 20 byte blob.
Jul 12, 2023 15:26:06.287 [547593236704] DEBUG - BPQ: [Processing] -> [Idle]
Jul 12, 2023 15:26:06.289 [547508502752] DEBUG - [Req#453/Database optimization/com.plexapp.plugins.library.db] Activity: Ended activity ca8f460c-4a23-45a9-98ee-0d452cb263ce.
Jul 12, 2023 15:26:43.228 [547643433184] DEBUG - WebSocket: client initiated close
Jul 12, 2023 15:26:43.228 [547643433184] DEBUG - NotificationStream: Removing because of close
Jul 12, 2023 15:26:43.240 [547643433184] DEBUG - handleStreamRead code 1: stream truncated
Jul 12, 2023 15:26:43.240 [547643433184] DEBUG - Completed after connection close: [192.168.1.31:63205] -3 GET /:/websockets/notifications?filters=log (8 live) #443 TLS GZIP 138478ms 21929 bytes
Jul 12, 2023 15:26:43.277 [547538055392] DEBUG - Request: [192.168.1.31:63238 (Subnet)] GET /:/prefs (10 live) #4ef TLS GZIP Signed-in Token (mdreed72) (Chrome)
Jul 12, 2023 15:26:43.280 [547593269472] DEBUG - Request: [192.168.1.31:63239 (Subnet)] GET /accounts/1 (10 live) #565 TLS GZIP Signed-in Token (mdreed72) (Chrome)
Jul 12, 2023 15:26:43.285 [547576361184] DEBUG - Request: [192.168.1.31:63240 (Subnet)] GET /myplex/account (10 live) #564 TLS GZIP Signed-in Token (mdreed72) (Chrome)
Jul 12, 2023 15:26:43.299 [547641323744] DEBUG - Completed: [192.168.1.31:63239] 200 GET /accounts/1 (10 live) #565 TLS GZIP 22ms 683 bytes (pipelined: 1)
Jul 12, 2023 15:26:43.299 [547641323744] DEBUG - Completed: [192.168.1.31:63240] 200 GET /myplex/account (10 live) #564 TLS GZIP 14ms 3965 bytes (pipelined: 1)
Jul 12, 2023 15:26:43.311 [547641323744] DEBUG - Completed: [192.168.1.31:63238] 200 GET /:/prefs (10 live) #4ef TLS GZIP 34ms 8863 bytes (pipelined: 1)
Jul 12, 2023 15:26:45.951 [547593269472] DEBUG - Request: [192.168.1.31:63244 (Subnet)] GET /diagnostics/logs (11 live) #566 TLS GZIP Signed-in Token (mdreed72) (Chrome)
Jul 12, 2023 15:26:45.951 [547593269472] DEBUG - [Req#566] Diagnostics: Building logfile zip

What is it doing now?

Lastly, Regarding my tool, it knows the all the syno & docker structures (when run from inside the docker container), so that should still be good for you …

Please advise.

6

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