farvour commented on issue #21947:
URL: https://github.com/apache/airflow/issues/21947#issuecomment-1316181238
Also seeing this in the same table with a massive number of DAGs (3k+). We
are running multi-scheduler. Will #19842 resolve this? We're on `2.3.3` at this
time.
```
sqlalchemy.exc.OperationalError: (psycopg2.errors.DeadlockDetected) deadlock
detected
DETAIL: Process 25726 waits for ShareLock on transaction 374820848; blocked
by process 26495.
Process 26495 waits for ShareLock on transaction 374820791; blocked by
process 25726.
HINT: See server log for query details.
CONTEXT: while updating tuple (7,13) in relation "dag"
[SQL: UPDATE dag SET next_dagrun=%(next_dagrun)s,
next_dagrun_data_interval_start=%(next_dagrun_data_interval_start)s,
next_dagrun_data_interval_end=%(next_dagrun_data_interval_end)s,
next_dagrun_create_after=%(next_dagrun_create_after)s WHERE dag.dag_id =
%(dag_dag_id)s]
[parameters: {'next_dagrun': DateTime(2022, 11, 16, 1, 48, 0,
tzinfo=Timezone('UTC')), 'next_dagrun_data_interval_start': DateTime(2022, 11,
16, 1, 48, 0, tzinfo=Timezone('UTC')), 'next_dagrun_data_interval_end':
DateTime(2022, 11, 16, 1, 50, 0, tzinfo=Timezone('UTC')),
'next_dagrun_create_after': DateTime(2022, 11, 16, 1, 50, 0,
tzinfo=Timezone('UTC')), 'dag_dag_id': '<redacted>'}]
```
--
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]
