Can not change scheduled backup time

48 views
Skip to first unread message

Huy Nguyen

unread,
Feb 21, 2017, 9:43:05 PM2/21/17
to Google Cloud SQL discuss
Hi guy,

I using GAE 1 year ago.. I want backup my cloud sql to local but can not show recent backup.. (total storage capacity of about 20G)

I want edit my sql instance config (Edit backup time, add authorized networks..) but all attempts to change were unsuccessful. I received message 

"Operation failed because another operation was already in progress". 

I tried restarting but remain so.. Plz help me solve this problem. Tks


David Newgas

unread,
Feb 22, 2017, 12:43:12 PM2/22/17
to Google Cloud SQL discuss
Hi,

Cloud SQL backups are an internal disk snapshot and cannot be downloaded to local storage. If you want to get a local copy of your database (or store a copy in GCS so that cloud-based backups last more than 7 days) you should use the export feature.

If you want advice on the operation, please run "gcloud --project=YOUR_PROJECT sql operations list --instance=YOUR_INSTANCE_NAME" (or look at operations on your instance in the Cloud Console) to find what operation is still running. Use "gcloud --project=YOUR_PROJECT sql operations describe INSTANCE_ID --instance=YOUR_INSTANCE_NAME" to get more details on the still-running operation. If you share this information with us we might be able to figure out what's going on with the operation.

It would also be helpful to know if this is a 1st Generation or 2nd Generation instance.

David

--
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+unsub...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/97e34e7a-b05a-493f-8f9a-6482805eaf0d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Huy Nguyen

unread,
Feb 22, 2017, 10:35:43 PM2/22/17
to Google Cloud SQL discuss
Hi David,

I using 1st Generation.. 
I execute cmd Operation and received:

25d15755-a918-4a49-b359-4d5b8a9b6e57  RESTART          2017-02-21T18:31:27.186+00:00  2017-02-21T18:31:27.186+00:00  -               DONE
43ff967d-5e5c-417e-ad1c-a28319848e3e  DELETE_USER      2016-11-30T08:19:57.705+00:00  2016-11-30T08:19:57.705+00:00  -               DONE
af971718-7860-4e90-9dcf-8c100a54ebad  DELETE_USER      2016-11-30T08:19:57.176+00:00  2016-11-30T08:19:57.176+00:00  -               DONE
8f87ce40-db99-4b4d-a032-f59a023916ca  BACKUP_VOLUME    2016-11-29T18:10:34.585+00:00  2016-11-29T18:23:53.177+00:00  -               DONE
010d96a6-c15b-4082-8a82-f4fe61ba8fab  BACKUP_VOLUME    2016-11-28T15:40:31.485+00:00  2016-11-28T15:54:47.768+00:00  -               DONE

You can show lastest BACKUP_VOLUME  completed is 2016-11-30. I don't known why is stoped.. I want this continue.
I will sent private message for you my project id.

Tks,

David Newgas

unread,
Feb 24, 2017, 8:21:35 PM2/24/17
to Google Cloud SQL discuss
Hi,

It looks like this instance has got in some bad state internally. I'm looking to see if we can get it back into a good state and find out how this happened.

David

To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscr...@googlegroups.com.

--
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+unsub...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/19d962e2-c47e-48f8-a22e-8e0b4a704155%40googlegroups.com.

Huy Nguyen

unread,
Feb 26, 2017, 11:06:56 PM2/26/17
to Google Cloud SQL discuss
I'm looking forward.. 

Tks guy,
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsub...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/97e34e7a-b05a-493f-8f9a-6482805eaf0d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Huy Nguyen

unread,
Feb 28, 2017, 10:40:38 PM2/28/17
to Google Cloud SQL discuss
I'm looking..
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsub...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/97e34e7a-b05a-493f-8f9a-6482805eaf0d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

David Newgas

unread,
Mar 1, 2017, 12:21:16 PM3/1/17
to Google Cloud SQL discuss
Hi Huy,

I haven't forgotten! This is taking a little time as a) there are two possible places that need to be fixed, and I want to make sure we change the right one and b) I don't have necessary permissions to make the change directly, so I'm working with some other folks to do it.

David

To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscr...@googlegroups.com.

--
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+unsubscr...@googlegroups.com.

--
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+unsub...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/581fb9a7-5f77-4503-b587-7df3af853102%40googlegroups.com.

David Newgas

unread,
Mar 1, 2017, 1:58:42 PM3/1/17
to Google Cloud SQL discuss
Hi Huy,

We have cleared what we believe is the issue. Can you see if you are able to run operations on your instance now?

David

Huy Nguyen

unread,
Mar 2, 2017, 12:06:59 AM3/2/17
to Google Cloud SQL discuss
Great, David,

I can add authorized networks or edit backups time now..
Continue try backup instance status..

Have a weekend,
H,
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsub...@googlegroups.com.

--
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+unsub...@googlegroups.com.

--
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+unsub...@googlegroups.com.

David Newgas

unread,
Mar 2, 2017, 12:17:35 PM3/2/17
to Google Cloud SQL discuss
Do you mean that something is still wrong with the backups? Can you let me know what error you saw?

To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscr...@googlegroups.com.

--
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+unsubscr...@googlegroups.com.

--
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+unsubscr...@googlegroups.com.

--
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+unsub...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/3d1e28a1-f0ca-45b1-816d-5e3684a65d63%40googlegroups.com.

Huy Nguyen

unread,
Mar 3, 2017, 5:52:08 AM3/3/17
to Google Cloud SQL discuss
Hi David,

I do not see recent backups ago, i changed it now..

Tks
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsub...@googlegroups.com.

--
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+unsub...@googlegroups.com.

--
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+unsub...@googlegroups.com.

David Newgas

unread,
Mar 6, 2017, 1:51:32 PM3/6/17
to Google Cloud SQL discuss
Hi,

I see backups are running properly (the last was at 2017-03-05 12:20:45 PST). I'm going to consider this fixed unless you let me know otherwise.

To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscr...@googlegroups.com.

--
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+unsubscr...@googlegroups.com.

--
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+unsubscr...@googlegroups.com.

--
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+unsubscr...@googlegroups.com.

--
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+unsub...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/fb3e82ac-9946-4d51-bed3-c7e9eadbd625%40googlegroups.com.

Huy Nguyen

unread,
Mar 6, 2017, 9:01:48 PM3/6/17
to Google Cloud SQL discuss
Everything was working properly from your last message..

Thank you very much,
H,

Reply all
Reply to author
Forward
0 new messages