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

Debezium 2.0.0.Beta1 Azure SQL breaking change

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 2.0.0.CR1
    • 2.0.0.Beta1
    • sqlserver-connector
    • None
    • False
    • None
    • False

      Bug report

      For bug reports, provide this information, please:

      What Debezium connector do you use and what version?

      Debezium 2.0.0.Beta1

      What is the connector configuration?

       

      "connector.class": "io.debezium.connector.sqlserver.SqlServerConnector",
      "database.hostname": "<server>",
      "database.port": "1433",
      "database.user": "${file:/secrets/dev.properties:user}",
      "database.password": "${file:/secrets/dev.properties:password}",
      "database.server.name": "<server>",
      "database.names": "test-db",
      "table.include.list": "dbo.Payments,dbo.Step_FeePayments",
      "snapshot.mode": "schema_only",
      "database.history.kafka.topic": "db-events-history",
      "transforms": "Reroute,flatten,ValueToKey",
      "transforms.Reroute.type": "io.debezium.transforms.ByLogicalTableRouter",
      "transforms.Reroute.topic.regex": ".*",
      "transforms.Reroute.topic.replacement": "db-events",
      "transforms.flatten.type": "org.apache.kafka.connect.transforms.Flatten$Value",
      "transforms.flatten.delimiter": ".",
      "transforms.ValueToKey.type": "org.apache.kafka.connect.transforms.ValueToKey",
      "transforms.ValueToKey.fields": "source.db",
      "topic.creation.default.replication.factor": 1,
      "topic.creation.default.partitions": 10,
      "database.history.kafka.bootstrap.servers": "<bootstrap server>",
      "database.history.consumer.security.protocol": "SASL_SSL",
      "database.history.consumer.ssl.endpoint.identification.algorithm": "https",
      "database.history.consumer.sasl.mechanism": "PLAIN",
      "database.history.consumer.sasl.jaas.config": "${file:/secrets/dev.properties:confluentAuth}",
      "database.history.producer.security.protocol": "SASL_SSL",
      "database.history.producer.ssl.endpoint.identification.algorithm": "https",
      "database.history.producer.sasl.mechanism": "PLAIN",
      "database.history.producer.sasl.jaas.config": "${file:/secrets/dev.properties:confluentAuth}",
      "value.convertor": "org.apache.kafka.connect.json.JsonConverter",
      "value.converter.schemas.enable": "false"

      What is the captured database version and mode of depoyment?

      Microsoft SQL Azure (RTM) - 12.0.2000.8 

      What behaviour do you expect?

      Debezium 2.0.0.Beta1 to connect with either single or multiple `database.names` listed.

      What behaviour do you see?

      Debezium will perform a check to see if CDC is enabled. The query it's attempting to perform `EXEC db.sys.sp_cdc_help_change_data_capture` this is not a valid query in Azure SQL. This causes the server to fail the check and Debezium to not connect.

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

      Yes it is in the most recent 2.0.0.Beta1. Debezium currently works with 1.9.5.Final using Azure SQL.

              Unassigned Unassigned
              tgrimesog Timothy Grimes (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

                Created:
                Updated:
                Resolved: