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

remove table.whitelist not work

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate Issue
    • Affects Version/s: 1.0.0.Final
    • Fix Version/s: None
    • Component/s: mysql-connector
    • Labels:
      None

      Description

      First, I used table.whitelist to create a mysql connector.

      Then, after a few hours, I want to monitor all the tables in this database.

      Then, I removed the table.whitelist item

      However, the history topic still shows only the ddl of table.whitelist. Even if schema_only_recovery is set, delete historical topics and regenerate historical topics.

      {
          "connector.class": "io.debezium.connector.mysql.MySqlConnector",
          "snapshot.locking.mode": "none",
          "database.user": "**",
          "database.server.id": "***",
          "tasks.max": "1",
          "database.history.kafka.bootstrap.servers": "**",
          "database.history.kafka.topic": "",
          "database.server.name": "**",
          "database.port": "3306",
          "decimal.handling.mode": "string",
          "database.hostname": "**",
          "database.password": "****",
          "name": "mysql-****-1",
          "database.history.store.only.monitored.tables.ddl": "true",
          "database.whitelist": "aaa",
          "table.whitelist": "aaa.btable"
          "snapshot.mode": "schema_only"
      }
      

      Then, I add table.blacklist: "aaa.test1", and recreate history topic.

      However, the message in the topic of offsets still show the original whitelist:

      {
          "table.whitelist": "aaa.btable",
          "table.blacklist": null
      }
      

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  kai.hou kai hou
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: