[Bug]: When updating attributes like base capacity, publicly_accessible or enhanced vpc routing in aws_redshiftserverless_workgroup update to config params is also triggered

[meetvasu15]

Terraform Core Version

1.1.5

AWS Provider Version

4.31.0

Affected Resource(s)

• aws_redshiftserverless_workgroup

Expected Behavior

Update to attributes such as base capacity, enhanced_vpc_routing and publicly accessible should not trigger update on config parameters.

Actual Behavior

Update to attributes such as base capacity, enhanced_vpc_routing and publicly accessible triggers update to config parameters causing a validation exception.

Relevant Error/Panic Output Snippet

2022-12-07T16:11:48.317-0600 [DEBUG] provider.terraform-provider-aws_v4.31.0_x5.exe: [DEBUG] [aws-sdk-go] {"__type":"ValidationException","message":"Can't update multiple configurations at the same time for workgroup eng-datamart-compute."}

Terraform Configuration Files

resource "aws_redshiftserverless_workgroup" "[redacted]" {
  namespace_name       = aws_redshiftserverless_namespace.[redacted].id
  workgroup_name       = "[redacted]"
  base_capacity        = 64
  enhanced_vpc_routing = true
  publicly_accessible  = false
  subnet_ids           = data.terraform_remote_state.vpc.outputs.module_vpc_private_subnets
}

Steps to Reproduce

1. Create a aws_redshiftserverless_workgroup
2. Update any attribute like base_capacity, enhanced_vpc_routing or publicly_accessible.

Debug Output

