[2021-06-16 07:17:14,188] TRACE Reconciling transaction 2b000d00cefc2100 (io.debezium.connector.oracle.logminer.TransactionalBuffer:513) [2021-06-16 07:17:14,188] TRACE Transaction 2b000d00cefc2100 event queue was unmodified. (io.debezium.connector.oracle.logminer.TransactionalBuffer:545) [2021-06-16 07:17:14,188] TRACE COMMIT, transactionId=2b000d00cefc2100, SCN=11119395270489, table_name=null, segOwner=null, operationCode=7, offsetSCN=11119395252932, commitOffsetSCN=11119395263763, smallest SCN: 11119395268927 (io.debezium.connector.oracle.logminer.TransactionalBuffer:252) [2021-06-16 07:17:14,188] TRACE Updated transaction buffer max commit SCN to '11119395270489' (io.debezium.connector.oracle.logminer.TransactionalBuffer:291) [2021-06-16 07:17:14,188] TRACE COMMIT, transactionId=2b000d00cefc2100, SCN=11119395270489, table_name=null, segOwner=null, operationCode=7, offsetSCN=11119395252932, commitOffsetSCN=11119395263763 (io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor:141) [2021-06-16 07:17:14,188] TRACE scn=11119395270495, operationCode=3, operation=UPDATE, table=D_PLAN_SCHEDULE_VERSION, segOwner=ABCD_SHARD_1_3, userName=ABCD_SHARD_1_3, rowId=AAA4DgAANAACNl7AAk, rollbackFlag=0 (io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor:123) [2021-06-16 07:17:14,188] TRACE DML, transactionId=10001100fd391300, SCN=11119395270495, table_name=D_PLAN_SCHEDULE_VERSION, segOwner=ABCD_SHARD_1_3, operationCode=3, offsetSCN=11119395252932, commitOffsetSCN=11119395263763, sql update "ABCD_SHARD_1_3"."D_PLAN_SCHEDULE_VERSION" set "VERSION" = '2', "SPGZ_INNOVATION_SUM" = '0' where "ID" = '13268281' and "ENTITY_ID" = '13340568' and "CREATED_DATE" = TO_TIMESTAMP('2021-06-16 06:54:24.925000') and "DELETED_DATE" IS NULL and "PUBLICATION_DATE" IS NULL and "APPROVED_VERSION" = '1' and "ACTUAL" = '1' and "REASON_FOR_CHANGE_ID" = '0' and "GRBS_APPROVED_SENT_DATE" IS NULL and "GRBS_APPROVED_DATE" = TO_DATE('2021-06-16 06:54:24', 'YYYY-MM-DD HH24:MI:SS') and "GRBS_RESULT_OF_REVIEW_ID" = '1' and "OPERATION_ID" IS NULL and "APPROVED_DATE" IS NULL and "SIGNER_USER_ID" = '0' and "DOCX_FILE_ACCESS_CODE" IS NULL and "OOS_XML_FILE_ACCESS_CODE" IS NULL and "OOS_REF_ID" IS NULL and "OOS_USER" IS NULL and "OOS_PASSWORD" IS NULL and "VERSION" = '1' and "STATUS_ID" = '11' and "DF_REQUEST_ID" IS NULL and "DF_RESULT_OF_REVIEW_ID" IS NULL and "DF_APPROVED_DATE" IS NULL and "DF_APPROVED_SENT_DATE" IS NULL and "YEAR_SUM" = '12312313.23' and "FO_APPROVAL_RECEIVED" = '0' and "PRINT_FORM_FILE_ID" IS NULL and "EXCLUDED_PURCHASE_VOLUME" = '0' and "PLANNED_PURCHASE_VOLUME" = '0' and "AGGREGATE_ANNUAL_CONTR_VALUE" = '0' and "ANNUAL_MSP_PURCHASE_VOLUME" = '0' and "ANNUAL_ONLY_MSP_PURCHASE_VOL" = '0' and "SPGZ_INNOVATION_SUM" IS NULL and "PLANNED_ONLY_MSP_PURCHASE_VOLUME" IS NULL and "OOS_VERSION" IS NULL; (io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor:223) [2021-06-16 07:17:14,188] TRACE scn=11119395270498, operationCode=7, operation=COMMIT, table=null, segOwner=null, userName=ABCD_SHARD_1_3, rowId=AAAAAAAAAAAAAAAAAA, rollbackFlag=0 (io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor:123) [2021-06-16 07:17:14,188] TRACE Reconciling transaction 10001100fd391300 (io.debezium.connector.oracle.logminer.TransactionalBuffer:513) [2021-06-16 07:17:14,189] TRACE Processing event io.debezium.connector.oracle.logminer.TransactionalBuffer$DmlEvent@4f700529 (io.debezium.connector.oracle.logminer.TransactionalBuffer:520) [2021-06-16 07:17:14,189] TRACE Detected DmlEvent 1 (io.debezium.connector.oracle.logminer.TransactionalBuffer:669) [2021-06-16 07:17:14,189] TRACE Previous event is now io.debezium.connector.oracle.logminer.TransactionalBuffer$DmlEvent@4f700529 (io.debezium.connector.oracle.logminer.TransactionalBuffer:538) [2021-06-16 07:17:14,189] TRACE Processing event io.debezium.connector.oracle.logminer.TransactionalBuffer$DmlEvent@87c330cf (io.debezium.connector.oracle.logminer.TransactionalBuffer:520) [2021-06-16 07:17:14,189] TRACE Detected DmlEvent 1 (io.debezium.connector.oracle.logminer.TransactionalBuffer:669) [2021-06-16 07:17:14,189] TRACE DmlEvent 1 event is for different row, merge skipped. (io.debezium.connector.oracle.logminer.TransactionalBuffer:728) [2021-06-16 07:17:14,189] TRACE Previous event is now io.debezium.connector.oracle.logminer.TransactionalBuffer$DmlEvent@87c330cf (io.debezium.connector.oracle.logminer.TransactionalBuffer:538) [2021-06-16 07:17:14,189] TRACE Processing event io.debezium.connector.oracle.logminer.TransactionalBuffer$DmlEvent@4ad234a7 (io.debezium.connector.oracle.logminer.TransactionalBuffer:520) [2021-06-16 07:17:14,189] TRACE Detected DmlEvent 3 (io.debezium.connector.oracle.logminer.TransactionalBuffer:669) [2021-06-16 07:17:14,189] ERROR Mining session stopped due to the {} (io.debezium.connector.oracle.logminer.LogMinerHelper:494) io.debezium.DebeziumException: Could not find column ID in event at io.debezium.connector.oracle.logminer.TransactionalBuffer.isSameTableRow(TransactionalBuffer.java:832) at io.debezium.connector.oracle.logminer.TransactionalBuffer.shouldMergeDmlEvent(TransactionalBuffer.java:681) at io.debezium.connector.oracle.logminer.TransactionalBuffer.reconcileTransaction(TransactionalBuffer.java:530) at io.debezium.connector.oracle.logminer.TransactionalBuffer.commit(TransactionalBuffer.java:250) at io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor.processResult(LogMinerQueryResultProcessor.java:140) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:188) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:63) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:159) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:122) 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) [2021-06-16 07:17:14,189] ERROR Producer failure (io.debezium.pipeline.ErrorHandler:31) io.debezium.DebeziumException: Could not find column ID in event at io.debezium.connector.oracle.logminer.TransactionalBuffer.isSameTableRow(TransactionalBuffer.java:832) at io.debezium.connector.oracle.logminer.TransactionalBuffer.shouldMergeDmlEvent(TransactionalBuffer.java:681) at io.debezium.connector.oracle.logminer.TransactionalBuffer.reconcileTransaction(TransactionalBuffer.java:530) at io.debezium.connector.oracle.logminer.TransactionalBuffer.commit(TransactionalBuffer.java:250) at io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor.processResult(LogMinerQueryResultProcessor.java:140) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:188) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:63) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:159) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:122) 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) [2021-06-16 07:17:14,189] INFO startScn=11119395252932, endScn=11119395272932, offsetContext.getScn()=11119395252932 (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:206) [2021-06-16 07:17:14,189] INFO Transactional buffer dump: Transaction{transactionId=01001500b94d2200, firstScn=11119395268927, lastScn=11119395268927}Transaction{transactionId=080007004f651800, firstScn=11119395269101, lastScn=11119395269101} (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:207) [2021-06-16 07:17:14,189] INFO Streaming metrics dump: OracleStreamingChangeEventSourceMetrics{currentScn=11119395499219, oldestScn=11119395268927, committedScn=11119395270489, offsetScn=11119395252932, logMinerQueryCount=1, totalProcessedRows=0, totalCapturedDmlCount=0, totalDurationOfFetchingQuery=PT2.771390387S, lastCapturedDmlCount=0, lastDurationOfFetchingQuery=PT2.771390387S, maxCapturedDmlCount=0, maxDurationOfFetchingQuery=PT2.771390387S, totalBatchProcessingDuration=PT0S, lastBatchProcessingDuration=PT0S, maxBatchProcessingDuration=PT0S, maxBatchProcessingThroughput=0, currentLogFileName=null, minLogFilesMined=0, maxLogFilesMined=0, redoLogStatus=null, switchCounter=0, batchSize=21000, millisecondToSleepBetweenMiningQuery=800, recordMiningHistory=false, hoursToKeepTransaction=0, networkConnectionProblemsCounter0, batchSizeDefault=20000, batchSizeMin=1000, batchSizeMax=100000, sleepTimeDefault=1000, sleepTimeMin=0, sleepTimeMax=3000, sleepTimeIncrement=200, totalParseTime=PT0.001S, totalStartLogMiningSessionDuration=PT57.136S, lastStartLogMiningSessionDuration=PT57.136S, maxStartLogMiningSessionDuration=PT57.136S, totalProcessTime=PT0S, minBatchProcessTime=PT0S, maxBatchProcessTime=PT0S, totalResultSetNextTime=PT0S, lagFromTheSource=DurationPT22M42.362S, maxLagFromTheSourceDuration=PT22M43.36S, minLagFromTheSourceDuration=PT0S, lastCommitDuration=PT0S, maxCommitDuration=PT0.003S, activeTransactions=3, rolledBackTransactions=0, committedTransactions=2642, abandonedTransactionIds=[], rolledbackTransactionIds=[], registeredDmlCount=137, committedDmlCount=0, errorCount=1, warningCount=0, scnFreezeCount=0, unparsableDdlCount=0} (io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource:208) [2021-06-16 07:17:14,189] INFO Finished streaming (io.debezium.pipeline.ChangeEventSourceCoordinator:160) [2021-06-16 07:17:14,189] INFO Connected metrics set to 'false' (io.debezium.pipeline.metrics.StreamingChangeEventSourceMetrics:70) [2021-06-16 07:17:14,554] DEBUG checking for more records... (io.debezium.connector.base.ChangeEventQueue:238) [2021-06-16 07:17:14,554] INFO WorkerSourceTask{id=logminer_160621_v0-0} flushing 0 outstanding messages for offset commit (org.apache.kafka.connect.runtime.WorkerSourceTask:487) [2021-06-16 07:17:14,555] ERROR WorkerSourceTask{id=logminer_160621_v0-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.