I had a huge queue in my sabnzbd, when sab suddenly threw them all out in 4 seconds time, probably a problem with my news provider.
Things are working fine again now, but all those files are now blacklisted in nzbdrone.
Is there a way to clear this list and start fresh?
Not currently. The work around is to disable it in media management settings (advanced). Then you can re-enable it later on.
EDIT: Added to Trello: https://trello.com/c/iZUJY7AR/533-ui-for-blacklist
ok, thx!
So, disabling failed download handling works, BUT, say that there’s a 1080 bluray, which is incomplete, and a 1080 webdl, which is complete.
The bluray is correctly blacklisted for being incomplete, the webdl is incorrectly blacklisted.
Now when I disable blacklisting, it tries for the BR over and over again.
So I’d need a way to clear the blacklist, but keep it enabled, so it can start building it again.
Would migrating my settings, uninstalling and then re-installing nzbdrone do that?
Either use manual search, or clear the Blacklist table in the nzbdrone.db (sqlite3 DB). Or you would need to wipe out the entire DB and set everything back up, since everything is stored in the DB (settings/series/etc).
I couldn’t open the .db file with any sglite reader, so just reinstalled nzbdrone, was the easiest fix 
I use Database.net all the time, but also did it on Ubuntu with the sqlite command line tool. http://fishcodelib.com/database.htm - I did notice on Ubuntu it complained that the DB was in use, so I shutdown drone first, with Database.net I’ve never has an issue.
1 Like