Multiple Seasons Randomly Monitored in Sonarr

[ExtremeFiretop]

Describe the bug
When either a regular user or admin user attempt to request multiple seasons of a show already existing in Sonarr at once.
(i.e not searching for all seasons or a single season, but instead selecting a multiple of seasons of a show such as 1-9 but not all seasons). Will result in random seasons being monitored in Sonarr.

To Reproduce
Steps to reproduce the behavior:

1. Connect Sonarr to Ombi
2. As either a regular user or admin user attempt to request multiple seasons of a show that already exist in Sonarr.
3. For example if you search for the TV show "Intervention" and request only Season 1-9 (Not all seasons which is more)
4. You will get season 3 and 4 monitored and 9; all the others (1,5,6,7,8) will not be monitored in Sonarr
   (even though they were selected.)

Expected behavior
If you request season 1-9 of Intervention; Sonarr monitors Intervention Seasons 1-9.

Screenshots

Logs (Logs directory where Ombi is located)

2022-02-14 03:59:34.811 -05:00 [Debug] Batch acquisition of 1 triggers
2022-02-14 04:00:00.008 -05:00 [Debug] Batch acquisition of 0 triggers
2022-02-14 04:00:00.024 -05:00 [Debug] Calling Execute on job Plex.IPlexContentSyncRecentlyAdded
2022-02-14 04:00:01.026 -05:00 [Debug] Batch acquisition of 1 triggers
2022-02-14 04:00:01.027 -05:00 [Debug] Batch acquisition of 0 triggers
2022-02-14 04:00:01.027 -05:00 [Debug] Calling Execute on job Plex.IPlexAvailabilityChecker
2022-02-14 04:00:01.028 -05:00 [Debug] Trigger instruction : NoInstruction
2022-02-14 04:00:01.165 -05:00 [Debug] Trigger instruction : DeleteTrigger
2022-02-14 04:00:01.165 -05:00 [Debug] Deleting trigger
2022-02-14 04:00:27.928 -05:00 [Debug] Batch acquisition of 0 triggers
2022-02-14 04:00:57.342 -05:00 [Debug] Batch acquisition of 0 triggers
2022-02-14 04:01:25.222 -05:00 [Debug] Batch acquisition of 0 triggers
2022-02-14 04:01:54.803 -05:00 [Debug] Batch acquisition of 0 triggers
2022-02-14 04:02:17.918 -05:00 [Debug] Batch acquisition of 0 triggers
2022-02-14 04:02:47.108 -05:00 [Debug] Batch acquisition of 0 triggers
2022-02-14 04:03:15.905 -05:00 [Debug] Batch acquisition of 0 triggers
2022-02-14 04:03:39.944 -05:00 [Debug] Batch acquisition of 0 triggers
2022-02-14 04:04:05.069 -05:00 [Debug] Batch acquisition of 0 triggers
2022-02-14 04:04:29.436 -05:00 [Debug] Batch acquisition of 0 triggers
2022-02-14 04:04:56.691 -05:00 [Debug] Batch acquisition of 1 triggers
2022-02-14 04:05:00.000 -05:00 [Debug] Batch acquisition of 0 triggers
2022-02-14 04:05:00.000 -05:00 [Debug] Calling Execute on job Jellyfin.IJellyfinContentSync
2022-02-14 04:05:00.005 -05:00 [Debug] Trigger instruction : NoInstruction
2022-02-14 04:05:26.396 -05:00 [Debug] Batch acquisition of 0 triggers
2022-02-14 04:05:55.926 -05:00 [Debug] Batch acquisition of 0 triggers
2022-02-14 04:06:22.138 -05:00 [Debug] Batch acquisition of 0 triggers
2022-02-14 04:06:50.441 -05:00 [Debug] Batch acquisition of 0 triggers
2022-02-14 04:07:15.337 -05:00 [Debug] Batch acquisition of 0 triggers
2022-02-14 04:07:42.362 -05:00 [Debug] Batch acquisition of 0 triggers
2022-02-14 04:08:06.125 -05:00 [Debug] Batch acquisition of 0 triggers

Desktop (please complete the following information):

• OS: Windows 10 21H2 (19044.1503)

Ombi Version (please complete the following information):

• Version: 4.11.8
• Media Server: 1.25.5.5492
• Database Type: SQLite

Additional context
I tested on Sonarr version: 3.0.6.1451 (nightly) and version: 3.0.6.1342 (master) and the problem continues on both. Also tested on Ombi 4.11.6 and had the same issue; upgrading to 4.11.8 did not solve it.

[github-actions]

Hi!

Thanks for the issue report. Before a real human comes by, please make sure you used our bug report format.

Have you looked at the wiki yet? https://docs.ombi.app/

Before posting make sure you also read our FAQ.

Make the title describe your issue. Having 'not working' or 'I get this bug' for 100 issues, isn't really helpful.

If we need more information or there is some progress we tag the issue or update the tag and keep you updated.

Thanks!

Ombi Bot.

[tidusjar]

I can't seem to reproduce this, is it still happening?

[ExtremeFiretop]

I can't seem to reproduce this, is it still happening?

Oh wow! Sorry I totally forgot to follow up on this.
Let me test right now I'll get back to you in a few minutes once I have a good scenario identified to test.

[ExtremeFiretop]

@tidusjar So yes and no?

I actually found a different show and tested and everything worked flawlessly.
I requested seasons missing and they were all monitored in Sonarr as expected.

I then went back to the show I originally opened this issue for; "Intervention"

You'll see (below) in Sonarr I have only seasons 15 and up originally monitored:

I went to Ombi and requested the seasons not monitored in Sonarr; (so season 1 to 9 as found below):

And only Seasons 2, 3 and 8 were added as "monitored" in Sonarr as found below:

So I can actually say it must be something else... It's not generic; it's specific to this show for some reason.
Is there a delay for stuff to get in sync after deleting a request using the SQLite database? If so how much of a delay?

Thanks again for your time. Sorry again for the confusion and not following up with more info.

[ExtremeFiretop]

To test a possible delay; I deleted a request manually and it still shows as "Requested" 15 minutes later and I also did a clear cache and sync with Plex and made sure it was communication with Sonarr correctly and no difference as found below:

And the request is no where to be found:

[ExtremeFiretop]

@tidusjar I checked again today and even though I deleted the request it still shows as "Requested" in the UI.

Is this a bug or some type of DB corruption you think? Any theories?

Thanks again!

[tidusjar]

If the show and seasons are monitored in sonarr. Ombi will detect that and show them as requested. No point requesting something that’s always monitors.

[ExtremeFiretop]

If the show and seasons are monitored in sonarr. Ombi will detect that and show them as requested. No point requesting something that’s always monitors.

Ah yes! Your correct I forgot to delete the request from Sonarr. That explains that; but it still doesn't explain the results with with the Show 'Intervention".

Thanks again!

[ExtremeFiretop]

@tidusjar Just updated to 4.14.2 and the issue is confirmed fixed now on "Intervention"

Your awesome for taking the time. I hope you realize that :) This seemed like a very specific issue since it wasn't easily reproduceable.

Thanks again for your time Jamie! As always I'll keep an eye for any unexpected behaviour.