The connector is trying to read binlog starting at binlog file 'mysql-bin.000003', pos=..., but this is no longer available on the server

Root cause

The MySQL/MariaDB binlog file recorded in the connector's offset has been purged before the connector could read it. Binlog retention is controlled by binlog_expire_logs_seconds (MySQL 8.0+) or expire_logs_days (MySQL 5.7). Connectors that are stopped for more than the retention window will always hit this.

How to fix

1. Check available binlogs:
   SHOW BINARY LOGS;
2. Increase binlog retention — MySQL 8.0+:
   SET GLOBAL binlog_expire_logs_seconds = 604800; (7 days)
3. MySQL 5.7:
   SET GLOBAL expire_logs_days = 7;
4. To recover: delete the connector, recreate it (triggers a full re-snapshot), or set snapshot.mode=when_needed.
5. Never PURGE BINARY LOGS while the connector offset still references those files.