The Migration That Locked Everything | DevOps Nightmares

ALTER TABLE orders ADD COLUMN running. 50M rows.

FOUR HOURS OF PAIN:
• Migration ran at 2PM Friday — peak traffic. no maintenance window. "it'll be quick."
• Lock escalated immediately — postgres took exclusive lock on the orders table. nothing moved.
• Can't kill it safely — killing the migration mid-run would leave the table corrupted.
• CTO joined the call at hour 2 — it was a Friday. he had plans.

"TEST ON PROD-SIZED DATA OR TEST NOTHING"

─────────────────────────────
Follow @devopswithkosa for weekly DevOps war stories.
Real incidents. Real chaos. Real lessons.

Subscribe for new episodes every week.
─────────────────────────────

#DevOps #SoftwareEngineering #TechStories #CodeLife #SRE #Programming #DevOpsNightmares #TechTok #Database #PostgreSQL #Migration #SRE #Performance #SQL #DBOps

Видео The Migration That Locked Everything | DevOps Nightmares канала DevOps with Kosa