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

LogMiner could not receive changed data

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Obsolete
    • Icon: Major Major
    • None
    • 1.4.0.Final
    • oracle-connector
    • None
    • False
    • False
    • Undefined

      When I synchronize data with the logminer mode of oracle-connector, my topic always does not receive the changed data of the table, only the initial data of the table.The log also saw no error messages.What is the reason for this?

      The attachment information is the trace log of the connector before and after I changed the data.

       
      oracle version:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

      this is my configuration:

      {
          "name": "inventory_connector_oracl_11",
          "config": {
              "connector.class" : "io.debezium.connector.oracle.OracleConnector",
              "tasks.max" : "1",
              "database.server.name" : "oracle_11",
              "database.schema":"logminer",
              "database.user" : "logminer",
              "database.password" : "123456",
              "database.url": "jdbc:oracle:thin:@172.16.11.4:1521/orcl1",
              "database.dbname" : "orcl1",
              "table.include.list": "logminer.ORACLE_CDC",
              "database.history.kafka.bootstrap.servers" : "172.16.11.5:7090",
              "database.history.kafka.topic": "inventory_connector_oracle_11",
              "database.connection.adapter": "logminer",
              "database.hostname":"172.16.11.5",
              "database.port" : "1521",
              "database.oracle.version":"11",
              "database.tablename.case.insensitive": "true"
          }
      }
      

        1. oracle.log
          13.11 MB
          yongwang qu
        2. image-2021-01-19-20-01-16-685.png
          44 kB
          yongwang qu
        3. image-2021-03-02-09-36-26-324.png
          8 kB
          yongwang qu
        4. image-2021-03-02-09-36-32-731.png
          8 kB
          yongwang qu
        5. image-2021-03-02-09-38-15-310.png
          9 kB
          yongwang qu

            ccranfor@redhat.com Chris Cranford
            qyw919867774 yongwang qu (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: