alldata icon indicating copy to clipboard operation
alldata copied to clipboard

[Bug][studio]数据质量任务后端任务jdbc会失去连接,导致页面无法访问数据

Open alldatafounder opened this issue 9 months ago • 0 comments

1、正常情况: 首次启动,质量任务,质量规则,质量日志,质量报告都是正常访问 image image

2、后端日志显示:质量任务正在运行 image

3、异常情况: 过了半小时或者8小时之后,页面出现访问不了 image

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

image

alldatafounder avatar May 24 '24 10:05 alldatafounder