Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-5009

Make ORA-00600 - krvrdccs10 automatically retriable

XMLWordPrintable

      1. Environment :

      Flink version : 1.13.6
      Flink CDC version: 2.2.0
      Database and version: oracle 19.7
      Debezium version1.6.4.Final

      To Reproduce
      Steps to reproduce the behavior:

      Thes test data :
      The test code :

      DROP TABLE IF EXISTS source_Test;
      CREATE TABLE source_Test (
      TESTID INT,
      TESTCONTENT STRING,
      PRIMARY KEY (TESTID) NOT ENFORCED
      ) WITH (
      'connector' = 'oracle-cdc',
      'hostname' = '10.10.10.100',
      'port' = '1521',
      'username' = 'test',
      'password' = 'test!2324',
      'database-name' = 'testpdb',
      'schema-name' = 'test',
      'table-name' = 'testTable',
      'debezium.database.hostname' = '10.10.10.100',
      'debezium.database.port' = '1521',
      'debezium.database.server.name' = 'orclcdb',
      'debezium.database.dbname' = 'orclcdb',
      'debezium.database.pdb.name' = 'testpdb',
      'debezium.database.user' = 'c##dbzuser',
      'debezium.database.password' = 'dbz@1235',
      'debezium.log.mining.strategy' = 'online_catalog',
      'debezium.log.tasks.max' = '1'
      );
      

      The error :

      Caused by: com.ververica.cdc.connectors.shaded.org.apache.kafka.connect.errors.ConnectException: An exception occurred in the change event producer. This connector will be stopped.
          at io.debezium.pipeline.ErrorHandler.setProducerThrowable(ErrorHandler.java:42)
          at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:208)
          at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:152)
          at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:119)
          at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
          at java.util.concurrent.FutureTask.run(FutureTask.java:266)
          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:750)
      Caused by: java.sql.SQLException: ORA-00600: internal error code, arguments: [krvrdccs10], [], [], [], [], [], [], [], [], [], [], []
      
          at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
          at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
          at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
          at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)
          at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268)
          at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
          at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270)
          at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91)
          at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:807)
          at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983)
          at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
          at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666)
          at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426)
          at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3713)
          at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1167)
          at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:184)
          ... 7 more
      Caused by: Error : 600, Position : 49, Sql = SELECT SCN, SQL_REDO, OPERATION_CODE, TIMESTAMP, XID, CSF, TABLE_NAME, SEG_OWNER, OPERATION, USERNAME, ROW_ID, ROLLBACK FROM V$LOGMNR_CONTENTS WHERE SCN > :1  AND SCN <= :2  AND ((OPERATION_CODE IN (5,34) AND USERNAME NOT IN ('SYS','SYSTEM','C##LOGMINER')) OR (OPERATION_CODE IN (7,36)) OR (OPERATION_CODE IN (1,2,3) AND TABLE_NAME != 'LOG_MINING_FLUSH' AND SEG_OWNER NOT IN ('APPQOSSYS','AUDSYS','CTXSYS','DVSYS','DBSFWUSER','DBSNMP','GSMADMIN_INTERNAL','LBACSYS','MDSYS','OJVMSYS','OLAPSYS','ORDDATA','ORDSYS','OUTLN','SYS','SYSTEM','WMSYS','XDB') AND (REGEXP_LIKE(SEG_OWNER,'^test$','i')) AND (REGEXP_LIKE(SEG_OWNER || '.' || TABLE_NAME,'^test.testTable$','i')) )), OriginalSql = SELECT SCN, SQL_REDO, OPERATION_CODE, TIMESTAMP, XID, CSF, TABLE_NAME, SEG_OWNER, OPERATION, USERNAME, ROW_ID, ROLLBACK FROM V$LOGMNR_CONTENTS WHERE SCN > ? AND SCN <= ? AND ((OPERATION_CODE IN (5,34) AND USERNAME NOT IN ('SYS','SYSTEM','C##LOGMINER')) OR (OPERATION_CODE IN (7,36)) OR (OPERATION_CODE IN (1,2,3) AND TABLE_NAME != 'LOG_MINING_FLUSH' AND SEG_OWNER NOT IN ('APPQOSSYS','AUDSYS','CTXSYS','DVSYS','DBSFWUSER','DBSNMP','GSMADMIN_INTERNAL','LBACSYS','MDSYS','OJVMSYS','OLAPSYS','ORDDATA','ORDSYS','OUTLN','SYS','SYSTEM','WMSYS','XDB') AND (REGEXP_LIKE(SEG_OWNER,'^test$','i')) AND (REGEXP_LIKE(SEG_OWNER || '.' || TABLE_NAME,'^test.testTable$','i')) )), Error Msg = ORA-00600: 内部错误代码, 参数: [krvrdccs10], [], [], [], [], [], [], [], [], [], [], []
      
          at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)
          ... 22 more
      

        1. GLBUADB_ora_22873_i39538.txt
          7.57 MB
        2. error.png
          error.png
          279 kB
        3. alert_GLBUADB.7z
          1.43 MB

              ccranfor@redhat.com Chris Cranford
              hehetown hehetown wang (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

                Created:
                Updated:
                Resolved: