Log(attached below) shows that after Google updated the CloudSQL version this problem started. Still no response from Tech Support for created P1 case and our business been seriously affected by this 13+hrs downtime :( . Any suggestions how it can be solved?
Cannot determine thread, fp=7f71fabfe770
Thanks for contacting Google Cloud Platform support. I understand that your Cloud SQL instance (xxxxxxx) did get stuck on an operation on 2020-02-22 at 1:00 AM EST which resulted in “unknown error” and prevented you from taking any further actions. I understand that this situation raises concern and I will do my best to investigate the root cause of the issue. I do also apologize for the delay in response, as this was initially created on Feb 22 and was actioned in a timely manner.
The case was initially routed to a different team and since the support package on your account does not include the weekends, this case stayed unattended during that time, however, it is now in the right department and I’ll be providing support on this case.
I noticed that the project name is missing from the case and I had to make sure I am looking at the right project and Instance. By checking your email and the projects assigned to your email, I came to the conclusion that the project in question is ‘xxxxxxxxx’. Please correct me if I'm looking at the wrong project.
Furthermore, By reviewing the cloud SQL instance status (xxxxxx), I can confirm that it is currently up and in the Running state. By looking at the recent operations, I noticed that there was a roll out scheduled for 1AM EST on Feb 22, however, it did not complete and therefore the instance got stuck on that operation up until Feb 24 at 11:03 AM. Once the instance is in the middle of a maintenance, no further action can be taken, unless the operation is cancelled by a Cloud SQL specialist or it is completed. Our Cloud SQL specialist was able to cancel it on Feb 24 at 11:03 AM EST and that enabled the instance to go back to Running status. This should no longer be an issue and should not be a concern anymore. Please let me know if you still experience any issue on your instance and I shall investigate it further.
Once again, I do apologize for the delay in responding to your request as this was due to inappropriate assignment of the case. Please let me know if you have further questions or require further clarification regarding the issue and I shall address them accordingly.