代码拉取完成，页面将自动刷新
【标题描述】:opengass3.1.0升级opengass5.0.0，灰度升级失败
问题描述
openGass 3.1.0升级5.0.0，执行灰度升级，执行如下命令：
gs_upgradectl -t auto-upgrade -X /home/omm/cluster_config.xml --grey
预见报错信息如下：
function dolphin_attname_cq(name,name) dose not exist
【数据库版本】(查询命令: gaussdb -V):3.1.0
【操作步骤】(请填写详细的操作步骤):
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
li-xin12345
2年前
已回归
灰度升级：
[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:33:46 INFO UpgradeScene 19 10121] 验证B库dolphin插件可用
[2023-08-08 16:33:48 INFO UpgradeScene 19 10121] List of installed extensions
Name | Version | Schema | Description
-----------------+---------+------------+--------------------------------------------------
dist_fdw | 1.0 | pg_catalog | foreign-data wrapper for distfs access
dolphin | 1.0 | public | sql engine
file_fdw | 1.0 | pg_catalog | foreign-data wrapper for flat file access
hstore | 1.1 | pg_catalog | data type for storing sets of (key, value) pairs
log_fdw | 1.0 | pg_catalog | Foreign Data Wrapper for accessing logging data
mot_fdw | 1.0 | pg_catalog | foreign-data wrapper for MOT access
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
security_plugin | 1.0 | pg_catalog | provides security functionality
(8 rows)
升级：
[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插件
回滚：
[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
[2023-08-08 16:51:26 INFO UpgradeScene 19 10121] 验证B库dolphin插件可用
[2023-08-08 16:51:28 INFO UpgradeScene 19 10121] List of installed extensions
Name | Version | Schema | Description
-----------------+---------+------------+--------------------------------------------------
dist_fdw | 1.0 | pg_catalog | foreign-data wrapper for distfs access
dolphin | 1.0 | public | sql engine
file_fdw | 1.0 | pg_catalog | foreign-data wrapper for flat file access
hstore | 1.1 | pg_catalog | data type for storing sets of (key, value) pairs
log_fdw | 1.0 | pg_catalog | Foreign Data Wrapper for accessing logging data
mot_fdw | 1.0 | pg_catalog | foreign-data wrapper for MOT access
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
security_plugin | 1.0 | pg_catalog | provides security functionality
(8 rows)
登录 后才可以发表评论
FileDragTip