Packet for query is too large(1508792 > 1048576)
昨天在调试一个接口的时候,由于入参的字符串太长了,然后爆了一个问题,具体的日志如下:1234567891011121314org.springframework.dao.TransientDataAccessResourceException: \n###Error updating database. Cause: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1508792 > 1048576).You can change this value on the server by setting the max_allowed_packet' variable.\n###The error may involve com.wdzj.thirdpartzx.core.dao.OrderDetailMapper.insertSelectiveAndGetId-Inline\n###The error occurred while setting parameters\n###SQL: insert into tb_order ( owner_id, amount, status, plat_id, endpoint_id, sid, adder, add_time, request_info ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ? )\n###Cause: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1508792 > 1048576).You can change this value on the server by setting the max_allowed_packet' variable.\n; SQL [];Packet for query is too large (1508792 > 1048576).You can change this value on the server by setting the max_allowed_packet' variable.; nested exception is com.mysql.jdbc.PacketTooBigException:Packet for query is too large (1508792 > 1048576).You can change this value on the server by setting the max_allowed_packet' variable.,org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:106)看到这个日志的关键词Packet for query is too large(1508792 > 1048576),看这意思貌似是传给MySQL解析