数据库 General error: 2006 MySQL server has gone away

问题描述

把webman升级了2.1 运行了一段时间

之前 idle_timeout ，heartbeat_interval 2个值很大 确实会出现丢连接的问题

数据库 wait_timeout ：30

设置完之后
'idle_timeout' => 25,
'heartbeat_interval' => 15,
一直稳定运行

但是今天线上一台又提示服务器突然提示： General error: 2006 MySQL server has gone away

心跳也一直正常 但是丢了连接没重连

程序代码

自定义进程 ：
  getenv('APP_NAME') => [
        'handler' => process\JsonRpc::class,
        'listen'  => 'JsonNL://0.0.0.0:'.getenv('HTTP_PORT'),
        'count'   => 2, //'
    ],

数据库配置 ：
'connections' => [
            'read' => [
                'host' => 127.0.0.1,
                'port'  => 3306,
                'username'  => 'root',
                'password'  => 'j123',
            ],
            'write' => [
                'host' => 127.0.0.1,
                'port'  => 3306,
                'username'  => 'root',
                'password'  => 'j123',
            ],

            'driver'    => 'mysql',
            'database'  => test,
            'charset'   => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix'    => test,
            'strict'    => true,
            'engine'      => null,
            'options'     => [
                PDO::ATTR_EMULATE_PREPARES => false,
            ],

            'pool' => [
                'max_connections' => 5,
                'min_connections' => 1,
                'wait_timeout' => 3,
                'idle_timeout' => 25,
                'heartbeat_interval' => 15,
    ],
]

报错信息

{"code":"500","msg":"line:825|message:SQLSTATE[HY000]: General error: 2006 MySQL server has gone away (Connection: connections, SQL: select * from test limit 1)|file:/var/local/webman/60/vendor/illuminate/database/Connection.php","log_id":"3f9aaa775b79d8329fcc9109f35e2693","data":[]}}
{"@timestamp":"2026-01-20T15:07:49+08:00","log_message":"error","log_data":{"code":"500","msg":"line:2989|message:Call to a member function compileSelect() on null|file:/var/local/webman/60/vendor/illuminate/database/Query/Builder.php","log_id":"51d5a70fe270028ea10547ca0f9a62ab","data":[]}}
{"@timestamp":"2026-01-20T15:08:25+08:00","log_message":"error","log_data":{"code":"500","msg":"line:987|message:Call to a member function getBitwiseOperators() on null|file:/var/local/webman/60/vendor/illuminate/database/Query/Builder.php","log_id":"86939850dbd95e1936f8ef4d964d4a5e","data":[]}}

截图报错信息里报错文件相关代码

操作系统及workerman/webman等框架组件具体版本

这里写具体的系统环境相关信息