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.

Sign up for GitHub

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

Jump to bottom

While changing the root_password for MSSQL server is destroying the instance and then creating the new instance #405

Closed
sk251319 opened this issue Jan 12, 2023 · 4 comments · Fixed by GoogleCloudPlatform/magic-modules#7136, hashicorp/terraform-provider-google-beta#5133, hashicorp/terraform-provider-google#13574 or GoogleCloudPlatform/terraform-validator#1316
Closed

While changing the root_password for MSSQL server is destroying the instance and then creating the new instance #405

sk251319 opened this issue Jan 12, 2023 · 4 comments · Fixed by GoogleCloudPlatform/magic-modules#7136, hashicorp/terraform-provider-google-beta#5133, hashicorp/terraform-provider-google#13574 or GoogleCloudPlatform/terraform-validator#1316
Labels
bug Something isn't working Stale

Comments

@sk251319
Copy link

sk251319 commented Jan 12, 2023 •
edited
Loading

Expected behavior

Terraform should do not destroy the instance if we are changing the root-password.

Observed behavior

When I am changing the root_password for the existing MSSQL instance rather that doing the in-place edit it is destroying the instance and then recreating the instance.

we can change root_password using GCP console and gcloud utility and it is not recreating the instance but using terraform it is recreating the instance.

No response

Terraform Configuration

Provider version 
google      = "~> 3.61.0"
google-beta = "~> 3.61.0"

Terraform Version

Provider version
google      = "~> 3.61.0"
google-beta = "~> 3.61.0"

Additional information

No response
@sk251319 sk251319 added the bug Something isn't working label Jan 12, 2023
@sk251319
Copy link
Author

Can anyone confirm someone is looking into that as it is a showstopper for me.

@sk251319
Copy link
Author

@KelvinVenancio Anyone from your team has an idea about the issue which I have raised?

@sk251319 sk251319 mentioned this issue Jan 16, 2023
Closed
@ravisiddhu ravisiddhu mentioned this issue Jan 18, 2023
Merged
5 tasks
c2thorn pushed a commit to GoogleCloudPlatform/magic-modules that referenced this issue Jan 25, 2023
@ravisiddhu
Make root_password field in google_sql_database_instance resource…
eedcfb6 
… updatable (#7136)

fix terraform-google-modules/terraform-google-sql-db#405
modular-magician added a commit to modular-magician/terraform-provider-google-beta that referenced this issue Jan 25, 2023
@modular-magician
Make root_password field in google_sql_database_instance resource…
b04909c 
… updatable (hashicorp#7136)

fix terraform-google-modules/terraform-google-sql-db#405

Signed-off-by: Modular Magician <[email protected]>
@modular-magician modular-magician mentioned this issue Jan 25, 2023
Merged
5 tasks
modular-magician added a commit to modular-magician/terraform-provider-google that referenced this issue Jan 25, 2023
@modular-magician
Make root_password field in google_sql_database_instance resource…
aab962f 
… updatable (hashicorp#7136)

fix terraform-google-modules/terraform-google-sql-db#405

Signed-off-by: Modular Magician <[email protected]>
@modular-magician modular-magician mentioned this issue Jan 25, 2023
Merged
5 tasks
modular-magician added a commit to hashicorp/terraform-provider-google-beta that referenced this issue Jan 25, 2023
@modular-magician
Make root_password field in google_sql_database_instance resource…
97d4ffc 
… updatable (#7136) (#5133)

fix terraform-google-modules/terraform-google-sql-db#405

Signed-off-by: Modular Magician <[email protected]>

Signed-off-by: Modular Magician <[email protected]>
modular-magician added a commit to hashicorp/terraform-provider-google that referenced this issue Jan 25, 2023
@modular-magician
Make root_password field in google_sql_database_instance resource…
c758f91 
… updatable (#7136) (#13574)

fix terraform-google-modules/terraform-google-sql-db#405

Signed-off-by: Modular Magician <[email protected]>

Signed-off-by: Modular Magician <[email protected]>
modular-magician added a commit to modular-magician/terraform-validator that referenced this issue Jan 25, 2023
@modular-magician
Make root_password field in google_sql_database_instance resource…
d4577d3 
… updatable (#7136)

fix terraform-google-modules/terraform-google-sql-db#405

Signed-off-by: Modular Magician <[email protected]>
@modular-magician modular-magician mentioned this issue Jan 25, 2023
Merged
5 tasks
modular-magician added a commit to GoogleCloudPlatform/terraform-validator that referenced this issue Jan 25, 2023
@modular-magician
Make root_password field in google_sql_database_instance resource…
a6edb12 
… updatable (#7136) (#1316)

fix terraform-google-modules/terraform-google-sql-db#405

Signed-off-by: Modular Magician <[email protected]>

Signed-off-by: Modular Magician <[email protected]>
@DeLoWaN
Copy link
Contributor

DeLoWaN commented Feb 1, 2023

I've just tested it: I changed the root_password, it did not do anything: no change in the database instance. Fortunately, that was a test instance, I destroyed and recreated it.

@github-actions
Copy link

github-actions bot commented Apr 2, 2023

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 7 days

@github-actions github-actions bot added the Stale label Apr 2, 2023
@github-actions github-actions bot closed this as not planned Won't fix, can't repro, duplicate, stale Apr 10, 2023
ericayyliu pushed a commit to ericayyliu/magic-modules that referenced this issue Jul 26, 2023
@ravisiddhu @ericayyliu
Make root_password field in google_sql_database_instance resource…
e12e96f 
… updatable (GoogleCloudPlatform#7136)

fix terraform-google-modules/terraform-google-sql-db#405
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working Stale
Projects
None yet
Milestone
No milestone
2 participants
@DeLoWaN @sk251319