DM optimistic fail sync data when restart master or worker frequently

[WizardXiao]

Which jobs are flaking?

https://ci2.pingcap.net/blue/organizations/jenkins/dm_ghpr_integration_test/detail/dm_ghpr_integration_test/5855/pipeline/

Which test(s) are flaking?

IT shardddl4_1/DM-155 optimistic

Jenkins logs or GitHub Actions link

[2022-05-18T09:28:55.766Z] [2022/05/18 17:28:23.346 +08:00] [DEBUG] [source_worker.go:197] ["runtime status"] [component="worker controller"] [status="{\n    \"status\": [\n        {\n            \"name\": \"test\",\n            \"stage\": \"Paused\",\n            \"unit\": \"Sync\",\n            \"result\": {\n                \"isCanceled\": false,\n                \"errors\": [\n                    {\n                        \"ErrCode\": 36027,\n                        \"ErrClass\": \"sync-unit\",\n                        \"ErrScope\": \"internal\",\n                        \"ErrLevel\": \"high\",\n                        \"Message\": \"startLocation: [position: (dm-integration-test-go1180-5855-lxrlz-pqmwr-bin|000001.000001, 175923), gtid-set: ce5c8dfc-d68b-11ec-b933-d289d6da190a:1-716], endLocation: [position: (dm-integration-test-go1180-5855-lxrlz-pqmwr-bin|000001.000001, 175979), gtid-set: ce5c8dfc-d68b-11ec-b933-d289d6da190a:1-716]: gen insert sqls failed, sourceTable: `shardddl1`.`tb1`, targetTable: `shardddl`.`tb`: Column count doesn't match value count: 4 (columns) vs 5 (values)\",\n                        \"RawCause\": \"\",\n                        \"Workaround\": \"Please check the log files to see if a related DDL has been skipped, and you could use `operate-schema` to get and set the table structure.\"\n                    }\n                ],\n                \"detail\": null\n            },\n            \"unresolvedDDLLockID\": \"\",\n            \"sync\": {\n                \"totalEvents\": \"22\",\n                \"totalTps\": \"0\",\n                \"recentTps\": \"0\",\n                \"masterBinlog\": \"(dm-integration-test-go1180-5855-lxrlz-pqmwr-bin.000001, 186753)\",\n                \"masterBinlogGtid\": \"ce5c8dfc-d68b-11ec-b933-d289d6da190a:1-753\",\n                \"syncerBinlog\": \"(dm-integration-test-go1180-5855-lxrlz-pqmwr-bin|000001.000001, 173995)\",\n                \"syncerBinlogGtid\": \"ce5c8dfc-d68b-11ec-b933-d289d6da190a:1-708\",\n                \"blockingDDLs\": [\n                ],\n                \"unresolvedGroups\": [\n                ],\n                \"synced\": false,\n                \"binlogType\": \"local\",\n                \"secondsBehindMaster\": \"0\",\n                \"blockDDLOwner\": \"\",\n                \"conflictMsg\": \"\"\n            }\n        }\n    ]\n}"]

Anything else we need to know

it need to wait sync ddl finish like https://github.com/pingcap/tiflow/blob/master/dm/tests/shardddl_optimistic/run.sh#L176