mysql- Packet for query is too large (60 > -1).

程序员文章站 2022-05-18 19:53:10

...

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

不知道什么情况下会引起负值，请高手帮忙排查

推荐阅读

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).
com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large

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).

com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large