2024.4.0 LongRunningTransaction

[szinn]

Describe the bug
Prometheus alert for a long running transaction.

I think the transaction is

SELECT pg_advisory_unlock($1)

To Reproduce
No activity, sitting idle

Expected behavior
Shouldn't have the alert

Screenshots

Logs

Version and Deployment (please complete the following information):
2024.4.0 kubernetes

Additional context
Add any other context about the problem here.

[MegaShinySnivy]

Can confirm, same thing happens on mine.

[szinn]

This appears to happen once a day - happened again, same query

[BeryJu]

So it seems that this is a side-effect of #9081 and part of the connection not being fully released, even though we only (currently) use advisory locks to prevent multiple servers/workers from migrating at the same time