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

Skip "SHOW TABLES IN" for blacklisted database during snapshot

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Done
    • Icon: Minor Minor
    • 0.3.6, 0.4
    • None
    • mysql-connector
    • None

      When starting the mysql-connector all available databases are checked using the "SHOW TABLES IN db" command. Due to a bug (https://bugs.mysql.com/bug.php?id=22615) a database named "#mysql50#lost+found" can be present. Running "SHOW TABLES IN #mysql50#lost+found" will throw a syntax error. The mysql-connector will attempt to run the command even if the database is blacklisted.

      It would be nice if blacklisted (or non-whitelisted) databases are excluded from this initial check.

              rhauch Randall Hauch (Inactive)
              tanooren Tim Nooren (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: