当前位置：首页 > news >正文

ob导出租户所有表记录

news 2025/7/23 6:58:25

导出租户下的所有表记录

[root@ob cluster]# cd /backup
[root@ob backup]# /root/ob-loader-dumper-4.3.3.1-RELEASE/bin/obdumper -h 192.168.207.18 -P 2881 -u gistar -t lnzyob -p xxxxxx --csv --all -f /backup/2/ --skip-check-dir
2025-07-22 16:20:33 [INFO] Parsed args:
[--csv] true
[--file-path] /backup/2/
[--host] 192.168.207.18
[--port] 2881
[--user] gistar
[--tenant] lnzyob
[--password] ******
[--sys-user] root
[--all] true
[--skip-check-dir] true

2025-07-22 16:26:31 [INFO] Generate 1 sub-tasks for table "SYS_ORG" succeed. Elapsed: 425.8 ms
2025-07-22 16:26:31 [INFO] TABLE "SYS_ORG" is dumping, and several objects are waiting. Remain: [387/568]
2025-07-22 16:26:31 [INFO] Query table entry for table "DES_HTTP_MESSAGE" success. Elapsed: 57.13 ms
2025-07-22 16:26:31 [INFO] Generating sub-tasks for table "DES_HTTP_MESSAGE" by partitions and primary/unique keys...
2025-07-22 16:26:32 [INFO] Generate 1 sub-tasks for table "DES_HTTP_MESSAGE" succeed. Elapsed: 456.9 ms
2025-07-22 16:26:32 [INFO] TABLE "DES_HTTP_MESSAGE" is dumping, and several objects are waiting. Remain: [386/568]
2025-07-22 16:26:32 [INFO] Query table entry for table "AN_HOMEGATEWAY_PORT" success. Elapsed: 35.12 ms
2025-07-22 16:26:32 [INFO] Generating sub-tasks for table "AN_HOMEGATEWAY_PORT" by partitions and primary/unique keys...
2025-07-22 16:26:32 [INFO] Generate 1 sub-tasks for table "AN_HOMEGATEWAY_PORT" succeed. Elapsed: 48.29 μs
2025-07-22 16:26:32 [INFO] TABLE "AN_HOMEGATEWAY_PORT" is dumping, and several objects are waiting. Remain: [385/568]
2025-07-22 16:26:32 [INFO] Query table entry for table "INT_RESCONFIRM_LOG" success. Elapsed: 32.70 ms
2025-07-22 16:26:32 [INFO] Generating sub-tasks for table "INT_RESCONFIRM_LOG" by partitions and primary/unique keys...
2025-07-22 16:26:33 [INFO] Generate 1 sub-tasks for table "INT_RESCONFIRM_LOG" succeed. Elapsed: 857.1 ms
2025-07-22 16:26:33 [INFO] TABLE "INT_RESCONFIRM_LOG" is dumping, and several objects are waiting. Remain: [384/568]
2025-07-22 16:26:33 [INFO] Query table entry for table "TP_FACTORY_CARD_TYPE" success. Elapsed: 35.86 ms
2025-07-22 16:26:33 [INFO] Generating sub-tasks for table "TP_FACTORY_CARD_TYPE" by partitions and primary/unique keys...
2025-07-22 16:26:33 [INFO] Generate 1 sub-tasks for table "TP_FACTORY_CARD_TYPE" succeed. Elapsed: 52.84 μs
2025-07-22 16:26:33 [INFO] TABLE "TP_FACTORY_CARD_TYPE" is dumping, and several objects are waiting. Remain: [383/568]
2025-07-22 16:26:33 [INFO] Query table entry for table "DA_ADSL_ODF_CONN" success. Elapsed: 46.09 ms
2025-07-22 16:26:33 [INFO] Generating sub-tasks for table "DA_ADSL_ODF_CONN" by partitions and primary/unique keys...
2025-07-22 16:26:33 [ERROR] Splitting rows for non-partitioned table: "DA_ADSL_ODF_CONN" failed.. Reason: SQLException: ORA-01000: maximum open cursors exceeded
2025-07-22 16:26:33 [ERROR] Split rows for non-partitioned table(with primary key): "DA_ADSL_ODF_CONN" failed. Reason: SQLException: ORA-01000: maximum open cursors exceeded
2025-07-22 16:26:33 [ERROR] Query DDL for table: "CABLE_BOX_BLOCK" failed. Reason: SQLTransientConnectionException: (conn=3221560549) ORA-01000: maximum open cursors exceeded
2025-07-22 16:26:33 [WARN] Failed to query table entry. Reason: (conn=3221560549) ORA-01000: maximum open cursors exceeded
2025-07-22 16:26:33 [INFO] Query partitions for table: "CABLE_BOX_BLOCK" with sys account...
2025-07-22 16:26:33 [ERROR] Failed to dump. java.util.concurrent.ExecutionException: java.sql.SQLTransientConnectionException: (conn=3221560549) ORA-01000: maximum open cursors exceededat java.util.concurrent.FutureTask.report(FutureTask.java:122) ~[?:1.8.0_221]at java.util.concurrent.FutureTask.get(FutureTask.java:192) ~[?:1.8.0_221]at com.oceanbase.tools.loaddump.dumper.AbstractDumper.doDumpAsync(AbstractDumper.java:300) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at com.oceanbase.tools.loaddump.dumper.AbstractDumper.dumpRecordAsync(AbstractDumper.java:148) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at com.oceanbase.tools.loaddump.client.DumpClient.dumpRecord(DumpClient.java:114) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at com.oceanbase.tools.loaddump.cmd.Obdumper.run(Obdumper.java:303) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at com.oceanbase.tools.loaddump.cmd.Obdumper.main(Obdumper.java:255) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]
Caused by: java.sql.SQLTransientConnectionException: (conn=3221560549) ORA-01000: maximum open cursors exceededat com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:128) ~[oceanbase-client-2.4.11.jar:?]at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:202) ~[oceanbase-client-2.4.11.jar:?]at com.oceanbase.jdbc.JDBC4ServerPreparedStatement.prepare(JDBC4ServerPreparedStatement.java:311) ~[oceanbase-client-2.4.11.jar:?]at com.oceanbase.jdbc.JDBC4ServerPreparedStatement.<init>(JDBC4ServerPreparedStatement.java:163) ~[oceanbase-client-2.4.11.jar:?]at com.oceanbase.jdbc.ServerSidePreparedStatement.<init>(ServerSidePreparedStatement.java:78) ~[oceanbase-client-2.4.11.jar:?]at com.oceanbase.jdbc.OceanBaseConnection.internalPrepareStatement(OceanBaseConnection.java:799) ~[oceanbase-client-2.4.11.jar:?]at com.oceanbase.jdbc.OceanBaseConnection.prepareStatement(OceanBaseConnection.java:561) ~[oceanbase-client-2.4.11.jar:?]at com.alibaba.druid.pool.DruidStatementConnection.prepareStatement(DruidStatementConnection.java:171) ~[druid-1.2.22.jar:?]at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:592) ~[druid-1.2.22.jar:?]at com.alibaba.druid.filter.FilterAdapter.connection_prepareStatement(FilterAdapter.java:921) ~[druid-1.2.22.jar:?]at com.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:137) ~[druid-1.2.22.jar:?]at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:587) ~[druid-1.2.22.jar:?]at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.prepareStatement(ConnectionProxyImpl.java:361) ~[druid-1.2.22.jar:?]at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:407) ~[druid-1.2.22.jar:?]at com.oceanbase.tools.loaddump.dumper.task.generator.RecordDumpTaskGenerator.queryBounds(RecordDumpTaskGenerator.java:196) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at com.oceanbase.tools.loaddump.dumper.task.generator.RecordDumpTaskGenerator.splitTableRows(RecordDumpTaskGenerator.java:136) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at com.oceanbase.tools.loaddump.dumper.task.generator.RecordDumpTaskGenerator.doGenerateDumpTasks(RecordDumpTaskGenerator.java:81) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at com.oceanbase.tools.loaddump.dumper.task.generator.AbstractSqlParserBasedRecordDumpTaskGenerator.generateDumpTasks(AbstractSqlParserBasedRecordDumpTaskGenerator.java:117) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at com.oceanbase.tools.loaddump.dumper.task.generator.RecordDumpTaskGenerator.generateDumpTasks(RecordDumpTaskGenerator.java:58) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at com.oceanbase.tools.loaddump.dumper.AbstractDumper.lambda$doDumpAsync$1(AbstractDumper.java:282) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_221]at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_221]at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_221]at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_221]
Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceededat com.oceanbase.jdbc.internal.com.send.ComStmtPrepare.buildErrorException(ComStmtPrepare.java:181) ~[oceanbase-client-2.4.11.jar:?]at com.oceanbase.jdbc.internal.com.send.ComStmtPrepare.read(ComStmtPrepare.java:99) ~[oceanbase-client-2.4.11.jar:?]at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.prepare(AbstractQueryProtocol.java:280) ~[oceanbase-client-2.4.11.jar:?]at com.oceanbase.jdbc.JDBC4ServerPreparedStatement.prepare(JDBC4ServerPreparedStatement.java:295) ~[oceanbase-client-2.4.11.jar:?]at com.oceanbase.jdbc.JDBC4ServerPreparedStatement.<init>(JDBC4ServerPreparedStatement.java:163) ~[oceanbase-client-2.4.11.jar:?]at com.oceanbase.jdbc.ServerSidePreparedStatement.<init>(ServerSidePreparedStatement.java:78) ~[oceanbase-client-2.4.11.jar:?]at com.oceanbase.jdbc.OceanBaseConnection.internalPrepareStatement(OceanBaseConnection.java:799) ~[oceanbase-client-2.4.11.jar:?]at com.oceanbase.jdbc.OceanBaseConnection.prepareStatement(OceanBaseConnection.java:561) ~[oceanbase-client-2.4.11.jar:?]at com.alibaba.druid.pool.DruidStatementConnection.prepareStatement(DruidStatementConnection.java:171) ~[druid-1.2.22.jar:?]at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:592) ~[druid-1.2.22.jar:?]at com.alibaba.druid.filter.FilterAdapter.connection_prepareStatement(FilterAdapter.java:921) ~[druid-1.2.22.jar:?]at com.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:137) ~[druid-1.2.22.jar:?]at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:587) ~[druid-1.2.22.jar:?]at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.prepareStatement(ConnectionProxyImpl.java:361) ~[druid-1.2.22.jar:?]at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:407) ~[druid-1.2.22.jar:?]at com.oceanbase.tools.loaddump.dumper.task.generator.RecordDumpTaskGenerator.queryBounds(RecordDumpTaskGenerator.java:196) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at com.oceanbase.tools.loaddump.dumper.task.generator.RecordDumpTaskGenerator.splitTableRows(RecordDumpTaskGenerator.java:136) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at com.oceanbase.tools.loaddump.dumper.task.generator.RecordDumpTaskGenerator.doGenerateDumpTasks(RecordDumpTaskGenerator.java:81) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at com.oceanbase.tools.loaddump.dumper.task.generator.AbstractSqlParserBasedRecordDumpTaskGenerator.generateDumpTasks(AbstractSqlParserBasedRecordDumpTaskGenerator.java:117) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at com.oceanbase.tools.loaddump.dumper.task.generator.RecordDumpTaskGenerator.generateDumpTasks(RecordDumpTaskGenerator.java:58) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at com.oceanbase.tools.loaddump.dumper.AbstractDumper.lambda$doDumpAsync$1(AbstractDumper.java:282) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_221]at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_221]at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_221]at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_221]2025-07-22 16:26:33 [ERROR] Merge table 'ZTWG_CIRCUIT' dumped files failed. java.lang.InterruptedException: nullat java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(AbstractQueuedSynchronizer.java:2014) ~[?:1.8.0_221]at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2048) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.takeFirst(LinkedBlockingDeque.java:492) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.take(LinkedBlockingDeque.java:680) ~[?:1.8.0_221]at com.oceanbase.tools.loaddump.dumper.task.record.FileMergeTask.run(FileMergeTask.java:106) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_221]at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_221]at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_221]2025-07-22 16:26:33 [ERROR] Merge table 'DA_DDN_SDH_CONN' dumped files failed. java.lang.InterruptedException: nullat java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(AbstractQueuedSynchronizer.java:2014) ~[?:1.8.0_221]at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2048) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.takeFirst(LinkedBlockingDeque.java:492) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.take(LinkedBlockingDeque.java:680) ~[?:1.8.0_221]at com.oceanbase.tools.loaddump.dumper.task.record.FileMergeTask.run(FileMergeTask.java:106) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_221]at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_221]at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_221]2025-07-22 16:26:33 [ERROR] Merge table 'XL_WAITHISTORY' dumped files failed. java.lang.InterruptedException: nullat java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(AbstractQueuedSynchronizer.java:2014) ~[?:1.8.0_221]at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2048) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.takeFirst(LinkedBlockingDeque.java:492) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.take(LinkedBlockingDeque.java:680) ~[?:1.8.0_221]at com.oceanbase.tools.loaddump.dumper.task.record.FileMergeTask.run(FileMergeTask.java:106) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_221]at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_221]at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_221]2025-07-22 16:26:33 [ERROR] Merge table 'DES_HTTP_MESSAGE' dumped files failed. java.lang.InterruptedException: nullat java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(AbstractQueuedSynchronizer.java:2014) ~[?:1.8.0_221]at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2048) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.takeFirst(LinkedBlockingDeque.java:492) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.take(LinkedBlockingDeque.java:680) ~[?:1.8.0_221]at com.oceanbase.tools.loaddump.dumper.task.record.FileMergeTask.run(FileMergeTask.java:106) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_221]at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_221]at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_221]2025-07-22 16:26:33 [ERROR] Merge table 'TP_FACTORY_CARD_TYPE' dumped files failed. java.lang.InterruptedException: nullat java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(AbstractQueuedSynchronizer.java:2014) ~[?:1.8.0_221]at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2048) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.takeFirst(LinkedBlockingDeque.java:492) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.take(LinkedBlockingDeque.java:680) ~[?:1.8.0_221]at com.oceanbase.tools.loaddump.dumper.task.record.FileMergeTask.run(FileMergeTask.java:106) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_221]at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_221]at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_221]2025-07-22 16:26:33 [ERROR] Merge table 'SHAPETABLE' dumped files failed. java.lang.InterruptedException: nullat java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(AbstractQueuedSynchronizer.java:2014) ~[?:1.8.0_221]at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2048) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.takeFirst(LinkedBlockingDeque.java:492) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.take(LinkedBlockingDeque.java:680) ~[?:1.8.0_221]at com.oceanbase.tools.loaddump.dumper.task.record.FileMergeTask.run(FileMergeTask.java:106) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_221]at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_221]at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_221]2025-07-22 16:26:33 [ERROR] Merge table 'AN_HOMEGATEWAY_PORT' dumped files failed. java.lang.InterruptedException: nullat java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(AbstractQueuedSynchronizer.java:2014) ~[?:1.8.0_221]at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2048) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.takeFirst(LinkedBlockingDeque.java:492) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.take(LinkedBlockingDeque.java:680) ~[?:1.8.0_221]at com.oceanbase.tools.loaddump.dumper.task.record.FileMergeTask.run(FileMergeTask.java:106) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_221]at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_221]at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_221]2025-07-22 16:26:33 [ERROR] Merge table 'DES_RECONFIG_INFO' dumped files failed. java.lang.InterruptedException: nullat java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(AbstractQueuedSynchronizer.java:2014) ~[?:1.8.0_221]at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2048) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.takeFirst(LinkedBlockingDeque.java:492) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.take(LinkedBlockingDeque.java:680) ~[?:1.8.0_221]at com.oceanbase.tools.loaddump.dumper.task.record.FileMergeTask.run(FileMergeTask.java:106) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_221]at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_221]at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_221]2025-07-22 16:26:33 [ERROR] Merge table 'INSTANCELOG' dumped files failed. java.lang.InterruptedException: nullat java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(AbstractQueuedSynchronizer.java:2014) ~[?:1.8.0_221]at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2048) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.takeFirst(LinkedBlockingDeque.java:492) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.take(LinkedBlockingDeque.java:680) ~[?:1.8.0_221]at com.oceanbase.tools.loaddump.dumper.task.record.FileMergeTask.run(FileMergeTask.java:106) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_221]at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_221]at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_221]2025-07-22 16:26:33 [ERROR] Merge table 'DA_BRAS_ODF_CONN' dumped files failed. java.lang.InterruptedException: nullat java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(AbstractQueuedSynchronizer.java:2014) ~[?:1.8.0_221]at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2048) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.takeFirst(LinkedBlockingDeque.java:492) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.take(LinkedBlockingDeque.java:680) ~[?:1.8.0_221]at com.oceanbase.tools.loaddump.dumper.task.record.FileMergeTask.run(FileMergeTask.java:106) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_221]at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_221]at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_221]2025-07-22 16:26:33 [ERROR] Merge table 'THIRD_ONU_SUPPORT200M' dumped files failed. java.lang.InterruptedException: nullat java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(AbstractQueuedSynchronizer.java:2014) ~[?:1.8.0_221]at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2048) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.takeFirst(LinkedBlockingDeque.java:492) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.take(LinkedBlockingDeque.java:680) ~[?:1.8.0_221]at com.oceanbase.tools.loaddump.dumper.task.record.FileMergeTask.run(FileMergeTask.java:106) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_221]at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_221]at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_221]2025-07-22 16:26:33 [ERROR] Merge table 'FACTORY' dumped files failed. java.lang.InterruptedException: nullat java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(AbstractQueuedSynchronizer.java:2014) ~[?:1.8.0_221]at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2048) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.takeFirst(LinkedBlockingDeque.java:492) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.take(LinkedBlockingDeque.java:680) ~[?:1.8.0_221]at com.oceanbase.tools.loaddump.dumper.task.record.FileMergeTask.run(FileMergeTask.java:106) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_221]at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_221]at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_221]2025-07-22 16:26:33 [ERROR] Merge table 'DA_ADSL_PORT' dumped files failed. java.lang.InterruptedException: nullat java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(AbstractQueuedSynchronizer.java:2014) ~[?:1.8.0_221]at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2048) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.takeFirst(LinkedBlockingDeque.java:492) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.take(LinkedBlockingDeque.java:680) ~[?:1.8.0_221]at com.oceanbase.tools.loaddump.dumper.task.record.FileMergeTask.run(FileMergeTask.java:106) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_221]at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_221]at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_221]2025-07-22 16:26:33 [ERROR] Merge table 'SYS_ORG' dumped files failed. java.lang.InterruptedException: nullat java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(AbstractQueuedSynchronizer.java:2014) ~[?:1.8.0_221]at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2048) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.takeFirst(LinkedBlockingDeque.java:492) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.take(LinkedBlockingDeque.java:680) ~[?:1.8.0_221]at com.oceanbase.tools.loaddump.dumper.task.record.FileMergeTask.run(FileMergeTask.java:106) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_221]at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_221]at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_221]2025-07-22 16:26:33 [ERROR] Merge table 'AN_OLT_CUTOVER_OLTLIST' dumped files failed. java.lang.InterruptedException: nullat java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(AbstractQueuedSynchronizer.java:2014) ~[?:1.8.0_221]at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2048) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.takeFirst(LinkedBlockingDeque.java:492) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.take(LinkedBlockingDeque.java:680) ~[?:1.8.0_221]at com.oceanbase.tools.loaddump.dumper.task.record.FileMergeTask.run(FileMergeTask.java:106) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_221]at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_221]at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_221]2025-07-22 16:26:33 [ERROR] Merge table 'DA_CIR_ADSL_IPADDR_LN' dumped files failed. java.lang.InterruptedException: nullat java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(AbstractQueuedSynchronizer.java:2014) ~[?:1.8.0_221]at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2048) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.takeFirst(LinkedBlockingDeque.java:492) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.take(LinkedBlockingDeque.java:680) ~[?:1.8.0_221]at com.oceanbase.tools.loaddump.dumper.task.record.FileMergeTask.run(FileMergeTask.java:106) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_221]at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_221]at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_221]2025-07-22 16:26:33 [ERROR] Merge table 'WORKFLOWCONFIG' dumped files failed. java.lang.InterruptedException: nullat java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(AbstractQueuedSynchronizer.java:2014) ~[?:1.8.0_221]at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2048) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.takeFirst(LinkedBlockingDeque.java:492) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.take(LinkedBlockingDeque.java:680) ~[?:1.8.0_221]at com.oceanbase.tools.loaddump.dumper.task.record.FileMergeTask.run(FileMergeTask.java:106) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_221]at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_221]at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_221]2025-07-22 16:26:33 [ERROR] Merge table 'AN_ONU_SUBRACK' dumped files failed. java.lang.InterruptedException: nullat java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(AbstractQueuedSynchronizer.java:2014) ~[?:1.8.0_221]at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2048) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.takeFirst(LinkedBlockingDeque.java:492) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.take(LinkedBlockingDeque.java:680) ~[?:1.8.0_221]at com.oceanbase.tools.loaddump.dumper.task.record.FileMergeTask.run(FileMergeTask.java:106) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_221]at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_221]at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_221]2025-07-22 16:26:33 [ERROR] Merge table 'TEL_NBR_BROADBAND' dumped files failed. java.lang.InterruptedException: nullat java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(AbstractQueuedSynchronizer.java:2014) ~[?:1.8.0_221]at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2048) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.takeFirst(LinkedBlockingDeque.java:492) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.take(LinkedBlockingDeque.java:680) ~[?:1.8.0_221]at com.oceanbase.tools.loaddump.dumper.task.record.FileMergeTask.run(FileMergeTask.java:106) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_221]at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_221]at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_221]2025-07-22 16:26:33 [ERROR] Merge table 'DA_IP_PDH_CONN' dumped files failed. java.lang.InterruptedException: nullat java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(AbstractQueuedSynchronizer.java:2014) ~[?:1.8.0_221]at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2048) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.takeFirst(LinkedBlockingDeque.java:492) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.take(LinkedBlockingDeque.java:680) ~[?:1.8.0_221]at com.oceanbase.tools.loaddump.dumper.task.record.FileMergeTask.run(FileMergeTask.java:106) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_221]at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_221]at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_221]2025-07-22 16:26:33 [ERROR] Merge table 'PHONETYPE_VS_GRADE' dumped files failed. java.lang.InterruptedException: nullat java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(AbstractQueuedSynchronizer.java:2014) ~[?:1.8.0_221]at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2048) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.takeFirst(LinkedBlockingDeque.java:492) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.take(LinkedBlockingDeque.java:680) ~[?:1.8.0_221]at com.oceanbase.tools.loaddump.dumper.task.record.FileMergeTask.run(FileMergeTask.java:106) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_221]at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_221]at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_221]2025-07-22 16:26:33 [ERROR] Merge table 'INT_RESCONFIRM_LOG' dumped files failed. java.lang.InterruptedException: nullat java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(AbstractQueuedSynchronizer.java:2014) ~[?:1.8.0_221]at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2048) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.takeFirst(LinkedBlockingDeque.java:492) ~[?:1.8.0_221]at java.util.concurrent.LinkedBlockingDeque.take(LinkedBlockingDeque.java:680) ~[?:1.8.0_221]at com.oceanbase.tools.loaddump.dumper.task.record.FileMergeTask.run(FileMergeTask.java:106) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_221]at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_221]at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_221]2025-07-22 16:26:33 [INFO] Dump data to "/backup/2/data/GISTAR/TABLE/TEL_NBR_BROADBAND.0.csv" finished.
2025-07-22 16:26:33 [WARN] Query table entry failed. Reason: SQLException: Query table partition failure. table: CABLE_BOX_BLOCK
2025-07-22 16:26:33 [ERROR] Query partition level for table: "CABLE_BOX_BLOCK" failed. Reason: (conn=3221560549) ORA-01000: maximum open cursors exceeded
2025-07-22 16:26:33 [ERROR] Query partition names for partitioned table:" CABLE_BOX_BLOCK" failed. (No sys). Reason: java.sql.SQLTransientConnectionException: (conn=3221560549) ORA-01000: maximum open cursors exceeded
2025-07-22 16:26:33 [ERROR] Dump failed! Error: ORA-01000: maximum open cursors exceeded
2025-07-22 16:26:33 [ERROR] System exit 1
[root@ob backup]#

