mdw00d commented on issue #65712:
URL: https://github.com/apache/airflow/issues/65712#issuecomment-4382760010
Not sure if this is related but we are experiencing what may be a similar
issue where we have lots of tasks accumulating in the "idle in transaction"
state executing a query of the form:
```
SELECT task_instance.task_id, task_instance.state,
task_instance.dag_version_id, task_instance.start_date, task_instance.end_date,
dag_version.version_number
FROM task_instance LEFT OUTER JOIN dag_version ON
task_instance.dag_version_id = dag_version.id
WHERE task_instance.dag_id = {OUR DAG} AND task_instance.run_id =
'scheduled__2026-04-30T05:00:00+00:00' ORDER BY task_instance.task_id
```
Not sure where this query is originating; perhaps someone more
knowledgeable would know where?
This eventually causes an unrecoverable error situation.
--
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]
