kobotoolbox / kpi / 22775989014 / 1

81%

master: 76%

push

github

fix(migrations): fix materialized view migration conflict DEV-1822 (#6796)

### 📣 Summary
Fixes a database locking issue caused by the
`user_reports_userreportsmv` materialized view that could block
migrations during upgrades or local setup.

### 📖 Description
This update resolves a technical conflict where the background
materialized view used for user reports (`user_reports_userreportsmv`)
would lock database tables, preventing database migrations from applying
successfully.

This PR automates the resolution:
1. Adds a management command (`manage_user_reports_mv`) to safely handle
dropping and recreating the view.
2. Updates `scripts/migrate.sh` to automatically intercept the
`django.db.utils.NotSupportedError`. When detected, the script drops the
view, safely applies the blocked migrations, and then manages the
recreation.
3. Respects `SKIP_HEAVY_MIGRATIONS`: To prevent container orchestrators
from timing out during deployment, if heavy migrations are skipped, the
view recreation is deferred to a Celery Long-Running Migration
background task (`0019_recreate_user_reports_mv`), ensuring instant
container startup.
---------

Co-authored-by: Olivier Léger <olivierleger@gmail.com>

7080 of 11475 branches covered (61.7%)

27161 of 34422 relevant lines covered (78.91%)

0.79 hits per line