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회 조회
답변 없음

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