Saturday, December 17, 2016

[google-cloud-sql-discuss] Stuck on PENDING_CREATE state while creating replica

About 2 weeks ago, I was trying to create external master replication following this instruction:

  https://cloud.google.com/sql/docs/replication/configure-external-master


But even after creating replication db, replica instances are under pending status.


FYI this is what it looks like.

$ curl --header "Authorization: Bearer ${ACCESS_TOKEN}" \
>  --header 'Content-Type: application/json' \
>  -X GET \
>  https://www.googleapis.com/sql/v1beta4/projects/mathpresso-1016/instances/qbase-primary-repl-read/
{
 "kind": "sql#instance",
 "selfLink": "https://www.googleapis.com/sql/v1beta4/projects/mathpresso-1016/instances/qbase-primary-repl-read",
 "name": "qbase-primary-repl-read",
 "connectionName": "mathpresso-1016:qbase-primary-repl-read",
 "etag": some values,
 "project": "mathpresso-1016",
 "state": "PENDING_CREATE",
 "backendType": "FIRST_GEN",
 "databaseVersion": "MYSQL_5_6",
 "region": "us-central",
 "currentDiskSize": "281812187",
 "maxDiskSize": "268435456000",
 "settings": {
  "kind": "sql#settings",
  "settingsVersion": "1",
  "authorizedGaeApplications": [],
  "tier": "D4",
  "backupConfiguration": {
   "kind": "sql#backupConfiguration",
   "startTime": "01:00",
   "enabled": false,
   "binaryLogEnabled": false
  },
  "pricingPlan": "PER_USE",
  "replicationType": "ASYNCHRONOUS",
  "activationPolicy": "ALWAYS",
  "ipConfiguration": {
   "ipv4Enabled": false,
   "authorizedNetworks": []
  },
  "databaseReplicationEnabled": true,
  "crashSafeReplicationEnabled": true
 },
 "serverCaCert": {
  "kind": "sql#sslCert",
  "instance": "qbase-primary-repl-read",
  ...
  ...
  "createTime": "2016-12-02T17:45:20.934Z",
  "expirationTime": "2018-12-02T17:46:20.934Z"
 },
 "instanceType": "READ_REPLICA_INSTANCE",
 "masterInstanceName": "mathpresso-1016:qbase-primary-repl-internalmaster",
 "ipv6Address": some values,
 "replicaConfiguration": {
  "kind": "sql#replicaConfiguration",
  "failoverTarget": false
 }
}


Now I want to delete them, and I don't know how to delete these instances (every time I try it shows error)

Could you please delete these instances?

qbase-primary-repl-internalmaster
qbase-primary-repl-read
qbase-primary-replica-internalmaster
qbase-primary-replica-read
qbase-primary-replica-readonly

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/f6c19a0c-f5d7-487b-91f1-1584be7afbc0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment