Details
-
Bug
-
Resolution: Duplicate
-
Major
-
None
-
1.0.0.Final
-
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
}
