Database Corruption

[bsquidwrd]

Server Version#: v1.18.0.1913-e5cc93306
Player Version#: The same version? I’m accessing it from the web

Soci Exception handled: sqlite3_statement_backend::loadRS: database disk image is malformed

Following the steps here I was able to get the “database disk image malformed” error to go away, but once it was up and running again it only took a matter of minutes to get it back.

I stopped Plex, deleted the Logs, ran the “repair” again (aka the migration drop) and started it back up when I got the error again.

I have my logs and database copied and zipped right now. If I need to send them over, let me know where/how.

[CWallace]

Don’t have UnRAID but remembered seeing this:

Plex Database keeps Corrupting

I have 2 Plex servers runing in dockers on UNraid (one is from the Linuxserver repo and the other is from the unraid/limetech repo). One as my main and the other as an emergency backup. recently the main ones DB failed. The docker was running fine and updated (even tried Force Update). i followed the recover a corrupted DB steps (which didn’t work. Well the process change from corrupted to fine, but i still had no media). I then rolled back a couple of DB in the appdata folder, which resto…

Hope this helps.

[bsquidwrd]

I’ll take a read of it tomorrow. Can’t believe I didn’t see that with my searching

[bsquidwrd]

So far moving my plex appdata folder to my cache drive and making the mapping changes under the containers advanced settings has fixed this issue.

For those who don’t want to dig through the post linked by @CWallace , see the below quotes:

@Mongo75

In my research, I came across a piece that said having your appdata spread across the array can cause this. The recommendation was to have appdata either on a cache drive only, or on a single dedicated drive in the array.

@Mongo75

This is my Step by Step:

1. Go to Docker and stop Plex.
2. Go to your appdata folder.
3. Rename (or delete) your Plex folder.
4. Either reboot now, or update unRaid to 6.7.0 and reboot.
5. After the reboot or update, install and configure Plex. Before you click on “APPLY” and after configuring it to your liking, click the “Show more settings…” dropdown near the bottom of the screen. This is where you set your Plex folder location.
6. You will see the default setting, /mnt/user/appdata/(container name) . You want to change this to /mnt/cache/appdata/(container name) if you use a cache drive, or to /mnt/disk(number)/appdata/(container name) if you don’t use cache. I don’t use cache, so in my case, I changed /config from /mnt/user/appdata/PlexMediaServer to /mnt/disk1/appdata/PlexMediaServer .
7. Now click on “APPLY” to install Plex.

EDIT: I had to change my appdata share to be “cache only” then it seemed to work. I opted for starting fresh with all my appdata.