磐维集中式数据库升级种常见问题
1.环境信息
升级环境：
gs_om -t status –detail
ip a | grep vip --检查vip是否正常挂载
硬件平台：Linux panwei01 3.10.0-1160.el7.x86_64 #1 SMP Mon Oct 19 16:18:59 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux
操作系统：CentOS Linux release 7.9.2009 (Core)
数据库版本：PanWeiDB_V2.0(openGauss)-distributed version-3.0.1_B01 build d2edb141
问题（一）
[omm@panwei01 script]$ ./pwpatch -C
The environment variable "PWPATCH_CONFIGURATION_FILE":"None" must exist and the path must be absolute. Or set it by --setparam
[omm@panwei01 script]$
通过./pwpatch -C命令对检查环境变量与配置和检查执行失败，该问题由于环境变量为正确配置，可以选择手动配置，具体操作如下：
[root@panwei01 script]# vi /database/panweidb/tmp/a.ini
[pwpatch]
userName=omm
userGroup=dbgrp
appPath=/database/panweidb/app
dataPath=/database/panweidb/data
port=17700
tmpPath=/database/panweidb/tmp
[root@panwei01 script]# export PWPATCH_CONFIGURATION_FILE=/database/panweidb/tmp/a.ini
## 同时需要对文件进行授权，以防止后边权限导致升级失败
[root@panwei01 script]# chown omm:dbgrp /database/panweidb/tmp/a.ini
问题（二）
[omm@panwei01 script]$ ./pwpatch --upgrade
Perform pwpatch upgrade.
Upgrade instances under user omm and group dbgrp.
Regenerate profile. user: omm, group: dbgrp, clusterXml: /database/panweidb/tmp/pw_cluster_omm_dbgrp_17700.xml.
Successfully regenerate profile. user: omm, group: dbgrp, clusterXml: /database/panweidb/tmp/pw_cluster_omm_dbgrp_17700.xml.
Perform upgrade. clusterXml: /database/panweidb/tmp/pw_cluster_omm_dbgrp_17700.xml.
Execute command failed:
python3 '/database/panweidb/soft/panwei310/patch/PanWeiDB_V2.0-S3.1.0_B01-patch-centos_7-x86_64/PWPatch/script/gs_upgradectl' -t auto-upgrade -X '/database/panweidb/tmp/pw_cluster_omm_dbgrp_17700.xml'
通过./pwpatch -P命令对检查环境变量与配置和检查执行失败，可以通过一下方式进行排查：
（
1）检查python3版本：python3 -V，如果python3版本为python3.7，则可以忽略改报错，如果不是python3.7，需要我们在/database/panweidb/soft/panwei310/patch/PanWeiDB_V2.0-S3.1.0_B01-patch-centos_7-x86_64/PWPatch/script目录下执行source prepare_env.sh，执行后可以获取升级包种的python3.7路径，将python3.7.9路径复制后修改操作系统python3版本，具体步骤如下：
[root@panwei01 script]# ll /usr/bin/python3*
lrwxrwxrwx 1 root root 9 May 24 2024 /usr/bin/python3 -> python3.6
-rwxr-xr-x 2 root root 11336 Nov 15 2023 /usr/bin/python3.6
-rwxr-xr-x 2 root root 11336 Nov 15 2023 /usr/bin/python3.6m
[root@panwei01 script]# mv /usr/bin/python3 /usr/bin/python3_bak
[root@panwei01 script]# ln -s /database/panweidb/soft/panwei310/patch/PanWeiDB_V2.0-S3.1.0_B01-patch-centos_7-x86_64/python3/python3.7.9/bin/python3 /usr/bin/python3
[root@panwei01 script]# ll /usr/bin/python3*
lrwxrwxrwx 1 root root 128 Apr 17 20:20 /usr/bin/python3 -> //database/panweidb/soft/panwei310/patch/PanWeiDB_V2.0-S3.1.0_B01-patch-centos_7-x86_64/python3/python3.7.9/bin/python3
-rwxr-xr-x 2 root root 11336 Nov 15 2023 /usr/bin/python3.6
-rwxr-xr-x 2 root root 11336 Nov 15 2023 /usr/bin/python3.6m
lrwxrwxrwx 1 root root 9 May 24 2024 /usr/bin/python3_bak -> python3.6
[root@panwei01 script]#
（2）检查/database/panweidb/tmp/a.ini文件权限
[omm@panwei01 script]$ ll /database/panweidb/tmp/a.ini
-rw-r--r-- 1 root root 145 Apr 17 20:14 /database/panweidb/tmp/a.ini
[omm@panwei01 script]$
# 使用root对文件进行授权
[root@panwei01 ~]# chown omm: /database/panweidb/tmp/a.ini
[root@panwei01 ~]# ll /database/panweidb/tmp/a.ini
-rw-r--r-- 1 omm dbgrp 145 Apr 17 20:14 /database/panweidb/tmp/a.ini
[root@panwei01 ~]#
（3）如果安装数据库时做过环境变量隔离
# 将环境变量隔离文件内容复制至~/.bashrc，并注释MPPDB_ENV_SEPARATE_PATH
#export MPPDB_ENV_SEPARATE_PATH=/home/omm/.panweidb_env
export GPHOME=/database/panweidb/tool
export UNPACKPATH=/database/panweidb/soft
export PGDATA=/database/panweidb/data
export PGDATABASE=postgres
export PGPORT=17700
export PATH=$GPHOME/script/gspylib/pssh/bin:$GPHOME/script:$PATH
export LD_LIBRARY_PATH=$GPHOME/script/gspylib/clib:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH=$GPHOME/lib:$LD_LIBRARY_PATH
export PYTHONPATH=$GPHOME/lib
export PATH=/root/gauss_om/omm/script:$PATH
export GAUSSHOME=/database/panweidb/app
export PATH=$GAUSSHOME/bin:$PATH
export LD_LIBRARY_PATH=$GAUSSHOME/lib:$LD_LIBRARY_PATH
export S3_CLIENT_CRT_FILE=$GAUSSHOME/lib/client.crt
export PANWEIDB_PKG_ENV=panweidb
export GAUSS_VERSION=2.0
export PGHOST=/database/panweidb/tmp
export GAUSSLOG=/database/panweidb/log/omm
umask 077
export GAUSS_ENV=2
export GS_CLUSTER_NAME=panweidb
