-
Bug
-
Resolution: Unresolved
-
Major
-
2.7.0.Final
-
None
-
False
-
None
-
False
What Debezium connector do you use and what version?
2.7.0.Final
What is the connector configuration?
{
"name": "relation_cdc_server_1860922765189140481_1860922728858079233",
"config": {
"snapshot.locking.mode": "none",
"connector.class": "io.debezium.connector.oracle.OracleConnector",
"tasks.max": "1",
"database.history.kafka.topic": "relation_cdc_server_1860922765189140481_history.DACOO",
"transforms": "Reroute",
"log.mining.transaction.retention.ms": "3600000",
"schema.include.list": "DACOO",
"log.mining.strategy": "online_catalog",
"schema.history.internal.store.only.captured.databases.ddl": "true",
"topic.prefix": "relation_cdc_server_1860922765189140481",
"transforms.Reroute.topic.replacement": "relation_cdc_server_1860922765189140481_1860922728858079233_all",
"decimal.handling.mode": "string",
"schema.history.internal.kafka.topic": "relation_cdc_server_1860922765189140481_history.DACOO",
"log.mining.archive.log.hours": "1",
"snapshot.include.collection.list": "49222f10f53e40a0ab44579b15d8b58a",
"database.dbname": "ORCL",
"transforms.Reroute.type": "io.debezium.transforms.ByLogicalTableRouter",
"database.user": "test",
"database.history.kafka.bootstrap.servers": "10.10.23.24:9092",
"database.url": "jdbc:oracle:thin:@${hostname}:${port}:${dbname}",
"database.server.name": "relation_cdc_server_1860922765189140481",
"schema.history.internal.kafka.bootstrap.servers": "10.10.53.24:9092",
"event.processing.failure.handling.mode": "warn",
"transforms.Reroute.topic.regex": "(.*)",
"schema.history.internal.skip.unparseable.ddl": "true",
"database.port": "1521",
"column.exclude.list": "",
"errors.max.retries": "5",
"log.mining.query.filter.mode": "in",
"database.connectionTimeZone": "Asia/Shanghai",
"database.hostname": "10.10.25.194",
"database.password": "test",
"name": "relation_cdc_server_1860922765189140481_1860922728858079233",
"table.include.list": "DACOO.local_test_1112_02",
"snapshot.mode": "initial",
"snowflakeId": "1861243303682904066"
},
"tasks": [
{
"connector": "relation_cdc_server_1860922765189140481_1860922728858079233",
"task": 0
}
],
"type": "source"
}
What is the captured database version and mode of deployment?
oracle 11g
What behavior do you expect?
Mark the task as an abnormal state after the last retry is completed
What behavior do you see?
The task has been trying again continuously
Do you have the connector logs, ideally from start till finish?
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]
How to reproduce the issue using our tutorial deployment?
delete logfile or reduce the time range of archive log queries
