ashwinshankar77 commented on issue #27473:
URL: https://github.com/apache/airflow/issues/27473#issuecomment-1377758547
Hi, we are seeing this deadlock error at Slack at scale causing disruptions.
Is there any fix thats been worked on? cc: @potiuk
Details: Airflow version: 2.2.5, Celery, 2 schedulers with row level locking
enabled, mysql 8 metadata db
```
raise exception
File
"/opt/airflow/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py",
line 1276, in _execute_context
self.dialect.do_execute(
File
"/opt/airflow/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py",
line 608, in do_execute
cursor.execute(statement, parameters)
File "/opt/airflow/.venv/lib/python3.9/site-packages/MySQLdb/cursors.py",
line 206, in execute
res = self._query(query)
File "/opt/airflow/.venv/lib/python3.9/site-packages/MySQLdb/cursors.py",
line 319, in _query
db.query(q)
File
"/opt/airflow/.venv/lib/python3.9/site-packages/MySQLdb/connections.py", line
254, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (1213,
'Deadlock found when trying to get lock; try restarting transaction')
[SQL: UPDATE task_instance SET state=%s WHERE task_instance.dag_id = %s AND
task_instance.run_id = %s AND task_instance.task_id IN (%s, %s, %s, %s, %s, %s,
%s, %s, %s, %s, %s, %s, %s)]
```
--
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]
