2025-08-29: gprd post-deploy migration with InFailedSqlTransaction error

gprd post-deploy migration with InFailedSqlTransaction error (Severity 3 (Medium))

Problem: The post-deployment migration on gprd failed due to a PG::InFailedSqlTransaction error, indicating a problem with transaction execution.

Impact: No customer impact. auto-deploy is blocked.

Causes: The PG::InFailedSqlTransaction error occurs because a SQL command was executed within a transaction that has already failed, requiring a rollback before any new commands can be executed.

Response strategy: Multiple retry attempts failed and various strategies are being discussed, including marking the migration as successful to unblock deployments and considering a rollback of the failed transaction.

---

This ticket was created to track INC-3599, by incident.io 🔥