处理办法：

obclient(GISTAR@lnzyob)[GISTAR]> show parameters like '%cursor%';
+-------+----------+----------------+----------+--------------+-----------+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+--------+---------+-------------------+---------------+-----------+
| ZONE | SVR_TYPE | SVR_IP | SVR_PORT | NAME | DATA_TYPE | VALUE | INFO | SECTION | SCOPE | SOURCE | EDIT_LEVEL | DEFAULT_VALUE | ISDEFAULT |
+-------+----------+----------------+----------+--------------+-----------+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+--------+---------+-------------------+---------------+-----------+
| zone1 | observer | 192.168.207.18 | 2882 | open_cursors | NULL | 50 | specifies the maximum number of open cursors a session can have at once.can use this parameter to prevent a session from opening an excessive number of cursors.Range: [0, 65535] in integer | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 50 | 1 |
+-------+----------+----------------+----------+--------------+-----------+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+--------+---------+-------------------+---------------+-----------+
1 row in set (0.085 sec)

obclient(GISTAR@lnzyob)[GISTAR]> alter system set open_cursors=5000;
Query OK, 0 rows affected (0.161 sec)

obclient(GISTAR@lnzyob)[GISTAR]> show parameters like '%cursor%';
+-------+----------+----------------+----------+--------------+-----------+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+--------+---------+-------------------+---------------+-----------+
| ZONE | SVR_TYPE | SVR_IP | SVR_PORT | NAME | DATA_TYPE | VALUE | INFO | SECTION | SCOPE | SOURCE | EDIT_LEVEL | DEFAULT_VALUE | ISDEFAULT |
+-------+----------+----------------+----------+--------------+-----------+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+--------+---------+-------------------+---------------+-----------+
| zone1 | observer | 192.168.207.18 | 2882 | open_cursors | NULL | 5000 | specifies the maximum number of open cursors a session can have at once.can use this parameter to prevent a session from opening an excessive number of cursors.Range: [0, 65535] in integer | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 50 | 0 |
+-------+----------+----------------+----------+--------------+-----------+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+--------+---------+-------------------+---------------+-----------+
1 row in set (0.009 sec)

