[SQLite DB Corruption testers needed]

1 minute ago, Frank1940 said:

Another factor would SSD or HD cache drive(s). 

SSD.

[SQLite DB Corruption testers needed]

54 minutes ago, trott said:

actually even for the appdata on cache, there will be 2 setup

1. map directly to /mnt/cache/xxx

2. map to user share /mnt/user/xxx with setup "use cache disk" only

 

by testing on this 2 setup, we might be able to isolate if the issue is fuse related or not

 

FWIW I'm following #2 and am not seeing corruption issues.

[SQLite DB Corruption testers needed]

One week on, I'm seeing no issues using the disk1/cache-preferred setup I described above. Running an integrity check on both Sonarr and Plex's databases returns no errors; and everything seems stable.

[SQLite DB Corruption testers needed]

So far so good... There's also a noticeable speed benefit (though that's to be expected I guess).

 

Note that i'm effectively running my databases on the cache drive only, with fallback to disk1 if they get too full. This does mean you lose parity on them, though.

[SQLite DB Corruption testers needed]

I've been debugging this solo, but came across this thread and wanted to share my experiences in case they might offer some pointers. Unraid has been bulletproof for me until now – I'd love to help you guys with this if I can!

 

I've been having regular corruption over the past week or two. It first occurred on 6.7.0, and has definitely become worse on 6.7.2.

 

A couple of days back I created two new shares – Plex AppData and Sonarr AppData, configured both to prefer the Cache (but exist on disk1 only), pointed both Plex and Sonarr there via /mnt/user/[app-specific share]/ and that seems to have potentially fixed the issue – the corruption was nightly before. I'll keep watching.

 

The sqlite3 .dump and re-ingest trick has never worked for me when the databases have corrupted.

 

I also noticed that when Sonarr's db hosed itself, Plex's performance for the TV library became abysmally slow – often timing out. Music and Movies were unaffected, and still loaded. As soon as I stopped the Sonarr container, Plex performance recovered.

 

I've attached my diagnostics in case it's useful.

 

 

tower-diagnostics-20190801-1307.zip