How can I fix an Amazon RDS DB instance that is stuck in the incompatible-parameters status?
To Nha Notes | April 21, 2022, 8:25 a.m.
This can be caused by:
- A DB instance that's scaled to use an instance type that has less memory available than the previous one. At least one of the memory settings in the associated parameter group exceeds the memory size available for the current DB instance.
- A database engine that's upgraded to a different version. The engine is no longer compatible with one or more parameter settings of the current custom parameter group.
To resolve this issue, change the value of each incompatible parameter to a compatible value using one of the following options:
- Reset all the parameters in the parameter group to the default value.
- Reset the values of the parameters that are incompatible.
References
https://aws.amazon.com/premiumsupport/knowledge-center/rds-incompatible-parameters/