Hello There,
The ‘Backup database every three days’ feature is checked but not making the separate backup copies. How do I fix this problem?
Thank you,
-Alex
I am having this same issue. The directory I specified has no files in it, more than 2 weeks after setting it up.
I too have this issue. I’ve changed the scheduled tasks options to allow 23 hours of operation but no backups are being made.
It looks like I too have DB corruption, judging by the vast quantity of errors being spat into the console.
I’ve attempted to dump the SQLite DB and then reimport it, but I’m presented with the following errors and a resulting zero-byte DB file. Is there anything I can do?
root@MyCloud repair # sqlite3 com.plexapp.plugins.library.db.tmp < dump.sql
Error: near line 297035: PRIMARY KEY must be unique
Error: near line 297036: PRIMARY KEY must be unique
Error: near line 297037: PRIMARY KEY must be unique
Error: near line 297038: PRIMARY KEY must be unique
Error: near line 297039: PRIMARY KEY must be unique
Error: near line 297040: PRIMARY KEY must be unique
Error: near line 297041: PRIMARY KEY must be unique
Error: near line 297042: PRIMARY KEY must be unique
Error: near line 297043: PRIMARY KEY must be unique
Error: near line 297044: PRIMARY KEY must be unique
Error: near line 297045: PRIMARY KEY must be unique
Error: near line 297046: PRIMARY KEY must be unique
Error: near line 297047: PRIMARY KEY must be unique
Error: near line 297048: PRIMARY KEY must be unique
Error: near line 297049: PRIMARY KEY must be unique
Error: near line 297050: PRIMARY KEY must be unique
Error: near line 297051: PRIMARY KEY must be unique
Error: near line 297052: PRIMARY KEY must be unique
Error: near line 297053: PRIMARY KEY must be unique
Error: near line 297054: PRIMARY KEY must be unique
Error: near line 297055: PRIMARY KEY must be unique
Error: near line 297056: PRIMARY KEY must be unique
Error: near line 297057: PRIMARY KEY must be unique
Error: near line 297058: PRIMARY KEY must be unique
Error: near line 297059: PRIMARY KEY must be unique
Error: near line 520992: PRIMARY KEY must be unique
Error: near line 520993: PRIMARY KEY must be unique
Error: near line 520994: PRIMARY KEY must be unique
Error: near line 520995: PRIMARY KEY must be unique
Error: near line 520996: PRIMARY KEY must be unique
Error: near line 520997: PRIMARY KEY must be unique
Error: near line 520998: PRIMARY KEY must be unique
Error: near line 520999: PRIMARY KEY must be unique
Error: near line 521000: PRIMARY KEY must be unique
Error: near line 521001: PRIMARY KEY must be unique
Error: near line 521002: PRIMARY KEY must be unique
Error: near line 521003: PRIMARY KEY must be unique
Error: near line 521004: PRIMARY KEY must be unique
Error: near line 521005: PRIMARY KEY must be unique
Error: near line 521006: PRIMARY KEY must be unique
Error: near line 521007: PRIMARY KEY must be unique
Error: near line 521008: PRIMARY KEY must be unique
Error: near line 521009: PRIMARY KEY must be unique
Error: near line 521010: PRIMARY KEY must be unique
Error: near line 521011: PRIMARY KEY must be unique
Error: near line 521012: PRIMARY KEY must be unique
Error: near line 521013: PRIMARY KEY must be unique
root@MyCloud repair # ls -l
-rw-r--r-- 1 root root 197852160 Feb 15 13:47 com.plexapp.plugins.library.db
-rw-r--r-- 1 root root 0 Feb 15 13:50 com.plexapp.plugins.library.db.tmp
-rw-r--r-- 1 root root 163159760 Feb 15 13:48 dump.sql
Just an update here - I was unable to do anything on the NAS as I think it has out-of-date sqlite binaries, but I shut down Plex, moved the DB to my Mac and ran the following:
sqlite3 com.plexapp.plugins.library.db
and then within the sqlite prompt
.clone new.db
I then copied the new.db back to the NAS and renamed it com.plexapp.plugins.library.db, then restarted Plex and it seems to have fixed the corruption.
