【 使用环境 】测试环境
【 使用版本 】ob-loader-dumper-4.0.1-SNAPSHOT.zip
【问题描述】执行数据导入命令报错
【复现路径】
【错误日志】debug日志
2023-12-25 14:47:53 [ERROR] Load failed! java.lang.RuntimeException: java.sql.SQLException: ORA-00942: table or view does not exist
[10.201.69.21:2882] [2023-12-25 14:44:59.938889] [YB420AC94515-000608EE11B2480F-0-0]
at com.oceanbase.partition.calculator.template.ExecutorTemplate.waitForResult(ExecutorTemplate.java:163) ~[ob-partition-calculator-1.5.0-RELEASE.jar:?]
at com.oceanbase.tools.loaddump.loader.AbstractRecordFileLoader.shuffleByLeaderLocation(AbstractRecordFileLoader.java:801) ~[ob-loader-dumper-4.0.1-SNAPSHOT.jar:?]
at com.oceanbase.tools.loaddump.loader.AbstractRecordFileLoader.loadRecordAsync(AbstractRecordFileLoader.java:938) ~[ob-loader-dumper-4.0.1-SNAPSHOT.jar:?]
at com.oceanbase.tools.loaddump.client.LoadClient.loadRecord(LoadClient.java:198) ~[ob-loader-dumper-4.0.1-SNAPSHOT.jar:?]
at com.oceanbase.tools.loaddump.cmd.Obloader.run(Obloader.java:226) ~[ob-loader-dumper-4.0.1-SNAPSHOT.jar:?]
at com.oceanbase.tools.loaddump.cmd.Obloader.main(Obloader.java:190) ~[ob-loader-dumper-4.0.1-SNAPSHOT.jar:?]
at com.oceanbase.tools.loaddump.cmd.ObloaderDebuger.runPrevAdjustment(ObloaderDebuger.java:268) ~[ob-loader-dumper-4.0.1-SNAPSHOT.jar:?]
at com.oceanbase.tools.loaddump.cmd.ObloaderDebuger.main(ObloaderDebuger.java:124) ~[ob-loader-dumper-4.0.1-SNAPSHOT.jar:?]
Caused by: java.sql.SQLException: ORA-00942: table or view does not exist
[10.201.69.21:2882] [2023-12-25 14:44:59.938889] [YB420AC94515-000608EE11B2480F-0-0]
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:2147) ~[oceanbase-client-2.2.11.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:2012) ~[oceanbase-client-2.2.11.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1905) ~[oceanbase-client-2.2.11.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:482) ~[oceanbase-client-2.2.11.jar:?]
at com.oceanbase.jdbc.JDBC4ServerPreparedStatement.executeInternal(JDBC4ServerPreparedStatement.java:799) ~[oceanbase-client-2.2.11.jar:?]
at com.oceanbase.jdbc.JDBC4ServerPreparedStatement.execute(JDBC4ServerPreparedStatement.java:778) ~[oceanbase-client-2.2.11.jar:?]
at com.oceanbase.jdbc.JDBC4ServerPreparedStatement.executeQuery(JDBC4ServerPreparedStatement.java:740) ~[oceanbase-client-2.2.11.jar:?]
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:213) ~[druid-1.2.11.jar:1.2.11]
at com.oceanbase.partition.calculator.helper.TableEntryExtractorV4.isOneUnitWithNonRandomPrimaryZone(TableEntryExtractorV4.java:711) ~[ob-partition-calculator-1.5.0-RELEASE.jar:?]
at com.oceanbase.partition.calculator.helper.TableEntryExtractor.isOneUnitWithNonRandomPrimaryZone(TableEntryExtractor.java:513) ~[ob-partition-calculator-1.5.0-RELEASE.jar:?]
at com.oceanbase.partition.calculator.helper.TableEntryExtractor.queryLeaderLocationMap(TableEntryExtractor.java:292) ~[ob-partition-calculator-1.5.0-RELEASE.jar:?]
at com.oceanbase.tools.loaddump.loader.AbstractRecordFileLoader.lambda$shuffleByLeaderLocation$2(AbstractRecordFileLoader.java:792) ~[ob-loader-dumper-4.0.1-SNAPSHOT.jar:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_372]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_372]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_372]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_372]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_372]
at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_372]
2023-12-25 14:47:53 [INFO] Query the leader location of “OMS_HIS_INSTRUCTFLOW” finished. Remain: 0
com.oceanbase.tools.loaddump.cmd.ObloaderDebuger$PreCheckFailureException: 设置数据库系统参数失败。错误：获取系统租户的数据库连接失败。错误：(conn=3653435) Access denied for user ‘root@sys’@’...’ (using password: NO)