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

java.lang.NullPointerException for oracle connector in 1.7 final version

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 1.7.0.Final
    • oracle-connector
    • None
    • False
    • False

      our oracle connector was normal when it first started. but after running a while, it occurs 'java.lang.NullPointerException' issue, but we cannot find out the reason. 

      here is the oracle connector config and  error messages.  please noted that: for safe, I already removed some sensitive information, such as 'database.user', 'database.password', 'database.history.kafka.bootstrap.servers'.

       

      Config:
       database.connection.adapter: logminer
       database.dbname: BUDWH01
       database.history.kafka.topic: kafka-tss-uat.qs-1
       database.port: 1521
       database.server.name: BUDWH01
       decimal.handling.mode: string
       snapshot.locking.mode: none
       snapshot.mode: schema_only
       table.include.list: MPRD199.gm_cmps_prem_daily,MPRD199.gm_egle_prem_daily,MPRD199.gm_gpse_anp_daily,MPRD199.gm_hias_prem_daily,MPRD199.gm_inge_prem_daily
       tombstones.on.delete: false
       topic.creation.default.partitions: 3
       topic.creation.default.replication.factor: 3
       Tasks Max: 1
       Status:
       Conditions:
       Last Transition Time: 2021-10-13T01:22:31.401108Z
       Status: True
       Type: Ready
       Connector Status:
       Connector:
       State: RUNNING
       worker_id: 10.214.169.16:8083
       Name: uat-qs-connector-2
       Tasks:
       Id: 0
       State: FAILED
       Trace: org.apache.kafka.connect.errors.ConnectException: An exception occurred in the change event producer. This connector will be stopped.
       at io.debezium.pipeline.ErrorHandler.setProducerThrowable(ErrorHandler.java:42)
       at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:175)
       at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:54)
       at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:166)
       at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:127)
       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.logminer.processor.AbstractLogMinerEventProcessor.processRow(AbstractLogMinerEventProcessor.java:173)
       at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.processResults(AbstractLogMinerEventProcessor.java:161)
       at io.debezium.connector.oracle.logminer.processor.memory.MemoryLogMinerEventProcessor.process(MemoryLogMinerEventProcessor.java:116)
       at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:162)
       ... 8 more
       
      

       

       

              ccranfor@redhat.com Chris Cranford
              gimmen gimmen mai (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: