Pranaykarvi opened a new pull request, #63591: URL: https://github.com/apache/airflow/pull/63591
## Problem Migration `0101_3_2_0_ui_improvements_for_deadlines` downgrade uses `conn.begin_nested()` (savepoints) per DAG. On PostgreSQL, savepoint locks accumulate in the parent transaction until the outer COMMIT, exhausting the shared lock table with thousands of DAGs: ``` psycopg2.errors.OutOfMemory: out of shared memory HINT: You might need to increase max_locks_per_transaction. ``` ## Fix Replaced per-DAG savepoints with `engine.begin()` so each DAG commits and releases locks independently. The outer `conn` is still used for batch SELECTs only. Fixes #63535 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
