tidb升级到7.5.0, tidb servers升级报错了怎么处理

zhanggame1 · 2023 年12 月 4 日 07:58

【 TiDB 使用环境】测试/
【 TiDB 版本】v.7.5.0
【复现路径】做过哪些操作出现的问题
【遇到的问题：问题现象及影响】
使用tiup cluster upgrade tidb-test v7.5.0 升级到tidb server组件出错了，这里怎么处理

看了下集群状态这样的

tidb.txt (3.7 MB)

芮芮是产品 · 2023 年12 月 4 日 08:02

让你去查一下tidb的日志有启动失败的原因

Billmay表妹 · 2023 年12 月 4 日 08:03

你翻译一下报错，哪里给你指出了去看日志。

zhanggame1 · 2023 年12 月 4 日 08:06

zhanggame1 · 2023 年12 月 4 日 08:11

有猫万事足 · 2023 年12 月 4 日 08:18

// CreateRunawayWatchTable stores the condition which is used to check whether query should be quarantined.
CreateRunawayWatchTable = CREATE TABLE IF NOT EXISTS mysql.tidb_runaway_watch ( id BIGINT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY, resource_group_name varchar(32) not null, start_time datetime(6) NOT NULL, end_time datetime(6), watch bigint(10) NOT NULL, watch_text TEXT NOT NULL, source varchar(512) NOT NULL, action bigint(10), INDEX sql_index(resource_group_name,watch_text(700)) COMMENT "accelerate the speed when select quarantined query", INDEX time_index(end_time) COMMENT "accelerate the speed when querying with active watch" ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

// CreateDoneRunawayWatchTable stores the condition which is used to check whether query should be quarantined.
CreateDoneRunawayWatchTable = CREATE TABLE IF NOT EXISTS mysql.tidb_runaway_watch_done ( id BIGINT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY, record_id BIGINT(20) not null, resource_group_name varchar(32) not null, start_time datetime(6) NOT NULL, end_time datetime(6), watch bigint(10) NOT NULL, watch_text TEXT NOT NULL, source varchar(512) NOT NULL, action bigint(10), done_time TIMESTAMP(6) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

可能升级的时候执行建表的sql失败了。用root手工建立一下看看。

芮芮是产品 · 2023 年12 月 4 日 08:19

表见一下

zhanggame1 · 2023 年12 月 4 日 08:21

手工建表的做完然后做什么操作吗，目前版本没升级上去，手工建表成功了

有猫万事足 · 2023 年12 月 4 日 08:30

那不怕，因为给你的这个建表语句就是bootstrap.go里面扒出来的。

你看他有个IF NOT EXISTS。所以没升上去的话，重启tidb，这个bootstrap.go里面的代码会尝试再升级一次，并不会有什么大问题。

芮芮是产品 · 2023 年12 月 4 日 08:39

太棒了撒花庆祝

zhanggame1 · 2023 年12 月 4 日 08:42

建表后重新升级成功了版本8.0.11-TiDB-v7.5.0

tidb@center:~$ tiup cluster upgrade tidb-test v7.5.0
tiup is checking updates for component cluster ...
Starting component `cluster`: /home/tidb/.tiup/components/cluster/v1.14.0/tiup-cluster upgrade tidb-test v7.5.0
Before the upgrade, it is recommended to read the upgrade guide at https://docs.pingcap.com/tidb/stable/upgrade-tidb-using-tiup and finish the preparation steps.
This operation will upgrade tidb v7.1.2 cluster tidb-test to v7.5.0:
will upgrade component           "tiflash" to "v7.5.0",
will upgrade component                "pd" to "v7.5.0",
will upgrade component              "tikv" to "v7.5.0",
will upgrade component              "tidb" to "v7.5.0",
will upgrade component        "prometheus" to "v7.5.0",
will upgrade component           "grafana" to "v7.5.0",
will upgrade component      "alertmanager" to "",
will upgrade component     "node-exporter" to "",
will upgrade component "blackbox-exporter" to "".
Do you want to continue? [y/N]:(default=N) y
Upgrading cluster...
+ [ Serial ] - SSHKeySet: privateKey=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/ssh/id_rsa, publicKey=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/ssh/id_rsa.pub
+ [Parallel] - UserSSH: user=tidb, host=10.10.10.208
+ [Parallel] - UserSSH: user=tidb, host=10.10.10.211
+ [Parallel] - UserSSH: user=tidb, host=10.10.10.210
+ [Parallel] - UserSSH: user=tidb, host=10.10.10.210
+ [Parallel] - UserSSH: user=tidb, host=10.10.10.209
+ [Parallel] - UserSSH: user=tidb, host=10.10.10.212
+ [Parallel] - UserSSH: user=tidb, host=10.10.10.221
+ [Parallel] - UserSSH: user=tidb, host=10.10.10.220
+ [Parallel] - UserSSH: user=tidb, host=10.10.10.211
+ [Parallel] - UserSSH: user=tidb, host=10.10.10.100
+ [Parallel] - UserSSH: user=tidb, host=10.10.10.100
+ [Parallel] - UserSSH: user=tidb, host=10.10.10.207
+ [Parallel] - UserSSH: user=tidb, host=10.10.10.212
+ [Parallel] - UserSSH: user=tidb, host=10.10.10.100
+ [ Serial ] - Download: component=prometheus, version=v7.5.0, os=linux, arch=amd64
+ [ Serial ] - Download: component=tidb, version=v7.5.0, os=linux, arch=amd64
+ [ Serial ] - Download: component=tikv, version=v7.5.0, os=linux, arch=amd64
+ [ Serial ] - Download: component=pd, version=v7.5.0, os=linux, arch=amd64
+ [ Serial ] - Download: component=tiflash, version=v7.5.0, os=linux, arch=amd64
+ [ Serial ] - Download: component=grafana, version=v7.5.0, os=linux, arch=amd64
+ [ Serial ] - Download: component=alertmanager, version=, os=linux, arch=amd64
download monitored
  - Download node_exporter: (linux/amd64) ... Done
  - Download blackbox_exporter: (linux/amd64) ... Done
+ [ Serial ] - Mkdir: host=10.10.10.212, directories='/tidb-data/pd-2379'
+ [ Serial ] - Mkdir: host=10.10.10.220, directories='/tidb-data/tiflash-9000'
+ [ Serial ] - Mkdir: host=10.10.10.221, directories='/tidb-data/tiflash-9000'
+ [ Serial ] - Mkdir: host=10.10.10.210, directories='/tidb-data/pd-2379'
+ [ Serial ] - Mkdir: host=10.10.10.211, directories='/tidb-data/pd-2379'
+ [ Serial ] - BackupComponent: component=pd, currentVersion=v7.1.2, remote=10.10.10.211:/tidb-deploy/pd-2379
+ [ Serial ] - CopyComponent: component=pd, version=v7.5.0, remote=10.10.10.211:/tidb-deploy/pd-2379 os=linux, arch=amd64
+ [ Serial ] - BackupComponent: component=pd, currentVersion=v7.1.2, remote=10.10.10.210:/tidb-deploy/pd-2379
+ [ Serial ] - BackupComponent: component=pd, currentVersion=v7.1.2, remote=10.10.10.212:/tidb-deploy/pd-2379
+ [ Serial ] - BackupComponent: component=tiflash, currentVersion=v7.1.2, remote=10.10.10.220:/tidb-deploy/tiflash-9000
+ [ Serial ] - BackupComponent: component=tiflash, currentVersion=v7.1.2, remote=10.10.10.221:/tidb-deploy/tiflash-9000
+ [ Serial ] - CopyComponent: component=pd, version=v7.5.0, remote=10.10.10.210:/tidb-deploy/pd-2379 os=linux, arch=amd64
+ [ Serial ] - CopyComponent: component=pd, version=v7.5.0, remote=10.10.10.212:/tidb-deploy/pd-2379 os=linux, arch=amd64
+ [ Serial ] - CopyComponent: component=tiflash, version=v7.5.0, remote=10.10.10.220:/tidb-deploy/tiflash-9000 os=linux, arch=amd64
+ [ Serial ] - CopyComponent: component=tiflash, version=v7.5.0, remote=10.10.10.221:/tidb-deploy/tiflash-9000 os=linux, arch=amd64
+ [ Serial ] - InitConfig: cluster=tidb-test, user=tidb, host=10.10.10.211, path=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/config-cache/pd-2379.service, deploy_dir=/tidb-deploy/pd-2379, data_dir=[/tidb-data/pd-2379], log_dir=/tidb-deploy/pd-2379/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/config-cache
+ [ Serial ] - InitConfig: cluster=tidb-test, user=tidb, host=10.10.10.210, path=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/config-cache/pd-2379.service, deploy_dir=/tidb-deploy/pd-2379, data_dir=[/tidb-data/pd-2379], log_dir=/tidb-deploy/pd-2379/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/config-cache
+ [ Serial ] - InitConfig: cluster=tidb-test, user=tidb, host=10.10.10.212, path=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/config-cache/pd-2379.service, deploy_dir=/tidb-deploy/pd-2379, data_dir=[/tidb-data/pd-2379], log_dir=/tidb-deploy/pd-2379/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/config-cache
+ [ Serial ] - Mkdir: host=10.10.10.207, directories='/tidb-data/tikv-20160'
+ [ Serial ] - BackupComponent: component=tikv, currentVersion=v7.1.2, remote=10.10.10.207:/tidb-deploy/tikv-20160
+ [ Serial ] - Mkdir: host=10.10.10.208, directories='/tidb-data/tikv-20160'
+ [ Serial ] - Mkdir: host=10.10.10.209, directories='/tidb-data/tikv-20160'
+ [ Serial ] - CopyComponent: component=tikv, version=v7.5.0, remote=10.10.10.207:/tidb-deploy/tikv-20160 os=linux, arch=amd64
+ [ Serial ] - InitConfig: cluster=tidb-test, user=tidb, host=10.10.10.221, path=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/config-cache/tiflash-9000.service, deploy_dir=/tidb-deploy/tiflash-9000, data_dir=[/tidb-data/tiflash-9000], log_dir=/tidb-deploy/tiflash-9000/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/config-cache
+ [ Serial ] - BackupComponent: component=tikv, currentVersion=v7.1.2, remote=10.10.10.208:/tidb-deploy/tikv-20160
+ [ Serial ] - InitConfig: cluster=tidb-test, user=tidb, host=10.10.10.220, path=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/config-cache/tiflash-9000.service, deploy_dir=/tidb-deploy/tiflash-9000, data_dir=[/tidb-data/tiflash-9000], log_dir=/tidb-deploy/tiflash-9000/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/config-cache
+ [ Serial ] - CopyComponent: component=tikv, version=v7.5.0, remote=10.10.10.208:/tidb-deploy/tikv-20160 os=linux, arch=amd64
+ [ Serial ] - BackupComponent: component=tikv, currentVersion=v7.1.2, remote=10.10.10.209:/tidb-deploy/tikv-20160
+ [ Serial ] - CopyComponent: component=tikv, version=v7.5.0, remote=10.10.10.209:/tidb-deploy/tikv-20160 os=linux, arch=amd64
+ [ Serial ] - Mkdir: host=10.10.10.210, directories=''
+ [ Serial ] - BackupComponent: component=tidb, currentVersion=v7.1.2, remote=10.10.10.210:/tidb-deploy/tidb-4000
+ [ Serial ] - Mkdir: host=10.10.10.211, directories=''
+ [ Serial ] - BackupComponent: component=tidb, currentVersion=v7.1.2, remote=10.10.10.211:/tidb-deploy/tidb-4000
+ [ Serial ] - CopyComponent: component=tidb, version=v7.5.0, remote=10.10.10.211:/tidb-deploy/tidb-4000 os=linux, arch=amd64
+ [ Serial ] - CopyComponent: component=tidb, version=v7.5.0, remote=10.10.10.210:/tidb-deploy/tidb-4000 os=linux, arch=amd64
+ [ Serial ] - InitConfig: cluster=tidb-test, user=tidb, host=10.10.10.207, path=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/config-cache/tikv-20160.service, deploy_dir=/tidb-deploy/tikv-20160, data_dir=[/tidb-data/tikv-20160], log_dir=/tidb-deploy/tikv-20160/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/config-cache
+ [ Serial ] - InitConfig: cluster=tidb-test, user=tidb, host=10.10.10.208, path=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/config-cache/tikv-20160.service, deploy_dir=/tidb-deploy/tikv-20160, data_dir=[/tidb-data/tikv-20160], log_dir=/tidb-deploy/tikv-20160/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/config-cache
+ [ Serial ] - InitConfig: cluster=tidb-test, user=tidb, host=10.10.10.211, path=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/config-cache/tidb-4000.service, deploy_dir=/tidb-deploy/tidb-4000, data_dir=[], log_dir=/tidb-deploy/tidb-4000/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/config-cache
+ [ Serial ] - InitConfig: cluster=tidb-test, user=tidb, host=10.10.10.210, path=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/config-cache/tidb-4000.service, deploy_dir=/tidb-deploy/tidb-4000, data_dir=[], log_dir=/tidb-deploy/tidb-4000/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/config-cache
+ [ Serial ] - InitConfig: cluster=tidb-test, user=tidb, host=10.10.10.209, path=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/config-cache/tikv-20160.service, deploy_dir=/tidb-deploy/tikv-20160, data_dir=[/tidb-data/tikv-20160], log_dir=/tidb-deploy/tikv-20160/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/config-cache
+ [ Serial ] - Mkdir: host=10.10.10.212, directories=''
+ [ Serial ] - BackupComponent: component=tidb, currentVersion=v7.1.2, remote=10.10.10.212:/tidb-deploy/tidb-4000
+ [ Serial ] - Mkdir: host=10.10.10.100, directories='/tidb-data/prometheus-9090'
+ [ Serial ] - CopyComponent: component=tidb, version=v7.5.0, remote=10.10.10.212:/tidb-deploy/tidb-4000 os=linux, arch=amd64
+ [ Serial ] - Mkdir: host=10.10.10.100, directories=''
+ [ Serial ] - BackupComponent: component=grafana, currentVersion=v7.1.2, remote=10.10.10.100:/tidb-deploy/grafana-3000
+ [ Serial ] - CopyComponent: component=grafana, version=v7.5.0, remote=10.10.10.100:/tidb-deploy/grafana-3000 os=linux, arch=amd64
+ [ Serial ] - Mkdir: host=10.10.10.100, directories='/tidb-data/alertmanager-9093'
+ [ Serial ] - BackupComponent: component=prometheus, currentVersion=v7.1.2, remote=10.10.10.100:/tidb-deploy/prometheus-9090
+ [ Serial ] - CopyComponent: component=prometheus, version=v7.5.0, remote=10.10.10.100:/tidb-deploy/prometheus-9090 os=linux, arch=amd64
+ [ Serial ] - BackupComponent: component=alertmanager, currentVersion=v7.1.2, remote=10.10.10.100:/tidb-deploy/alertmanager-9093
+ [ Serial ] - CopyComponent: component=alertmanager, version=, remote=10.10.10.100:/tidb-deploy/alertmanager-9093 os=linux, arch=amd64
+ [ Serial ] - InitConfig: cluster=tidb-test, user=tidb, host=10.10.10.212, path=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/config-cache/tidb-4000.service, deploy_dir=/tidb-deploy/tidb-4000, data_dir=[], log_dir=/tidb-deploy/tidb-4000/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/config-cache
+ [ Serial ] - InitConfig: cluster=tidb-test, user=tidb, host=10.10.10.100, path=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/config-cache/alertmanager-9093.service, deploy_dir=/tidb-deploy/alertmanager-9093, data_dir=[/tidb-data/alertmanager-9093], log_dir=/tidb-deploy/alertmanager-9093/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/config-cache
+ [ Serial ] - InitConfig: cluster=tidb-test, user=tidb, host=10.10.10.100, path=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/config-cache/grafana-3000.service, deploy_dir=/tidb-deploy/grafana-3000, data_dir=[], log_dir=/tidb-deploy/grafana-3000/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/config-cache
+ [ Serial ] - InitConfig: cluster=tidb-test, user=tidb, host=10.10.10.100, path=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/config-cache/prometheus-9090.service, deploy_dir=/tidb-deploy/prometheus-9090, data_dir=[/tidb-data/prometheus-9090], log_dir=/tidb-deploy/prometheus-9090/log, cache_dir=/home/tidb/.tiup/storage/cluster/clusters/tidb-test/config-cache
deploy monitored
  - Deploy node_exporter -> 10.10.10.212 ... Done
  - Deploy node_exporter -> 10.10.10.220 ... Done
  - Deploy node_exporter -> 10.10.10.100 ... Done
  - Deploy node_exporter -> 10.10.10.208 ... Done
  - Deploy node_exporter -> 10.10.10.209 ... Done
  - Deploy node_exporter -> 10.10.10.221 ... Done
  - Deploy node_exporter -> 10.10.10.210 ... Done
  - Deploy node_exporter -> 10.10.10.211 ... Done
  - Deploy node_exporter -> 10.10.10.207 ... Done
  - Deploy blackbox_exporter -> 10.10.10.211 ... Done
  - Deploy blackbox_exporter -> 10.10.10.207 ... Done
  - Deploy blackbox_exporter -> 10.10.10.208 ... Done
  - Deploy blackbox_exporter -> 10.10.10.209 ... Done
  - Deploy blackbox_exporter -> 10.10.10.221 ... Done
  - Deploy blackbox_exporter -> 10.10.10.210 ... Done
  - Deploy blackbox_exporter -> 10.10.10.220 ... Done
  - Deploy blackbox_exporter -> 10.10.10.100 ... Done
  - Deploy blackbox_exporter -> 10.10.10.212 ... Done
refresh monitored config
  - Generate config node_exporter -> 10.10.10.221 ... Done
  - Generate config node_exporter -> 10.10.10.210 ... Done
  - Generate config node_exporter -> 10.10.10.211 ... Done
  - Generate config node_exporter -> 10.10.10.207 ... Done
  - Generate config node_exporter -> 10.10.10.208 ... Done
  - Generate config node_exporter -> 10.10.10.209 ... Done
  - Generate config node_exporter -> 10.10.10.212 ... Done
  - Generate config node_exporter -> 10.10.10.220 ... Done
  - Generate config node_exporter -> 10.10.10.100 ... Done
  - Generate config blackbox_exporter -> 10.10.10.210 ... Done
  - Generate config blackbox_exporter -> 10.10.10.211 ... Done
  - Generate config blackbox_exporter -> 10.10.10.207 ... Done
  - Generate config blackbox_exporter -> 10.10.10.208 ... Done
  - Generate config blackbox_exporter -> 10.10.10.209 ... Done
  - Generate config blackbox_exporter -> 10.10.10.221 ... Done
  - Generate config blackbox_exporter -> 10.10.10.212 ... Done
  - Generate config blackbox_exporter -> 10.10.10.220 ... Done
  - Generate config blackbox_exporter -> 10.10.10.100 ... Done
+ [ Serial ] - UpgradeCluster
Upgrading component tiflash
        Restarting instance 10.10.10.221:9000
        Restart instance 10.10.10.221:9000 success
        Restarting instance 10.10.10.220:9000
        Restart instance 10.10.10.220:9000 success
Upgrading component pd
        Restarting instance 10.10.10.211:2379
        Restart instance 10.10.10.211:2379 success
        Restarting instance 10.10.10.212:2379
        Restart instance 10.10.10.212:2379 success
        Restarting instance 10.10.10.210:2379
        Restart instance 10.10.10.210:2379 success
Upgrading component tikv
        Evicting 646 leaders from store 10.10.10.207:20160...
          Still waitting for 646 store leaders to transfer...
          Still waitting for 641 store leaders to transfer...
          Still waitting for 641 store leaders to transfer...
          Still waitting for 641 store leaders to transfer...
          Still waitting for 641 store leaders to transfer...
          Still waitting for 641 store leaders to transfer...
          Still waitting for 641 store leaders to transfer...
          Still waitting for 641 store leaders to transfer...
          Still waitting for 641 store leaders to transfer...
          Still waitting for 641 store leaders to transfer...
          Still waitting for 502 store leaders to transfer...
          Still waitting for 502 store leaders to transfer...
          Still waitting for 502 store leaders to transfer...
          Still waitting for 502 store leaders to transfer...
          Still waitting for 502 store leaders to transfer...
          Still waitting for 497 store leaders to transfer...
          Still waitting for 497 store leaders to transfer...
          Still waitting for 497 store leaders to transfer...
          Still waitting for 497 store leaders to transfer...
          Still waitting for 497 store leaders to transfer...
          Still waitting for 497 store leaders to transfer...
          Still waitting for 497 store leaders to transfer...
          Still waitting for 497 store leaders to transfer...
          Still waitting for 497 store leaders to transfer...
        Restarting instance 10.10.10.207:20160
        Restart instance 10.10.10.207:20160 success
        Recovering about 430 leaders to store 10.10.10.207:20160, original count is 646...
          Still waiting for at least 430 leaders to transfer back...
          Still waiting for at least 430 leaders to transfer back...
          Still waiting for at least 430 leaders to transfer back...
          Still waiting for at least 430 leaders to transfer back...
          Still waiting for at least 430 leaders to transfer back...
        Skip recovering leaders to 10.10.10.207:20160, because leader count has been unchanged for 5 times
        Evicting 964 leaders from store 10.10.10.208:20160...
          Still waitting for 964 store leaders to transfer...
          Still waitting for 964 store leaders to transfer...
          Still waitting for 964 store leaders to transfer...
        Restarting instance 10.10.10.208:20160
        Restart instance 10.10.10.208:20160 success
        Recovering about 642 leaders to store 10.10.10.208:20160, original count is 964...
          Still waiting for at least 642 leaders to transfer back...
          Still waiting for at least 642 leaders to transfer back...
          Still waiting for at least 642 leaders to transfer back...
          Still waiting for at least 642 leaders to transfer back...
          Still waiting for at least 642 leaders to transfer back...
        Skip recovering leaders to 10.10.10.208:20160, because leader count has been unchanged for 5 times
        Evicting 964 leaders from store 10.10.10.209:20160...
          Still waitting for 964 store leaders to transfer...
          Still waitting for 394 store leaders to transfer...
          Still waitting for 394 store leaders to transfer...
          Still waitting for 394 store leaders to transfer...
          Still waitting for 394 store leaders to transfer...
          Still waitting for 394 store leaders to transfer...
        Restarting instance 10.10.10.209:20160
        Restart instance 10.10.10.209:20160 success
        Recovering about 642 leaders to store 10.10.10.209:20160, original count is 964...
          Still waiting for at least 642 leaders to transfer back...
          Still waiting for at least 642 leaders to transfer back...
          Still waiting for at least 642 leaders to transfer back...
          Still waiting for at least 642 leaders to transfer back...
          Still waiting for at least 642 leaders to transfer back...
        Skip recovering leaders to 10.10.10.209:20160, because leader count has been unchanged for 5 times
Upgrading component tidb
        Restarting instance 10.10.10.210:4000
        Restart instance 10.10.10.210:4000 success
        Restarting instance 10.10.10.211:4000
        Restart instance 10.10.10.211:4000 success
        Restarting instance 10.10.10.212:4000
        Restart instance 10.10.10.212:4000 success
Upgrading component prometheus
        Restarting instance 10.10.10.100:9090
        Restart instance 10.10.10.100:9090 success
Upgrading component grafana
        Restarting instance 10.10.10.100:3000
        Restart instance 10.10.10.100:3000 success
Upgrading component alertmanager
        Restarting instance 10.10.10.100:9093
        Restart instance 10.10.10.100:9093 success
Stopping component node_exporter
        Stopping instance 10.10.10.209
        Stopping instance 10.10.10.100
        Stopping instance 10.10.10.212
        Stopping instance 10.10.10.221
        Stopping instance 10.10.10.207
        Stopping instance 10.10.10.220
        Stopping instance 10.10.10.208
        Stopping instance 10.10.10.211
        Stopping instance 10.10.10.210
        Stop 10.10.10.100 success
        Stop 10.10.10.212 success
        Stop 10.10.10.211 success
        Stop 10.10.10.220 success
        Stop 10.10.10.208 success
        Stop 10.10.10.210 success
        Stop 10.10.10.221 success
        Stop 10.10.10.209 success
        Stop 10.10.10.207 success
Stopping component blackbox_exporter
        Stopping instance 10.10.10.209
        Stopping instance 10.10.10.207
        Stopping instance 10.10.10.211
        Stopping instance 10.10.10.221
        Stopping instance 10.10.10.212
        Stopping instance 10.10.10.208
        Stopping instance 10.10.10.210
        Stopping instance 10.10.10.220
        Stopping instance 10.10.10.100
        Stop 10.10.10.208 success
        Stop 10.10.10.211 success
        Stop 10.10.10.220 success
        Stop 10.10.10.221 success
        Stop 10.10.10.207 success
        Stop 10.10.10.100 success
        Stop 10.10.10.209 success
        Stop 10.10.10.212 success
        Stop 10.10.10.210 success
Starting component node_exporter
        Starting instance 10.10.10.209
        Starting instance 10.10.10.221
        Starting instance 10.10.10.212
        Starting instance 10.10.10.211
        Starting instance 10.10.10.207
        Starting instance 10.10.10.208
        Starting instance 10.10.10.220
        Starting instance 10.10.10.210
        Starting instance 10.10.10.100
        Start 10.10.10.211 success
        Start 10.10.10.208 success
        Start 10.10.10.220 success
        Start 10.10.10.100 success
        Start 10.10.10.221 success
        Start 10.10.10.207 success
        Start 10.10.10.210 success
        Start 10.10.10.209 success
        Start 10.10.10.212 success
Starting component blackbox_exporter
        Starting instance 10.10.10.209
        Starting instance 10.10.10.100
        Starting instance 10.10.10.211
        Starting instance 10.10.10.212
        Starting instance 10.10.10.207
        Starting instance 10.10.10.210
        Starting instance 10.10.10.208
        Starting instance 10.10.10.220
        Starting instance 10.10.10.221
        Start 10.10.10.208 success
        Start 10.10.10.211 success
        Start 10.10.10.207 success
        Start 10.10.10.209 success
        Start 10.10.10.100 success
        Start 10.10.10.220 success
        Start 10.10.10.221 success
        Start 10.10.10.212 success
        Start 10.10.10.210 success
Upgraded cluster `tidb-test` successfully

tidb菜鸟一只 · 2023 年12 月 4 日 09:31

可以，解决了就好，顺便记录一下，防止下次碰到同样的问题

dba远航 · 2023 年12 月 5 日 00:36

建表语句的问题

Billdi表弟 · 2023 年12 月 5 日 10:32

从哪个版本升级上来的？

Jellybean · 2023 年12 月 5 日 12:32

升级的过程出现这种问题，感觉有些不太正常。
楼主在执行的时候有做什么额外操作吗

有猫万事足 · 2023 年12 月 5 日 15:48

确实挺奇怪的。不过要分析之前为啥没有成功，就需要以前的升级时期的日志了。

zhanggame1 · 2023 年12 月 6 日 01:25

没什么操作，tidb日志也发了可以看看

zhanggame1 · 2023 年12 月 6 日 01:26

从7.1.2升级的

system · 2024 年2 月 4 日 01:26

此话题已在最后回复的 60 天后被自动关闭。不再允许新回复。