SamWheating commented on issue #65712:
URL: https://github.com/apache/airflow/issues/65712#issuecomment-4856989357

   It seems like we're seeing the same issue running in 3.2.2 - seeing lots of 
long-running queries like this
   ```sql
   UPDATE task_instance SET 
last_heartbeat_at='2026-07-01T15:17:36.739110+00:00'::timestamptz, 
updated_at='2026-07-01T15:17:36.741242+00:00'::timestamptz WHERE 
task_instance.id = '019f1dfd-0e45-729c-a148-c18a311147fd'::uuid::UUID AND 
task_instance.state = 'running' AND task_instance.hostname = '<hostname>' AND 
task_instance.pid = 39
   ```
   
   which then exhaust pgbouncer's pool and eventually cause api-servers, 
schedulers etc to fail.
   
   I'll continue to investigate, but I don't think that this was fixed by the 
linked PR.


-- 
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]

Reply via email to