[FLINK-39207][mysql] Fix mysql cdc could get stuck in backfill binlog reading when reuse snapshot split reader #2148

Job	Run time
License Check	5m 59s
Common Unit Tests / test (11, generic, core)	14m 4s
Source Unit Tests / test (11, generic, mysql-source)	8m 9s
Source Unit Tests / test (11, generic, postgres-source, oceanbase-source, tidb, vitess)	37m 12s
Source Unit Tests / test (11, generic, oracle, sqlserver)	47m 47s
Source E2E Tests / test (11, 1.20.3, source_e2e)	24m 57s
Source E2E Tests / test (11, 1.19.3, source_e2e)	26m 5s
Pipeline E2E Tests (1-Parallelism) / test (11, 1.20.3, pipeline_e2e)	1h 20m 45s
Source Unit Tests / test (11, generic, db2, mongodb)	44m 1s
Pipeline E2E Tests (1-Parallelism) / test (11, 1.19.3, pipeline_e2e)	1h 24m 13s
Pipeline E2E Tests (4-Parallelism) / test (11, 1.20.3, pipeline_e2e)	1h 22m 0s
Pipeline Unit Tests / test (11, generic, doris, elasticsearch, fluss, hudi, iceberg, kafka, maxcompute, mysql-pipeline,...	1h 0m 44s
Pipeline E2E Tests (4-Parallelism) / test (11, 1.19.3, pipeline_e2e)	1h 20m 24s
	9h 56m 20s

Provide feedback