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
已提問 4 個月前檢視次數 81 次
沒有答案

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南