google-cloud-sql network architecture upgrade error

[no-name_1]

Hi support,

I have the same error like this link:

“https://stackoverflow.com/questions/78290104/google-cloud-sql-network-architecture-upgrade-error”

can anyone help for this ?

gcloud sql instances patch mysql-A --upgrade-sql-network-architecture

The following message will be used for the patch API method.
{“name”: “mysql-A”, “project”: “gcp-project”, “settings”: {}, “sqlNetworkArchitecture”: “NEW_NETWORK_ARCHITECTURE”}
ERROR: (gcloud.sql.instances.patch) FAILED_PRECONDITION: Precondition check failed.

For the same project and the same VPC, I can do this for mysql-B but fail for mysql-A

mysql-A details:

mysql 5.7.44, same vpc with private service access “google-managed-services-default, 10.50.208.0/20” (same error with non-legacy HA enabled)[created very long time ago with HA disabled]

mysql-B-details:

mysql 8.0.18, same vpc with private service access " private-ip-range-for-cloudsql, 10.25.148.0/24, servicenetworking-googleapis-com, cloudsql-mysql-googleapis-com " (HA disabled)

[Rhett]

Hi @no-name_1 ,

I understand that you’re currently in the process of upgrading your MySQL instances to the new network architecture on Cloud SQL. Before you continue, make sure note the upgrade limitations and to check your instance eligibility with the following command:

gcloud sql instances list --show-sql-network-architecture

From the Stack Overflow thread you shared, the user had the following error:

ERROR: (gcloud.sql.instances.patch) INVALID_ARGUMENT: Request contains an invalid argument.

Potential causes of this error occurs when:

• Your subnet does not have enough IP space in your allocated IP ranges for private services access for the upgrade.
• Your MySQL instance has a legacy high availability configuration.

To resolve this, I recommend the following actions:

• Allocate a new IP range for your private service access instance, then update the configuration to make sure the subnet is not. larger than /24
• Update your current instance from legacy to current high availability.

If these steps don’t resolve the issue, reach out to Google Cloud support for a deeper investigation and resolution.

I hope this helps!

[no-name_1]

Hi -Rhett,

Thx for your reply.

For IP range not enough issue, can you explain more? Mysql-A & Mysql-B are use the same VPC but in different “private service access” IP Range.( as screen captured) Mysql-B can upgraded successfully but Mysql-A not.

For HA, I guess I’m using “current HA” as I just enable it to for this upgrade error but still fail.

can you show me how to check this?

thx

no–name

[no-name_1]

Hi Rhett or Support,

do you have any update of my question?

thx

no–name

[no-name_1]

Hi Rhett or Support,

do you have any update of my question?

thx

no–name