Hi Everyone,
I'm having issues deploying SQL DB instance on GCP.
Error: Error waiting for Create Service Networking Connection:
Error code 9, message: Cannot modify allocated ranges in CreateConnection. Please use UpdateConnection.
resource "google_compute_network" "vpc" {
name = "edddddddd-one-vpc"
auto_create_subnetworks = false
}
resource "google_compute_subnetwork" "public_subnet" {
name = "edddddddd-public-one-subnet"
ip_cidr_range = "10.0.0.0/24"
region = var.region
network = google_compute_network.vpc.self_link
}
resource "google_compute_subnetwork" "private_subnet" {
name = "edddddddd-private-one-subnet"
ip_cidr_range = "10.1.0.0/24"
region = var.region
network = google_compute_network.vpc.self_link
purpose = "PRIVATE_SERVICE_CONNECT"
private_ip_google_access = true
}
resource "google_compute_global_address" "private_service_access" {
name = "edddddddd-private-service-access"
purpose = "VPC_PEERING"
address_type = "INTERNAL"
prefix_length = 24
network = google_compute_network.vpc.name
}
resource "google_service_networking_connection" "private_vpc_connection" {
network = google_compute_network.vpc.self_link
service = "servicenetworking.googleapis.com"
reserved_peering_ranges = [google_compute_global_address.private_service_access.name]
}
resource "google_sql_database_instance" "database" {
for_each = toset([
"serv1",
"serv2",
"serv3",
])
name = "${each.key}-one-mysql-db"
region = var.region
database_version = "MYSQL_8_0"
depends_on = [google_service_networking_connection.private_vpc_connection]
settings {
tier = "db-n1-standard-2"
edition = "ENTERPRISE"
availability_type = "ZONAL"
location_preference {
zone = var.zone
}
ip_configuration {
ipv4_enabled = false
private_network = "projects/${var.gcp_project}/global/networks/${google_compute_subnetwork.private_subnet.name}"
enable_private_path_for_google_cloud_services = false
}
}
}