Help Center/ GaussDB(for MySQL)/ Troubleshooting/ Backup and Restoration Issues/ Canal Fails to Parse Binlogs
Updated on 2024-09-05 GMT+08:00
View PDF
Share

Canal Fails to Parse Binlogs

Scenario

An error occurred when Canal parsed binlogs, interrupting binlog collection. The error message is as follows:

com.alibaba.otter.canal.parse.exception.CanalParseException: java.lang.NumberFormatException:- Caused by: java.lang.NumberFormatException:  - at com.alibaba.fastsql.sql.parser.Lexer.integerValue(Lexer.java:2454)

Possible Causes

Check whether the value of binlog_rows_query_log_events of your instance is set to 1 or ON.

  • Canal supports only subscriptions to binlogs in row format.
  • When the value of binlog_rows_query_log_events 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 to OFF and restart the interrupted Canal task.