Error deleting security group: DependencyViolation: sg- has a dependent object about terraform-aws-rds-aurora HOT 10 CLOSED

I had this issue, turns out that the security group was still attached to an available elastic network interface, navigate to elastic network interfaces and search for your security group there, delete the network interface and terraform will be able to delete it. I got the hint when attempting to manually delete the security group in the AWS Console

from terraform-aws-rds-aurora.

Hi everyone. Thanks for reporting this.

I'm not sure what the "dependent object" is. In the module the security group is populated with two rules, but since those are under the control of terraform I don't think that's it.

Anyway, for reference, it seems to me like it should be possible to work around this issue by creating a temporary SG to replace the one terraform want's to re-create, then let terraform re-create the SG and assign it back to where it was in the first place. On the other hand, we can also add some code to the module to "fix it". That code would be a new variable to override the description on the SG and set it to the terraform default of "Managed by Terraform". Is that the kind of fix you are looking for @antonbabenko?

from terraform-aws-rds-aurora.

v2.12.0 has been released with this bug fixed.

I've based it on #86 but I made this release backward compatible with the previous versions, so it should work without any new arguments (recreation to just update SG is not possible for most users).

from terraform-aws-rds-aurora.

I added vpc_id and tried applying the change and got this error - Error deleting security group: DependencyViolation: resource sg-xxxx has a dependent object.

from terraform-aws-rds-aurora.

@miguelaferreira could you please take a look and fix this one?

from terraform-aws-rds-aurora.

we had the same issue.

from terraform-aws-rds-aurora.

Same here.

from terraform-aws-rds-aurora.

I've made a WIP PR #86 to address this issue with a variable to override the SG description. It would be helpful to me if people could test that and validate it is enough to prevent the issue.
I did test the PR using a new example that it introduces, but I would love to have extra feedback.

from terraform-aws-rds-aurora.

Just had this same issue on Terraform v0.12.29

from terraform-aws-rds-aurora.

I'm going to lock this issue because it has been closed for 30 days ⏳. This helps our maintainers find and focus on the active issues. If you have found a problem that seems similar to this, please open a new issue and complete the issue template so we can capture all the details necessary to investigate further.

from terraform-aws-rds-aurora.