Navigation

    数据用户治理组

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups

    采用redo模式同步时,增量时日志报错,导致延迟,位节点不走

    CloudCanal
    增量任务延迟 丢数据
    2
    2
    660
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • wx-ou3Ig6aWe_jf2u4xZoYoJjDCUO-w
      wx-ou3Ig6aWe_jf2u4xZoYoJjDCUO-w last edited by

      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

      1 Reply Last reply Reply Quote 0
      • KamiWan
        KamiWan last edited by

        超时了 检查下网络吧

        1 Reply Last reply Reply Quote 0
        • 1 / 1
        • First post
          Last post
        Copyright © 2020 ClouGence, Inc.备案号:浙ICP备20007605号-2