2022-12-07T16:11:48.073-0600 [DEBUG] provider.terraform-provider-aws_v4.31.0_x5.exe: [DEBUG] [aws-sdk-go] DEBUG: Request Redshift Serverless/UpdateWorkgroup Details:
2022-12-07T16:11:48.073-0600 [DEBUG] provider.terraform-provider-aws_v4.31.0_x5.exe: ---[ REQUEST POST-SIGN ]-----------------------------
2022-12-07T16:11:48.073-0600 [DEBUG] provider.terraform-provider-aws_v4.31.0_x5.exe: POST / HTTP/1.1
2022-12-07T16:11:48.073-0600 [DEBUG] provider.terraform-provider-aws_v4.31.0_x5.exe: Host: redshift-serverless.us-east-1.amazonaws.com
2022-12-07T16:11:48.073-0600 [DEBUG] provider.terraform-provider-aws_v4.31.0_x5.exe: User-Agent: APN/1.0 HashiCorp/1.0 Terraform/1.1.5 (+https://www.terraform.io) terraform-provider-aws/dev (+https://registry.terraform.io/providers/hashicorp/aws) aws-sdk-go/1.44.94 (go1.18.4; windows; amd64)
2022-12-07T16:11:48.073-0600 [DEBUG] provider.terraform-provider-aws_v4.31.0_x5.exe: Content-Length: 719
2022-12-07T16:11:48.073-0600 [DEBUG] provider.terraform-provider-aws_v4.31.0_x5.exe: Authorization: [redacted]
2022-12-07T16:11:48.073-0600 [DEBUG] provider.terraform-provider-aws_v4.31.0_x5.exe: Content-Type: application/x-amz-json-1.1
2022-12-07T16:11:48.073-0600 [DEBUG] provider.terraform-provider-aws_v4.31.0_x5.exe: X-Amz-Date: 20221207T221148Z
2022-12-07T16:11:48.073-0600 [DEBUG] provider.terraform-provider-aws_v4.31.0_x5.exe: X-Amz-Security-Token: [redacted]
2022-12-07T16:11:48.073-0600 [DEBUG] provider.terraform-provider-aws_v4.31.0_x5.exe: X-Amz-Target: RedshiftServerless.UpdateWorkgroup
2022-12-07T16:11:48.073-0600 [DEBUG] provider.terraform-provider-aws_v4.31.0_x5.exe: Accept-Encoding: gzip
2022-12-07T16:11:48.073-0600 [DEBUG] provider.terraform-provider-aws_v4.31.0_x5.exe: 
2022-12-07T16:11:48.074-0600 [DEBUG] provider.terraform-provider-aws_v4.31.0_x5.exe: {"baseCapacity":32,"configParameters":[{"parameterKey":"auto_mv","parameterValue":"true"},{"parameterKey":"datestyle","parameterValue":"ISO, MDY"},{"parameterKey":"enable_case_sensitive_identifier","parameterValue":"false"},{"parameterKey":"enable_user_activity_logging","parameterValue":"true"},{"parameterKey":"query_group","parameterValue":"default"},{"parameterKey":"search_path","parameterValue":"$user, public"},{"parameterKey":"max_query_execution_time","parameterValue":"14400"}],"enhancedVpcRouting":true,"securityGroupIds":["sg-redacted"],"subnetIds":["subnet-redacted","subnet-redacted","subnet-redacted","subnet-redacted"],"workgroupName":"redacted"}
2022-12-07T16:11:48.074-0600 [DEBUG] provider.terraform-provider-aws_v4.31.0_x5.exe: -----------------------------------------------------
2022-12-07T16:11:48.317-0600 [DEBUG] provider.terraform-provider-aws_v4.31.0_x5.exe: [DEBUG] [aws-sdk-go] DEBUG: Response Redshift Serverless/UpdateWorkgroup Details:
2022-12-07T16:11:48.317-0600 [DEBUG] provider.terraform-provider-aws_v4.31.0_x5.exe: ---[ RESPONSE ]--------------------------------------
2022-12-07T16:11:48.317-0600 [DEBUG] provider.terraform-provider-aws_v4.31.0_x5.exe: HTTP/1.1 400 Bad Request
2022-12-07T16:11:48.317-0600 [DEBUG] provider.terraform-provider-aws_v4.31.0_x5.exe: Content-Length: 134
2022-12-07T16:11:48.317-0600 [DEBUG] provider.terraform-provider-aws_v4.31.0_x5.exe: Content-Type: application/x-amz-json-1.1
2022-12-07T16:11:48.317-0600 [DEBUG] provider.terraform-provider-aws_v4.31.0_x5.exe: Date: Wed, 07 Dec 2022 22:11:48 GMT
2022-12-07T16:11:48.317-0600 [DEBUG] provider.terraform-provider-aws_v4.31.0_x5.exe: X-Amzn-Requestid: redacted
2022-12-07T16:11:48.317-0600 [DEBUG] provider.terraform-provider-aws_v4.31.0_x5.exe: 
2022-12-07T16:11:48.317-0600 [DEBUG] provider.terraform-provider-aws_v4.31.0_x5.exe: 
2022-12-07T16:11:48.317-0600 [DEBUG] provider.terraform-provider-aws_v4.31.0_x5.exe: -----------------------------------------------------
2022-12-07T16:11:48.317-0600 [DEBUG] provider.terraform-provider-aws_v4.31.0_x5.exe: [DEBUG] [aws-sdk-go] {"__type":"ValidationException","message":"Can't update multiple configurations at the same time for workgroup eng-datamart-compute."}
2022-12-07T16:11:48.317-0600 [DEBUG] provider.terraform-provider-aws_v4.31.0_x5.exe: [DEBUG] [aws-sdk-go] DEBUG: Validate Response Redshift Serverless/UpdateWorkgroup failed, attempt 0/25, error ValidationException: Can't update multiple configurations at the same time for workgroup eng-datamart-compute.

Panic Output

No response

Important Factoids

No response

References

No response

Would you like to implement a fix?

None

[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.

[mcalfin]

Has anyone looked into this yet? Seems like this is still an ongoing issue. After deploying a redshift serverless instance, changing the base_capacity is not possible due to this error.

Is there any workaround at the moment? this is a bit frustrating since it means we can easily make changes once we've deployed this to production. Deleting and recreating isn't an ideal solution...

[ewbankkit]

Similar: #27973.

[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.