RDS Aurora PostgreSQL - Graceful statement termination for "idle in transaction" connections?

0

Hi there.

We have an Aurora PostgreSQL DB running with several reader instances. We also got a custom Jenkins job to launch and terminate the read replicas based on our needs.

What I noticed is, that the connections that are in the "idle in transaction" are not getting properly handled gracefully.

Multiple "idle in transaction" connections got disconnected unexpectedly while other normal connections were gracefully terminated.

I know that Aurora can gracefully shutdown the statements since I found this in the official docs :

"If there are statements running on the Aurora Replica that is being deleted, there is a three minute grace period. Existing statements can finish gracefully during the grace period."

But I am not 100% sure whether this includes the connections in "idle in transaction" status.

Can someone clarify this? I searched the docs more but couldn't find further info.

Thanks a lot.

Yechan
gefragt vor 4 Monaten81 Aufrufe
Keine Antworten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen