br restore hang when creating table

[dbsid]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

[2023/01/03 13:03:28.317 +08:00] [INFO] [utils.go:403] ["\n    export AWS_ACCESS_KEY_ID=minioadmin AWS_SECRET_ACCESS_KEY=minioadmin\n    tiup br:nightly restore db --db=test --pd \"pd-peer.benchbot-sysbe
nch-a-base-master-1672531200-tps-1329820-1-224:2379\" \\\n        --storage \"s3://benchmark/sysbench-32-1000w-auto\" \\\n        --s3.endpoint \"http://minio.pingcap.net:9001/\" \\\n        --send-creden
tials-to-tikv=true \\\n\t\t--check-requirements=false "]

2. What did you expect to see? (Required)

no hang

3. What did you see instead (Required)

mysql> admin show ddl \G;
*************************** 1. row ***************************
   SCHEMA_VER: 40
     OWNER_ID: be7d4ece-fac2-4199-9b45-788bbee8d582
OWNER_ADDRESS: tidb-1-peer:4000
 RUNNING_JOBS: ID:1133, Type:create tables, State:done, SchemaState:public, SchemaID:2, TableID:1132, RowCount:0, ArgLen:0, start time: 2023-01-03 13:03:30.224 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0
      SELF_ID: be7d4ece-fac2-4199-9b45-788bbee8d582
        QUERY: /*from(br)*/CREATE TABLE `sbtest1` (
  `id` int(11) NOT NULL,
  `k` int(11) NOT NULL DEFAULT '0',
  `c` char(120) NOT NULL DEFAULT '',
  `pad` char(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */,
  KEY `k_1` (`k`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;/*from(br)*/CREATE TABLE `sbtest15` (
  `id` int(11) NOT NULL,
  `k` int(11) NOT NULL DEFAULT '0',
  `c` char(120) NOT NULL DEFAULT '',
  `pad` char(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */,
  KEY `k_15` (`k`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;/*from(br)*/CREATE TABLE `sbtest14` (...

[root@tiup-0 tmp]# tail br.log.2023-01-03T13.03.30+0800
[2023/01/03 15:28:30.153 +08:00] [INFO] [domain.go:2375] ["refreshServerIDTTL succeed"] [serverID=1833320] ["lease id"=db4857603068dec]
[2023/01/03 15:33:30.153 +08:00] [INFO] [domain.go:2375] ["refreshServerIDTTL succeed"] [serverID=1833320] ["lease id"=db4857603068dec]
[2023/01/03 15:38:30.153 +08:00] [INFO] [domain.go:2375] ["refreshServerIDTTL succeed"] [serverID=1833320] ["lease id"=db4857603068dec]
[2023/01/03 15:43:30.153 +08:00] [INFO] [domain.go:2375] ["refreshServerIDTTL succeed"] [serverID=1833320] ["lease id"=db4857603068dec]
[2023/01/03 15:48:30.153 +08:00] [INFO] [domain.go:2375] ["refreshServerIDTTL succeed"] [serverID=1833320] ["lease id"=db4857603068dec]
[2023/01/03 15:53:30.153 +08:00] [INFO] [domain.go:2375] ["refreshServerIDTTL succeed"] [serverID=1833320] ["lease id"=db4857603068dec]
[2023/01/03 15:58:30.153 +08:00] [INFO] [domain.go:2375] ["refreshServerIDTTL succeed"] [serverID=1833320] ["lease id"=db4857603068dec]
[2023/01/03 16:03:30.153 +08:00] [INFO] [domain.go:2375] ["refreshServerIDTTL succeed"] [serverID=1833320] ["lease id"=db4857603068dec]
[2023/01/03 16:08:30.153 +08:00] [INFO] [domain.go:2375] ["refreshServerIDTTL succeed"] [serverID=1833320] ["lease id"=db4857603068dec]
[2023/01/03 16:13:30.154 +08:00] [INFO] [domain.go:2375] ["refreshServerIDTTL succeed"] [serverID=1833320] ["lease id"=db4857603068dec]

[2023/01/03 16:24:19.784 +08:00] [INFO] [syncer.go:333] ["[ddl] syncer check all versions, someone is not synced"] [info="instance ip , port 4000, id 221eeb5d-28cb-4d62-be26-fa52491fad05"] ["ddl id"=1133] [ver=40]
[2023/01/03 16:24:19.805 +08:00] [INFO] [syncer.go:333] ["[ddl] syncer check all versions, someone is not synced"] [info="instance ip , port 4000, id 221eeb5d-28cb-4d62-be26-fa52491fad05"] ["ddl id"=1133] [ver=40]
[2023/01/03 16:24:19.826 +08:00] [INFO] [syncer.go:333] ["[ddl] syncer check all versions, someone is not synced"] [info="instance ip , port 4000, id 221eeb5d-28cb-4d62-be26-fa52491fad05"] ["ddl id"=1133] [ver=40]
[2023/01/03 16:24:19.847 +08:00] [INFO] [syncer.go:333] ["[ddl] syncer check all versions, someone is not synced"] [info="instance ip , port 4000, id 221eeb5d-28cb-4d62-be26-fa52491fad05"] ["ddl id"=1133] [ver=40]
[2023/01/03 16:24:19.869 +08:00] [INFO] [syncer.go:333] ["[ddl] syncer check all versions, someone is not synced"] [info="instance ip , port 4000, id 221eeb5d-28cb-4d62-be26-fa52491fad05"] ["ddl id"=1133] [ver=40]
[2023/01/03 16:24:19.890 +08:00] [INFO] [syncer.go:333] ["[ddl] syncer check all versions, someone is not synced"] [info="instance ip , port 4000, id 221eeb5d-28cb-4d62-be26-fa52491fad05"] ["ddl id"=1133] [ver=40]
[2023/01/03 16:24:19.911 +08:00] [INFO] [syncer.go:333] ["[ddl] syncer check all versions, someone is not synced"] [info="instance ip , port 4000, id 221eeb5d-28cb-4d62-be26-fa52491fad05"] ["ddl id"=1133] [ver=40]

4. What is your TiDB version? (Required)

latest master, same issue for tidb commit 91adaaf

[dbsid]

it's caused by the commit #39684