Caused by: com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large

最近在学习爬一个网站的时候，存入爬起的信息到本地数据库中报了这么一个错·

; Packet for query is too large (7,465,380 > 4,194,304). You can change this value on the server by setting the 'max_allowed_packet' variable.; nested exception is com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large (7,465,380 > 4,194,304). You can change this value on the server by setting the 'max_allowed_packet' variable.
	at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:110)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
	at com.sun.proxy.$Proxy76.insert(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:278)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:58)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
	at com.sun.proxy.$Proxy81.insertMultiple(Unknown Source)
	at org.mybatis.dynamic.sql.util.mybatis3.MyBatis3Utils.insertMultiple(MyBatis3Utils.java:105)
	at com.java2nb.novel.mapper.BookContentMapper.insertMultiple(BookContentMapper.java:102)
	at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627)
	at org.apache.ibatis.binding.MapperProxy.invokeDefaultMethod(MapperProxy.java:84)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
	at com.sun.proxy.$Proxy81.insertMultiple(Unknown Source)
	at com.java2nb.novel.service.impl.BookServiceImpl.saveBookAndIndexAndContent(BookServiceImpl.java:92)
	at com.java2nb.novel.service.impl.BookServiceImpl$$FastClassBySpringCGLIB$$1.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:295)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
	at com.java2nb.novel.service.impl.BookServiceImpl$$EnhancerBySpringCGLIB$$1.saveBookAndIndexAndContent(<generated>)
	at com.java2nb.novel.service.impl.CrawlServiceImpl.parseBookList(CrawlServiceImpl.java:194)
	at com.java2nb.novel.service.impl.CrawlServiceImpl.lambda$openOrCloseCrawl$0(CrawlServiceImpl.java:115)
	at java.lang.Thread.run(Thread.java:748)

然后查了下有两种解决方案

一.修改my.ini 文件 ，增加一条配置，max_allowed_packet = 100M

然后重启本地MySQL服务

请注意 但是 我没有成功 本地的max_allowed_packet 仍然是原来的配置大小 400k
在本地Mysql命令行 show VARIABLES like ‘%max_allowed_packet%’;

所以hxd知道咋回事的 在评论里告诉我下。

二 .直接就是 set global max_allowed_packet = 10 * 1024 * 1024 * 10 ;

然后重新进入Mysql命令行
show VARIABLES like ‘%max_allowed_packet%’;
这个时候可以看到是已经成功更改了