☰

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 Linux(x86_64)용 Distrib 5.5.64-MariaDB, readline 5.1 사용

관련 정보