Partial outage on Helpdesk in us-east1-635c cluster

Incident Report for Gorgias

Postmortem

On September 25th and 26th, 2025, we experienced a service disruption that impacted a subset of our customers. We want to be transparent about what happened, the steps we took to restore services, and how we are ensuring this does not occur again.

What Happened

In preparation for Black Friday and Cyber Monday, our team performed proactive tuning on our largest and oldest PostgreSQL database to improve performance and reliability during the upcoming peak season.

During this process, a rare and unexpected interaction between PostgreSQL vacuum and replication settings caused replication deadlocks at the buffer and storage level. These issues were not immediately apparent; the system operated normally for several hours before degradation began. At that point, the replication lag caused stale data to be served to some customers.

How We Responded

Once the problem became visible, our engineers:

  • Investigated and identified the replication deadlocks.
  • Performed additional maintenance operations to restore replication stability.
  • Re-routed traffic to healthier database instances to minimize further disruption.

Despite these efforts, customers experienced disruptions and stale data before full service was restored.

Why This Happened

Individually, the database settings applied were not harmful. However, combined with the multi-terabyte scale of our datasets and the disk throughput required for cleanup operations, they created a failure condition that PostgreSQL could not automatically recover from.

What We’re Doing to Prevent This in the Future

We have launched initiatives to strengthen resilience and prevent this type of issue from recurring:

  • Dataset optimization: Reducing the size of the datasets within this database to improve efficiency and recovery times.
  • Resource scaling: Expanding available compute and disk throughput for large PostgreSQL instances.
  • Resilience improvements: Investing in architectural changes that make the system more tolerant to replication failures.
  • Enhanced monitoring: Implementing earlier detection for replication lag and vacuum anomalies.

Our Commitment

We sincerely apologize for the disruption this incident may have caused to your business. Reliability is our highest priority, and we are taking concrete steps to ensure the stability of our systems moving forward.

If you have any questions or concerns, please don’t hesitate to contact our support team.

Thank you for your understanding and trust.

Posted Oct 03, 2025 - 15:34 UTC

Resolved

This incident has been resolved.
Posted Sep 25, 2025 - 16:39 UTC

Update

We're continuing to replay webhook events to catch up with several hours of partial or complete outage on the impacted cluster.
Posted Sep 25, 2025 - 15:46 UTC

Monitoring

A fix has been implemented and we are monitoring the results.

Webhooks are delayed due to the time we went under maintenance, they are currently catching up and we'll give an update once the situation is back to normal.
Posted Sep 25, 2025 - 12:58 UTC

Update

We've identified the issue and need to proceed to an urgent maintenance on the impacted cluster to apply a configuration change.
Posted Sep 25, 2025 - 12:03 UTC

Update

We are continuing to work on a fix for this issue.
Posted Sep 25, 2025 - 11:40 UTC

Identified

We have identified the source of the issue, and working on a fix.
Posted Sep 25, 2025 - 11:35 UTC

Update

We are continuing to investigate this issue.
Posted Sep 25, 2025 - 11:27 UTC

Investigating

We are currently experiencing issues that are causing delays in processing ticket-related actions
Posted Sep 25, 2025 - 11:24 UTC
This incident affected: Helpdesk Clusters (us-east1-635c).