数据库报错Packet for query is too large (1985 > 1024).

Packet for query is too large (1985 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.

原因：超出数据库max_allowed_packet最大值

 

修改：

先查询当前数据库最大值：SHOW VARIABLES LIKE '%max_allowed_packet%';
更改最大值：SET GLOBAL max_allowed_packet = 2*1024*1024*10;

注意：修改后断开数据库连接，重启mysql，连接数据库后重启服务器，即可正常访问接口。