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

LogMiner reports change as "unsupported" erroneously

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • under-triaging
    • 2.5.1.Final
    • oracle-connector
    • None
    • False
    • None
    • False

    Description

      Taken from a discussion on the mailing list: "[debezium] "Unsupported operation" warnings".

      The user's configuration:

      {
          "snapshot.locking.mode": "none",
          "connector.class": "io.debezium.connector.oracle.OracleConnector",
          "message.key.columns": "EHDA.A_COSHIPTO:CONO,COSHIPTOSEQNO; EHDA.A_CSCUBUSINESS:CUSTNO,BUUNIT,COMPNO; EHDA.A_CUSTPARTGRP:CUSTPARTGRP,PARTNO; EHDA.A_ISINVSTATHOLD:PARTNO,STOCKNO,INVSTATCD,INVHOLDSEQNO; EHDA.A_LOCALPART:COMPNO,PARTNO; EHDA.A_PARTPRICE:PARTNO,PRICELIST,VALID_FROM; EHDA.A_POPARTVENDOR:COMPNO,PARTNO,VENDNO,FROMDATE; EHDA.A_POSHIPTO:PONO,POSHIPTOSEQNO; EHDA.A_PSBASE:PARTNO,STOCKNO; EHDA.A_PSPARTPACK:PARTNO,PARTPACK; EHDA.A_PSPARTSTOPDATES:PARTNO,STOPTYPE; EHDA.A_PSRESERV:PARTNO,STOCKNO; EHDA.A_PSSTLOC:PARTNO,STOCKNO; EHDA.A_SYCOMPORGUNIT:COMPNO,ORGUNIT; EHDA.A_SYEVENTTRIGGER:ESSEVENT,ESSID,ESSIDQUAL,EVENTSEQNO; EHDA.COAGREEHEAD:CUSTNO,AGREETYPE,COCLASS,BUUNIT,COMPNO,CURRENCY,COOBJ,CUSTDISC,SEQNO; EHDA.COAGREELINE:CUSTNO,AGREETYPE,COCLASS,BUUNIT,COMPNO,CURRENCY,COOBJ,CUSTDISC,SEQNO,LINENO; EHDA.COHEAD:CONO; EHDA.COROW:CONO,ROWPOS,ROWSUBPOS,ROWSEQ; EHDA.CUSTBILL:CUSTNOBILL; EHDA.CUSTBUY:CUSTNO; EHDA.CUSTSHIP:CUSTNO,SHIPTONO; EHDA.CZACCGROUPHEAD:COMPNO,CZCUSTNOGROUP,CUSTNO,SHIPTONO; EHDA.CZACCGROUPLINE:COMPNO,CZCUSTNOGROUP,CLASS1,CLASS2,CLASS3,CLASS4,CLASS5,CZCLASS8; EHDA.CZAGRPRDATE:CUSTNO,AGREETYPE,COCLASS,BUUNIT,COMPNO,CURRENCY,COOBJ,CUSTDISC,SEQNO,LINENO; EHDA.CZCLASS8GEN:COMPNO,PARTNO,VALID_FROM; EHDA.CZDISCTEMPLATE:CZDISCTEMPL,COMPNO; EHDA.CZDISCTEMPLATEROW:CZDISCTEMPL,COMPNO,CUSTDISC; EHDA.CZCUSTCOM:CZCUSTNOCOM; EHDA.CZCUSTCOMBREAK:CZCUSTNOCOM,CZCUSTCOMBR; EHDA.CZEDIORDERERRLOG:EDISEQNO,CODATE,CUSTNO,CONO,ROWPOS,PARTNO,CZEDIERRORTEXT,METHOFREC,CZEDIERRORNO; EHDA.CZHICLASS8:COMPNO,PARTNO,VALID_TO; EHDA.CZMULTIPLEAGR:CUSTNO,BUUNIT,COMPNO,CUSTDISC; EHDA.CZPARTPROPERTYART:COMPNO,PARTNO,CZSUBPROPERTY2; EHDA.CZPRFACTCLASS8:COMPNO,CZCLASS8; EHDA.CZPRFACTGEN:COMPNO,VALID_FROM,PARTNO,CZCLASS8; EHDA.CZREGIONORGSTRUCT:COMPNO,REGION,DISTRICT,CUSTCLASS,BRANCH; EHDA.CZVENDCOM:CZVENDNOCOM; EHDA.CZVENDCOMBREAK:CZVENDNOCOM,CZVENDCOMBR; EHDA.PART:PARTNO; EHDA.PARTKIT:PARTNO,PARTPOS; EHDA.PARTSEARCH:PARTSEARCHNAME,PARTNO,CZDUBBLETTYN; EHDA.PERS:SY_USER; EHDA.POHEAD:PONO; EHDA.POROW:PONO,POROWPOS,POROWSEQ; EHDA.SFSYCODEVALUE:CODEID,CODEKEY,COMPNO; EHDA.SFSYTEXTLANG:CMPTNAME,CMPTTYPE,CMPTID1,CMPTID2,LANGCODE; EHDA.STOCK:STOCKNO; EHDA.STOCKLOC:STOCKNO,PICKST,STOCKLOC; EHDA.STOCKPICK:STOCKNO,PICKST; EHDA.STOCKTAKE:STOCKNO,PARTNO,PICKST,STOCKLOC,STMISSNO,INDNO; EHDA.VENDBILL:VENDNO; EHDA.VENDBUY:VENDNO;",
          "topic.creation.default.allow.auto.create.topics": "true",
          "topic.creation.default.partitions": "6",
          "schema.history.internal.consumer.sasl.jaas.config": "org.apache.kafka.common.security.plain.PlainLoginModule required username='${file:/opt/kafka/external-configuration/dbz-ccloud-credentials/cred:username}' password='${file:/opt/kafka/external-configuration/dbz-ccloud-credentials/cred:password}';",
          "config.providers": "file",
          "topic.creation.default.auto.create.topics.enable": "true",
          "value.converter.basic.auth.credentials.source": "USER_INFO",
          "topic.creation.default.delete.retention.ms": "604800000",
          "schema.history.internal.producer.security.protocol": "SASL_SSL",
          "poll.interval.ms": "500",
          "topic.creation.default.replication.factor": "3",
          "config.providers.file.class": "org.apache.kafka.common.config.provider.FileConfigProvider",
          "key.converter": "io.confluent.connect.avro.AvroConverter",
          "schema.history.internal.producer.sasl.mechanism": "PLAIN",
          "schema.history.internal.producer.allow.auto.create.topics": "true",
          "database.dbname": "VIVP",
          "database.user": "${file:/opt/kafka/external-configuration/dbz-oracle-credentials/oracle:user}",
          "topic.creation.default.compression.type": "lz4",
          "schema.history.internal.kafka.bootstrap.servers": "redacted",
          "key.converter.schemas.enable": "false",
          "value.converter.schema.registry.url": "redacted",
          "database.password": "${file:/opt/kafka/external-configuration/dbz-oracle-credentials/oracle:password}",
          "topic.creation.default.min.compaction.lag.ms": "604800000",
          "value.converter.schemas.enable": "false",
          "name": "vivaldi-cdc-connector",
          "schema.history.internal.consumer.sasl.mechanism": "PLAIN",
          "schema.history.internal.producer.sasl.jaas.config": "org.apache.kafka.common.security.plain.PlainLoginModule required username='${file:/opt/kafka/external-configuration/dbz-ccloud-credentials/cred:username}' password='${file:/opt/kafka/external-configuration/dbz-ccloud-credentials/cred:password}';",
          "key.converter.schema.registry.basic.auth.user.info": "${file:/opt/kafka/external-configuration/dbz-ccloud-sr-credentials/cred:username}:${file:/opt/kafka/external-configuration/dbz-ccloud-sr-credentials/cred:password}",
          "schema.history.internal.producer.auto.create.topics.enable": "true",
          "max.batch.size": "10000",
          "key.converter.basic.auth.credentials.source": "USER_INFO",
          "snapshot.mode": "initial",
          "schema.history.internal.consumer.security.protocol": "SASL_SSL",
          "schema.history.internal.consumer.allow.auto.create.topics": "true",
          "max.queue.size": "40000",
          "tasks.max": "1",
          "value.converter.schema.registry.basic.auth.user.info": "${file:/opt/kafka/external-configuration/dbz-ccloud-sr-credentials/cred:username}:${file:/opt/kafka/external-configuration/dbz-ccloud-sr-credentials/cred:password}",
          "log.mining.strategy": "online_catalog",
          "schema.history.internal.consumer.auto.create.topics.enable": "true",
          "schema.history.internal.store.only.captured.databases.ddl": "true",
          "schema.history.internal.store.only.captured.tables.ddl": "true",
          "value.converter.enhanced.avro.schema.support": "true",
          "topic.prefix": "dbzvivaldi",
          "decimal.handling.mode": "double",
          "schema.history.internal.kafka.topic": "dbzvivaldi.schema-changes.vivaldi-cdc-connector",
          "topic.creation.default.key.converter.schemas.enable": "false",
          "value.converter": "io.confluent.connect.avro.AvroConverter",
          "topic.creation.default.cleanup.policy": "compact",
          "database.url": "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST= redacted )(PORT=1521)) (CONNECT_DATA=(SID=VIVP)))",
          "topic.creation.default.value.converter.schemas.enable": "false",
          "snapshot.max.threads": "53",
          "log.mining.query.filter.mode": "in",
          "table.include.list": "EHDA.A_COSHIPTO, EHDA.A_CSCUBUSINESS, EHDA.A_CUSTPARTGRP, EHDA.A_ISINVSTATHOLD, EHDA.A_LOCALPART, EHDA.A_PARTPRICE, EHDA.A_POPARTVENDOR, EHDA.A_POSHIPTO, EHDA.A_PSBASE, EHDA.A_PSPARTPACK, EHDA.A_PSPARTSTOPDATES, EHDA.A_PSRESERV, EHDA.A_PSSTLOC, EHDA.A_SYCOMPORGUNIT, EHDA.A_SYEVENTTRIGGER, EHDA.COAGREEHEAD, EHDA.COAGREELINE, EHDA.COHEAD, EHDA.COROW, EHDA.CUSTBILL, EHDA.CUSTBUY, EHDA.CUSTSHIP, EHDA.CZACCGROUPHEAD, EHDA.CZACCGROUPLINE, EHDA.CZAGRPRDATE, EHDA.CZCLASS8GEN, EHDA.CZDISCTEMPLATE, EHDA.CZDISCTEMPLATEROW, EHDA.CZCUSTCOM, EHDA.CZCUSTCOMBREAK, EHDA.CZEDIORDERERRLOG, EHDA.CZHICLASS8, EHDA.CZMULTIPLEAGR, EHDA.CZPARTPROPERTYART, EHDA.CZPRFACTCLASS8, EHDA.CZPRFACTGEN, EHDA.CZREGIONORGSTRUCT, EHDA.CZVENDCOM, EHDA.CZVENDCOMBREAK, EHDA.PART, EHDA.PARTKIT, EHDA.PARTSEARCH, EHDA.PERS, EHDA.POHEAD, EHDA.POROW, EHDA.SFSYCODEVALUE, EHDA.SFSYTEXTLANG, EHDA.STOCK, EHDA.STOCKLOC, EHDA.STOCKPICK, EHDA.STOCKTAKE, EHDA.VENDBILL, EHDA.VENDBUY",
          "key.converter.schema.registry.url": "redacted"
      }
      

      User's environment:

      • Oracle 19.13.0.0.0
      • Standalone

      The issue is in the logs the following is reported:

      An unsupported operation detected for table 'VIVP.EHDA.COROW' in transaction 00110006018e3dcb with SCN 504580244433 on redo thread 0.
      

      Attachments

        Activity

          People

            ccranfor@redhat.com Chris Cranford
            ccranfor@redhat.com Chris Cranford
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: