General error: 2013 Lost connection to MySQL server during query

第一种可能的解决方案:  有可能是你设置的读写超时!

mysql> show global variables like '%timeout%';
+----------------------------+-------+
| Variable_name              | Value |
+----------------------------+-------+
| connect_timeout            | 10    |
| delayed_insert_timeout     | 300   |
| innodb_lock_wait_timeout   | 100   |
| innodb_rollback_on_timeout | OFF   |
| interactive_timeout        | 28800 |
| net_read_timeout           | 30    |
| net_write_timeout          | 60    |
| slave_net_timeout          | 3600  |
| table_lock_wait_timeout    | 200   |
| wait_timeout               | 28800 |
+----------------------------+-------+
rows in set (0.00 sec)

mysql> set global net_read_timeout = 120;
Query OK, 0 rows affected (0.03 sec)

mysql> set global net_write_timeout = 900;
Query OK, 0 rows affected (0.00 sec)

mysql> show global variables like '%timeout%';
+----------------------------+-------+
| Variable_name              | Value |
+----------------------------+-------+
| connect_timeout            | 10    |
| delayed_insert_timeout     | 300   |
| innodb_lock_wait_timeout   | 100   |
| innodb_rollback_on_timeout | OFF   |
| interactive_timeout        | 28800 |
| net_read_timeout           | 120   |
| net_write_timeout          | 900   |
| slave_net_timeout          | 3600  |
| table_lock_wait_timeout    | 200   |
| wait_timeout               | 28800 |
+----------------------------+-------+
rows in set (0.00 sec)

第一种可能的解决方案: PDO连接MySQL预处理语句设置不对。

// PDO连接参数
    protected $params = [
        PDO::ATTR_CASE              => PDO::CASE_NATURAL,
        PDO::ATTR_ERRMODE           => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_ORACLE_NULLS      => PDO::NULL_NATURAL,
        PDO::ATTR_STRINGIFY_FETCHES => false,
        PDO::ATTR_EMULATE_PREPARES  => false,
    ];

在你的config配置文件设置PDO::ATTR_EMULATE_PREPARES  => true, 对应的固定参数设置为true

'xhb_growth'  => [
            'type'           => 'mysql',
            'hostname'       => '127.0.0.1',
            'hostport'       => 3306,
            'database'       => 'test',
            'username'       => 'user',
            'password'       => 'user',
            'charset'        => 'utf8',
            'params'         => [
                20 => true, //PDO::ATTR_EMULATE_PREPARES
            ],
        ],