2024-11-26 03:09:42,804 INFO || [task-thread-relation_cdc_server_1860922765189140481_1860922728858079233-0hread] Metrics reporters closed [org.apache.kafka.common.metrics.Metrics] 2024-11-26 03:09:42,804 INFO || [task-thread-relation_cdc_server_1860922765189140481_1860922728858079233-0hread] Closing reporter org.apache.kafka.common.telemetry.internals.ClientTelemetryReporter [org.apache.kafka.common.metrics.Metrics] 2024-11-26 03:09:42,804 INFO || [task-thread-relation_cdc_server_1860922765189140481_1860922728858079233-0hread] Closing reporter org.apache.kafka.common.metrics.JmxReporter [org.apache.kafka.common.metrics.Metrics] 2024-11-26 03:09:42,804 INFO || [task-thread-relation_cdc_server_1860922765189140481_1860922728858079233-0hread] Metrics scheduler closed [org.apache.kafka.common.metrics.Metrics] 2024-11-26 03:09:42,802 INFO || [task-thread-relation_cdc_server_1860922765189140481_1860922728858079233-0hread] [Producer clientId=relation_cdc_server_1860922765189140481-schemahistory] Closing the Kafka producer with timeoutMillis = 30000 ms. [org.apache.kafka.clients.producer.KafkaProducer] 2024-11-26 03:09:42,802 INFO || [pool-425-thread-1hread] Connection gracefully closed [io.debezium.jdbc.JdbcConnection] 2024-11-26 03:09:42,769 INFO || [pool-424-thread-1hread] Connection gracefully closed [io.debezium.jdbc.JdbcConnection] 2024-11-26 03:09:42,764 INFO || [task-thread-relation_cdc_server_1860922765189140481_1860922728858079233-0hread] Debezium ServiceRegistry stopped. [io.debezium.service.DefaultServiceRegistry] 2024-11-26 03:09:42,764 INFO || [task-thread-relation_cdc_server_1860922765189140481_1860922728858079233-0hread] SignalProcessor stopped [io.debezium.pipeline.signal.SignalProcessor] 2024-11-26 03:09:42,764 WARN || [task-thread-relation_cdc_server_1860922765189140481_1860922728858079233-0hread] Going to restart connector after 10 sec. after a retriable exception [io.debezium.connector.common.BaseSourceTask] 2024-11-26 03:09:42,422 INFO Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Connected metrics set to 'false' [io.debezium.pipeline.ChangeEventSourceCoordinator] 2024-11-26 03:09:42,422 INFO Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Finished streaming [io.debezium.pipeline.ChangeEventSourceCoordinator] 2024-11-26 03:09:42,422 INFO Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Offsets: OracleOffsetContext [scn=127828973, commit_scn=[], lcr_position=null] [io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource] 2024-11-26 03:09:42,422 INFO Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Streaming metrics dump: LogMinerStreamingChangeEventSourceMetrics{connectorConfig=io.debezium.connector.oracle.OracleConnectorConfig@5d1cfac6, startTime=2024-11-26T03:09:38.757155312Z, clock=SystemClock[Z], currentScn=128354403, offsetScn=null, commitScn=null, oldestScn=null, oldestScnTime=null, currentLogFileNames=[Ljava.lang.String;@4989208c, redoLogStatuses=[Ljava.lang.String;@6a194939, databaseZoneOffset=+08:00, batchSize=26000, logSwitchCount=0, logMinerQueryCount=0, sleepTime=0, minimumLogsMined=1, maximumLogsMined=1, maxBatchProcessingThroughput=0, timeDifference=-1012, processedRowsCount=0, activeTransactionCount=0, rolledBackTransactionCount=0, oversizedTransactionCount=0, changesCount=0, scnFreezeCount=0, batchProcessingDuration=io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSourceMetrics$DurationHistogramMetric@2f3f8945, fetchQueryDuration=io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSourceMetrics$DurationHistogramMetric@15cf8cae, commitDuration=io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSourceMetrics$DurationHistogramMetric@15c243db, lagFromSourceDuration=io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSourceMetrics$DurationHistogramMetric@35b280db, miningSessionStartupDuration=io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSourceMetrics$DurationHistogramMetric@66144289, parseTimeDuration=io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSourceMetrics$DurationHistogramMetric@fd71819, resultSetNextDuration=io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSourceMetrics$DurationHistogramMetric@88c5ea3, userGlobalAreaMemory=io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSourceMetrics$MaxLongValueMetric@2919a331, processGlobalAreaMemory=io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSourceMetrics$MaxLongValueMetric@6dddbc91, abandonedTransactionIds=io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSourceMetrics$LRUSet@5a7d76e3, rolledBackTransactionIds=io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSourceMetrics$LRUSet@30ee5249} io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSourceMetrics@35c96115 [io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource] 2024-11-26 03:09:42,422 INFO Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] startScn=127828973, endScn=127853973 [io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource] 2024-11-26 03:09:42,422 WARN Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Retry 1 of 5 retries will be attempted [io.debezium.pipeline.ErrorHandler] ... 24 more at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637) ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_LOGMNR", line 58 Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '127828974', endScn => '127853973', OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '127828974', endScn => '127853973', OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile at java.base/java.lang.Thread.run(Thread.java:1583) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:143) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:203) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:312) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:61) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:241) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:617) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1476) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:328) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2118) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2163) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1311) at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1531) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1011) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:498) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:771) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1151) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:564) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:630) ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_LOGMNR", line 58 java.sql.SQLException: ORA-01291: missing logfile 2024-11-26 03:09:42,422 ERROR Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Producer failure [io.debezium.pipeline.ErrorHandler] ... 24 more at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637) ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_LOGMNR", line 58 Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '127828974', endScn => '127853973', OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '127828974', endScn => '127853973', OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile at java.base/java.lang.Thread.run(Thread.java:1583) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:143) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:203) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:312) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:61) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:241) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:617) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1476) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:328) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2118) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2163) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1311) at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1531) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1011) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:498) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:771) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1151) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:564) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:630) ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_LOGMNR", line 58 java.sql.SQLException: ORA-01291: missing logfile 2024-11-26 03:09:42,422 ERROR Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Mining session stopped due to error. [io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource] ... 24 more at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637) ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_LOGMNR", line 58 Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '127828974', endScn => '127853973', OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '127828974', endScn => '127853973', OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile at java.base/java.lang.Thread.run(Thread.java:1583) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:143) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:203) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:312) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:61) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:241) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:617) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1476) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:328) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2118) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2163) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1311) at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1531) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1011) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:498) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:771) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1151) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:564) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:630) ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_LOGMNR", line 58 java.sql.SQLException: ORA-01291: missing logfile 2024-11-26 03:09:42,422 ERROR Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Got exception when starting mining session. [io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource] 2024-11-26 03:09:42,422 ERROR Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] No logs were found with a status code of 4. [io.debezium.connector.oracle.logminer.LogMinerDatabaseStateWriter] ... 24 more at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637) ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_LOGMNR", line 58 Caused by: Error : 1291, Position : 0, Sql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '127828974', endScn => '127853973', OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, OriginalSql = BEGIN sys.dbms_logmnr.start_logmnr(startScn => '127828974', endScn => '127853973', OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG + DBMS_LOGMNR.NO_ROWID_IN_STMT);END;, Error Msg = ORA-01291: missing logfile at java.base/java.lang.Thread.run(Thread.java:1583) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:143) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:203) at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:312) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:61) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:241) at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.startMiningSession(LogMinerStreamingChangeEventSource.java:617) at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1476) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:328) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2118) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2163) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1311) at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1531) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1011) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:498) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:771) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1151) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:564) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:630) ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_LOGMNR", line 58 java.sql.SQLException: ORA-01291: missing logfile 2024-11-26 03:09:42,421 ERROR Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Failed to start Oracle LogMiner after '5' attempts. [io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource] 2024-11-26 03:09:42,421 ERROR Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] SCN: [127828974-127853974], Required Start SCN: 0, Options: 2064, Status: 0 - N/A [io.debezium.connector.oracle.logminer.LogMinerDatabaseStateWriter] 2024-11-26 03:09:42,421 ERROR Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Failed to start a LogMiner mining session with parameters: [io.debezium.connector.oracle.logminer.LogMinerDatabaseStateWriter] 2024-11-26 03:09:42,416 WARN Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Failed to start Oracle LogMiner session, retrying... [io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource] 2024-11-26 03:09:42,416 ERROR Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] SCN: [127828974-127852974], Required Start SCN: 0, Options: 2064, Status: 0 - N/A [io.debezium.connector.oracle.logminer.LogMinerDatabaseStateWriter] 2024-11-26 03:09:42,416 ERROR Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Failed to start a LogMiner mining session with parameters: [io.debezium.connector.oracle.logminer.LogMinerDatabaseStateWriter] 2024-11-26 03:09:42,209 WARN Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Failed to start Oracle LogMiner session, retrying... [io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource] 2024-11-26 03:09:42,209 ERROR Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] SCN: [127828974-127851974], Required Start SCN: 0, Options: 2064, Status: 0 - N/A [io.debezium.connector.oracle.logminer.LogMinerDatabaseStateWriter] 2024-11-26 03:09:42,209 ERROR Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Failed to start a LogMiner mining session with parameters: [io.debezium.connector.oracle.logminer.LogMinerDatabaseStateWriter] 2024-11-26 03:09:41,803 WARN Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Failed to start Oracle LogMiner session, retrying... [io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource] 2024-11-26 03:09:41,803 ERROR Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] SCN: [127828974-127850974], Required Start SCN: 0, Options: 2064, Status: 0 - N/A [io.debezium.connector.oracle.logminer.LogMinerDatabaseStateWriter] 2024-11-26 03:09:41,802 ERROR Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Failed to start a LogMiner mining session with parameters: [io.debezium.connector.oracle.logminer.LogMinerDatabaseStateWriter] 2024-11-26 03:09:41,195 WARN Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Failed to start Oracle LogMiner session, retrying... [io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource] 2024-11-26 03:09:41,195 ERROR Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] SCN: [127828974-127849974], Required Start SCN: 0, Options: 2064, Status: 0 - N/A [io.debezium.connector.oracle.logminer.LogMinerDatabaseStateWriter] 2024-11-26 03:09:41,195 ERROR Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Failed to start a LogMiner mining session with parameters: [io.debezium.connector.oracle.logminer.LogMinerDatabaseStateWriter] 2024-11-26 03:09:40,389 WARN Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Failed to start Oracle LogMiner session, retrying... [io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource] 2024-11-26 03:09:40,389 ERROR Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] SCN: [127828974-127848974], Required Start SCN: 0, Options: 2064, Status: 0 - N/A [io.debezium.connector.oracle.logminer.LogMinerDatabaseStateWriter] 2024-11-26 03:09:40,389 ERROR Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Failed to start a LogMiner mining session with parameters: [io.debezium.connector.oracle.logminer.LogMinerDatabaseStateWriter] 2024-11-26 03:09:40,357 INFO Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Group #6: 10485760 bytes [io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource] 2024-11-26 03:09:40,357 INFO Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Group #5: 10485760 bytes [io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource] 2024-11-26 03:09:40,357 INFO Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Group #4: 1048576000 bytes [io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource] 2024-11-26 03:09:40,357 INFO Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Group #3: 1048576000 bytes [io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource] 2024-11-26 03:09:40,357 INFO Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Group #2: 1048576000 bytes [io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource] 2024-11-26 03:09:40,357 INFO Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Group #1: 1048576000 bytes [io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource] 2024-11-26 03:09:40,357 INFO Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Redo Log Group Sizes: [io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource] 2024-11-26 03:09:40,350 INFO Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Starting streaming [io.debezium.pipeline.ChangeEventSourceCoordinator] 2024-11-26 03:09:40,350 INFO Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Creating thread debezium-oracleconnector-relation_cdc_server_1860922765189140481-SignalProcessor [io.debezium.util.Threads] 2024-11-26 03:09:40,350 INFO Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] SignalProcessor started. Scheduling it every 5000ms [io.debezium.pipeline.signal.SignalProcessor] 2024-11-26 03:09:40,349 INFO Oracle|relation_cdc_server_1860922765189140481|streaming [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Connected metrics set to 'true' [io.debezium.pipeline.ChangeEventSourceCoordinator] 2024-11-26 03:09:40,349 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Snapshot ended with SnapshotResult [status=COMPLETED, offset=OracleOffsetContext [scn=127828973, commit_scn=[], lcr_position=null]] [io.debezium.pipeline.ChangeEventSourceCoordinator] 2024-11-26 03:09:40,349 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Snapshot completed [io.debezium.pipeline.source.AbstractSnapshotChangeEventSource] 2024-11-26 03:09:40,349 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Snapshot - Final stage [io.debezium.pipeline.source.AbstractSnapshotChangeEventSource] 2024-11-26 03:09:40,349 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Creating snapshot worker pool with 1 worker thread(s) [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:40,348 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Snapshot step 7 - Snapshotting data [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:40,287 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Capturing structure of table ORCL.DACOO.local_test_1112_10 [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:40,226 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Capturing structure of table ORCL.DACOO.local_test_1112_09 [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:40,165 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Capturing structure of table ORCL.DACOO.local_test_1112_08 [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:40,104 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Capturing structure of table ORCL.DACOO.local_test_1112_07 [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:40,045 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Capturing structure of table ORCL.DACOO.local_test_1112_06 [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,985 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Capturing structure of table ORCL.DACOO.local_test_1112_05 [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,922 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Capturing structure of table ORCL.DACOO.local_test_1112_04 [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,861 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Capturing structure of table ORCL.DACOO.local_test_1112_03 [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,798 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Capturing structure of table ORCL.DACOO.local_test_1112_02 [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,730 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Capturing structure of table ORCL.DACOO.local_test_1112_01 [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,667 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Capturing structure of table ORCL.DACOO.local_test_1111 [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,603 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Capturing structure of table ORCL.DACOO.local_test_0823 [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,541 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Capturing structure of table ORCL.DACOO.TEST20240307_1 [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,482 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Capturing structure of table ORCL.DACOO.SOURCE_TABLE_2 [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,421 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Capturing structure of table ORCL.DACOO.SOURCE_TABLE_1 [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,334 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Capturing structure of table ORCL.DACOO.CDC_COLLECT_SIGNAL [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,334 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Snapshot step 6 - Persisting schema history [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,132 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Registering 'ORCL.DACOO.local_test_1112_10' attributes: object_id=97925, data_object_id=98085 [io.debezium.connector.oracle.OracleConnection] 2024-11-26 03:09:39,132 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Registering 'ORCL.DACOO.local_test_1112_09' attributes: object_id=97923, data_object_id=98633 [io.debezium.connector.oracle.OracleConnection] 2024-11-26 03:09:39,131 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Registering 'ORCL.DACOO.local_test_1112_08' attributes: object_id=97921, data_object_id=97962 [io.debezium.connector.oracle.OracleConnection] 2024-11-26 03:09:39,131 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Registering 'ORCL.DACOO.local_test_1112_07' attributes: object_id=97919, data_object_id=97919 [io.debezium.connector.oracle.OracleConnection] 2024-11-26 03:09:39,131 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Registering 'ORCL.DACOO.local_test_1112_06' attributes: object_id=97917, data_object_id=97917 [io.debezium.connector.oracle.OracleConnection] 2024-11-26 03:09:39,131 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Registering 'ORCL.DACOO.local_test_1112_05' attributes: object_id=97915, data_object_id=97940 [io.debezium.connector.oracle.OracleConnection] 2024-11-26 03:09:39,130 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Registering 'ORCL.DACOO.local_test_1112_04' attributes: object_id=97913, data_object_id=97948 [io.debezium.connector.oracle.OracleConnection] 2024-11-26 03:09:39,130 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Registering 'ORCL.DACOO.local_test_1112_03' attributes: object_id=97911, data_object_id=97946 [io.debezium.connector.oracle.OracleConnection] 2024-11-26 03:09:39,129 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Registering 'ORCL.DACOO.local_test_1112_02' attributes: object_id=97909, data_object_id=97944 [io.debezium.connector.oracle.OracleConnection] 2024-11-26 03:09:39,129 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Registering 'ORCL.DACOO.local_test_1112_01' attributes: object_id=97907, data_object_id=98544 [io.debezium.connector.oracle.OracleConnection] 2024-11-26 03:09:39,129 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Registering 'ORCL.DACOO.local_test_1111' attributes: object_id=97806, data_object_id=97806 [io.debezium.connector.oracle.OracleConnection] 2024-11-26 03:09:39,128 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Registering 'ORCL.DACOO.local_test_0823' attributes: object_id=86554, data_object_id=97952 [io.debezium.connector.oracle.OracleConnection] 2024-11-26 03:09:39,128 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Registering 'ORCL.DACOO.TEST20240307_1' attributes: object_id=73614, data_object_id=73614 [io.debezium.connector.oracle.OracleConnection] 2024-11-26 03:09:39,128 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Registering 'ORCL.DACOO.SOURCE_TABLE_2' attributes: object_id=95388, data_object_id=95388 [io.debezium.connector.oracle.OracleConnection] 2024-11-26 03:09:39,127 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Registering 'ORCL.DACOO.SOURCE_TABLE_1' attributes: object_id=81704, data_object_id=81704 [io.debezium.connector.oracle.OracleConnection] 2024-11-26 03:09:39,127 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Registering 'ORCL.DACOO.CDC_COLLECT_SIGNAL' attributes: object_id=82859, data_object_id=82859 [io.debezium.connector.oracle.OracleConnection] 2024-11-26 03:09:39,094 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] All eligible tables schema should be captured, capturing: [ORCL.DACOO.CDC_COLLECT_SIGNAL, ORCL.DACOO.SOURCE_TABLE_1, ORCL.DACOO.SOURCE_TABLE_2, ORCL.DACOO.TEST20240307_1, ORCL.DACOO.local_test_0823, ORCL.DACOO.local_test_1111, ORCL.DACOO.local_test_1112_01, ORCL.DACOO.local_test_1112_02, ORCL.DACOO.local_test_1112_03, ORCL.DACOO.local_test_1112_04, ORCL.DACOO.local_test_1112_05, ORCL.DACOO.local_test_1112_06, ORCL.DACOO.local_test_1112_07, ORCL.DACOO.local_test_1112_08, ORCL.DACOO.local_test_1112_09, ORCL.DACOO.local_test_1112_10] [io.debezium.connector.oracle.OracleSnapshotChangeEventSource] 2024-11-26 03:09:39,094 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Snapshot step 5 - Reading structure of captured tables [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,094 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Snapshot step 4 - Determining snapshot offset [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,094 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Schema locking was disabled in connector configuration [io.debezium.connector.oracle.OracleSnapshotChangeEventSource] 2024-11-26 03:09:39,094 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Snapshot step 3 - Locking captured tables [] [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,094 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Created connection pool with 1 threads [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,094 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Adding table ORCL.DACOO.SOURCE_TABLE_2 to the list of capture schema tables [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,094 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Adding table ORCL.DACOO.SOURCE_TABLE_1 to the list of capture schema tables [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,094 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Adding table ORCL.DACOO.local_test_1112_05 to the list of capture schema tables [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,094 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Adding table ORCL.DACOO.local_test_1112_06 to the list of capture schema tables [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,094 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Adding table ORCL.DACOO.local_test_1112_07 to the list of capture schema tables [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,094 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Adding table ORCL.DACOO.local_test_1112_08 to the list of capture schema tables [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,094 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Adding table ORCL.DACOO.local_test_1112_01 to the list of capture schema tables [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,094 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Adding table ORCL.DACOO.local_test_1112_02 to the list of capture schema tables [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,094 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Adding table ORCL.DACOO.local_test_1112_03 to the list of capture schema tables [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,094 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Adding table ORCL.DACOO.local_test_1112_04 to the list of capture schema tables [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,094 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Adding table ORCL.DACOO.local_test_1112_09 to the list of capture schema tables [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,094 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Adding table ORCL.DACOO.local_test_1112_10 to the list of capture schema tables [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,094 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Adding table ORCL.DACOO.TEST20240307_1 to the list of capture schema tables [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,094 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Adding table ORCL.DACOO.local_test_0823 to the list of capture schema tables [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,094 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Adding table ORCL.DACOO.local_test_1111 to the list of capture schema tables [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:39,094 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Adding table ORCL.DACOO.CDC_COLLECT_SIGNAL to the list of capture schema tables [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:38,757 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Snapshot step 2 - Determining captured tables [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:38,757 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Previous snapshot was cancelled before completion; a new snapshot will be taken. [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:38,757 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Snapshot step 1 - Preparing [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:38,757 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] According to the connector configuration both schema and data will be snapshot. [io.debezium.relational.RelationalSnapshotChangeEventSource] 2024-11-26 03:09:38,757 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Context created [io.debezium.pipeline.ChangeEventSourceCoordinator] 2024-11-26 03:09:38,757 INFO Oracle|relation_cdc_server_1860922765189140481|snapshot [debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinatorhread] Metrics registered [io.debezium.pipeline.ChangeEventSourceCoordinator] 2024-11-26 03:09:38,757 INFO || [task-thread-relation_cdc_server_1860922765189140481_1860922728858079233-0hread] Successfully restarted task [io.debezium.connector.common.BaseSourceTask] 2024-11-26 03:09:38,757 INFO || [task-thread-relation_cdc_server_1860922765189140481_1860922728858079233-0hread] Creating thread debezium-oracleconnector-relation_cdc_server_1860922765189140481-change-event-source-coordinator [io.debezium.util.Threads]