flink-cdc icon indicating copy to clipboard operation
flink-cdc copied to clipboard
verified publisher icon apache

[mysql] Received DML 'DELETE FROM `db`.`table`' for processing, binlog probably contains events generated with statement or mixed based replication format

Open qq443672581 opened this issue 3 years ago • 3 comments

Environment :

  • Flink version : 1.13.5
  • Flink CDC version: 2.2.0
  • Database and version: 5.7.25-log

Caused by: io.debezium.DebeziumException: Received DML 'DELETE FROM db.table' for processing, binlog probably contains events generated with statement or mixed based replication format

qq443672581 avatar Aug 08 '22 03:08 qq443672581

This mail could be helpful. Maybe your binlog format changes in some sessions.

ruanhang1993 avatar Aug 08 '22 09:08 ruanhang1993

Debezium has a issue to fix this DBZ-3949. We could set event.deserialization.failure.handling.mode to warn to skip this failure.

ruanhang1993 avatar Aug 11 '22 09:08 ruanhang1993

Dupliacted to #1017.

ruanhang1993 avatar Aug 11 '22 10:08 ruanhang1993

Closing this issue because it was created before version 2.3.0 (2022-11-10). Please try the latest version of Flink CDC to see if the issue has been resolved. If the issue is still valid, kindly report it on Apache Jira under project Flink with component tag Flink CDC. Thank you!

PatrickRen avatar Feb 28 '24 15:02 PatrickRen