Tuesday, February 7, 2017

[google-cloud-sql-discuss] Re: SQL instances locking up due to update?

Hello Rob, 

There is no recorded outage for CloudSQL at the times you indicate.

To properly address troubleshooting of possible locking issues, you may try examining and then communicating here the output of the following commands: 

SHOW ENGINE INNODB STATUS; 
SHOW PROCESSLIST; 

For more details about debugging MySQL server problems, you may refer to the "Diagnosing Issues with Cloud SQL Instances" documentation page. Firstly, you should check the error log in the console to see why the server does not restart. Log files are located in the data directory (typically C:\Program Files\MySQL\MySQL Server 5.7\data on Windows, /usr/local/mysql/data for a Unix/Linux binary distribution. 

More details on viewing the logs on the "Viewing Information About Your Cloud SQL Instance" documentation page.

If you would like us to investigate further, you may send us your project number via private email. 

--
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/22d8fc8f-4502-4503-83d4-fa1ba9c3d492%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment