Scenario Description
An error is reported when Canal parses Binlogs, interrupting binlog collection.
Possible Causes
Check whether the value of binlog_rows_query_log_events of MySQL is set to 1 or ON.
• In this version, Canal supports only subscriptions to binlogs in row format.
• When the value of binlog_rows_query_log_events of your RDS for MySQL instance is set to 1 or ON, Rows_query events are generated in binlogs. These events are not in row format. In certain scenarios, blank topics may occur in Canal, resulting in a binlog parsing failure.
Solution
Change the value of binlog_rows_query_log_events parameter in MySQL to OFF and restart the interrupted Canal task.