Error: Missing Column Data in Binary Log Event

Issue

While switching to a new replica, syncs fail. The following error appears:

Missing column data in binary log event

Environment

Connector: MySQL

Resolution

To resolve this issue, do the following:

1. Ensure the binlog_row_image binary logging system variable is set to FULL in global scope. For more information, see our MySQL setup guide. To see its current configuration, run the following command:

   SHOW VARIABLES LIKE 'binlog_row_image'
   

2. Restart the replica.

3. Trigger a full re-sync.

   i. In Fivetran, go to your MySQL connector page.

   ii. Select the Setup tab.

   iii. Click Resync all historical data.

   iv. In the confirmation pop-up window, click Re-sync Connector.

Cause

This issue occurs due to either of the following reasons:

• The binlog_row_image binary logging system variable is not set to FULL. This value may change while loading data using session variables.
• The binlog_row_image binary logging system variable is set to FULL for the replica database but not the master database.