Root Cause
Users experienced issues with our API due to a mismatch between the database function version and the code version. The discrepancy in data type definitions caused the malfunction.
Resolution
The issue was resolved by rolling back the function version to a previous state, which restored proper functionality to the API.
Action Plan
We plan to review and address database transactions within the code, develop a strategy for managing these transactions, and ensure consistency between production and development environments. Additionally, alerts will be created to identify related errors, and the feasibility of running tests post-migration will be assessed.