Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

URGENT: Aurora PostgreSQL Serverless cluster deadlocked in "modifying" state - Cannot kill queries or reboot

0

URGENT: Production Aurora PostgreSQL Serverless Cluster Completely Deadlocked

Summary: Aurora PostgreSQL Serverless cluster has been stuck in "modifying" state for over 1.5during an ACU increase operation. The cluster is completely deadlocked - cannot kill queries, cannot reboot, cannot perform any administrative actions.

Cluster Details:

Service: Aurora PostgreSQL Serverless v2 Region: us-east-1 Cluster Identifier: *** Engine: Aurora PostgreSQL Current Status: "Modifying" (stuck for 1.5 hours)

Problem Details:

Stuck Queries: Multiple queries are not processing and cannot be terminated Unkillable Processes: pg_terminate_backend(pid) and pg_cancel_backend(pid) have no effect Administrative Lockout: Cannot reboot, cannot modify, cannot perform any cluster operations Scaling Deadlock: ACU modification cannot complete due to stuck queries, but queries cannot be cleared due to modification in progress

Topics
ServerlessDatabase
Tags
Aurora PostgreSQLServerlessAmazon Aurora Serverless
Language
English
asked 5 months ago110 views
1 Answer
0

An Aurora PostgreSQL Serverless v2 cluster that becomes stuck in a “modifying” state when scaling operations such as adjustments to Aurora Capacity Units (ACUs) fail to complete, may enter an unresponsive condition in which queries cannot be terminated and administrative actions are blocked. You may raise a ticket to AWS Support:

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless-v2.html

EXPERT
answered 2 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content