现象
报表系统会查询大量数据,执行结果超过10s是属于正常的场景,但是现在会10秒报错
异常信息如下
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failuretestWhileIdle
The last packet successfully received from the server was 10,014 milliseconds ago. The last packet sent successfully to the server was 10,056 milliseconds ago.
解决
ds的yml增加了配置项
配置连接超时时间
connectTimeout: 30000
配置网络超时时间
socketTimeout: 60000