kobotoolbox / kpi / 23617314814

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.

7437 of 11551 branches covered (64.38%)

28552 of 34928 relevant lines covered (81.75%)

5.81 hits per line