Cause: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (5430881 > 4194304). You can change this value on the server by setting the max_allowed_packet’ variable.
场景:插入的数据大小超过max_allowed_packet指定的值
解决:修改my.cnf中的配置来解决
注意:应该编辑/etc/my.cnf来修改,直接执行命令行会报错。
which mysql
/usr/bin/mysql --verbose --help | grep -A 1 'Default options'
# 修改my.cnf
max_allowed_packet=1024M
sudo systemctl restart mysqld