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

debezium not work during the snapshot phase (Snapshot step 5)

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Cannot Reproduce
    • Icon: Major Major
    • None
    • 1.2.1.Final
    • oracle-connector
    • None

      Oracle version: 11.2.0.3

      configuration of the Debezium Oracle connector:

      {
      "name": "connector_name",
      "config":

      { "connector.class" : "io.debezium.connector.oracle.OracleConnector", "tasks.max" : "1", "database.server.name" : "database", "database.hostname" : "ip address", "database.port" : "port", "database.user" : "xstrm", "database.password" : "********", "database.out.server.name" : "dbzxout", "database.dbname" : "database", "database.oracle.version": "11", "database.tablename.case.insensitive": "false", "snapshot.mode": "schema_only", "database.history.kafka.bootstrap.servers" : "localhost:9092", "database.history.kafka.topic": "schema-changes.database" }

      }

      Error:

      [2020-07-30 11:03:22,412] INFO Snapshot step 5 - Reading structure of captured tables (io.debezium.relational.RelationalSnapshotCh
      angeEventSource:122)
      [2020-07-30 11:03:28,346] INFO Snapshot - Final stage (io.debezium.pipeline.source.AbstractSnapshotChangeEventSource:79)
      [2020-07-30 11:03:28,348] ERROR Producer failure (io.debezium.pipeline.ErrorHandler:31)
      java.lang.IllegalArgumentException: The primary key cannot reference a non-existant column'SYS_NC00004$' in table 'EXFSYS.RLM$PARS
      EDCOND'
      at io.debezium.relational.TableEditorImpl.setPrimaryKeyNames(TableEditorImpl.java:133)
      at io.debezium.relational.TableImpl.edit(TableImpl.java:116)
      at io.debezium.relational.Tables.editTable(Tables.java:334)
      at io.debezium.connector.oracle.OracleConnection.readSchema(OracleConnection.java:114)
      at io.debezium.connector.oracle.OracleSnapshotChangeEventSource.readTableStructure(OracleSnapshotChangeEventSource.java:19
      8)
      at io.debezium.relational.RelationalSnapshotChangeEventSource.doExecute(RelationalSnapshotChangeEventSource.java:123)
      at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:63)
      at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:96)
      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
      at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
      at java.lang.Thread.run(Thread.java:748)

      Tell me, please, what could be the reason for this error?

       

              Unassigned Unassigned
              amanzhan.sariyev Amanzhan Sariyev (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: