It is not normal for an UPDATE Operation in Google Cloud Cloud SQL - MySQL to take more than 9 hours. The update operation typically takes a few minutes to complete, but it can take longer if the database is large or if there are a lot of changes being made. If the update operation has been stuck for more than 9 hours, it is likely that there is a problem with the database or with the update itself.
There are a few ways to try to cancel or to know when the operation will finish. You can:
- Check the Cloud SQL console to see the status of the update operation. If the status is "Updating", the operation is still in progress. If the status is "Failed", the operation has failed and you will need to troubleshoot the problem.
- Use the
gcloud sql operations command to get more information about the update operation. This command will show you the status of the operation, the start time, the estimated completion time, and any errors that have occurred.
- Contact Google Cloud support for help. If the update operation is stuck and you cannot cancel it yourself, you can contact Google Cloud support for help. They may be able to restart the database or to manually cancel the update operation.
Here are some tips to help prevent UPDATE Operations from getting stuck:
- Make sure that your database is properly configured and that it has enough resources to handle the update operation.
- Break the update operation up into smaller chunks if possible. This will make it less likely that the operation will get stuck.
- Test the update operation in a staging environment before running it in production. This will help you to identify any problems before they affect your production database.
LinkedIn
Twitter
