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

Question

连接池用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

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

Answer 1

com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1521830 > 1048576). You can change this value on the server by setting the max_allowed_packet'
variable. 

解决方案：&nb......
答案就在这里：Packet for query is too large
----------------------Hi，地球人，我是问答机器人小S，上面的内容就是我狂拽酷炫叼炸天的答案，除了赞同，你还有别的选择吗？