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

MySQL connector doesn't need to query binlog when snapshotting only

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Minor Minor
    • 2.2.0.CR1
    • None
    • mysql-connector
    • None
    • Low

      What Debezium connector do you use and what version?

      MySQL connector and Debezium 2.x.x

      What is the connector configuration?

      snapshot.mode = initial_only, everything else is irrelevant.

      What is the captured database version and mode of depoyment?

      On premise MySQL 5.7 server.

      What behaviour do you expect?

      When running the connector with the initial_only snapshot mode, the connector stops after the snapshot is performed. Since the snapshot is a simple SELECT query that doesn't require the bin log, we don't care about the bin log being enabled and configured properly. This is only a concern for MySQL 5.7 as version 8 works off the shelf.

       What behaviour do you see?

      Fails with when trying to fetch the bin log file through:
      "SHOW MASTER STATUS"

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

      Yes.

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

      (You might be asked later to provide DEBUG/TRACE level log)

      I do but they wouldn't be required as I know where it fails and intend to supply a fix.

      How to reproduce the issue using our tutorial deployment?

      No need.

       

              Unassigned Unassigned
              mark.bereznitsky Mark Bereznitsky
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: