Details
-
Bug
-
Resolution: Unresolved
-
Major
-
2.5.1.Final
-
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.