☰

MariaDB：错误 2006 (HY000)：MySQL 服务器已消失

tag-icon • tag-icon linux mysql mysql-connection
MariaDB：错误 2006 (HY000)：MySQL 服务器已消失

当我尝试执行查询时出现错误：

  MariaDB [suitecrm]> select *   from waiter_log;
    ERROR 2006 (HY000): MySQL server has gone away
    No connection. Trying to reconnect...

并不是每次都会出现错误：

MariaDB [suitecrm]> select count(*) from waiter_log;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    64418348
Current database: suitecrm

+----------+
| count(*) |
+----------+
|      893 |
+----------+
1 row in set (2.13 sec)

MariaDB [suitecrm]> select count(*) from waiter_log; 
+----------+
| count(*) |
+----------+
|      893 |
+----------+
1 row in set (0.00 sec)

/etc/my.cnf

max_allowed_packet = 128M
interactive_timeout=20
wait_timeout=20

Ver 15.1 Distrib 5.5.64-MariaDB，适用于 Linux (x86_64)，使用 readline 5.1

相关内容