采用redo模式同步时,增量时日志报错,导致延迟,位节点不走
-
CloudCanal版本:2.2.40
源端: oracle
对端: oracle
数据问题产生阶段:增量
问题描述:采用redo模式同步时,增量时日志报错异常信息:
java.sql.SQLRecoverableException: IO Error: Socket read interrupted
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1007)
at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1507)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1287)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2137)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2092)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:328)
at com.alibaba.druid.pool.DruidPooledStatement.execute(DruidPooledStatement.java:644)
at com.clougence.cloudcanal.oracle.logminer.LogMinerProvider.beginLogMinerAnalysis(LogMinerProvider.java:470)
at com.clougence.cloudcanal.oracle.logminer.LogMinerExtractor.initLogFile(LogMinerExtractor.java:160)
at com.clougence.cloudcanal.oracle.logminer.LogMinerExtractor.initRedoLogs(LogMinerExtractor.java:123)
at com.clougence.cloudcanal.oracle.worker.reader.incre.logminer.LoopExtractorImpl.extractorLoop(LoopExtractorImpl.java:131)
at com.clougence.cloudcanal.oracle.worker.reader.incre.logminer.OracleLogminerInstance.doExtractorWorker(OracleLogminerInstance.java:214)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Suppressed: java.sql.SQLRecoverableException: Closed Connection
at oracle.jdbc.driver.PhysicalConnection.needLine(PhysicalConnection.java:4089)
at oracle.jdbc.driver.OracleStatement.closeOrCache(OracleStatement.java:1803)
at oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:1786)
at oracle.jdbc.driver.OracleStatementWrapper.close(OracleStatementWrapper.java:147)
at com.alibaba.druid.pool.DruidPooledStatement.close(DruidPooledStatement.java:516)
at com.clougence.cloudcanal.oracle.logminer.LogMinerProvider.beginLogMinerAnalysis(LogMinerProvider.java:471)
… 7 common frames omitted
Caused by: java.io.InterruptedIOException: Socket read interrupted
at oracle.net.nt.TimeoutSocketChannel.handleInterrupt(TimeoutSocketChannel.java:549)
at oracle.net.nt.TimeoutSocketChannel.read(TimeoutSocketChannel.java:420)
at oracle.net.ns.NSProtocolNIO.doSocketRead(NSProtocolNIO.java:1119)
at oracle.net.ns.NIOPacket.readHeader(NIOPacket.java:267)
at oracle.net.ns.NIOPacket.readPacketFromSocketChannel(NIOPacket.java:199)
at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:141)
at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:114)
at oracle.net.ns.NIONSDataChannel.readDataFromSocketChannel(NIONSDataChannel.java:98)
at oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall(T4CMAREngineNIO.java:834)
at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:487)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:577)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:291)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:492)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:108)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:997)
… 14 common frames omitted -
超时了 检查下网络吧