Error: Error creating DB Subnet Group: DBSubnetGroupAlreadyExists: The DB subnet group 'my-cool-project-vpc' already exists.

[terraform-in-action]

Error: Error creating DB Subnet Group: DBSubnetGroupAlreadyExists: The DB subnet group 'my-cool-project-vpc' already exists.

[scottwinkler]

I suspect this is a user error. There is no reason for the DB subnet group with that name to exist unless it was deployed either by yourself or another person in your AWS account. Are you sure the code is exactly the same as what I have here?

[maina360]

Yes it is, I will try this in a different region and also double check if someone else ran the code. Thank you!

…

On Wed, Sep 1, 2021 at 1:05 AM Scott Winkler ***@***.***> wrote: I suspect this is a user error. There is no reason for the DB subnet group with that name to exist unless it was deployed either by yourself or another person in your AWS account. Are you sure the code is exactly the same as what I have here? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#20 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AGEWHY63CS7XK72FAJ35G4DT7XNFLANCNFSM5DAW7PDA> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.

[maina360]

So I found out what the issue was. When I first ran the code, I got this error that need me to add sensitive = true to the output in the root module outputs.tf

++++++++++++
From
++++++++

output "db_password" {
value = module.database.db_config.password
}

+++++++++++
To
+++++++
output "db_password" {
sensitive = true
value = module.database.db_config.password
}

After seeing that error I ran, destroy command but the RDS subnet group never got destroyed, not sure why and that was causing the issue I opened. Anyway, after figuring that out there was another error with the resource "random_password" "password"
++++++++++++++++++++++
code with issue
++++++++++++++++
resource "random_password" "password" { #A
length = 16
special = true
override_special = "_%@/'""
}

for this one I had to remove the extra \ on there to fix the issue then I ran a destroy again and apply and this time everything worked well.
+++++++++++++++++++
Changes made
++++++++++++++++++
resource "random_password" "password" { #A
length = 16
special = true
override_special = "_%@"
}

So you might want to modify the two resources I mentioned for future users. Thank you!

[scottwinkler]

Hmm not sure what is going on in the second part but adding sensitive to the output is definitely something I can fix In the errata. Thanks

[maina360]

No problem, thank you for writing this awesome book. I hope I can pick up quick and get better at Terraform.