Details
-
Bug
-
Resolution: Done
-
Major
-
1.9.5.Final, 2.0.0.Final
-
None
-
False
-
None
-
False
Description
What Debezium connector do you use and what version?
1.9.5,2.0
What is the connector configuration?
"database.connection.adapter": "logminer", "snapshot.mode":"initial", "log.mining.strategy": "online_catalog", "connector.class" : "io.debezium.connector.oracle.OracleConnector", "tasks.max" : "1", "database.hostname" : "***", "database.port" : "1521", "database.user" : "***", "database.password" : "***", "database.dbname" : "***", "topic.prefix" : "oracle", "schema.history.internal.kafka.bootstrap.servers" : "kafka:29092", "schema.history.internal.kafka.topic": "oracle.schema_changes", "schema.history.internal.store.only.captured.tables.ddl": "false", "decimal.handling.mode": "string", "table.include.list" : "DEV.D_DIR_CANC_REASONS,DEV.D_ATX,DEV.D_BLOODGROUPE,DEV.D_CATEGORIES", "transforms": "name", "transforms.name.type": "io.debezium.transforms.ByLogicalTableRouter", "transforms.name.topic.regex": "([^.]+)\\.([^.]+)\\.([^.]+)", "transforms.name.topic.replacement": "$2.$3", "transforms.name.key.enforce.uniqueness": false
What is the captured database version and mode of depoyment?
11.2.0.4
What behaviour do you expect?
schema snapshot successful execute
What behaviour do you see?
Snapshot was not completed successfully, it will be re-executed upon connector restart due
2022-10-17 13:44:07,531 INFO Oracle|oracle|snapshot Capturing structure of table MIS.EXFSYS.RLM$INCRRRSCHACT [io.debezium.connector.oracle.OracleSnapshotChangeEventSource] 2022-10-17 13:44:07,532 INFO Oracle|oracle|snapshot Snapshot - Final stage [io.debezium.pipeline.source.AbstractSnapshotChangeEventSource] 2022-10-17 13:44:07,532 WARN Oracle|oracle|snapshot Snapshot was not completed successfully, it will be re-executed upon connector restart [io.debezium.pipeline.source.AbstractSnapshotChangeEventSource] 2022-10-17 13:44:07,532 ERROR Oracle|oracle|snapshot Producer failure [io.debezium.pipeline.ErrorHandler] io.debezium.DebeziumException: java.lang.NullPointerException at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:85) at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:155) at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:137) at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:109) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: java.lang.NullPointerException at io.debezium.connector.oracle.OracleSnapshotChangeEventSource.createSchemaChangeEventsForTables(OracleSnapshotChangeEventSource.java:215) at io.debezium.relational.RelationalSnapshotChangeEventSource.doExecute(RelationalSnapshotChangeEventSource.java:122) at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:76) ... 8 more
Do you see the same behaviour using the latest relesead Debezium version?
(Ideally, also verify with latest Alpha/Beta/CR version)
do not verify on latest
Do you have the connector logs, ideally from start till finish?
(You might be asked later to provide DEBUG/TRACE level log)
How to reproduce the issue using our tutorial deployment?
<Your answer>
Feature request or enhancement
For feature requests or enhancements, provide this information, please:
Which use case/requirement will be addressed by the proposed feature?
<Your answer>
Implementation ideas (optional)
when copy select from trace log on previous to error table and replace with tablename which cause an error (RLM$INCRRRSCHACT)
SELECT dbms_metadata.get_ddl('TABLE','RLM$INCRRRSCHACT','EXFSYS') FROM DUAL
cause an error
SQL Error [31603] [99999]: ORA-31603: object "RLM$INCRRRSCHACT" of type TABLE not found in schema "EXFSYS" ORA-06512: at "SYS.DBMS_METADATA", line 5805 ORA-06512: at "SYS.DBMS_METADATA", line 8344 ORA-06512: at line 1
