504 Error Incident Due to Database Indexing Issue

Incident Summary

• Date of Incident: 2024-09-03
• Time of Incident: 11:40 (CET)
• Duration: 10 minutes
• Impact: The application experienced a 504 Gateway Timeout error, affecting users' ability to access data from the customers table.

Root Cause

The 504 error encountered this morning was caused by a database indexing issue. Specifically, the voyado_id field in the customers table did not have an index. As a result, the application faced delays while trying to retrieve data, leading to the 504 Gateway Timeout error.

Resolution

The incident was resolved by rolling back the schema change applied the day before, which removed the issue of inefficient queries caused by the missing index.