错误提示:
Unsatisfied dependency expressed through field 'jobService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sysJobServiceImpl': Invocation of init method failed; nested exception is org.quartz.JobPersistenceException: Couldn't store job: Packet for query is too large (2,128 > 1,024). You can change this value on the server by setting the 'max_allowed_packet' variable. [See nested exception: sql.ptions.PacketTooBigException: Packet for query is too large (2,128 > 1,024). You can change this value on the server by setting the 'max_allowed_packet' variable
mysql数据库中的这个这个东西小于加载数据
可以先输入语句查看:show VARIABLES like '%max_allowed_packet%'; 查询 value
解决方法:
第一种:
设置默认值为10M:set global max_allowed_packet = 5*1024*1024;
退出命令行,重启mysql服务,再进入。即可
第二种:
如果恢复默认设置:
修改my.ini 在[mysqld]段或者mysql的server配置段进行修改。(终极修改, 修改后重启数据库,永久生效)
如下: max_allowed_packet = 5M
本文发布于:2024-01-28 07:33:22,感谢您对本站的认可!
本文链接:https://www.4u4v.net/it/17063984045819.html
版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系,我们将在24小时内删除。
留言与评论(共有 0 条评论) |