kobotoolbox / kpi / 22775989014 / 2

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>

7330 of 11487 branches covered (63.81%)

27960 of 34429 relevant lines covered (81.21%)

0.81 hits per line