sinbai
commented
2 years ago @AvtsVivek thanks for opening this issue here. Unfortunately, I could not reproduce this issue with the blow tf configuration. It works fine on my local. Could you reproduce it with the following configuration?
terraform {
# required_version = ">= 1.0.0"
# The right most version upgrade is allowed by the following.
# So for production, the following should be used with ~> 1.0.0
# https://stackoverflow.com/q/72975317/1977871
required_version = "~> 1.0"
required_providers {
azurerm = {
source = "hashicorp/azurerm"
version = "~> 3.0"
}
random = {
source = "hashicorp/random"
version = "~> 3.0"
}
}
}
# Generic Input Variables
# Business Division
variable "business_divsion" {
description = "Business Division in the large organization this Infrastructure belongs"
type = string
default = "hr"
}
# Environment Variable
variable "environment" {
description = "Environment Variable used as a prefix"
type = string
default = "dev"
}
# Azure Resource Group Name
variable "resource_group_name" {
description = "Resource Group Name"
type = string
default = "rg-vivrag"
}
# Azure Resources Location
variable "resource_group_location" {
description = "Region in which Azure Resources to be created"
type = string
default = "eastus"
}
locals {
owners = var.business_divsion
environment = var.environment
resource_name_prefix = "${var.business_divsion}-${var.environment}"
#name = "${local.owners}-${local.environment}"
}
variable "mssql_server_name" {
description = "Ms Sql server name"
type = string
default = "ms-sql-server0909"
}
variable "mssql_database_name" {
description = "Ms Sql Database Name "
type = string
default = "ms-sql-db0909"
}
# Provider Block
provider "azurerm" {
features {}
}
resource "azurerm_resource_group" "rg" {
name = "18311"
location = "eastus"
}
resource "azurerm_mssql_server" "mssql_server" {
name = "${local.resource_name_prefix}-${var.mssql_server_name}"
resource_group_name = azurerm_resource_group.rg.name
location = azurerm_resource_group.rg.location
version = "12.0"
administrator_login = "adm1n157r470r"
administrator_login_password = "4-v3ry-53cr37-p455w0rd"
}
resource "azurerm_mssql_database" "mssql_database" {
name = "${local.resource_name_prefix}-${var.mssql_database_name}"
server_id = azurerm_mssql_server.mssql_server.id
collation = "SQL_Latin1_General_CP1_CI_AS"
license_type = "LicenseIncluded"
max_size_gb = 1
read_scale = false
sku_name = "S0"
zone_redundant = false
depends_on = [azurerm_mssql_server.mssql_server]
tags = {
environment = "dev",
owners = "hr"
}
}
AvtsVivek
zucler
mdurell
Upanshu11
RavinderReddyF5
stbenjam
learnprofile
Is there an existing issue for this?
Community Note
Terraform Version
Terraform v1.2.9
AzureRM Provider Version
~> 3.0
Affected Resource(s)/Data Source(s)
N/A
Terraform Configuration Files
The full config files are here.
So the parent resource here is the sql server(azurerm_mssql_server.mssql_server) and the child is database(azurerm_mssql_database.mssql_database) to be created on the server.
The child has an implicit dependency on the parent. The parent gets created, but still when its the time for the child, terraform says that the parent is not found.
Debug Output/Panic Output
The full gist is here.
Expected Behaviour
The sql database on the ms sql server should get created without errors.
Actual Behaviour
azurerm_mssql_database.mssql_database: Creating... ╷ │ Error: creating/updating Database: (Name "hr-dev-ms-sql-db" / Server Name "hr-dev-ms-sql-server" / Resource Group "hr-dev-rg-vivrag-dtdwxd"): sql.DatabasesClient#CreateOrUpdate: Failure sending request: StatusCode=404 -- Original Error: Code="ParentResourceNotFound" Message="Can not perform requested operation on nested resource. Parent resource 'hr-dev-ms-sql-server' not found." │ │ with azurerm_mssql_database.mssql_database, │ on tf6-02-sql-server-db.tf line 20, in resource "azurerm_mssql_database" "mssql_database": │ 20: resource "azurerm_mssql_database" "mssql_database" { │ ╵
Steps to Reproduce
The command list is below.
Full file is here.
Important Factoids
N/A
References
Similar issue is explained here on the ms docs, but this about bicep and not terraform.
Now found a work around and seems to be working.
Based on the sleep terraform timer resource here, I added a timer to the config.
The full set of new configs are here
You can see the time_sleep resource here.
Also I found similar errors with another example.
The terraform configuration files are here.
When I plan and apply, I get the following error.
So here the child resource azurerm_virtual_machine_extension should be created after the parent resource azurerm_windows_virtual_machine is created.
But unless I have sleep timer setup, its giving me the above error. I had to keep azurerm_virtual_machine_extension waiting for 6 minutes, and then only its successful. 30 or 60 sec wait did not work. You can see that resource in this file here.
My conclusion is, we have to wait for an indefinite amount of time after the parent is created and then execute the plan and apply commands. We can use the time_sleep resource but the time we need to specify is indefinite. It could be 30s or it can be as high as half hour. So the way I am working now is, execute plan and apply repeatedly till at one point, finally the child is successfully gets created without error.
Is it that I am missing something?