Migration locks table
Your task
During a routine deploy, a database schema migration kicked off. Within a minute, requests that read or write one important table start timing out, and the dashboard shows a pile-up of queries waiting on that table. The DB CPU is low but query latency is huge. The migration is an ALTER on that table and it's still running. What's happening, and what do you do?
It covers
- Database
- Schema change
- Blocking