alldata
alldata copied to clipboard
[Bug][studio]数据质量任务后端任务jdbc会失去连接,导致页面无法访问数据
1、正常情况:
首次启动,质量任务,质量规则,质量日志,质量报告都是正常访问
2、后端日志显示:质量任务正在运行
3、异常情况:
过了半小时或者8小时之后,页面出现访问不了
4、异常日志:
The last packet successfully received from the server was 7,208,889 milliseconds ago. The last packet sent successfully to the server was 7,208,892 milliseconds ago.
### The error may exist in URL [jar:file:/usr/local/aoling/8g002/prod/quality/quality.jar!/BOOT-INF/classes!/mapper/CheckReportMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT temp.*, l.name AS rule_level_name from ( SELECT r.rule_source_id, r.rule_source AS rule_source_name, r.rule_level_id, COALESCE(SUM(t.check_error_count), 0) AS check_error_count FROM quality_check_rule r LEFT JOIN quality_check_report t ON t.check_rule_id = r.id and t.check_date = (select max(check_date) from quality_check_report where check_rule_id = r.id and date(check_date) = ?) GROUP BY r.rule_source_id, r.rule_source, r.rule_level_id ) temp LEFT JOIN quality_rule_level l ON l.id = temp.rule_level_id
### Cause: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
The last packet successfully received from the server was 7,208,889 milliseconds ago. The last packet sent successfully to the server was 7,208,892 milliseconds ago.
; Communications link failure
The last packet successfully received from the server was 7,208,889 milliseconds ago. The last packet sent successfully to the server was 7,208,892 milliseconds ago.; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure