V0lantis commented on issue #23361:
URL: https://github.com/apache/airflow/issues/23361#issuecomment-1133147273
Again, some more information about my last comments.
Here is the failed log:
```
×Failed to clear task instances: "(psycopg2.errors.DeadlockDetected)
deadlock detected DETAIL:
Process 22854 waits for ShareLock on transaction 778696725; blocked by
process 21808. Process 21808 waits for ShareLock on transaction 778696547;
blocked by process 22854.
HINT: See server log for query details.
CONTEXT: while updating tuple (3743,4) in relation "task_instance" [SQL:
UPDATE task_instance SET state=%(state)s WHERE task_instance.task_id =
%(task_instance_task_id)s AND task_instance.dag_id = %(task_instance_dag_id)s
AND task_instance.run_id = %(task_instance_run_id)s] [
parameters: ({'state': None, 'task_instance_task_id': 'some_tasks_name',
'task_instance_dag_id': 'some_tasks_name', 'task_instance_run_id':
'scheduled__2022-05-14T22:00:00+00:00'}, {'state': None,
'task_instance_task_id': 'some_tasks_name', 'task_instance_dag_id':
'some_dag_id', 'task_instance_run_id': 'scheduled__2022-04-29T00:00:00+00:00'},
{'state': None, 'task_instance_task_id': 'some_dag_id', 'task_instance_dag_id':
'some_dag_id', 'task_instance_run_id':
'scheduled__2022-05-19T00:00:00+00:00'})] (Background on this error at:
http://sqlalche.me/e/13/e3q8)"
```
--
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]
