-
Bug
-
Resolution: Done
-
Major
-
None
-
None
Note: This ticket may (or may not) be a duplicate of:
https://issues.jboss.org/browse/DBZ-413
It would seem that TRUNCATE TABLE events are not being emitted to either the (for connector use only) database history topic nor the schema change topic.
Both of these topics are receiving events for other DDL events, for example:
null {
"source" : {
"server" : "dev_db1"
},
"position" : {
"ts_sec" : 1527864397,
"file" : "dev-db1-bin.000006",
"pos" : 1887472,
"server_id" : 1,
"event" : 1
},
"databaseName" : "vcmeta",
"ddl" : "ALTER TABLE `twh` CHANGE `a` `a` INT(11) NULL DEFAULT NULL"
}
{"schema":{"type":"struct","fields":[{"type":"string","optional":false,"field":"databaseName"}],"optional":false,"name":"io.debezium.connector.mysql.SchemaChangeKey"},"payload":{"databaseName":"vcmeta"}} {"schema":{"type":"struct","fields":[{"type":"struct","fields":[{"type":"string","optional":true,"field":"version"},{"type":"string","optional":false,"field":"name"},{"type":"int64","optional":false,"field":"server_id"},{"type":"int64","optional":false,"field":"ts_sec"},{"type":"string","optional":true,"field":"gtid"},{"type":"string","optional":false,"field":"file"},{"type":"int64","optional":false,"field":"pos"},{"type":"int32","optional":false,"field":"row"},{"type":"boolean","optional":true,"default":false,"field":"snapshot"},{"type":"int64","optional":true,"field":"thread"},{"type":"string","optional":true,"field":"db"},{"type":"string","optional":true,"field":"table"}],"optional":false,"name":"io.debezium.connector.mysql.Source","field":"source"},{"type":"string","optional":false,"field":"databaseName"},{"type":"string","optional":false,"field":"ddl"}],"optional":false,"name":"io.debezium.connector.mysql.SchemaChangeValue"},"payload":{"source":{"version":"0.7.5","name":"dev_db1","server_id":1,"ts_sec":1527864397,"gtid":null,"file":"dev-db1-bin.000006","pos":1887321,"row":0,"snapshot":false,"thread":null,"db":null,"table":null},"databaseName":"vcmeta","ddl":"ALTER TABLE `twh` CHANGE `a` `a` INT(11) NULL DEFAULT NULL"}}
Any insight would be greatly appreciated. Thank you!
- relates to
-
DBZ-413 TRUNCATE TABLE events to be emitted in respective kafka topics
-
- Closed
-
