Jump to content
Rich Minear

Downgraded back to 6.6.7 due to Sqlite corruption

188 posts in this topic Last Reply

Recommended Posts

2 minutes ago, Abzstrak said:

yeah, just been lazy... was thinking of doing that as well as shooting out an email/sms message to my phone letting me know its corrupt. its been 10 or 11 days since my last corruption, so... motivation isn't all there either :)

 

haha i feel you - i was extremely motivated when it was dying every day but now with 2-3 weeks in between, there is not much motivation and hopefully this gets sorted out by the dev team!

Share this post


Link to post
54 minutes ago, Abzstrak said:

its been 10 or 11 days since my last corruption

Sounds like you are attending a meeting. Stay strong.

Share this post


Link to post
1 hour ago, Abzstrak said:

I just have been running this command hourly (using user scripts addon). Obviously you'll need to create the dbbackups folder.


tar zcvf /mnt/cache/appdata/PlexMediaServer/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Databases/dbbackups/com.plexapp.plugins.library.db-$(date +%A-%H%M).tar.gz /mnt/cache/appdata/PlexMediaServer/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Databases/com.plexapp.plugins.library.db

 

Thanks. I modified it for my setup (replaced cache with user) and stuck it in a bash script under /etc/chron.daily, set it to executable and ran `update_cron`. It appeared in the list of daily tasks in scheduler, so I'm hoping it will work. :)

Share this post


Link to post

Didn't took long. Database again corrupted. Unraid 6.7.1. 

I use a r710 with a H700 Raid Card, if you want to know. 

Share this post


Link to post
6 minutes ago, Noim said:

Didn't took long. Database again corrupted. Unraid 6.7.1. 

I use a r710 with a H700 Raid Card, if you want to know. 

On which disk does your database reside? How is it formatted? What is your appdata config path for the docker? What is your DirectIO setting?

Share this post


Link to post
Just now, jonathanm said:

On which disk does your database reside? How is it formatted? What is your appdata config path for the docker? What is your DirectIO setting?

Which disk: I only have one 8TB WD Drive. One you can find in the wd my book things.

Formatted: xfs

appdata config path, don't know how this helps you: /mnt/user/appdata/PlexMedia/

direct io: Default? Never changed this settings. I am not even able to find it. 

Share this post


Link to post
47 minutes ago, Noim said:

Which disk: I only have one 8TB WD Drive. One you can find in the wd my book things.

Formatted: xfs

appdata config path, don't know how this helps you: /mnt/user/appdata/PlexMedia/

direct io: Default? Never changed this settings. I am not even able to find it. 

 

You need to change it to use /mnt/diskX, where X is your disk number. This will for most user be good enough to not get a corrupted database.

Share this post


Link to post

I want to add a datapoint for @testdasi - I am -not- having the corruption issue and never did but I use basically all the same containers (plex, sonarr, deluge.) Maybe something different in my config will help isolate what's different.

 

What CPU? How much RAM? Array config?

i5-760, P55 motherboard, 8GB ram. 

Array is 3 drives, all XFS+LUKS encrypted, 8+8+4TB, + 256GB xfs cache.

in addition, one 4TB unassigned device used mostly for deluge scratch disk, the partition is btrfs+LUKS encrypted.

All five devices connected to motherboard P55 SATA controller.

 

Roughly how large is your collection? I think file count, even a rough estimate, is more important here.

movies = 158GB / 288 files

tv = 1.7 TB / 8202 files

 

Have you set your appdata to /mnt/cache (or for those without cache, /mnt/disk1)? If you haven't, we'll ignore you.

I am using /mnt/user/appdata/<app> for -all- my containers, without corruption issue. I thought about changing it when reading the first four pages but now I won't, because I want to see if I ever do get corrupted. I don't mind rebuilding my library from scratch if it happens.

 

Do you have a link between Sonarr and Plex? If yes, have you disable it? If you haven't, we'll ignore you.

No, it's not linked. I wanted to, I couldn't get it to auth properly. Sonarr is linked to Deluge though.

 

Do you have automatic library update on change / partial change? If yes, have you set it to hourly? If you haven't we'll ignore you.

No, I manually update to avoid spinning disks up needlessly.

 

----
I repeat, I do not have the issue, I just wanted to put my info in so maybe we could see if there was any significant difference between my config and other people's configs.

Share this post


Link to post
On 6/19/2019 at 1:22 PM, ProZac said:

How about the people who started to report this issue? If more people test this, maybe there is some more information to gather from this?
@Rich Minear, @Brian H., @Jackjohnsonuk, @DiRiN, @principis, @Scythe, @runraid, @Abzstrak, @Daniel Samuels, @Addy?
The more who are able to test the better :)

 

Sorry I am in the middle of exams and didn't get an email... The issue is completely solved for me. Just moved plex db from /mnt/user to /mnt/disk1.

I'm sorry but I won't do any testing. I have way too much work to do and it's really annoying. I posted diagnostics on the different thread.

Share this post


Link to post
On 6/24/2019 at 10:10 PM, saarg said:

 

You need to change it to use /mnt/diskX, where X is your disk number. This will for most user be good enough to not get a corrupted database.

This would defeat the hole purpose of using unraid. At least for me. Btw updated unraid to 6.7.2. However, the corruption happened again. 

Share this post


Link to post
44 minutes ago, Noim said:

This would defeat the hole purpose of using unraid. At least for me. Btw updated unraid to 6.7.2. However, the corruption happened again. 

How so?  As a general rule, appdata (and that's the only path mapping that has relevance here) is confined to either the cache drive (use Cache: Prefer), or a single disk for performance reasons.  In that case, there is fundamentally zero difference between referencing it as /mnt/user/appdata or as /mnt/cache/appdata

 

That being said, this issue is a priority for limetech.

Share this post


Link to post
On 7/1/2019 at 4:57 PM, Squid said:

How so?  As a general rule, appdata (and that's the only path mapping that has relevance here) is confined to either the cache drive (use Cache: Prefer), or a single disk for performance reasons.  In that case, there is fundamentally zero difference between referencing it as /mnt/user/appdata or as /mnt/cache/appdata

 

That being said, this issue is a priority for limetech.

Your tipp didn't work. Database corruption still happens. 

Share this post


Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.