GCP MySQL服务器不见了(Google SQL MySQL 2nd Gen 5.7) [英] GCP MySQL server has gone away (Google SQL MySQL 2nd Gen 5.7)

问题描述

我们正在Google Compute Engine/Debian9/PHP/Lumen/Doctrine2<-> Google SQL MySQL第二代5.7上运行.

We are running on Google Compute Engine/Debian9/PHP/Lumen/Doctrine2 <-> Google SQL MySQL 2nd Gen 5.7.

通常它不会打h，但我们现在得到的错误消息与下面的消息类似，并且频率越来越高:

Usually it works without hiccups, but we are now getting error messages, similar to the one below, with increasing frequency:

发送QUERY数据包时出错. PID = 123456

PDOStatement :: execute():MySQL服务器已消失

任何想法为什么会发生这种情况以及我将如何解决?

Any idea why this is happening and how i would fix it?

推荐答案

如所述此处中，列出了可能导致此错误的情况.一些是:

As noted here, there is a list of cases which may be causing this error. A few are:

• 您在服务器端遇到了超时，并且客户端中的自动重新连接被禁用( MYSQL结构等于0).
• 如果向服务器发送不正确或太大的查询，也会出现这些错误. 插入很多行也会导致这类错误.

• You have encountered a timeout on the server side and the automatic reconnection in the client is disabled (the reconnect flag in the MYSQL structure is equal to 0).
• You can also get these errors if you send a query to the server that is incorrect or too large...An INSERT or REPLACE statement that inserts a great many rows can also cause these sorts of errors.

. .

请参阅链接以获取完整列表.

Please refer to the link for a complete list.

此外，在相同的问题上也可以看到此答案.

Also, there see this answers on the same problem.

这篇关于GCP MySQL服务器不见了(Google SQL MySQL 2nd Gen 5.7)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！