github-actions[bot] opened a new pull request, #76983: URL: https://github.com/apache/airflow/pull/76983
The migration lock connection stays idle in transaction for the whole migration. Under psycopg3 the parameterized `pg_advisory_lock(:id)` keeps its snapshot on that idle transaction, so a migration running CREATE INDEX CONCURRENTLY (e.g. from an external DB manager) waits on its own process's lock connection and `airflow db migrate` hangs forever. Inline the lock id instead. The transaction stays open, so behind a transaction-pooling PgBouncer the lock and unlock still run on the same server connection. (cherry picked from commit 38c11037bc11e57f17849629253447a2960fa849) Co-authored-by: Rahul Vats <[email protected]> -- 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]
