This is an automated archive made by the Lemmit Bot.

The original was posted on /r/selfhosted by /u/lokwaniyash on 2025-01-18 03:23:55+00:00.

Hey everyone, Since I set sonarr and radarr up to manage my media, It has been a breeze, but there have been a few problems, one of them being that my indexers keep showing as failed, after looking into this apparently if an indexer doesn’t give results, it is assumed to be “not working” and marked as disabled, for which we see an error that indexer is disabled (sometimes for over 6 hours), and since sonarr and radarr doesn’t make more frequent health checks on those, its possible all indexers are not being used and we may not get results that are as good, i figured a solution would be to make an api callout every few minutes to check those indexers health, which worked pretty great, but i still saw sometimes that even after that, sometimes indexers might not be available, my requirement was, that even if the indexer is not working, force sonarr and radarr to use them, to which I thought of checking the radarr.db/sonarr.db database file(I’m on windows so I found it in C:/ProgramData/ replace AppName with sonarr or radarr), and see if i can find any more details there, where i found a table called “IndexerStatus” which has escalation level, basically if an indexer fails continuously, it’ll be disabled for even longer, so I made a trigger which checks any updates on that table and make sure the escalation level stays at 0, and the delay until column stays null as well, here’s the sql i wrote (don’t mind me, first trigger)

CREATE TRIGGER prevent_change_to_column AFTER UPDATE ON IndexerStatus FOR EACH ROW BEGIN -- Ensure the column always has the value 0 UPDATE IndexerStatus SET EscalationLevel = '0', DisabledTill = NULL WHERE rowid = OLD.rowid; END

and after adding this to the db and saving it, haven’t seen any failures so far, and have been noticing sonarr and radarr using all indexers, I’ll keep you guys updated to see if this gives any problems