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ビュー
回答なし

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