chore(issues): Backfill IGNORED groups with missing substatuses

[snigdhas]

We need to run a backfill to fix the missing substatuses for IGNORED groups. This redash query shows we have ~120K ignored groups that have no substatus. Further digging shows that we should have the info needed to backfill via Activity and GroupSnooze tables.

Marking this as a post-deploy migration for safety.

Fixes https://github.com/getsentry/sentry/issues/75684

[github-actions[bot]]

This PR has a migration; here is the generated SQL for src/sentry/migrations/0748_fix_substatus_for_ignored_groups.py ()

--
-- Raw Python operation
--
-- THIS OPERATION CANNOT BE WRITTEN AS SQL

[codecov[bot]]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

:white_check_mark: All tests successful. No failed tests found.

Additional details and impacted files

@@           Coverage Diff           @@
##           master   #75702   +/-   ##
=======================================
  Coverage   78.16%   78.16%           
=======================================
  Files        6901     6901           
  Lines      307088   307088           
  Branches    52895    52895           
=======================================
+ Hits       240024   240032    +8     
+ Misses      60635    60633    -2     
+ Partials     6429     6423    -6     

[github-actions[bot]]

This PR has a migration; here is the generated SQL for src/sentry/migrations/0752_fix_substatus_for_ignored_groups.py ()

--
-- Raw Python operation
--
-- THIS OPERATION CANNOT BE WRITTEN AS SQL

[github-actions[bot]]

This PR has a migration; here is the generated SQL for src/sentry/migrations/0753_fix_substatus_for_ignored_groups.py ()

--
-- Raw Python operation
--
-- THIS OPERATION CANNOT BE WRITTEN AS SQL