mysql- Packet for query is too large (60 > -1).
程序员文章站
2024-01-18 18:36:04
...
mysqlamoebatomcat
连接池用tomcat jdbc ,数据库为mariadb10
中间经过amoeba代理读写分离
偶尔会报这个错
Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (60 > -1). You can change this value on the server by setting the max_allowed_packet' variable.
mariadb SHOW VARIABLES LIKE 'max_allowed_packet';返回结果为
max_allowed_packet 67108864
不知道什么情况下会引起负值,请高手帮忙排查
上一篇: 上周热点回顾(4.1-4.7)
推荐阅读
-
mysql- Packet for query is too large (60 > -1).
-
com.mysql.jdbc.PacketTooBigException: Packet for query is too large 异常解决办法
-
使用mybatis generator 出现Packet for query is too large (5,150 > 1,024)错误[ubuntu系统]
-
MySQL Packet for query is too large 问题及解决方法
-
mysql: Packet for query is too large 和Data too long for column
-
mysql: Packet for query is too large 和Data too long for column
-
mysql: Packet for query is too large 和Data too long for column
-
mysql: Packet for query is too large 和Data too long for column
-
Packet for query is too large (1986748 > 1048576). Yo_MySQL
-
mysql- Packet for query is too large (60 > -1).