Root Cause Analysis
An event trigger configured in a table within the Workflow Builder database encountered an edge case that caused a table lock. Subsequent queries were left in a waiting state, leading to database connection thread exhaustion. This resulted in database connection failures and intermittent 502 errors on Workflow Builder API requests.
Impact
Customers in us-east-1 experienced intermittent 502 errors on Workflow Builder for ~2 hours (01:50–03:50 AM UTC).
Resolution
The Engineering team identified the root cause and implemented a hotfix to address the issue. Additionally, the maximum connection limit on the MySQL database was increased to accommodate the elevated connection demand and help prevent similar issues.
Remediation Items