IL-0380 InfluxData · 2026-02-09databaseaws
A compaction change in InfluxDB Cloud us-east-1 dropped data from compacted files, and queries missed data for weeks
Data in InfluxDB Cloud 2 is split into 64 partitions, and each partition is compacted regularly because uncompacted data is slower to query. In January, partition 47 of prod101-us-east-1 stopped compacting successfully, partially compacted files piled up in it and performance suffered. InfluxData built an optimisation that runs several compaction jobs on a partition in parallel, each on a subset of the data by org id prefix, and two more engineers reviewed it in the standard release process. Under certain circumstances the new code made the compactor fail to read some source TSM data files. The compactor did not handle the failure: it silently skipped those TSM files, compacted the rest and replaced the original files with the result. Code review and internal testing did not catch this, and it appeared only after the change reached prod101-us-east-1 on 9 February.
On 10 February, after more tickets, InfluxData found the cause, rolled back the compaction change and began restoring data. Each Cloud 2 cluster has weekly TSM snapshots, and all incoming writes are also recorded as snapshots in Kafka logs; together these hold a complete record of the written data. Only partitions compacted while the faulty code ran were affected, but as a precaution the restore took recent data first, rebuilt from the Kafka logs, and historical data afterwards from the TSM snapshots. Because customers use the cluster for real-time work, it stayed online and the restore ran incrementally so ingest and queries could continue, which took longer than an offline restore from a full backup and at times raised TTBR and slowed queries. The restore was done first for a test set of customers, the process was changed on 17 February to speed up historical recovery, recent data was back for everyone on 23 February and historical data for all paying customers on 8 March. The incident was marked resolved on 10 March 2026.
- Severity
- –
- Scope
- Data in partitions compacted while the faulty code ran on prod101-us-east-1 was missing from queries until restored from backup; elevated TTBR and slower queries during the restore; no permanent data loss
- Users affected
- –
- Region
- AWS us-east-1
- Time to detect
- –
- Time to resolve
- –
Symptoms
From 9 February 2026, InfluxDB Cloud customers on the AWS us-east-1 cluster prod101-us-east-1 found that some recent data did not show up in query responses. The first support ticket about data availability came in on 9 February, the day a compaction change was deployed, and more tickets followed on 10 February.
The missing data was still in backups, so nothing was lost for good, but bringing it back took weeks. Recent data from 2 to 9 February was restored for all customers on 23 February, and historical data from before 2 February for all paying customers on 8 March. During the restore some customers saw elevated time-to-become-readable (TTBR) and slower queries.
Root cause
Root cause Faulty deployment
- Trigger
- On 9 February 2026 InfluxData deployed to prod101-us-east-1 a compaction change that runs several compaction jobs in parallel on one partition, each on a subset of the data chosen by org id prefix.
Detection
Tickets about data availability were raised, the first on 9 February and more on 10 February, when the status page reported that some recent data was not showing up in query responses.
Remediation
- Rolled back the compaction change
- Restored recent data first, rebuilt from the Kafka logs
- Changed the restoration process to make historical data recovery more efficient
- Restored historical data from the weekly TSM snapshots
- Kept the cluster online and restored data incrementally so ingest and queries could continue
Action items
- Expand test coverage for changes to critical storage components such as the compactor, with scenarios closer to production-scale workloads
- Strengthen safeguards around compaction so failures are detected and handled safely
- Review restoration workflows and procedures to reduce elevated TTBR and slow queries during large restores
- Revisit the backup and restore strategy to speed up cluster-wide restorations
Lessons
–
Sources
- https://status.influxdata.com/incidents/nw5fkj0r3gg1 · official-status · archived copy
Related cases
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 backups and snapshots, Database
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-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
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-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
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-0307Supabase's Postgres connection pooler Supavisor 2.0 dropped connections for about 80% of us-east-1 tenantsSupabase · 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-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-0380
- The cases most like it: https://incidentlib-api.benchlet.com/cases/IL-0380/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.