The last packet successfully received from the server was 27,832 milliseconds ago

问题
Caused by: org.springframework.dao.RecoverableDataAccessException: ### Error updating database. Cause: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure The last packet successfully received from the server was 27,832 milliseconds ago. The last packet sent successfully to the server was 27,885 milliseconds ago. ### The error may exist in class path resource [mapper/Batcer.xml] ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: insert into aaa ( trd, tradme, proviode, sourstem, exteo, ceme, ceype, cerum, phoame, phope, photate, phl, verore, uploat ) VALUES ( ?, ?, ?, ?, ?, ?,什么什么的

就是sql执行时间太长或者等待时间太长

改一下数据库的参数

show global variables like '%timeout%';

# 这里放大了一倍，可以根据自己的实际情况而定
set global net_read_timeout=60; 
set global net_write_timeout=120; # 等待将一个block发送给客户端的超时时间。