CloudSQLInstance contantly being updated

[bartse]

What happened?

1. Using crossplane 1.9.0 + gcp provider 0.21.0 running on GKE 1.21
2. Setup a CloudSQLInstance using below config

...
  forProvider:
    databaseVersion: POSTGRES_14
    instanceType: CLOUD_SQL_INSTANCE
    maxDiskSize: 40
    region: europe-west1
    settings:
      activationPolicy: ALWAYS
      availabilityType: ZONAL
      backupConfiguration:
        startTime: "04:00"
      dataDiskSizeGb: 10
      dataDiskType: PD_SSD
      ipConfiguration:
        privateNetwork: projects/<project-id>/global/networks/<network-name>
        requireSsl: true
      maintenanceWindow:
        day: 6
        hour: 23
        updateTrack: stable
      pricingPlan: PER_USE
      replicationType: SYNCHRONOUS
      storageAutoResize: true
      tier: db-custom-2-3840
...

3. The provider is constantly updating the instance to a point where it fails

  Type     Reason                        Age                   From                                                 Message
  ----     ------                        ----                  ----                                                 -------
  Normal   CreatedExternalResource       5m46s                 managed/cloudsqlinstance.database.gcp.crossplane.io  Successfully requested creation of external resource
  Warning  CannotUpdateExternalResource  81s (x12 over 103s)   managed/cloudsqlinstance.database.gcp.crossplane.io  cannot update the CloudSQL instance: googleapi: Error 409: Operation failed because another opera
tion was already in progress. Try your request after the current operation is complete., operationInProgress
  Normal   UpdatedExternalResource       42s (x18 over 5m46s)  managed/cloudsqlinstance.database.gcp.crossplane.io  Successfully requested update of external resource

I did find earlier bug reports but those seem to have been fixed a while ago so not sure anyone else is experiencing this issue.

• https://github.com/crossplane-contrib/provider-gcp/issues/121
• https://github.com/crossplane-contrib/provider-gcp/issues/352
• PR fix https://github.com/crossplane-contrib/provider-gcp/pull/374