chunhongZheng opened a new issue, #9097: URL: https://github.com/apache/seatunnel/issues/9097
### Search before asking - [x] I had searched in the [issues](https://github.com/apache/seatunnel/issues?q=is%3Aissue+label%3A%22bug%22) and found no similar issues. ### What happened When trying to resume a streaming job using the -r <job_id> flag with HDFS-based checkpointing, the job fails due to a MySQL GTID purged error, even though the job was previously running correctly and the checkpoint files exist in HDFS. ### SeaTunnel Version SeaTunnel Version: 2.3.8 Connector: MySQL-CDC HDFS: Local HDFS configured and accessible Checkpoint path: /tmp/seatunnel/checkpoint_snapshot/<job_id> MySQL binlog expired/purged (default expiration) ### SeaTunnel Config ```conf env { job.mode="STREAMING" checkpoint.interval=10000 parallelism=1 } source { MySQL-CDC { password="****" username="root" base-url="jdbc:mysql://<host>:3306/db" table-names=["db.table"] startup.mode = SPECIFIC startup.specific-offset.file = "mysql-bin.001143" startup.specific-offset.pos = 5389 } } transform { Sql { query = "SELECT * FROM table WHERE id IS NOT NULL" } } sink { jdbc { url = "jdbc:postgresql://<host>:5432/db" table = "public.table" primary_keys = ["id"] } } ``` ### Running Command ```shell ./seatunnel.sh -r <job_id> -c path/to/conf ``` ### Error Exception ```log org.apache.seatunnel.engine.common.exception.SeaTunnelEngineException: java.lang.RuntimeException: One or more fetchers have encountered exception ... Caused by: com.github.shyiko.mysql.binlog.network.ServerException: The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master has purged binary logs containing GTIDs that the slave requires. ``` ### Zeta or Flink or Spark Version _No response_ ### Java or Scala Version jdk1.8 ### Screenshots  ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
