【 TiDB 使用环境`】POC
【 TiDB 版本】v5.3.0
【遇到的问题】
使用mysql的jdbc连接提示异常
tidb nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
app.4163837c.js:1 Uncaught (in promise) Error:
Error querying database. Cause: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
The last packet successfully received from the server was 8,990 milliseconds ago. The last packet sent successfully to the server was 8,996 milliseconds ago.
The error may exist in class path resource [mapper/system/SysDeptMapper.xml]
The error may involve com.ruoyi.system.mapper.SysDeptMapper.selectDeptList-Inline
The error occurred while setting parameters
SQL: select d.dept_id, d.parent_id, d.ancestors, d.dept_name, d.order_num, d.leader, d.phone, d.email, d.status, d.del_flag, d.create_by, d.create_time from sys_dept d where d.del_flag = ‘0’ order by d.parent_id, d.order_num
Cause: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
The last packet successfully received from the server was 8,990 milliseconds ago. The last packet sent successfully to the server was 8,996 milliseconds ago.
; Communications link failure
The last packet successfully received from the server was 8,990 milliseconds ago. The last packet sent successfully to the server was 8,996 milliseconds ago.; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
The last packet successfully received from the server was 8,990 milliseconds ago. The last packet sent successfully to the server was 8,996 milliseconds ago.
at app.4163837c.js:1
【复现路径】做过哪些操作出现的问题
部署应用后，后端打开web访问系统会有概率出现以上JDBC连接丢失的问题
【问题现象及影响】
无法正常使用系统
