TIDB jdbc方式导入数据报错

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。

  • 【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 但是没有用

若提问为性能优化、故障排查类问题,请下载脚本运行。终端输出的打印结果,请务必全选并复制粘贴上传。

你好,看上面信息是被中断,可以看下 tidb.log 以及 message 信息,是否发生 oom

怎么配置tidb的内存大小

辛苦对应排查下:https://github.com/pingcap/tidb-map/blob/master/maps/diagnose-map.md#32-oom-问题