Re: [I] Airflow 3.2.1 locks heartbeat queries causing DB connection pool exhaustion and slow responses [airflow]

["mdw00d (via GitHub)" <gi...@apache.org>]

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: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org