Diese Seite ist in Ihrer lokalen Sprache noch nicht verfügbar. Wir arbeiten daran, weitere Sprachversionen hinzuzufügen. Vielen Dank für Ihre Unterstützung.

On this page

Canal Fails to Parse Binlogs

Updated on 2023-10-19 GMT+08:00

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.

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback