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