ashb commented on issue #11543: URL: https://github.com/apache/airflow/issues/11543#issuecomment-715199530
If I'm reading that trace right, the deadlock is caused by two processes trying to INSERT in to dag table at the same time. Statement that died was inserting `test_start_date_scheduling` (TRANSACTION 12600) Lock was held by a txn inserting `test_verify_integrity_if_dag_changed` (TRANSACTION 12605) Given that it's not a select/lock query causing the lock, I think that retry this insert in case of deadlock might be the only option. Also: Dear MySQL: that is not a _DEAD_ lock. No love, DB theory people. ---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected]
