Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Failure to migrate Postgres 9.6.6 snapshot to Aurora aws_rds_cluster #4214

Closed
steveh opened this issue Apr 16, 2018 · 2 comments · Fixed by #4215
Closed

Failure to migrate Postgres 9.6.6 snapshot to Aurora aws_rds_cluster #4214

steveh opened this issue Apr 16, 2018 · 2 comments · Fixed by #4215
Labels
bug Addresses a defect in current functionality. service/rds Issues and PRs that pertain to the rds service.
Milestone

Comments

@steveh
Copy link
Contributor

steveh commented Apr 16, 2018

Terraform Version

Terraform v0.11.7
+ provider.aws v1.14.1

Affected Resource(s)

  • aws_rds_cluster

Terraform Configuration Files

resource "aws_rds_cluster" "main" {
  engine         = "aurora-postgresql"
  engine_version = "9.6.6"
}

resource "aws_rds_cluster_instance" "main" {
  cluster_identifier  = "${aws_rds_cluster.main.id}"
  engine              = "aurora-postgresql"
  engine_version      = "9.6.6"
  snapshot_identifier = "arn:of:postgresql:9.6.6:snapshot"
}

Debug Output

2018-04-16T14:40:22.647+1200 [DEBUG] plugin.terraform-provider-aws_v1.14.1_x4: Action=RestoreDBClusterFromSnapshot&AvailabilityZones.AvailabilityZone.1=ap-southeast-2c&AvailabilityZones.AvailabilityZone.2=ap-southeast-2a&AvailabilityZones.AvailabilityZone.3=ap-southeast-2b&DBClusterIdentifier=telemetry-scale&DBSubnetGroupName=telemetry-scale&Engine=aurora-postgresql&Port=5432&SnapshotIdentifier=arn%3Aaws%3Ards%3Aap-southeast-2%3A561053517830%3Asnapshot%3Ards%3Atelemetry-production-2018-04-15-13-11&Tags=&Version=2014-10-31&VpcSecurityGroupIds.VpcSecurityGroupId.1=sg-f47a128d
2018-04-16T14:40:23.726+1200 [DEBUG] plugin.terraform-provider-aws_v1.14.1_x4: 2018/04/16 14:40:23 [DEBUG] [aws-sdk-go] DEBUG: Validate Response rds/RestoreDBClusterFromSnapshot failed, not retrying, error InvalidParameterCombination: Cannot upgrade from postgres 9.6.6 to aurora-postgresql 9.6.3.Specify a current active database version, the latest active minor version for postgres 9.6 is 9.6.6.

Expected Behavior

Terraform creates a new Aurora cluster from an RDS snapshot, which works through the AWS console.

Actual Behavior

Cannot upgrade from postgres 9.6.6 to aurora-postgresql 9.6.3.Specify a current active database version, the latest active minor version for postgres 9.6 is 9.6.6.

Steps to Reproduce

  1. terraform apply

References

Seems likely related to GH-4139

The RestoreDBClusterFromSnapshot call does not include an EngineVersion parameter, so presumably uses the default of 9.6.3.

@bflad bflad added bug Addresses a defect in current functionality. service/rds Issues and PRs that pertain to the rds service. labels Apr 17, 2018
@bflad bflad added this to the v1.15.0 milestone Apr 17, 2018
@bflad
Copy link
Contributor

bflad commented Apr 17, 2018

The fix has been merged into master and will release with v1.15.0 of the AWS provider, likely tomorrow.

@ghost
Copy link

ghost commented Apr 6, 2020

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 feel this issue should be reopened, we encourage creating a new issue linking back to this one for added context. Thanks!

@ghost ghost locked and limited conversation to collaborators Apr 6, 2020
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Addresses a defect in current functionality. service/rds Issues and PRs that pertain to the rds service.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants