AWS RDS – Cannot modify a default parameter group error

For details about AWS RDS Parameter groups, please click here.

Sometimes, when we try to modify the value of a dynamic variable in the Parameter group, it will throw the following error.

“Error saving: Cannot modify a default parameter group. (Service: AmazonRDS; Status Code: 400; Error Code: InvalidParameterValue; Request ID: b5179a68-xxxx-44a8-b396-xxx; Proxy: null)”

OR

“Error saving: This parameter group XXXXX cannot be modified because it is currently being applied to DB instance XXXX. (Service: AmazonRDS; Status Code: 400; Error Code: InvalidDBParameterGroupState; Request ID: 76e4-xxxx-bef9-xxxxxxx; Proxy: null)”

SOLUTION:

When the parameter group is mapped to a database instance, even though some of the variables are dynamic and editable, they cannot be altered. You must first create a new parameter group, change the values as appropriate, and then assign the parameter group to the DB instance if you experience any of the aforementioned issues.

One comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s