磐维数据库升级报错分析处理

问题概述

最近磐维数据库发布了新版本PanWeiDB_V2.0-S3.2.0_B01，应客户需求，需要将原来的PanWeiDB_V2.0-S2.0.2_B01升级至最新版本，升级过程中遇到报错，通过分析发现是大小写参数敏感设置导致，修改参数值之后，重新升级正常。

分析处理过程

升级报错如下：

 ./pwpatch --upgrade
Perform pwpatch upgrade.
Upgrade instances under user omm and group dbgrp.
Regenerate profile. user: omm, group: dbgrp, clusterXml: /data/panweidb/tmp/pw_cluster_omm_dbgrp_17700.xml.
Successfully regenerate profile. user: omm, group: dbgrp, clusterXml: /data/panweidb/tmp/pw_cluster_omm_dbgrp_17700.xml.
Perform upgrade. clusterXml: /data/panweidb/tmp/pw_cluster_omm_dbgrp_17700.xml.

Execute command failed:

/data/soft/panwei302/patch/PanWeiDB_V2.0-S3.2.0_B01-patch-bclinux_euler21.10-x86_64_hygon/PWPatch/script/gs_upgradectl -t auto-upgrade -X /data/panweidb/tmp/pw_cluster_omm_dbgrp_17700.xml

排查升级日志报错信息：

/data/panweidb/app_86db355/.update/updateLog/omm/gs_upgradectl-2025-07-25_020521.log

发现如下信息：

gsql:/data/panweidb/tmp/binary_upgrade/rollback-post_catalog_maindb_tmp.sql:8216: ERROR:  column dba_part_indexes.INTERVAL does not exist
LINE 30:                 dba_part_indexes."INTERVAL",
                         ^
QUERY:  CREATE OR REPLACE VIEW pg_catalog.user_part_indexes AS
            SELECT
                dba_part_indexes.INDEX_NAME,

。。。

查询 该表字段报错，怀疑大小写敏感 导致。

处理过程

查询数据库兼容版本

postgres=# SELECT name, setting 
postgres-# FROM pg_settings 
postgres-# WHERE name = 'sql_compatibility';
       name        | setting 
-------------------+---------
 sql_compatibility | B
(1 row)

检查配置文件参数

cat postgresql.conf| grep -i 'lower_case_*'

# Table_names
lower_case_table_names = 1

# Column_names
lower_case_column_names = 1

官方升级文档中提到v2.0-S3.1.0b01要的版本需要将该参数修改为0，和此次升级的版本不符。

手动修改为0，重启后再次尝试升级。

 ./pwpatch --upgrade
Perform pwpatch upgrade.
Upgrade instances under user omm and group dbgrp.
Regenerate profile. user: omm, group: dbgrp, clusterXml: /data/panweidb/tmp/pw_cluster_omm_dbgrp_17700.xml.
Successfully regenerate profile. user: omm, group: dbgrp, clusterXml: /data/panweidb/tmp/pw_cluster_omm_dbgrp_17700.xml.
Perform upgrade. clusterXml: /data/panweidb/tmp/pw_cluster_omm_dbgrp_17700.xml.
Successfully upgrade.
Perform commit. clusterXml: /data/panweidb/tmp/pw_cluster_omm_dbgrp_17700.xml.
Successfully commit.
Remove environment file (/home/omm/.PWPatch_20250718150154).
Begin clearing temporary environment variables in the file (/home/omm/.bashrc).
Start check.
Successfully perform pwpatch upgrade.

参考文档

磐维数据库（PanWeiDB）V2.0- S3.2.0_B01 集群升级指南