Are you using VideoStation as well concurrently with PMS ?
The log shows PMS running for 2 minutes.
This is more than enough time for your PMS logs to be written to.
If there are no logs then we know the problem.
2022/10/11 16:40:39 start PlexMediaServer 1.29.1.6276-7000 Begin start-stop-status start
2022/10/11 16:41:01 start PlexMediaServer 1.29.1.6276-7000 End start-stop-status start ret=[0]
2022/10/11 16:41:02 start PlexMediaServer: start version 1.29.1.6276-7000 successfully, result 0
2022/10/11 16:43:17 start PlexMediaServer: begin to stop due to abnormal status
2022/10/11 16:43:17 start PlexMediaServer: begin to stop version 1.29.1.6276-7000
2022/10/11 16:43:17 start PlexMediaServer 1.29.1.6276-7000 Begin start-stop-status stop
2022/10/11 16:43:17 start PlexMediaServer 1.29.1.6276-7000 End start-stop-status stop ret=[0]
I am having the EXACT same issue right now and am feeling very frustrated. I’ve read through this whole post and am not understanding how it was resolved?
The one I attached above was from the most recent uninstall/reinstall, where I tried the “claim lost token” route. I do have a copy of the logs from before that uninstall—attaching that one here. Logs2.zip (5.4 MB)
Jan 14, 2023 09:19:37.287 [0x7f9bb9e880d0] INFO - SQLITE3:0x80000001, 283, recovered 239 frames from WAL file /var/packages/PlexMediaServer/shares/PlexMediaServer/AppData/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db-wal
Jan 14, 2023 09:19:37.289 [0x7f9bb9e880d0] ERROR - SQLITE3:0x80000001, 11, database corruption at line 66843 of [1b256d97b5]
Jan 14, 2023 09:19:37.289 [0x7f9bb9e880d0] ERROR - SQLITE3:0x80000001, 11, database corruption at line 66993 of [1b256d97b5]
Jan 14, 2023 09:19:37.289 [0x7f9bb9e880d0] ERROR - SQLITE3:0x80000001, 11, statement aborts at 10: [] database disk image is malformed
Jan 14, 2023 09:19:37.289 [0x7f9bb9e880d0] ERROR - SQLITE3:0x80000001, 11, database disk image is malformed in "PRAGMA cache_size=2048"
Jan 14, 2023 09:19:37.289 [0x7f9bb9e880d0] ERROR - SQLITE3:0x80000001, 11, database corruption at line 61875 of [1b256d97b5]
Jan 14, 2023 09:19:37.289 [0x7f9bb9e880d0] ERROR - Database corruption: sqlite3_statement_backend::prepare: database disk image is malformed for SQL: PRAGMA cache_size=2048
Changing cache size isn’t always the answer.
If the DB is fragmented, it can easily be fixed and you can go back to the default which does work the best.
Dang! Not sure how everything got so messed up. How do I easily fix the fragmented DB? Right now all drives are reading healthy. Should I scrub all the data?
Assuming that is a paid service? Is there a way to direct message you? I’m happy to pay to have this fixed by someone who knows what they’re doing and clearly you do.
PMS default is 40 on cache size? So when I increased the cache size it screwed it all up? I don’t fully understand still. Just willing to do what it takes to recover my server.
Actually - quick clarification. Does it matter if I change the PMS location after the fix? I want the server hosted on a storage pool with 4 drives to ensure longevity. The logs I sent through above have it hosted on a single drive not apart of the larger storage pool. I’m going to move the file location to Volume 2 and then do this fix? So long as that won’t majorly mess with the way your tool works…
longevity meaning, if a drive fails I won’t have to lose my server due to a degraded storage pool. Which has happened to me twice. If it’s on the larger storage pool with 4 drives if one corrupts I won’t have to move my server.