Question

Unable to read binary log and warning messaged displayed to re-sync the connector.

Environment

Connector: Aurora MySQL

Answer

1. As per the connector setup documentation, set the binary log retention period to a value between 24 and 168 hours using the following command (168 is set in the command):

CALL mysql.rds_set_configuration('binlog retention hours', 168);

2.  Re-sync the connector to sync any missed updates.  

Cause

The connector has not synced all updates from the binary log before they have expired.