Create SQL Instance fails with "An unknown error occurred."

Question

I'm trying to create a Cloud SQL instance but am unable to do so.

I have tried many variations:

DB: Postgres 9.6 / 11.1, Mysql 5.9
Tier: micro, 1 vcpu / 3.75MiB
Public network (non selected)
Via the console (pictured) or via gcloud

I have an up-to-date billing account (have other GCP services running ok). I am the project owner and logged into the console and gcloud as such

Each time i see the same unhelpful, generic error message "An unknown error occurred.". See below also for an error log example.

{
 insertId:  "XXX"  
 logName:  "projects/XXXX/logs/cloudaudit.googleapis.com%2Factivity"  
 protoPayload: {
  @type:  "type.googleapis.com/google.cloud.audit.AuditLog"   
  authenticationInfo: {
   principalEmail:  "XXXX"    
  }
  authorizationInfo: [
   0: {
    granted:  true     
    permission:  "cloudsql.instances.create"     
    resource:  "instances/XXXX"     
    resourceAttributes: {
    }
   }
  ]
  methodName:  "cloudsql.instances.create"   
  request: {
   @type:  "type.googleapis.com/cloudsql.admin.InstancesInsertRequest"    
   clientIp:  "XXXX"    
   resource: {
    backendType:  "SECOND_GEN"     
    databaseVersion:  "POSTGRES_11"     
    instanceName: {
     fullProjectId:  "XXXX"      
     instanceId:  "XXXX"      
    }
    instanceType:  "CLOUDSQL_INSTANCE"     
    region:  "us-central1"     
    settings: {
     activationPolicy:  "ALWAYS"      
     availabilityType:  "ZONAL"      
     backupConfig: {
      enabled:  true       
      replicationLogArchivingEnabled:  false       
      specification:  "every day 07:00"       
     }
     dataDiskSizeGb:  "10"      
     dataDiskType:  "PD_SSD"      
     ipConfiguration: {
      enabled:  true       
     }
     locationPreference: {
      gceZone:  "us-central1-a"       
     }
     maintenanceWindow: {
     }
     pricingPlan:  "PER_USAGE"      
     storageAutoResize:  true      
     storageAutoResizeLimit:  "0"      
     tier:  "db-custom-1-3840"      
    }
   }
  }
  requestMetadata: {
   callerIp:  "XXXX"    
   destinationAttributes: {
   }
   requestAttributes: {
    auth: {
    }
    time:  "2019-06-04T05:46:10.255Z"     
   }
  }
  resourceName:  "instances/XXXX"   
  response: {
   @type:  "type.googleapis.com/cloudsql.admin.InstancesInsertResponse"    
  }
  serviceName:  "cloudsql.googleapis.com"   
  status: {
   code:  2    
   message:  "UNKNOWN"    
  }
 }
 receiveTimestamp:  "2019-06-04T05:46:10.297960113Z"  
 resource: {
  labels: {
   database_id:  "XXXX"    
   project_id:  "XXXX"    
   region:  "us-central"    
  }
  type:  "cloudsql_database"   
 }
 severity:  "ERROR"  
 timestamp:  "2019-06-04T05:46:10.250Z"  
}

Maxim · Accepted Answer · 2019-06-04 11:30:45Z

1

Since as you've said, the error message is too generic, the appropriate course of action, in my mind, is to have the issue digged into deeper by inspecting your project.

As a GCP Support employee I recommend you to open private issue by providing your project number in the following component:

https://issuetracker.google.com/issues/new?component=187202

Once you have it created, please let me know, and I'll start working on it as soon as possible.

answered Jun 4, 2019 at 11:30

Maxim

4,4451 gold badge17 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

elmpp Over a year ago

Thank you. Issue created. issuetracker.google.com/issues/134370350

noamt · Accepted Answer · 2019-12-04 10:02:10Z

0

I've had a similar issue trying to create a SQL instance using Terraform.

As it turns out, database instance names can't be reused immediately:

If I delete my instance, can I reuse the instance name?

Yes, but not right away. The instance name is unavailable for up to a week before it can be reused.

To solve this I had to add a random suffix to the database instance name upon creation.

answered Dec 4, 2019 at 10:02

noamt

7,8854 gold badges44 silver badges63 bronze badges

Collectives™ on Stack Overflow

Create SQL Instance fails with "An unknown error occurred."

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related