mysql 从 5.1 升级至 5.7 之后,部分数据库的部分表,执行任何操作均报错: 2013 - Lost connection to MySQL server during query. 直接在命令行中执行
mysql> select * from AO_9412A1_AOTASK; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect...
Connection id: 2 Current database: confluence ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ERROR: Can't connect to the server
网上的解决方案比如设置
max_allowed_packet=500M;
wait_timeout = 6000
均无效
请问这个什么原因导致的,该如何解决呢,谢谢