-
Bug
-
Resolution: Unresolved
-
Major
-
2.7.0.Final
-
None
-
False
-
None
-
False
Bug report
After Oracle generated the log archive, the connector immediately encountered an exception, Error Message=ORA-01291: missing logfile.
The problem is not necessary, it happens occasionally
What Debezium connector do you use and what version?
2.7.0.Final
What is the connector configuration?
{ "name": "relation_cdc_server_1862083316347539458_1860884936367505409", "config": { "snapshot.locking.mode": "none", "connector.class": "io.debezium.connector.oracle.OracleConnector", "tasks.max": "1", "database.history.kafka.topic": "relation_cdc_server_1862083316347539458_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_1862083316347539458", "transforms.Reroute.topic.replacement": "relation_cdc_server_1862083316347539458_1860884936367505409_all", "decimal.handling.mode": "string", "schema.history.internal.kafka.topic": "relation_cdc_server_1862083316347539458_history.DACOO", "log.mining.archive.log.hours": "1", "snapshot.include.collection.list": "80a2239532ef4c2086085745f33f9493", "database.dbname": "ORCL", "transforms.Reroute.type": "io.debezium.transforms.ByLogicalTableRouter", "database.user": "test", "database.history.kafka.bootstrap.servers": "11.111.21.24:9092", "database.url": "jdbc:oracle:thin:@${hostname}:${port}:${dbname}", "database.server.name": "relation_cdc_server_1862083316347539458", "heartbeat.interval.ms": "300000", "schema.history.internal.kafka.bootstrap.servers": "11.116.213.24:9092", "event.processing.failure.handling.mode": "warn", "transforms.Reroute.topic.regex": "(.*)", "database.port": "1521", "column.exclude.list": "", "errors.max.retries": "5", "log.mining.query.filter.mode": "in", "database.connectionTimeZone": "Asia/Shanghai", "database.hostname": "10.106.251.194", "database.password": "test", "name": "relation_cdc_server_1862083316347539458_1860884936367505409", "table.include.list": "DACOO.local_test_1112_02", "snapshot.mode": "initial", "snowflakeId": "1862083316347539458" }, "tasks": [ { "connector": "relation_cdc_server_1862083316347539458_1860884936367505409", "task": 0 } ], "type": "source" }json
What is the captured database version and mode of deployment?
oracle 11g
What behavior do you expect?
The connector is executing normally
What behavior do you see?
After Oracle generated the log archive, the connector immediately encountered an exception, Error Message=ORA-01291: missing logfile
Do you have the connector logs, ideally from start till finish?
V_ARCHIVED_LOG_202411290958.csv
How to reproduce the issue using our tutorial deployment?
Oracle database generates log archives.
Which use case/requirement will be addressed by the proposed feature?
The collector collects tables that do not generate data for a long time