PostgreSQL RDS minor version upgrade stuck with "Incompatible-parameters"

0

Hi AWS Support,

During a Production RDS maintenance (minor version upgrade from PostgreSQL 9.4.20 to 9.4.21), the instance has become stuck in "Incompatible-parameters" status.

The affected RDS resource ID is db-DZAT6VNZZ3JSXFDU6BQXRQOCJQ

The errors in the event log are:
-This DB instance was placed into incompatible-parameters status because the huge pages configuration for the instance would exceed 90% of the available instance memory. To fix this issue, modify the associated parameter group to lower the shared memory usage, and then reboot the instance. For more information, please refer to the RDS Postgres documentation
-Postgres could not be started due to incompatible parameters. Shared memory segment exceeded available memory or swap space. Please modify shared memory usage parameters to lower values and reboot the instance.

The maintenance only included minor version upgrade. Huge pages parameter is already set to OFF and we did not alter any parameters for this maintenance therefore we are unsure why the upgrade failed. To try and resolve the issue, we tried reducing max_connections, restarting the instance, but none of them worked.

This is a production instance and we had to urgently restore it using a different name.

To try replicate the issue, we created a test instance from the production snapshot with the same settings (instance class, parameters, etc), and tried the same upgrade again (9.4.20 -> 9.4.21) and this time it was successful.

Can you please check the cause of the upgrade failure? If upgrade failed, why is it not rolling back automatically? Also can you please allow the instance to be deleted so that it stops incurring further cost?

Regards,
James

aws-fm
已提问 5 年前1005 查看次数
2 回答
0

We found a solution in another thread.

Solution:

  1. Use AWS CLI to disable Delete Protection
    aws rds modify-db-instance --db-instance-identifier db01 --no-deletion-protection

  2. Use AWS Console UI to delete RDS instance.

aws-fm
已回答 5 年前
0

Setting huge_pages to off resolved here. It is surely an RDS bug as just automatic minor upgrade triggered the issue

已回答 2 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则