MySQL primary database server under extreme load and not responding

Incident Report for Tideways

Postmortem

Summary

A maintenance query to delete old entries in a large table was not adequately optimized and required a lot of load. This brought the primary database server under heavy load. Cancelling the query lead to a rollback that also took a while for the system to recover finally.

Customers experienced a dataloss of incoming data between 13:42 and 14:28 UTC time on October 16th, 2026.

We are very sorry for the inconvenience and you can be assured that we are following up on this incident to make sure a similar mistake does not happen again and is otherwise softened by better automatic recovery and retry mechanisms.

Timeline

  • 13:30 UTC - Maintenance query to large table was started.
  • 13:42 UTC - Database server load increased to a level that made UI/Ingest unavailable.
  • 13:49 UTC - query was killed and started to roll back.
  • 14:28 UTC - system recovered and load normalized.

Root Cause

An unoptimized maintenance SQL query to cleanup a large table caused high load.

Impact

  • ~45 minute total data gap across customers (13:42–14:28 UTC)
  • Possible transient UI errors during the incident window

Follow-ups

  • Current defined best-practices from Ops team were not followed for the maintenance query, so work is being done on reviewing them in the team and potentially surfacing them during code-reviews automatically.
  • We are investigating how the retry mechanism of daemons from customer machines worked and if we can optimize and improve it for the future.
Posted Oct 16, 2026 - 17:16 CEST

Resolved

Database is responsive again.
Posted Oct 16, 2026 - 16:33 CEST

Identified

A maintenance query rolled out during a deployment caused more load than expected, overloading the server. The query was aborted and is now being rolled back, still taking time to process. We hopefully expect the process to be completed in a few minutes.
Posted Oct 16, 2026 - 16:10 CEST

Update

We are continuing to investigate this issue.
Posted Oct 16, 2026 - 15:53 CEST

Investigating

We are currently investigating this issue.
Posted Oct 16, 2026 - 15:53 CEST
This incident affected: Ingest / Data Collection and User Interface.