Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-5738

NullPointerException thrown during snapshot of tables in Oracle source connector

    XMLWordPrintable

Details

    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)

      trace for error all capch.txt

      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

      Attachments

        Issue Links

          Activity

            People

              vjuranek@redhat.com Vojtech Juranek
              andrmax Andrey Maksimov
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: