Packet for query is too large (77000063 > 41943040). You can change this value on the server by setting the max_allowed_packet' variable.
这是因为单次传输的数据量超过了数据库设置的最大值
查看单次传输的最大值
SHOW VARIABLES LIKE '%max_allowed_packet%';
设置单次传输的数据量,单位是KB
SET GLOBAL max_allowed_packet=41943040
以上设置在数据库重启后会失效,最好配置到配置文件中
windows是my.ini
linux是my.conf
如下配置
max_allowed_packet=100M