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

CREATE TABLE with JSON-based CHECK constraint clause causes MultipleParsingExceptions

XMLWordPrintable

    • False
    • None
    • False

      Bug report

      For bug reports, provide this information, please:

      The connector throws exception:

      DDL statement couldn't be parsed. Please open a Jira issue with the statement 'revoke select on ORDERS from SV_DEBEZIUM_CDC;

      What Debezium connector do you use and what version?

      1.9.5.Final

      What is the connector configuration?

      {
        "name": "debezium-orders-connector",
        "config": {
          "connector.class" : "io.debezium.connector.oracle.OracleConnector",
          "tasks.max" : "1",
          "database.server.name" : "debezium-orders-connector",
          "database.hostname" : "db_server_ip",
          "database.url": "jdbc:oracle:thin:@db_server_ip:1521:ORCLCDB",
          "database.user" : "connector_db_user",
          "database.password" : "connector_db_pwd",
          "database.dbname" : "ORCLCDB",
          "database.connection.adapter" : "logminer",
          "log.mining.strategy": "online_catalog",
          "lob.enabled": "true",
          "database.history.kafka.bootstrap.servers" : "kafka:9092",
          "database.history.kafka.topic": "local.db.history-changes",
          "snapshot.mode": "schema_only",
          "table.include.list": "C##TESTER.ORDERS",
          "decimal.handling.mode": "string",
          "transforms": "Reroute, RerouteSchemaTopic",
          "transforms.Reroute.type": "io.debezium.transforms.ByLogicalTableRouter",
          "transforms.Reroute.topic.regex": ".*(.ORDERS)", 
          "transforms.Reroute.topic.replacement": "local.order-out",
          "transforms.RerouteSchemaTopic.type": "io.debezium.transforms.ByLogicalTableRouter",
          "transforms.RerouteSchemaTopic.topic.regex": "debezium-orders-connector", 
          "transforms.RerouteSchemaTopic.topic.replacement": "local.db.schema-changes",
          "key.converter": "org.apache.kafka.connect.json.JsonConverter",
          "key.converter.schemas.enable": "false",
          "value.converter": "io.confluent.connect.avro.AvroConverter",
          "value.converter.schema.registry.url": "http://schema-registry:8081",
          "value.converter.schemas.enable": "false",
          "database.history.store.only.captured.tables.ddl": "true"
        }
      }

      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?

      Did not check

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

      attached

       

            ccranfor@redhat.com Chris Cranford
            dzmitry.kaubenia Dzmitry Kaubenia (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: