php - Symfony 3.4 出现错误“2006 MySQL 服务器已消失”

Question

有时当用户访问应用程序时......在该应用程序正常工作一段时间后会引发异常，如果一段时间内没有活动，我会再次遇到该异常。

Uncaught PHP Exception Doctrine\DBAL\Driver\PDOException: "SQLSTATE[HY000]: General error: 2006 MySQL server has gone away" at /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php line 107 {"exception":"[object] (Doctrine\\DBAL\\Driver\\PDOException(code: HY000): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: HY000): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at /vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"} []

我的 PHP 版本是 5.6

mysql版本是5.6

我用谷歌搜索了一些答案，但对我没有任何帮助。

调试结果 SHOW STATUS WHERE变量名= 'Threads_connected'

SHOW STATUS WHERE variable_name LIKE "Threads_%" OR variable_name = "Connections"

Mysql max number of connection = 100
session wait_timeout = 328800
global wait_timeout = 328800

标签： phpmysqlsymfonydoctrine-orm