{"action":"created","issue":{"url":"https://api.github.com/repos/hashicorp/terraform/issues/1070","labels_url":"https://api.github.com/repos/hashicorp/terraform/issues/1070/labels{/name}","comments_url":"https://api.github.com/repos/hashicorp/terraform/issues/1070/comments","events_url":"https://api.github.com/repos/hashicorp/terraform/issues/1070/events","html_url":"https://github.com/hashicorp/terraform/issues/1070","id":59177882,"number":1070,"title":"RDS/MySQL version upgrade - forces new resource","user":{"login":"elliotmoore","id":1574673,"avatar_url":"https://avatars.githubusercontent.com/u/1574673?v=3","gravatar_id":"","url":"https://api.github.com/users/elliotmoore","html_url":"https://github.com/elliotmoore","followers_url":"https://api.github.com/users/elliotmoore/followers","following_url":"https://api.github.com/users/elliotmoore/following{/other_user}","gists_url":"https://api.github.com/users/elliotmoore/gists{/gist_id}","starred_url":"https://api.github.com/users/elliotmoore/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/elliotmoore/subscriptions","organizations_url":"https://api.github.com/users/elliotmoore/orgs","repos_url":"https://api.github.com/users/elliotmoore/repos","events_url":"https://api.github.com/users/elliotmoore/events{/privacy}","received_events_url":"https://api.github.com/users/elliotmoore/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/hashicorp/terraform/labels/bug","name":"bug","color":"f7c6c7"},{"url":"https://api.github.com/repos/hashicorp/terraform/labels/provider/aws","name":"provider/aws","color":"bfdadc"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-02-27T01:58:11Z","updated_at":"2015-02-27T02:22:34Z","closed_at":null,"body":"terraform -v\r\nTerraform v0.4.0-dev\r\nrev: b7459cb\r\n\r\nHi,\r\n\r\nPlaying around with terraform and RDS - went to bump a version and terraform plan advised me it would force a new resource. \r\n\r\n   ` engine_version:           \"5.6.19b\" => \"5.6.21b\" (forces new resource)`\r\n\r\nI went ahead anyway, its only a test and indeed it did destroy the database but failed to re-create it.\r\n\r\n```\r\n<snip>\r\naws_db_instance.default: Refreshing state... (ID: estest-database)\r\naws_db_instance.default: Destroying...\r\naws_db_instance.default: Destruction complete\r\nError applying plan:\r\n\r\n1 error(s) occurred:\r\n\r\n* 1 error(s) occurred:\r\n\r\n* aws_db_instance.default: diffs didn't match during apply. This is a bug with Terraform and should be reported.\r\n\r\nTerraform does not automatically rollback in the face of errors.\r\nInstead, your Terraform state file has been partially updated with\r\nany resources that successfully completed. Please address the error\r\nabove and apply again to incrementally change your infrastructure.\r\n```\r\n\r\nRunning `terraform apply` again recreated the database\r\n\r\nNote, Running an upgrade in the console just requires a reboot and http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-rds-database-instance.html#cfn-rds-dbinstance-engineversion also suggests it's a bug.\r\n\r\nthanks. \r\n\r\nI understand the aws/go library is in transition - so this might be mute soon...\r\n"},"comment":{"url":"https://api.github.com/repos/hashicorp/terraform/issues/comments/76319403","html_url":"https://github.com/hashicorp/terraform/issues/1070#issuecomment-76319403","issue_url":"https://api.github.com/repos/hashicorp/terraform/issues/1070","id":76319403,"user":{"login":"catsby","id":61721,"avatar_url":"https://avatars.githubusercontent.com/u/61721?v=3","gravatar_id":"","url":"https://api.github.com/users/catsby","html_url":"https://github.com/catsby","followers_url":"https://api.github.com/users/catsby/followers","following_url":"https://api.github.com/users/catsby/following{/other_user}","gists_url":"https://api.github.com/users/catsby/gists{/gist_id}","starred_url":"https://api.github.com/users/catsby/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/catsby/subscriptions","organizations_url":"https://api.github.com/users/catsby/orgs","repos_url":"https://api.github.com/users/catsby/repos","events_url":"https://api.github.com/users/catsby/events{/privacy}","received_events_url":"https://api.github.com/users/catsby/received_events","type":"User","site_admin":false},"created_at":"2015-02-27T02:22:34Z","updated_at":"2015-02-27T02:22:34Z","body":"Thanks for reporting! Def. seems bug-ish, but maybe in more way than one.\r\nI see that `engine_version` is currently set to force a new resource (the delete you saw):\r\n\r\n- https://github.com/hashicorp/terraform/blob/master/builtin/providers/aws/resource_aws_db_instance.go#L50\r\n\r\nThe `This is a bug with Terraform and should be reported.` is definitely a bug for us, thanks! /cc @mitchellh \r\n\r\nI'll look more into the docs and do some research here on options. "}}