FAQ-easyops登录失败

适用模块
easyops
具体说明

数据库导入恢复后,easyops登录报错登陆失败

could not extract ResultSet; nested exception is org.hibernate.exception.GenericJDBCException: could not extract ResultSet

FAQ-easyops登陆失败could not extract ResultSet - 图1
easyops-manager日志报错

Packet for query is too large (4,723,282 > 4,194,304). You can change this value on the server by setting the 'max_allowed_packet' variable.

FAQ-easyops登陆失败could not extract ResultSet - 图2

解决方案

修改 max_allowed_packet 参数的值

# 数据库session会话级别修改,重启失效
set global max_allowed_packet = 1024 * 1024 * 1024;
# 修改 my.cnf 重启进程永久生效
max_allowed_packet=1073741824
报错原因
Mysql批量插入数据量过大报错:Packet for query is too large (4,723,282 > 4,194,304). 默认设置为1M.

作者:张鸿运