Wednesday, December 19, 2018

[google-cloud-sql-discuss] "SQLSTATE[HY000] [2006] MySQL server has gone away" error

Hi,

My SQL Cloud Instance had a problem for ~20 hours (13:27 GMT yesterday to 09:47 today), it randomly dropped connections with the following error, without any reason :
SQLSTATE[HY000] [2006] MySQL server has gone away

The graphs were also dead for this period :

Screenshot_20181219_111405.png



I've found these errors in the logs, occurring only at the beginning and the end of this abnormal situation :

E 2018-12-18T13:27:08.099086Z 583928 [Note] Aborted connection 583928 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
E 2018-12-18T13:27:09.334641Z 583904 [Note] Aborted connection 583904 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
E 2018-12-18T13:27:09.335742Z 24 [Note] Aborted connection 24 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
E 2018-12-18T13:27:11.526683Z 9 [Note] Aborted connection 9 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
E 2018-12-19T09:47:58.863151Z 594976 [Note] Aborted connection 594976 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
E 2018-12-19T09:47:58.864093Z 594975 [Note] Aborted connection 594975 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
E 2018-12-19T09:47:58.914624Z 594974 [Note] Aborted connection 594974 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
E 2018-12-19T09:48:06.935322Z 594973 [Note] Aborted connection 594973 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)

My project only uses the cloudsql/gce-proxy docker image to connect to the sql server.

Any idea what could have caused this situation ?

--
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/54e7390b-d864-425f-b04a-2d404b77406e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment