[2022-05-24 08:35:56,891] INFO WorkerSourceTask{id=TESTJUN-0} flushing 0 outstanding messages for offset commit (org.apache.kafka.connect.runtime.WorkerSourceTask:487) [2022-05-24 08:35:58,376] ERROR Mining session stopped due to the {} (io.debezium.connector.oracle.logminer.LogMinerHelper:117) io.debezium.connector.oracle.logminer.parser.DmlParserException: DML statement couldn't be parsed. Please open a Jira issue with the statement 'insert into "TESTJUN"."TABLE_NAME"("ID","NAME","COLUMN_3") values ('35CE0F2D39B14E3EBF1FDB69ABF11C54','name',NULL);'. at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.parseDmlStatement(AbstractLogMinerEventProcessor.java:942) at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.lambda$handleDataEvent$5(AbstractLogMinerEventProcessor.java:751) at io.debezium.connector.oracle.logminer.processor.memory.MemoryLogMinerEventProcessor.addToTransaction(MemoryLogMinerEventProcessor.java:237) at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.handleDataEvent(AbstractLogMinerEventProcessor.java:750) at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.processRow(AbstractLogMinerEventProcessor.java:293) at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.processResults(AbstractLogMinerEventProcessor.java:243) at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.process(AbstractLogMinerEventProcessor.java:189) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:186) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:59) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:174) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:141) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:109) 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: io.debezium.connector.oracle.logminer.parser.DmlParserException: Failed to parse insert DML: 'insert into "TESTJUN"."TABLE_NAME"("ID","NAME","COLUMN_3") values ('35CE0F2D39B14E3EBF1FDB69ABF11C54','name',NULL);' at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parseInsert(LogMinerDmlParser.java:113) at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parse(LogMinerDmlParser.java:77) at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.parseDmlStatement(AbstractLogMinerEventProcessor.java:936) ... 16 more Caused by: java.lang.ArrayIndexOutOfBoundsException: 2 at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parseColumnListClause(LogMinerDmlParser.java:246) at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parseInsert(LogMinerDmlParser.java:104) ... 18 more [2022-05-24 08:35:58,376] ERROR Producer failure (io.debezium.pipeline.ErrorHandler:35) io.debezium.connector.oracle.logminer.parser.DmlParserException: DML statement couldn't be parsed. Please open a Jira issue with the statement 'insert into "TESTJUN"."TABLE_NAME"("ID","NAME","COLUMN_3") values ('35CE0F2D39B14E3EBF1FDB69ABF11C54','name',NULL);'. at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.parseDmlStatement(AbstractLogMinerEventProcessor.java:942) at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.lambda$handleDataEvent$5(AbstractLogMinerEventProcessor.java:751) at io.debezium.connector.oracle.logminer.processor.memory.MemoryLogMinerEventProcessor.addToTransaction(MemoryLogMinerEventProcessor.java:237) at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.handleDataEvent(AbstractLogMinerEventProcessor.java:750) at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.processRow(AbstractLogMinerEventProcessor.java:293) at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.processResults(AbstractLogMinerEventProcessor.java:243) at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.process(AbstractLogMinerEventProcessor.java:189) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:186) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:59) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:174) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:141) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:109) 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: io.debezium.connector.oracle.logminer.parser.DmlParserException: Failed to parse insert DML: 'insert into "TESTJUN"."TABLE_NAME"("ID","NAME","COLUMN_3") values ('35CE0F2D39B14E3EBF1FDB69ABF11C54','name',NULL);' at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parseInsert(LogMinerDmlParser.java:113) at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parse(LogMinerDmlParser.java:77) at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.parseDmlStatement(AbstractLogMinerEventProcessor.java:936) ... 16 more Caused by: java.lang.ArrayIndexOutOfBoundsException: 2 at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parseColumnListClause(LogMinerDmlParser.java:246) at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parseInsert(LogMinerDmlParser.java:104) ... 18 more [2022-05-24 08:35:58,376] INFO startScn=4896416, endScn=4896436 (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:202) [2022-05-24 08:35:58,391] INFO Streaming metrics dump: OracleStreamingChangeEventSourceMetrics{currentScn=4896436, oldestScn=-1, committedScn=4896428, offsetScn=4896416, logMinerQueryCount=24, totalProcessedRows=13855, totalCapturedDmlCount=2, totalDurationOfFetchingQuery=PT15.742S, lastCapturedDmlCount=0, lastDurationOfFetchingQuery=PT0.141S, maxCapturedDmlCount=2, maxDurationOfFetchingQuery=PT6.868S, totalBatchProcessingDuration=PT30.926S, lastBatchProcessingDuration=PT0.156S, maxBatchProcessingThroughput=4, currentLogFileName=[C:\WORK\DB\ORCALE12C\ORACLE\ORADATA\ORCL\REDO02.LOG], minLogFilesMined=1, maxLogFilesMined=1, redoLogStatus=[C:\WORK\DB\ORCALE12C\ORACLE\ORADATA\ORCL\REDO03.LOG | ACTIVE, C:\WORK\DB\ORCALE12C\ORACLE\ORADATA\ORCL\REDO01.LOG | ACTIVE, C:\WORK\DB\ORCALE12C\ORACLE\ORADATA\ORCL\REDO02.LOG | CURRENT], switchCounter=0, batchSize=20000, millisecondToSleepBetweenMiningQuery=3000, hoursToKeepTransaction=0, networkConnectionProblemsCounter0, batchSizeDefault=20000, batchSizeMin=1000, batchSizeMax=100000, sleepTimeDefault=1000, sleepTimeMin=0, sleepTimeMax=3000, sleepTimeIncrement=200, totalParseTime=PT0S, totalStartLogMiningSessionDuration=PT13.888S, lastStartLogMiningSessionDuration=PT0.016S, maxStartLogMiningSessionDuration=PT13.273S, totalProcessTime=PT30.926S, minBatchProcessTime=PT0.156S, maxBatchProcessTime=PT18.513S, totalResultSetNextTime=PT0.907S, lagFromTheSource=DurationPT3.376S, maxLagFromTheSourceDuration=PT26.991S, minLagFromTheSourceDuration=PT1.556S, lastCommitDuration=PT0S, maxCommitDuration=PT0.016S, activeTransactions=1, rolledBackTransactions=38, committedTransactions=6890, abandonedTransactionIds=[], rolledbackTransactionIds=[060021008d0a0000, 06001b00920a0000, 090018004a0a0000, 0a0000005d110000, 09000d004d0a0000, 01000e00ad0b0000, 04000a00d8090000, 0a00090057110000, 01001b00b30b0000, 070000000b0a0000, 07001500090a0000, 01001200b10b0000, 050017004c0a0000, 0a00180059110000, 050005004f0a0000, 09001400470a0000, 05002000520a0000, 04000200d7090000, 03000d00e7090000, 07001a000d0a0000, 04001800db090000, 06000100930a0000, 03001300da090000, 05000f005a0a0000, 08001b00bf0a0000, 0a000c005f110000, 0a0017005c110000, 050021004a0a0000, 07000f00080a0000, 01000900860b0000, 01000b00b20b0000, 01001000b40b0000, 05000800510a0000, 03000700de090000, 0a00070056110000, 090007004e0a0000, 03001c00dc090000, 0a0019005c110000], registeredDmlCount=2, committedDmlCount=2, errorCount=1, warningCount=0, scnFreezeCount=0, unparsableDdlCount=0, miningSessionUserGlobalAreaMemory=16029864, miningSessionUserGlobalAreaMaxMemory=35016480, miningSessionProcessGlobalAreaMemory=72381272, miningSessionProcessGlobalAreaMaxMemory=72381272} (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:203) [2022-05-24 08:35:58,391] INFO Offsets: OracleOffsetContext [scn=4896416, commit_scn=4895751] (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:204) [2022-05-24 08:35:58,391] INFO Finished streaming (io.debezium.pipeline.ChangeEventSourceCoordinator:175) [2022-05-24 08:35:58,391] INFO Connected metrics set to 'false' (io.debezium.pipeline.ChangeEventSourceCoordinator:234) [2022-05-24 08:35:58,751] INFO WorkerSourceTask{id=TESTJUN-0} flushing 0 outstanding messages for offset commit (org.apache.kafka.connect.runtime.WorkerSourceTask:487) [2022-05-24 08:35:58,751] ERROR WorkerSourceTask{id=TESTJUN-0} Task threw an uncaught and unrecoverable exception. Task is being killed and will not recover until manually restarted (org.apache.kafka.connect.runtime.WorkerTask:184) 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:50) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:199) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:59) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:174) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:141) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:109) 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: io.debezium.connector.oracle.logminer.parser.DmlParserException: DML statement couldn't be parsed. Please open a Jira issue with the statement 'insert into "TESTJUN"."TABLE_NAME"("ID","NAME","COLUMN_3") values ('35CE0F2D39B14E3EBF1FDB69ABF11C54','name',NULL);'. at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.parseDmlStatement(AbstractLogMinerEventProcessor.java:942) at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.lambda$handleDataEvent$5(AbstractLogMinerEventProcessor.java:751) at io.debezium.connector.oracle.logminer.processor.memory.MemoryLogMinerEventProcessor.addToTransaction(MemoryLogMinerEventProcessor.java:237) at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.handleDataEvent(AbstractLogMinerEventProcessor.java:750) at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.processRow(AbstractLogMinerEventProcessor.java:293) at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.processResults(AbstractLogMinerEventProcessor.java:243) at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.process(AbstractLogMinerEventProcessor.java:189) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:186) ... 9 more Caused by: io.debezium.connector.oracle.logminer.parser.DmlParserException: Failed to parse insert DML: 'insert into "TESTJUN"."TABLE_NAME"("ID","NAME","COLUMN_3") values ('35CE0F2D39B14E3EBF1FDB69ABF11C54','name',NULL);' at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parseInsert(LogMinerDmlParser.java:113) at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parse(LogMinerDmlParser.java:77) at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.parseDmlStatement(AbstractLogMinerEventProcessor.java:936) ... 16 more Caused by: java.lang.ArrayIndexOutOfBoundsException: 2 at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parseColumnListClause(LogMinerDmlParser.java:246) at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parseInsert(LogMinerDmlParser.java:104) ... 18 more [2022-05-24 08:35:58,751] INFO Stopping down connector (io.debezium.connector.common.BaseSourceTask:238) [2022-05-24 08:35:58,782] INFO Connection gracefully closed (io.debezium.jdbc.JdbcConnection:956) [2022-05-24 08:35:58,782] INFO [Producer clientId=orcl-dbhistory] Closing the Kafka producer with timeoutMillis = 30000 ms. (org.apache.kafka.clients.producer.KafkaProducer:1204) [