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

DDL statement couldn't be parsed - Oracle connector 2.1.3.Final

    XMLWordPrintable

Details

    Description

      Bug report

      For bug reports, provide this information, please:

      What Debezium connector do you use and what version?

      2.1.3.Final

      What is the connector configuration?

      {
        "connector.class": "io.debezium.connector.oracle.OracleConnector",
        "schema.history.internal.consumer.sasl.jaas.config": "${secrets:draak/draak-connect-user:sasl.jaas.config}",
        "transforms": "FilterFields",
        "schema.history.internal.producer.security.protocol": "SASL_SSL",
        "schema.history.internal.producer.ssl.truststore.password": "${secrets:draak/draak-cluster-ca-cert:ca.password}",
        "signal.data.collection": "AECBOFF3.P1QMS.QMS_DEBEZIUM_SIGNAL",
        "heartbeat.topics.prefix": "__debezium-heartbeat",
        "key.converter": "org.apache.kafka.connect.json.JsonConverter",
        "schema.history.internal.producer.sasl.mechanism": "SCRAM-SHA-512",
        "database.dbname": "aecboff3",
        "database.user": "${secrets:draak/debezium-credentials:dbz_user}",
        "transforms.FilterFields.type": "com.ahold.debezium.connect.transformation.FilterTableFieldsTransformation",
        "heartbeat.interval.ms": "30000",
        "schema.history.internal.kafka.bootstrap.servers": "${env:KAFKA_CONNECT_BOOTSTRAP_SERVERS}",
        "key.converter.schemas.enable": "false",
        "value.converter.schema.registry.url": "http://schema-registry-url",
        "database.password": "${secrets:draak/debezium-credentials:dbz_password}",
        "value.converter.schemas.enable": "false",
        "name": "debezium-acc-boff-source",
        "schema.history.internal.consumer.sasl.mechanism": "SCRAM-SHA-512",
        "schema.history.internal.consumer.ssl.truststore.type": "PKCS12",
        "schema.history.internal.producer.sasl.jaas.config": "${secrets:draak/draak-connect-user:sasl.jaas.config}",
        "max.batch.size": "20480",
        "snapshot.mode": "schema_only",
        "schema.history.internal.consumer.security.protocol": "SASL_SSL",
        "max.queue.size": "81290",
        "incremental.snapshot.chunk.size": "10000",
        "tasks.max": "1",
        "log.mining.strategy": "redo_log_catalog",
        "schema.history.internal.store.only.captured.tables.ddl": "true",
        "tombstones.on.delete": "false",
        "topic.prefix": "ACC.BOFF",
        "decimal.handling.mode": "string",
        "schema.history.internal.consumer.ssl.truststore.location": "/opt/kafka/external-configuration/cluster-ca-cert/ca.p12",
        "schema.history.internal.kafka.topic": "acc.boff.history-changes",
        "transforms.FilterFields.error.mode": "throw_error",
        "transforms.FilterFields.cache.expiration.minutes": "60",
        "value.converter": "io.confluent.connect.avro.AvroConverter",
        "log.mining.transaction.retention.hours": "5",
        "transforms.FilterFields.table.exclude.list": "P1QMS.QMS_DEBEZIUM_SIGNAL",
        "log.mining.batch.size.max": "500000",
        "database.connection.adapter": "logminer",
        "database.url": "${secrets:draak/debezium-credentials:boff_url}",
        "schema.history.internal.consumer.ssl.truststore.password": "${secrets:draak/draak-cluster-ca-cert:ca.password}",
        "schema.history.internal.producer.ssl.truststore.type": "PKCS12",
        "transforms.FilterFields.metadata.service.url": "http://metainfo-service",
        "schema.name.adjustment.mode": "avro",
        "schema.history.internal.producer.ssl.truststore.location": "/opt/kafka/external-configuration/cluster-ca-cert/ca.p12",
        "table.include.list": "P1BOFF.BOFF_ACCOUNTING,P1BOFF.BOFF_DELIVERY_RUN,P1BOFF.BOFF_DELIVERY_RUN_ORS_CVRS,P1BOFF.BOFF_LOCATION_DELIVERY,P1BOFF.BOFF_ORDER,P1BOFF.BOFF_ORDER_ITEM_PACKAGING,P1BOFF.BOFF_ORDER_LINE,P1BOFF.BOFF_ORDER_LINE_PROMO,P1BOFF.BOFF_VEHICLE_TYPE,P1EFIN.CHECKSUMS_PAYMENTS,P1QMS.QMS_DEBEZIUM_SIGNAL"
      }

      What is the captured database version and mode of depoyment?

      Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
      Version 19.13.0.0.0

      What behaviour do you expect?

      no errors

      What behaviour do you see?

      errors in logs  - connector stops

      Do you see the same behaviour using the latest relesead Debezium version?

      Checked only with 2.1.3.Final

      Do you have the connector logs, ideally from start till finish?

      Attached

       

      Attachments

        Issue Links

          Activity

            People

              rh-ee-mvitale Mario Fiore Vitale
              dzmitry.kaubenia Dzmitry Kaubenia (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: