[Bug]: Cannot delete redshift_workgroup due to invalid resource state: "AVAILABLE"

[ghost]

Terraform Core Version

1.3.9

AWS Provider Version

4.57.1

Affected Resource(s)

• aws_redshiftserverless_workgroup

Expected Behavior

Terraform should delete aws_redshiftserverless_workgroup without problems. It may expect AVAILABLE as temporary state or it may be fixed in the API.

Actual Behavior

Terraform cannot delete aws_redshiftserverless_workgroup due to initial state being AVAILABLE instead of DELETING or MODIFYING,

Relevant Error/Panic Output Snippet

Error: deleting Redshift Serverless Workgroup (my-workgroup): waiting for completion: unexpected state 'AVAILABLE', wanted target ''. last error: %!s(<nil>)

Terraform Configuration Files

resource "aws_redshiftserverless_namespace" "redshift" {
  namespace_name = "my-namespace"

  db_name             = "database"
  admin_username      = "admin"
  admin_user_password = "admin"

  default_iam_role_arn = aws_iam_role.redshift.arn

  log_exports = ["userlog", "connectionlog", "useractivitylog"]
}

resource "aws_redshiftserverless_workgroup" "redshift" {
  workgroup_name = "my-workgroup"

  namespace_name = aws_redshiftserverless_namespace.redshift.id
  base_capacity  = 32

  enhanced_vpc_routing = false
  publicly_accessible  = true
  security_group_ids   = var.sg_ids
  subnet_ids           = var.subnet_ids
}

Steps to Reproduce

• Create Redshift Namespace and Workgroup using Terraform
• Run terraform destroy

Debug Output

No response

Panic Output

No response

Important Factoids

I noticed same issue occurring when using boto3. State doesn't always change to DELETING immediately after calling delete_workgroup

References

• [Bug]: Terraform apply quits while destroying aws_redshiftserverless_workgroup due to unexpected resource state #28109
• https://github.com/hashicorp/terraform-provider-aws/pull/28114/files

Would you like to implement a fix?

No

[github-actions]

Community Note

Voting for Prioritization

• Please vote on this issue by adding a 👍 reaction to the original post to help the community and maintainers prioritize this request.
• Please see our prioritization guide for information on how we prioritize.
• Please do not leave "+1" or other comments that do not add relevant new information or questions, they generate extra noise for issue followers and do not help prioritize the request.

Volunteering to Work on This Issue

• If you are interested in working on this issue, please leave a comment.
• If this would be your first contribution, please review the contribution guide.

[github-actions]

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.