kobotoolbox / kpi / 23617314814 / 2

82%

master: 76%

push

github

fix(userReports): prevent infinite loop in MV background job (#6878)

### 💭 Notes

- Root cause: when `SKIP_HEAVY_MIGRATIONS=True`, `manage_user_reports_mv
--create` resets `LongRunningMigration.status` back to `'created'`,
which re-triggers `0019_recreate_user_reports_mv` indefinitely.
- Fix: a new `--force` flag bypasses `SKIP_HEAVY_MIGRATIONS` and runs
the migration immediately. The background job always passes `--force`.
- This PR also reverts the `CREATE INDEX CONCURRENTLY` approach
introduced in #6876: the view is freshly created at index time so there
are no concurrent readers — `CONCURRENTLY` would have required
autocommit mode for no benefit.
- No behavior change when `--force` is not passed.

3800 of 11417 branches covered (33.28%)

19061 of 34838 relevant lines covered (54.71%)

0.55 hits per line