IL-0307 Supabase · 2025-01-29database
Supabase's Postgres connection pooler Supavisor 2.0 dropped connections for about 80% of us-east-1 tenants
Supavisor manages Postgres connections for Supabase. Supabase scheduled a major upgrade to Supavisor 2.0 across 10 regions; the new version had already run in 9 smaller regions over the previous weeks. On January 29, 2025 the maintenance began at 13:00 UTC and Supavisor 2.0 was deployed to 9 regions with minimal downtime, needing only client connection restarts. The us-east-1 deployment completed at 14:46 UTC with clients reconnected and throughput stable. At 16:05:50 UTC an :ets.select_delete operation failed and corrupted an ETS table; process registry lookups in Syn and Cachex that rely on it began failing, and at 16:06:00 UTC the processes managed by the registry crashed, dropping connections for about 80% of tenants. The incident was declared at 16:11 UTC and a rollback started. It completed at 16:53 UTC, and the previous version restored normal operation. During the incident Supabase advised users to fall back to direct database connections.
- Severity
- –
- Scope
- Postgres connections through the Supavisor pooler and Supabase Storage connectivity in us-east-1
- Users affected
- about 80% of tenants in us-east-1
- Region
- us-east-1
- Time to detect
- 6m
- Time to resolve
- 48m
Symptoms
At 16:05 UTC on January 29, 2025, most clients connected through Supavisor, Supabase's Postgres connection pooler, in us-east-1 were disconnected and could not reconnect reliably. Connections dropped for about 80% of tenants, and Supabase Storage connectivity also failed until the pooler was fixed.
Inside Supavisor 2.0, an :ets.select_delete operation failed at 16:05:50 UTC and corrupted an ETS (Erlang Term Storage) table. From 16:05:56 UTC, process registry lookups in the Syn and Cachex libraries, which are backed by ETS, failed and kept tenants from reconnecting, and at 16:06:00 UTC the processes managed by that registry crashed.
Root cause
Root cause Faulty deployment
- Trigger
- The planned upgrade of Supavisor to version 2.0 in us-east-1, which completed at 14:46 UTC.
Detection
–
Remediation
- Rolled Supavisor back to the previous version
Action items
- Cut rollback time from 40 minutes to under 90 seconds
- Detect client disconnections within 2 minutes
Lessons
Rollback was too slow and the pooler was not resilient enough to unforeseen failures under load; future work focuses on faster rollbacks to reduce the impact of similar failed deployments.
Sources
- https://status.supabase.com/incidents/zk493yyz17hy · official-status · archived copy
Related cases
IL-0369Railway's backend API went down when a column migration waited on locks and replicas could not get database connectionsRailway · 2025same root cause · shared Database, Database proxy and connection pooler
IL-0315Railway's backend API went down when an index build locked a billion-row Postgres table and used up every connectionRailway · 2025same root cause · shared Database, Database proxy and connection pooler
IL-0356Every domain hosted on Railway returned HTTP 404 to new connections for five minutes because route lookups failedRailway · 2026same root cause · shared Database
IL-0136A deployment that cleared an internal service's caches at peak traffic sent 20 times the normal load to the Azure OpenAI metadata backend in Sweden Central, and health checks that depended on its database restarted instances in a loop for almost six hoursMicrosoft Azure · 2026same root cause · shared Database
IL-0570Dropping an unused MySQL table stalled queries on its busy parent table and crowdworks.jp was hard to reach for a minuteCrowdWorks · 2026same root cause · shared Database
IL-0510MIT Learn's RDS PostgreSQL ran out of storage after a release and learn.mit.edu returned 503s and 504s for hoursMIT Open Learning · 2026same root cause · shared Database
IL-0380A compaction change in InfluxDB Cloud us-east-1 dropped data from compacted files, and queries missed data for weeksInfluxData · 2026same root cause · shared Database
IL-0547Buildkite annotation queries timed out and drove database CPU up across shards after a migration removed an indexBuildkite · 2025same root cause · shared Database
IL-0327After a blue/green upgrade of CircleCI's workflows database every query hit disk, and workflow starts lagged or failedCircleCI · 2025same root cause · shared Database
IL-0324Three MediaWiki deployments lost Memcached after a PHP 8.1 rollout and overloaded the External Storage database clusterWikimedia Foundation · 2025same root cause · shared Database
IL-0552CircleCI's archival database ran out of storage, slowing workflow and job starts and the display of workflows in the UICircleCI · 2025same root cause · shared Database
IL-0554A database migration used up Sentry US's Postgres connections, and the site and event ingestion were down for 22 minutesSentry · 2024same root cause · shared Database
IL-0571STORES reservation returned bursts of 504 errors when a smart-list query held a database process for over 20 minutesSTORES · 2024same root cause · shared Database
IL-0293Cloud Bigtable in us-central1 had higher latency and connection errors for about 32 hours from low-rate packet lossGoogle Cloud · 2023same root cause · shared Database
IL-0523TANF-app production deployments were blocked for two months when a search-index migration ran out of database disk spaceU.S. Department of Health and Human Services · 2023same root cause · shared Database
IL-0567Aurora MySQL behind Cookie Run: OvenBreak hit 100% CPU after a sales-ranking feature launch, and players could not playDevsisters · 2023same root cause · shared Database
IL-0483Replicate's website and API returned slow responses and HTTP 500s for two hours as PostgreSQL connections ran outReplicate · 2023same root cause · shared Database
IL-0371Half of new connections to Render Postgres databases with point-in-time recovery failed while their backup jobs ranRender · 2023same root cause · shared Database
IL-0524An index migration locked Open Collective's whole Transactions table and degraded the service for nearly an hourOpen Collective · 2023same root cause · shared Database
IL-0328A field type change in the database of CircleCI's job distribution service left all jobs stuck in "not running"CircleCI · 2021same root cause · shared Database
IL-0566Hot ranges after a Cookie Run: Kingdom guild update drove CockroachDB nodes to 100% CPU, forcing emergency maintenanceDevsisters · 2021same root cause · shared Database
IL-0391GoCardless API requests timed out for about 15 seconds while a Postgres migration waited for an AccessExclusive lockGoCardless · 2015same root cause · shared Database
Check your cluster for this
For AI tools and scripts
- This case as JSON: https://incidentlib-api.benchlet.com/cases/IL-0307
- The cases most like it: https://incidentlib-api.benchlet.com/cases/IL-0307/similar
- MCP server (Streamable HTTP, no key):
https://incidentlib-mcp.benchlet.com/mcp
The API needs no key. The MCP server offers search_incidents, get_incident, list_incidents, get_topic and vocab; both are explained on API and MCP.