AWS RDS stuck changing vpc security group

Question

I've been trying to create a copy of an RDS I have under the same vpc as the old snapshot (but with a new name).

I restored from a snapshot and went into the modify and changed the vpc security group, however the console is stuck with a "removing" and "adding" message.

The vpc it is trying to add is indeed correct, however it is taking forever to change. Doing a bit of research, apparently vpc is supposed to be quick to change, so what gives?

Screenshot: https://i.sstatic.net/Tngbq.jpg

Answer 1

I had the same issue with Terraform where changes were not applied directly. See this GH Issue.

I was able to fix it using the AWS CLI, the console didn't allow me to apply the changes.

aws rds modify-db-instance \
    --db-instance-identifier ... \
    --db-subnet-group-name ... \
    --vpc-security-group-ids ... \
    --apply-immediately