Luca demonstrates how to
fix issues that cause the
"incompatible-parameters" state

rds-incompatible-parameters-luca

My Amazon Relational Database Service (Amazon RDS) instance is stuck in an incompatible-parameters state. I can't connect to the instance or modify it. All I can do is delete it or reboot. How can I fix this?

When an RDS instance is in the incompatible-parameters state, at least one of the parameters in the associated group is set with a value that's not compatible with the current engine version or instance class.

This can be caused by:

  • An instance that's scaled to use an instance type that has less memory available than the previous one, and at least one of the memory settings in the associated parameter group exceeds the memory size available for the current instance.
  • A database engine that's upgraded to a different version, and the engine is no longer compatible with one or more parameter settings of the current custom parameter group.

Configurations can fail if you attempt to associate a different parameter group, scale the instance type, change the engine version, or modify the instance configuration. To accept a new configuration, RDS instances must be in the available state. If the instance is in an incompatible-parameters state, then you can only reboot or delete it. To recover from the incompatible state, check the associated custom parameter group setting in a pending-reboot state.

For information about how to determine which values are incompatible, see How do I identify which Amazon RDS DB parameters are in custom parameter groups and which are in default parameter groups?

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.

Note: All the RDS instances associated with the incompatible parameter group are affected by these value changes. To back up the current parameter group settings, copy the parameter group before resetting the parameters.

To identify the root cause of the issue, you can copy the incompatible parameter group and then compare the differences between custom parameter values and default values.

To create a copy of the parameter group using the Amazon RDS console

  1. Open the Amazon RDS console, and then choose Parameter Groups from the navigation pane.
  2. Select the incompatible parameter group, and then choose Parameter group actions.
  3. Choose Copy.

To reset all the parameters in the parameter group to default values using the Amazon RDS console

  1. Open the Amazon RDS console, and then choose Parameter groups from the navigation pane.
  2. Choose the parameter group that you want to reset.
  3. Choose Parameter group actions, and then choose Reset.
  4. Choose Reset.

To reset parameter values using the Amazon RDS console

To avoid resetting all the parameter values of the incompatible parameter group, you can choose which parameters to change. You can do this by editing the incompatible parameter group from the Amazon RDS console.

  1. Open the Amazon RDS console, and then choose Parameter Groups from the navigation pane.
  2. Select the incompatible parameter groups (or to reset all parameters, select all the parameters).
  3. Choose Parameter group actions, and then choose Edit.
  4. Enter the valid parameter values, and then choose Save Changes.
  5. Reboot the instance without failover to apply new settings.

    Note: The Amazon RDS console allows you to change parameters to any related allowed values. The AWS Command Line Interface (AWS CLI) allows you to reset target parameters to their default values. Changes to parameter values using the AWS CLI to a value other than the default parameter value have no effect.

For more information about Oracle parameters that are incompatible with Amazon RDS, see Oracle 12c with Amazon RDS and Using Huge Pages with an Oracle DB Instance.


Did this page help you? Yes | No

Back to the AWS Support Knowledge Center

Need help? Visit the AWS Support Center

Published: 2016-11-11

Updated: 2019-01-25