【 使用环境 】生产环境
【 OB or 其他组件 】OBDUMPER
【 使用版本 】4.2.5
【问题描述】在使用dumper生成数据文件时出现报错,偶发性现象,
【复现路径】问题出现后重跑生成文件任务恢复正常
【附件及日志】推荐使用OceanBase敏捷诊断工具obdiag收集诊断信息,详情参见链接(右键跳转查看):
put_entinctax_20210228.log (31.2 KB)
2024-03-26 15:22:45 [INFO] Generate 1 dump tasks finished. Total Elapsed: 11.11 ms
2024-03-26 15:22:45 [INFO] Start 16 record dump threads for 1 dump tasks finished
2024-03-26 15:22:49 [INFO] ---------- Finished Tasks: 0 Running Tasks: 1 Progress: 0.00% ----------
2024-03-26 15:22:50 [ERROR] create connection SQLException, url: jdbc:oceanbase://10.116.87.40:2883/FMS_NCC?characterEncoding=utf8&socketTimeout=1800000&connectTimeout=180000&usePipelineAuth=false&verifyServerCertificate=false&log=true&useSSL=false&allowMultiQueries=true&rewriteBatchedStatements=true&useLocalSessionState=true&useCompression=true&noDatetimeStringSync=true&zeroDateTimeBehavior=convertToNull&emulateUnsupportedPstmts=true&useServerPrepStmts=true&log=true, errorCode 0, state 08000 java.sql.SQLNonTransientConnectionException: Could not connect to 10.116.87.40:2883 : unexpected end of stream, read 0 bytes from 4
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:122) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:235) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1644) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.util.Utils.retrieveProxy(Utils.java:1427) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.OceanBaseConnection.newConnection(OceanBaseConnection.java:306) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.Driver.connect(Driver.java:89) ~[oceanbase-client-2.4.3.jar:?]
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1691) ~[druid-1.2.18.jar:?]
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1789) ~[druid-1.2.18.jar:?]
at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2942) ~[druid-1.2.18.jar:?]
Caused by: java.sql.SQLNonTransientConnectionException: unexpected end of stream, read 0 bytes from 4
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.handleIoException(AbstractQueryProtocol.java:2559) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:2041) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1951) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.additionalData(AbstractConnectProtocol.java:1274) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.postConnectionQueries(AbstractConnectProtocol.java:986) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:626) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1639) ~[oceanbase-client-2.4.3.jar:?]
… 6 more
Caused by: java.io.EOFException: unexpected end of stream, read 0 bytes from 4
at com.oceanbase.jdbc.internal.io.input.StandardPacketInputStream.readMysqlStream(StandardPacketInputStream.java:158) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.io.input.StandardPacketInputStream.getPacketArray(StandardPacketInputStream.java:104) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.io.input.StandardPacketInputStream.getPacket(StandardPacketInputStream.java:91) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:2039) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1951) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.additionalData(AbstractConnectProtocol.java:1274) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.postConnectionQueries(AbstractConnectProtocol.java:986) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:626) ~[oceanbase-client-2.4.3.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1639) ~[oceanbase-client-2.4.3.jar:?]
… 6 more
2024-03-26 15:22:50 [INFO]
Dump Performance Monitor:
Dimension \ Metric | Tps | Throughput | Buffer
1.sec.avg | 0.0 Records/sec | 0.0 B/sec | 1 Slots
1.min.avg | 0.0 Records/sec | 0.0 B/sec | 1 Slots
Total | 0 Records | 0.0 B | 1 Slots
2024-03-26 15:22:52 [ERROR] Error: unexpected end of stream, read 0 bytes from 4
2024-03-26 15:22:52 [INFO] ---------- Finished Tasks: 1 Running Tasks: 0 Progress: 100.00% ----------
2024-03-26 15:22:52 [INFO]
All Dump Tasks Finished:
No.# | Type | Name | Count | Status
1 | TABLE | CUSTOM_SQL | 0 | FAILURE
Total Count: 0 End Time: 2024-03-26 15:22:52
2024-03-26 15:22:52 [INFO] Dump record finished. Total Elapsed: 6.282 s
2024-03-26 15:22:52 [ERROR] System exit 1