opengass3.1.0升级opengass5.0.0，升级失败【zyzx]

已回归
![输入图片说明](https://foruda.gitee.com/images/1691138070202635374/76a7d897_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1691139172861445528/f1705623_10357626.png "屏幕截图")

**灰度升级：** 
```
[2023-08-04 11:18:50 INFO UpgradeScene 19 23305] 开始执行: su - upgrade_0804 <<EOF
source /home/upgrade_0804/gaussdb.bashrc && gs_upgradectl -t auto-upgrade -X /opt/upgrade_0804/0804/pkg/upgrade_0804.xml --grey
EOF
[2023-08-04 11:22:08 INFO UpgradeScene 19 23305] Success: Static configuration matched with old static configuration files.
Successfully set upgrade_mode to 0.
Checking upgrade environment.
Successfully checked upgrade environment.
Start to do health check.
Successfully checked cluster status.
Upgrade all nodes.
NOTICE: The directory /data/upgrade_0804/cluster/app_4e931f9a will be deleted after commit-upgrade, please make sure there is no personal data.
Performing grey rollback.
No need to rollback.
The directory /data/upgrade_0804/cluster/app_4e931f9a will be deleted after commit-upgrade, please make sure there is no personal data.
Installing new binary.
copy certs from /data/upgrade_0804/cluster/app_4e931f9a to /data/upgrade_0804/cluster/app_a07d57c3.
Successfully copy certs from /data/upgrade_0804/cluster/app_4e931f9a to /data/upgrade_0804/cluster/app_a07d57c3.
Successfully backup hotpatch config file.
Sync cluster configuration.
Successfully synced cluster configuration.
Switch symbolic link to new binary directory.
Successfully switch symbolic link to new binary directory.
Start check CMS parameter.
Switching all db processes.
Check cluster state.
Cluster state: [   Cluster State   ]

cluster_state   : Normal
redistributing  : No
current_az      : AZ_ALL

[  Datanode State   ]

node           node_ip         port      instance     state
-------------------------------------------------------------------------------
1  kwepwebenv06293 xx.xx.xx.xx   50804      6001       P Primary Normal
2  kwepwebenv07953 xx.xx.xx.xx    50804      6002       S Standby Normal
3  kwepwebenv07954 xx.xx.xx.xx  50804      6003       S Standby Normal
Create checkpoint before switching.
Start to wait for om_monitor.
Switching DN processes.
Ready to grey start cluster.
Grey start cluster successfully.
Wait for the cluster status normal or degrade.
Successfully switch all process version
The nodes ['kwepwebenv06293', 'kwepwebenv07953', 'kwepwebenv07954'] have been successfully upgraded to new version. Then do health check.
Start to do health check.
Successfully checked cluster status.
Waiting for the cluster status to become normal.
.
The cluster status is normal.
Upgrade main process has been finished, user can do some check now.
Once the check done, please execute following command to commit upgrade:

gs_upgradectl -t commit-upgrade -X /opt/upgrade_0804/0804/pkg/upgrade_0804.xml

Successfully upgrade all nodes.
Last login: Fri Aug  4 11:18:48 CST 2023

[2023-08-04 11:22:08 INFO UpgradeScene 19 23305] 升级后验证
[2023-08-04 11:22:08 INFO UpgradeScene 19 23305] 1.版本验证
[2023-08-04 11:22:08 INFO UpgradeScene 19 23305] 开始执行: su - upgrade_0804 <<EOF
source /home/upgrade_0804/gaussdb.bashrc
gs_ssh -c "gsql -V"
EOF
[2023-08-04 11:22:11 INFO UpgradeScene 19 23305] Success: Successfully execute command on all nodes.

Output:
[SUCCESS] kwepwebenv06293:
gsql (openGauss 5.0.0 build a07d57c3) compiled at 2023-03-29 03:07:56 commit 0 last mr
[SUCCESS] kwepwebenv07953:
gsql (openGauss 5.0.0 build a07d57c3) compiled at 2023-03-29 03:07:56 commit 0 last mr
[SUCCESS] kwepwebenv07954:
gsql (openGauss 5.0.0 build a07d57c3) compiled at 2023-03-29 03:07:56 commit 0 last mr

```

**回滚成功：**

```
[2023-08-04 10:19:30 INFO UpgradeScene 19 18604] 开始回滚
[2023-08-04 10:19:30 INFO UpgradeScene 19 18604] 升级版本回滚
[2023-08-04 10:19:30 INFO UpgradeScene 19 18604] 开始执行: su - upgrade_0804 <<EOF
source /home/upgrade_0804/gaussdb.bashrc
gs_upgradectl -t auto-rollback -X /opt/upgrade_0804/0804/pkg/upgrade_0804.xml
EOF
[2023-08-04 10:21:05 INFO UpgradeScene 19 18604] Success: Static configuration matched with old static configuration files.
Performing grey rollback.
Start roll back CM instance.
Switch symbolic link to old binary directory.
Successfully switch symbolic link to old binary directory.
Successfully rollback hotpatch config file.
Switching all db processes.
Check cluster state.
Cluster state: [   Cluster State   ]

cluster_state   : Normal
redistributing  : No
current_az      : AZ_ALL

[  Datanode State   ]

node           node_ip         port      instance     state
-------------------------------------------------------------------------------
1  kwepwebenv06293 xx.xx.xx.xx   50804      6001       P Primary Normal
2  kwepwebenv07953 xx.xx.xx.xx   50804      6002       S Standby Normal
3  kwepwebenv07954 xx.xx.xx.xx  50804      6003       S Standby Normal
Create checkpoint before switching.
Start to wait for om_monitor.
Switching DN processes.
Switch DN processes for rolling upgrade.
Ready to grey start cluster.
Grey start cluster successfully.
Wait for the cluster status normal or degrade.
Successfully switch all process version
Rollbacking catalog.
Successfully Rollbacked catalog.
Successfully cleaned new install path.
Rollback succeeded.
Last login: Fri Aug  4 10:19:28 CST 2023

[2023-08-04 10:21:05 INFO UpgradeScene 19 18604] 开始执行: su - upgrade_0804 -c "source /home/upgrade_0804/gaussdb.bashrc; gaussdb -V"
[2023-08-04 10:21:05 INFO UpgradeScene 19 18604] Success: gaussdb (openGauss 3.1.0 build 4e931f9a) compiled at 2022-09-29 14:19:24 commit 0 last mr

```
 **强制回滚：**

```
Last login: Fri Aug  4 12:16:53 CST 2023

[2023-08-04 12:17:01 INFO UpgradeScene 19 19751] 开始回滚
[2023-08-04 12:17:01 INFO UpgradeScene 19 19751] 升级版本回滚
[2023-08-04 12:17:01 INFO UpgradeScene 19 19751] 开始执行: su - upgrade_0804 <<EOF
source /home/upgrade_0804/gaussdb.bashrc
gs_upgradectl -t auto-rollback -X /opt/upgrade_0804/0804/pkg/upgrade_0804.xml --force
EOF
[2023-08-04 12:18:32 INFO UpgradeScene 19 19751] Success: Static configuration matched with old static configuration files.
Performing grey rollback.
Start roll back CM instance.
Switch symbolic link to old binary directory.
Successfully switch symbolic link to old binary directory.
Successfully rollback hotpatch config file.
Switching all db processes.
Check cluster state.
Cluster state: [   Cluster State   ]

cluster_state   : Normal
redistributing  : No
current_az      : AZ_ALL

[  Datanode State   ]

node           node_ip         port      instance     state
-------------------------------------------------------------------------------
1  kwepwebenv06293 10.247.86.215   50804      6001       P Primary Normal
2  kwepwebenv07953 10.243.201.23   50804      6002       S Standby Normal
3  kwepwebenv07954 10.116.244.207  50804      6003       S Standby Normal
Create checkpoint before switching.
Start to wait for om_monitor.
Switching DN processes.
Switch DN processes for rolling upgrade.
Ready to grey start cluster.
Grey start cluster successfully.
Wait for the cluster status normal or degrade.
Successfully switch all process version
Rollbacking catalog.
Successfully Rollbacked catalog.
Successfully cleaned new install path.
Rollback succeeded.
Last login: Fri Aug  4 12:16:59 CST 2023

[2023-08-04 12:18:32 INFO UpgradeScene 19 19751] 开始执行: su - upgrade_0804 -c "source /home/upgrade_0804/gaussdb.bashrc; gaussdb -V"
[2023-08-04 12:18:32 INFO UpgradeScene 19 19751] Success: gaussdb (openGauss 3.1.0 build 4e931f9a) compiled at 2022-09-29 14:19:24 commit 0 last mr

```

**升级前：**

```
[2023-08-08 16:33:44 INFO InstallDb 19 10121] 获取数据库版本信息
[2023-08-08 16:33:44 INFO InstallDb 19 10121] 开始执行: su - upgrade_0808 -c "source /home/upgrade_0808/gaussdb.bashrc;         gsql -d postgres -p 50808 -c \"select version();\""|
        awk 'NR==3'
[2023-08-08 16:33:44 INFO InstallDb 19 10121] Success:  (openGauss 3.1.0 build 4e931f9a) compiled at 2022-09-29 14:19:24 commit 0 last mr   on x86_64-unknown-linux-gnu, compiled by g++ (GCC) 7.3.0, 64-bit

```

**升级：**

```
[2023-08-08 16:46:14 INFO UpgradeScene 19 10121] 开始执行: su - upgrade_0808 <<EOF
source /home/upgrade_0808/gaussdb.bashrc && gs_upgradectl -t auto-upgrade -X /opt/upgrade_0808/0808/pkg/upgrade_0808.xml --grey
EOF
[2023-08-08 16:49:41 INFO UpgradeScene 19 10121] Success: Static configuration matched with old static configuration files.
Successfully set upgrade_mode to 0.
Checking upgrade environment.
Successfully checked upgrade environment.
Start to do health check.
Successfully checked cluster status.
Upgrade all nodes.
NOTICE: The directory /data/upgrade_0808/cluster/app_4e931f9a will be deleted after commit-upgrade, please make sure there is no personal data.
Performing grey rollback.
No need to rollback.
The directory /data/upgrade_0808/cluster/app_4e931f9a will be deleted after commit-upgrade, please make sure there is no personal data.
Installing new binary.
copy certs from /data/upgrade_0808/cluster/app_4e931f9a to /data/upgrade_0808/cluster/app_31025cde.
Successfully copy certs from /data/upgrade_0808/cluster/app_4e931f9a to /data/upgrade_0808/cluster/app_31025cde.
Successfully backup hotpatch config file.
Sync cluster configuration.
Successfully synced cluster configuration.
Switch symbolic link to new binary directory.
Successfully switch symbolic link to new binary directory.
Start check CMS parameter.
Switching all db processes.
Check cluster state.
Cluster state: [   Cluster State   ]

cluster_state   : Normal
redistributing  : No
current_az      : AZ_ALL

[  Datanode State   ]

node           node_ip         port      instance     state
-------------------------------------------------------------------------------
1  kwepwebenv06293 xx.xx.xx.xx   50808      6001       P Primary Normal
2  kwepwebenv07953 xx.xx.xx.xx   50808      6002       S Standby Normal
3  kwepwebenv07954 xx.xx.xx.xx  50808      6003       S Standby Normal
Create checkpoint before switching.
Start to wait for om_monitor.
Switching DN processes.
Ready to grey start cluster.
Grey start cluster successfully.
Wait for the cluster status normal or degrade.
Successfully switch all process version
The nodes ['kwepwebenv06293', 'kwepwebenv07953', 'kwepwebenv07954'] have been successfully upgraded to new version. Then do health check.
Start to do health check.
Successfully checked cluster status.
Waiting for the cluster status to become normal.
.
The cluster status is normal.
Upgrade main process has been finished, user can do some check now.
Once the check done, please execute following command to commit upgrade:

gs_upgradectl -t commit-upgrade -X /opt/upgrade_0808/0808/pkg/upgrade_0808.xml

Successfully upgrade all nodes.
Last login: Tue Aug  8 16:46:12 CST 2023
```
 **升级后的dolphin**

```
[2023-08-08 17:38:34 INFO UpgradeScene 19 10121] 升级vs直接安装对比：B库dolphin插件
```
![输入图片说明](https://foruda.gitee.com/images/1691497543983260547/76d81845_10357626.png "屏幕截图")

**回滚：**

```
[2023-08-08 16:49:50 INFO UpgradeScene 19 10121] 开始回滚
[2023-08-08 16:49:50 INFO UpgradeScene 19 10121] 升级版本回滚
[2023-08-08 16:49:50 INFO UpgradeScene 19 10121] 开始执行: su - upgrade_0808 <<EOF
source /home/upgrade_0808/gaussdb.bashrc
gs_upgradectl -t auto-rollback -X /opt/upgrade_0808/0808/pkg/upgrade_0808.xml
EOF
[2023-08-08 16:51:26 INFO UpgradeScene 19 10121] Success: Static configuration matched with old static configuration files.
Performing grey rollback.
Start roll back CM instance.
Switch symbolic link to old binary directory.
Successfully switch symbolic link to old binary directory.
Successfully rollback hotpatch config file.
Switching all db processes.
Check cluster state.
Cluster state: [   Cluster State   ]

cluster_state   : Normal
redistributing  : No
current_az      : AZ_ALL

[  Datanode State   ]

node           node_ip         port      instance     state
-------------------------------------------------------------------------------
1  kwepwebenv06293 xx.xx.xx.xx   50808      6001       P Primary Normal
2  kwepwebenv07953 xx.xx.xx.xx   50808      6002       S Standby Normal
3  kwepwebenv07954 xx.xx.xx.xx  50808      6003       S Standby Normal
Create checkpoint before switching.
Start to wait for om_monitor.
Switching DN processes.
Switch DN processes for rolling upgrade.
Ready to grey start cluster.
Grey start cluster successfully.
Wait for the cluster status normal or degrade.
Successfully switch all process version
Rollbacking catalog.
Successfully Rollbacked catalog.
Successfully cleaned new install path.
Rollback succeeded.
Last login: Tue Aug  8 16:49:48 CST 2023

[2023-08-08 16:51:26 INFO UpgradeScene 19 10121] 开始执行: su - upgrade_0808 -c "source /home/upgrade_0808/gaussdb.bashrc; gaussdb -V"
[2023-08-08 16:51:26 INFO UpgradeScene 19 10121] Success: gaussdb (openGauss 3.1.0 build 4e931f9a) compiled at 2022-09-29 14:19:24 commit 0 last mr

```

GVP openGauss/openGauss-server

内容风险标识

评论 (4)

GVPopenGauss/openGauss-server

内容风险标识