obdumper导数报错： Error: maximum open cursors exceeded - #3，来自皇甫侯 - OceanBase 技术问题 - 社区问答- OceanBase社区-分布式数据库

2025-07-22 16:25:51 [ERROR] Dump GISTAR.AN_V5ID failed. java.lang.IllegalStateException: java.sql.SQLTransientConnectionException: ORA-00600: internal error code, arguments: -4012, Timeout, query has reached the maximum query timeout: 300000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again.at com.oceanbase.tools.loaddump.dumper.task.record.RecordDumpTask.executeUnsync(RecordDumpTask.java:327) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at com.oceanbase.tools.loaddump.dumper.task.record.RecordDumpTask.run(RecordDumpTask.java:182) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_221]at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_221]at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_221]at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_221]
Caused by: java.sql.SQLTransientConnectionException: ORA-00600: internal error code, arguments: -4012, Timeout, query has reached the maximum query timeout: 300000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again.at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:128) ~[oceanbase-client-2.4.11.jar:?]at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:230) ~[oceanbase-client-2.4.11.jar:?]at com.oceanbase.jdbc.JDBC4ResultSet.getNextRow(JDBC4ResultSet.java:619) ~[oceanbase-client-2.4.11.jar:?]at com.oceanbase.jdbc.JDBC4ResultSet.addStreamingValue(JDBC4ResultSet.java:577) ~[oceanbase-client-2.4.11.jar:?]at com.oceanbase.jdbc.JDBC4ResultSet.nextStreamingValue(JDBC4ResultSet.java:561) ~[oceanbase-client-2.4.11.jar:?]at com.oceanbase.jdbc.JDBC4ResultSet.next(JDBC4ResultSet.java:1151) ~[oceanbase-client-2.4.11.jar:?]at com.oceanbase.tools.loaddump.dumper.task.record.RecordDumpTask.executeUnsync(RecordDumpTask.java:275) ~[ob-loader-dumper-4.3.3.1-RELEASE.jar:?]... 6 more

处理办法：

修改租户参数是无效的，需要修改工具conf里的json参数：

obclient(GISTAR@lnzyob)[GISTAR]> show variables like '%timeout%';
+---------------------+------------------+
| VARIABLE_NAME | VALUE |
+---------------------+------------------+
| connect_timeout | 10 |
| interactive_timeout | 28800 |
| net_read_timeout | 30 |
| net_write_timeout | 60 |
| ob_pl_block_timeout | 3216672000000000 |
| ob_query_timeout | 10000000000 |
| ob_trx_idle_timeout | 86400000000 |
| ob_trx_lock_timeout | -1 |
| ob_trx_timeout | 86400000000 |
| wait_timeout | 28800 |
+---------------------+------------------+
10 rows in set (0.001 sec)
obclient(GISTAR@lnzyob)[GISTAR]> SET ob_query_timeout = 20000000000;
Query OK, 0 rows affected (0.001 sec)

obclient(GISTAR@lnzyob)[GISTAR]> SET GLOBAL ob_query_timeout = 20000000000;
Query OK, 0 rows affected (0.067 sec)

obclient(GISTAR@lnzyob)[GISTAR]> show variables like '%timeout%';
+---------------------+------------------+
| VARIABLE_NAME | VALUE |
+---------------------+------------------+
| connect_timeout | 10 |
| interactive_timeout | 28800 |
| net_read_timeout | 30 |
| net_write_timeout | 60 |
| ob_pl_block_timeout | 3216672000000000 |
| ob_query_timeout | 20000000000 |
| ob_trx_idle_timeout | 86400000000 |
| ob_trx_lock_timeout | -1 |
| ob_trx_timeout | 86400000000 |
| wait_timeout | 28800 |
+---------------------+------------------+
10 rows in set (0.001 sec)

obclient(GISTAR@lnzyob)[GISTAR]>

obclient(GISTAR@lnzyob)[GISTAR]> set connect_timeout = 3600;
ORA-00600: internal error code, arguments: -5101, Variable 'connect_timeout' is a GLOBAL variable and should be set with SET GLOBAL

obclient(GISTAR@lnzyob)[GISTAR]> set global connect_timeout = 3600;
Query OK, 0 rows affected (0.054 sec)
obclient(GISTAR@lnzyob)[GISTAR]> set net_read_timeout =3000;
Query OK, 0 rows affected (0.001 sec)

obclient(GISTAR@lnzyob)[GISTAR]> show variables like '%timeout%';
+---------------------+------------------+
| VARIABLE_NAME | VALUE |
+---------------------+------------------+
| connect_timeout | 3600 |
| interactive_timeout | 28800 |
| net_read_timeout | 3000 |
| net_write_timeout | 60 |
| ob_pl_block_timeout | 3216672000000000 |
| ob_query_timeout | 60000000000 |
| ob_trx_idle_timeout | 86400000000 |
| ob_trx_lock_timeout | -1 |
| ob_trx_timeout | 86400000000 |
| wait_timeout | 28800 |
+---------------------+------------------+
10 rows in set (0.001 sec)