Error 1027 - Unsupported BinLog format

Last updated on Oct 21, 2022
Error Code 1027
Error Message Text(s) - Unsupported bin-log format found. Supported formats: [ROW]

Potential Causes

  • The binlog_format server parameter is not set to ROW. Hevo requires the ROW format for log-based replication.

Diagnosis

Launch an SQL prompt and run the following query:

SHOW VARIABLES LIKE 'binlog_format'; # This should return ROW for successful <span class='glossary-term' data-toggle='glossary-tooltip' data-class='glossary-tooltip' data-for='BinLog'>BinLog</span>-based replication

Suggested Actions


Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Sep-05-2022 NA Brought this page under its respective Source documentation folder.
Aug-23-2021 1.70 New document.

Tell us what went wrong