[FLINK-39621] Fix incremental-snapshot based sources may get stuck in binlog-backfill stage #2453

Job	Run time
License Check	4m 34s
Pipeline Unit Tests / test (11, generic, doris, elasticsearch, fluss, hudi, iceberg, kafka, maxcompute, mysql-pipeline,...	1h 2m 28s
Pipeline Connectors Unit Tests 2.x / test (11, 2.2.0, doris, elasticsearch, fluss, iceberg, kafka, maxcompute, mysql-pipeline, oceanba...	1h 2m 56s
Source Unit Tests 2.x / test (11, 2.2.0, postgres-source, oceanbase-source, tidb, vitess)	49m 16s
Source Unit Tests 2.x / test (11, 2.2.0, oracle, sqlserver)	40m 26s
Source Unit Tests 2.x / test (11, 2.2.0, mysql-source)	41m 14s
Common Unit Tests 2.x / test (11, 2.2.0, core)	13m 57s
Source Unit Tests / test (11, generic, oracle, sqlserver)	48m 17s
Source Unit Tests 2.x / test (11, 2.2.0, db2, mongodb)	33m 58s
Source E2E Tests / test (11, 1.20.3, source_e2e)	27m 17s
Source Unit Tests / test (11, generic, mysql-source)	46m 9s
Source Unit Tests / test (11, generic, postgres-source, oceanbase-source, tidb, vitess)	1h 1m 23s
Source Unit Tests / test (11, generic, db2, mongodb)	43m 46s
Common Unit Tests / test (11, generic, core)	13m 21s
Pipeline E2E Tests (1-Parallelism) / test (11, 1.20.3, pipeline_e2e)	1h 23m 10s
Pipeline E2E Tests (4-Parallelism) / test (11, 1.20.3, pipeline_e2e)	1h 18m 44s
Pipeline E2E Tests 2.x (4-Parallelism) / test (11, 2.2.0, pipeline_e2e)	1h 0m 20s
Pipeline E2E Tests 2.x (1-Parallelism) / test (11, 2.2.0, pipeline_e2e)	1h 1m 21s
	13h 52m 37s

Provide feedback