Dumping the db and then recreating it works for me. Which I think is the same as the Plex recommended commands
Sadly not an Unraid guy, so clueless here, but as others has mentioned, Unraid has a history of bas SQLite handling
@dane, any chance you can still
Take a look at my
Logs in case anything stands out ??
That would req. a fresh set of logs 
@dane22 - Its āJustā corrupted again 
Iāll send you the logs directly if you could take a look ??
Nothing stands out here
Logs indicate a corruption most likely in media_items and/or media_parts table or their indexes
But no indication as to why
I did however do some searching, and found this:
https://sqlite.org/forum/info/02c1a784a2830a3d
and this:
So if using NFS, then consider moving config to a local disk
Not sure what NFS is ?
I use XSF file system for the unassigned drive
Hey,
Yup I donāt use that, so i dont think thats the problem.
Iām stumped.
Do the logs point to a corrupt DB ?
thanks
Yes, but as said, nothing to indicate why, so maybe something in your system/os logs?
And as said, not knowing your environment
its ok, what was the last action before the db error ?
Itās unlikely that thereās a āsmoking gunā event in the Plex logs.
Plex uses SQLite to read and write data.
Each IO operation will either succeed or fail.
Plex will log the first time a read or write encounters an error, but that indicates that the database was already damaged.
SQLite is absurdly reliable unless the underlying storage is lying to it and misbehaving.
How SQLite Is Tested
Most Widely Deployed SQL Database Engine
How To Corrupt An SQLite Database File
How do you currently have Unraid configured? Where is the Plex data & database stored? Whatās the filesystem?
In a nutshell:-
Iām using the linuxserver plex docker, with my plex app data on a dedicated SSD using āUnassigned Devicesā
The SSD is XSF formatted & is 1TB in size, and only 230GB used. its a Samsung 860 EVO & is 2 years (ish) old.
Ahh, interesting. Iām super unfamiliar with Unraid, so āUnassigned Devicesā didnāt mean anything to me.
It seems like itās a plugin for people who want to use Unraid, but donāt actually want to use Unraid? Odddddddd
Linux & XFS & SQLite should be fine. XFS is a conservative choice.
Iāve got no good suggestions.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
