CODEWITHSUNDEEP
amazon-web-servicesamazon-rds
user3236765
user3236765

Reputation: 413

AWS RDS parameter group showing "Pending-Reboot" after mysql upgrade

we upgraded our AWS RDS mysql instance from 5.5.42 to 53 and we applied the original parameter group to this instance.

However when I checked the rds instance's configuration details, the Parameter Group value remains "pending-reboot" even though I've manually rebooted the rds.

How do I fix this issue? Thanks!

Upvotes: 15

Views: 20950

Answers (2)

deepanshMathur
deepanshMathur

Reputation: 81

The above solution didn't work for me. My case was that I had the default parameter group attached to the instance originally. Then I had to change it to enable log replication. Then I wanted to change it back to the default one.

When I tried that, I ran into this issue of pending reboot no matter how many times I rebooted. And then I tried editing the default parameter group but AWS doesn't allow that. So I created a new parameter group, choose the default as a starting template, gave it some name like default-pg-13-copy and used that.

Upvotes: 2

user3236765
user3236765

Reputation: 413

Hi so I found a solution which is quite simple. I had to make a minor edit to the parameter group (any one of the many variables will do), and save the changes. After that I rebooted the rds instance and now the parameter group is in-sync.

Upvotes: 12

Related Questions