oms全量导入失败

OceanBase 技术问题
#1

【 使用环境 】生产环境
【 OB or 其他组件 】
OMS
【 使用版本 】
OB 3.1.3
MySQL 5.7.2
OMS 4.2.3_CE
【问题描述】
OMS进行全量同步，库里的一张表一直失败。其它表可以正常全量同步，有一些错误日志
17
at com.oceanbase.jdbc.JDBC4PreparedStatement.executeQuery(JDBC4PreparedStatement.java:184)
18
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:227)
19
at com.oceanbase.oms.dataflow.jdbcclient.AbstractJDBCClient.sliceByMinMax(AbstractJDBCClient.java:1510)
20
at com.oceanbase.oms.dataflow.slice.PkSliceService.lambda$slice$1(PkSliceService.java:172)
21
… 6 common frames omitted
22
Caused by: com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException: Timeout
23
at com.oceanbase.jdbc.internal.util.exceptions.OceanBaseSqlException.of(OceanBaseSqlException.java:79)
24
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:206)
25
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:187)
26
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:401)
27
at com.oceanbase.jdbc.JDBC4PreparedStatement.executeInternal(JDBC4PreparedStatement.java:247)
28
… 11 common frames omitted
29
Caused by: java.sql.SQLException: Timeout
30
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:2364)
31
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:2227)
32
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:2115)
33
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:399)
34
… 12 common frames omitted
35
[2024-09-30 12:38:45.007] [ERROR] [slice-worker-2] [DataFlowSliceTask: block slice should not returned for jdbc:oceanbase://10.28.65.45:2883?useUnicode=true&characterEncoding=utf8&sendConnectionAttributes=false&allowLoadLocalInfile=false&autoDeserialize=false&allowLocalInfile=false&allowUrlInLocalInfile=false&useSSL=false&allowPublicKeyRetrieval=true-kwaishop_funds-funds@kwaishop_funds.funds_account_threshold_record, with status FAILED, last error (conn=222528) Timeout]

#3

您好，这边暂未收到进群通知，您进群了么

1 个赞
#4

哪儿有群？

1 个赞
#5

扫码入群，没有码，是空的

1 个赞
#6

分片sql执行超时失败了，找到日志中的sql， 可以使用 grep min connector.log查一下，看一下sql在源库中执行情况
可以在配置中关闭min max方式的分片,source.sliceByMinMax=false

1 个赞
#7

OceanBase 社区已接收您的帖子，正在跟进中。

#8

你好问题解决了么