Lots of "An unknown error occurred" on automatic backups in operations logs

[Juan Arias]

Hi,

Today I tried to modify the access control of my Cloud SQL instance (2nd generation), but got an error saying I should check the Operations Logs. I opened it, I found these errors have been happening since Sept 6th, the last automatic backup was made on Sept 5th.

When I tried to do a manual backup I got the same error, but also the previous (older than sept 5th) backups were deleted each time I tried to do a backup.

I got the same error when trying to restart the instance.

It seems this is an error on Google's side, and I'm not willing to pay for support for this issue.

Hopefully someone can help me fix this.

[David Newgas]

Hi,

I agree something definitely has gone wrong on the instance, and can see internal errors on those operaitons. I am filing a bug as I believe investigating further requires some expertise and access that I don't have.  We'll let you know what we find.

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/597ac5bd-5711-4ef5-ab93-70543f1eaf28%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Kevin Malachowski]

Hey there Juan,

I'm hoping to help unblock your instance, there does indeed to be some backend problem with your database.

Is downtime acceptable? I believe I can fix it more quickly if it is OK for MySQL to be down momentarily. In the meantime, I will continue trying to fix the underlying issue without a restart.

-Kevin

[Juan Arias]

Hi David and Kevin,

Thanks for your help.

In this case I think downtime would be ok, just please make sure it's not longer than ~30 minutes.

Juan

[Kevin Malachowski]

I believe I have fixed the problem, can you issue a manual backup to verify that everything is OK?

I had to cause a restart to the database and there was about 5 minutes of downtime. Note that if you have a concern about availability, you should probably use a larger database tier. We're continually working to increase the stability of all tiers, but for now db-f1-micro is more likely to run into these edge-case problems that require manual work from us in the backend.

In addition, I have filed a bug to add a paging alert to for databases that have not had a successful backup within a reasonable amount of time.

Thanks again for letting us know about the problem, and please let me know if there is anything else I can do to help out.

Kevin

[Juan Arias]

Thanks a lot Kevin,

I was able to do a manual backup and it was completed successfully. The alert when backups are not completed would be a nice feature; I was aware of this problem just because I added a new backend server and wasn't able to add the permission, otherwise a lot of time would have passed before I realize it.

Juan

[Hussain Badusha]

Hi
We have been using GAE for the past 2 years and it was working fine since last saturday and now we have been facing an issue in our Cloud SQL. And none of our clients is able to use our applications which used Cloud SQL. 

This is the error we are getting when we connect database from our application
"Connection failed: SQLSTATE[HY000] [2006] MySQL server has gone away"
We have tried connecting using PHP with PDO for database actions

Any quick response would greatly be appreciated

Thanks,
Hussain

[Katayoon (Cloud Platform Support)]

Hi Hussain,

I recommend to follow up the private report you have already created in the Issue Tracker.

Note that, Google Groups are reserved for general Google Cloud Platform-end product discussions and not for reporting issues.