Migration says applied, but production says column does not exist

Why migration history can say applied when the SQL never ran, why data migrations drop rows silently, and two CI tests that catch both.