为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
- 【TiDB 版本】:v4.0.7
- 【问题描述】:java.lang.RuntimeException: com.mysql.cj.jdbc.exceptions.MySQLQueryInterruptedException: Query execution was interrupted
at com.weishao.dbswitch.data.service.MainService.doFullCoverSynchronize(MainService.java:271) ~[classes/:na]
at com.weishao.dbswitch.data.service.MainService.doDataMigration(MainService.java:174) ~[classes/:na]
at com.weishao.dbswitch.data.service.MainService.run(MainService.java:118) ~[classes/:na]
at com.weishao.dbswitch.data.DataSyncApplication.main(DataSyncApplication.java:35) ~[classes/:na]
Caused by: com.mysql.cj.jdbc.exceptions.MySQLQueryInterruptedException: Query execution was interrupted
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:126) ~[mysql-connector-java-8.0.18.jar:8.0.18]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.18.jar:8.0.18]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.18.jar:8.0.18]
at com.mysql.cj.jdbc.result.ResultSetImpl.next(ResultSetImpl.java:1739) ~[mysql-connector-java-8.0.18.jar:8.0.18]
at org.apache.commons.dbcp2.DelegatingResultSet.next(DelegatingResultSet.java:1160) ~[commons-dbcp2-2.7.0.jar:2.7.0]
at org.apache.commons.dbcp2.DelegatingResultSet.next(DelegatingResultSet.java:1160) ~[commons-dbcp2-2.7.0.jar:2.7.0]
at com.weishao.dbswitch.data.service.MainService.doFullCoverSynchronize(MainService.java:242) ~[classes/:na]
… 3 common frames omitted
在执行批量数据导入的时候报错,设置了max_execution_time 但是没有用
若提问为性能优化、故障排查类问题,请下载脚本运行。终端输出的打印结果,请务必全选并复制粘贴上传。