Issue with MySQL Binlog (CDC) sync to Clickhouse

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

The user is facing issues with a MySQL Binlog (CDC) sync to Clickhouse. The initial sync runs fine, but the subsequent sync reports ‘Saved offset no longer present on the server’. User is seeking advice on resolving the issue.


Question

Hi all, I’m having issues with a MySQL Binlog (CDC) sync to clickhouse. The initial sync runs fine, but the subsequent sync (1 hour later) reported the following:

> Saved offset no longer present on the server. Please reset the connection, and then increase binlog retention and/or increase sync frequency.
Our binlog is set to store 1 month’s history, and this is not a high traffic database at all.

Any ideas on what is going wrong here?


This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

["mysql-binlog", "cdc", "clickhouse", "sync", "binlog-retention", "sync-frequency"]