-
Bug
-
Resolution: Duplicate
-
Major
-
None
-
1.5.0.Beta1
-
None
-
False
-
False
-
Undefined
-
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
- duplicates
-
DBZ-3193 DML parser IndexOutOfRangeException with where-clause using "IS NULL"
- Closed