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
posta 4 mesi fa81 visualizzazioni
Nessuna risposta

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande