一个数据报备的功能，某一天突然挂了，报了这个异常。求大神指点，很懵，第一个线上问题。刚工作几个月

[Ls_SS]

org.springframework.dao.RecoverableDataAccessException: ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 27,991 milliseconds ago. The last packet sent successfully to the server was 43,833 milliseconds ago. ### The error may exist in file [/app/appuser/tools/classes/com/tools/dao/TranMDetailReportMapper.xml] ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: SELECT id as match_detail_id, investor_apply_id , loanee_apply_id, match_amount FROM t_zp_match_detail a WHERE a.MODIFIEDON >= ? AND a.MATCH_AMOUNT_STATUS='3' AND a.PRE_INVESTOR_APPID='-1' AND a.id >? ORDER BY a.id LIMIT ?; ### Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 27,991 milliseconds ago. The last packet sent successfully to the server was 43,833 milliseconds ago. ; SQL []; Communications link failure The last packet successfully received from the server was 27,991 milliseconds ago. The last packet sent successfully to the server was 43,833 milliseconds ago.; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 27,991 milliseconds ago. The last packet sent successfully to the server was 43,833 milliseconds ago.

[rucypli]

错误信息不太明确

[Ls_SS]

引用 1 楼 rucypli 的回复:

错误信息不太明确

线上的问题，邮件里有用的信息就这么点，猜想可能是网络的原因。同时还有两个定时任务也都执行失败了。可是我这个没有手动触发

[致命的西瓜]

TranMDetailReportMapper.xml 里的 SELECT id as match_detail_id, investor_apply_id , loanee_apply_id, match_amount FROM t_zp_match_detail a WHERE a.MODIFIEDON >= ? AND a.MATCH_AMOUNT_STATUS='3' AND a.PRE_INVESTOR_APPID='-1' AND a.id >? ORDER BY a.id LIMIT ? 这段sql有问题，看看是参数没传还是数据库问题

[Ls_SS]

[quote=引用 3 楼 wangjian0228 的回复:] 只有那一天有问题，别的时间都可以跑。同时的另两个任务也失败了，猜想是数据库问题，当时情况不好查，不想在次出现这种情况，所以想贴出来让大神们看看有没有遇到过。