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

Mining session stops with DmlParserException: Failed to parse update DML

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Major
    • None
    • 1.5.0.Beta1
    • oracle-connector
    • None
    • False
    • False
    • Undefined

    Description

      During mining session I got error:

      ERROR Mining session stopped due to the {} (io.debezium.connector.oracle.logminer.LogMinerHelper:561)ERROR Mining session stopped due to the {} (io.debezium.connector.oracle.logminer.LogMinerHelper:561)io.debezium.connector.oracle.logminer.parser.DmlParserException: Failed to parse update DML: 'update "IBS"."Z#BRANCH" set "C_DATE_OP_NEXT" = TO_DATE('2021-03-02 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), "SN" = '124', "SU" = '-55' where "ID" = '27743214' and "C_CODE" = '000' and "C_SHORTLABEL" = 'П' and "C_B" = '71742' and "C_DATE_BEGIN" IS NULL and "C_DATE_END" IS NULL and "C_DIFFERENCE" = '0' and "C_MAIN_FIL" IS NULL and "C_INTERNAL" = '1' and "C_LOCAL_CODE" = 'R' and "C_READY_FOR_FINISH" IS NULL and "C_DEPO" = '0' and "C_INT_R" IS NULL and "C_ALT_B" = '277' and "C_INTERNAL_D" = '0' and "C_B_REQ" IS NULL and "C_OP_DATE" = TO_DATE('2021-03-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and "C_DATE_OP_END" IS NULL and "C_DATE_OP_NEXT" = TO_DATE('2021-03-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and "C_JOUR_OP_DAYS" = '277' and "C_FILIAL_DEPART" IS NULL and "C_METHOD2CALL" = '27743212' and "C_HOLIDAYS" IS NULL and "C_CH_DAY_BEGIN_PKG" IS NULL and "C_MIN_NAME" IS NULL and "SN" = '123' and "SU" = '-55' and "C_EOD_TIME" IS NULL and "C_JOB_INFO" = '277' and "C_CMFR" IS NULL;' at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parseUpdate(LogMinerDmlParser.java:175) at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parse(LogMinerDmlParser.java:80) at io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor.processResult(LogMinerQueryResultProcessor.java:195) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:183) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:140) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:113) 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:748)Caused by: java.lang.IndexOutOfBoundsException: Index: 17, Size: 17 at java.util.ArrayList.rangeCheck(ArrayList.java:659) at java.util.ArrayList.get(ArrayList.java:435) at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parseUpdate(LogMinerDmlParser.java:153) ... 10 more[2021-03-02 11:33:27,607] ERROR Producer failure (io.debezium.pipeline.ErrorHandler:31)io.debezium.connector.oracle.logminer.parser.DmlParserException: Failed to parse update DML: 'update "IBS"."Z#BRANCH" set "C_DATE_OP_NEXT" = TO_DATE('2021-03-02 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), "SN" = '124', "SU" = '-55' where "ID" = '27743214' and "C_CODE" = '000' and "C_SHORTLABEL" = 'П' and "C_B" = '71742' and "C_DATE_BEGIN" IS NULL and "C_DATE_END" IS NULL and "C_DIFFERENCE" = '0' and "C_MAIN_FIL" IS NULL and "C_INTERNAL" = '1' and "C_LOCAL_CODE" = 'R' and "C_READY_FOR_FINISH" IS NULL and "C_DEPO" = '0' and "C_INT_R" IS NULL and "C_ALT_B" = '277' and "C_INTERNAL_D" = '0' and "C_B_REQ" IS NULL and "C_OP_DATE" = TO_DATE('2021-03-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and "C_DATE_OP_END" IS NULL and "C_DATE_OP_NEXT" = TO_DATE('2021-03-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and "C_JOUR_OP_DAYS" = '277' and "C_FILIAL_DEPART" IS NULL and "C_METHOD2CALL" = '27743212' and "C_HOLIDAYS" IS NULL and "C_CH_DAY_BEGIN_PKG" IS NULL and "C_MIN_NAME" IS NULL and "SN" = '123' and "SU" = '-55' and "C_EOD_TIME" IS NULL and "C_JOB_INFO" = '277' and "C_CMFR" IS NULL;' at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parseUpdate(LogMinerDmlParser.java:175) at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parse(LogMinerDmlParser.java:80) at io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor.processResult(LogMinerQueryResultProcessor.java:195) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:183) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:140) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:113) 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:748)Caused by: java.lang.IndexOutOfBoundsException: Index: 17, Size: 17 at java.util.ArrayList.rangeCheck(ArrayList.java:659) at java.util.ArrayList.get(ArrayList.java:435) at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parseUpdate(LogMinerDmlParser.java:153) ... 10 more[2021-03-02 11:33:27,613] INFO startScn=838127585762, endScn=838127607762, offsetContext.getScn()=838127585762 (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:209)
      

      DDL of the table is:

      CREATE TABLE "IBS"."Z#BRANCH" 
      ("ID" NUMBER, 
      "C_CODE" VARCHAR2(3), 
      "C_SHORTLABEL" VARCHAR2(100), 
      "C_B" NUMBER, 
      "C_DATE_BEGIN" DATE, 
      "C_DATE_END" DATE, 
      "C_DIFFERENCE" NUMBER(16,0), 
      "C_MAIN_FIL" NUMBER, 
      "C_INTERNAL" VARCHAR2(1), 
      "C_LOCAL_CODE" VARCHAR2(4), 
      "C_READY_FOR_FINISH" VARCHAR2(1), 
      "C_DEPO" VARCHAR2(1), 
      "C_INT_R" VARCHAR2(1), 
      "C_ALT_B" NUMBER NOT NULL ENABLE, 
      "C_INTERNAL_D" VARCHAR2(1), 
      "C_B_REQ" NUMBER, 
      "C_OP_DATE" DATE, 
      "C_DATE_OP_END" DATE, 
      "C_DATE_OP_NEXT" DATE, 
      "C_JOUR_OP_DAYS" NUMBER NOT NULL ENABLE, 
      "C_FILIAL_DEPART" NUMBER, 
      "C_METHOD2CALL" NUMBER NOT NULL ENABLE, 
      "C_HOLIDAYS" VARCHAR2(32), 
      "C_CH_DAY_BEGIN_PKG" NUMBER, 
      "C_MIN_NAME" VARCHAR2(128), 
      "SN" NUMBER, 
      "SU" NUMBER, 
      "C_EOD_TIME" DATE, 
      "C_JOB_INFO" NUMBER NOT NULL ENABLE, 
      "C_CMFR" VARCHAR2(1), 
      SUPPLEMENTAL LOG DATA (ALL) COLUMNS
      ) SEGMENT CREATION IMMEDIATE 
      ALTER TABLE "IBS"."Z#BRANCH" ADD CONSTRAINT "PK_Z#BRANCH_ID" PRIMARY KEY ("ID")
        USING INDEX "IBS"."PK_Z#BRANCH_ID"  ENABLE
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              ant0nk Anton Kondratev (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: