【测试类型：SQL功能】【测试版本：7.0.0-RC1】【升级】对比直接安装7.0.0-RC1，6.0.0升级至7.0.0-RC1后，元数据不一致问题（pr6616相关）

【标题描述】:对比直接安装7.0.0-RC1，6.0.0升级至7.0.0-RC1后，元数据不一致问题（pr6616相关）
【测试类型：SQL功能】【测试版本：7.0.0-RC1】【升级】对比直接安装7.0.0-RC1，6.0.0升级至7.0.0-RC1后，元数据不一致问题（pr6616相关）
【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):
openEuler release 20.03 (LTS)
Linux kwepwebenv08175 4.19.90-2003.4.0.0036.oe1.x86_64 #1 SMP Mon Mar 23 19:10:41 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux
【测试环境】(单机/1主x备x级联备):
一主两备
【被测功能】:
升级
【测试类型】:
自动化
【数据库版本】(查询命令: gaussdb -V):
6.0.0 gsql (openGauss 6.0.0 build aee4abd5) compiled at 2024-09-29 18:38:08 commit 0 last mr
7.0.0-RC1 (openGauss 7.0.0-RC1 build fede6243) compiled at 2024-11-08 00:08:49 commit 0 last mr

【预置条件】:
数据库状态正常
【操作步骤】(请填写详细的操作步骤):
1. 直接安装一个7.0.0-RC1数据库  gs_upgradechk export -p xxxx  导出元数据校验地图
2. 安装低版本数据库6.0.0，升级到7.0.0-RC1后  gs_upgradechk verify -p xxxx -v xxx 校验元数据
-v指定步骤1中导出的元数据地图路径
3. 分析元数据校验报告，获悉元数据不一致问题

【预期输出】:
元数据一致
【实际输出】:
元数据校验不一致，生成校验报告，如上sql分别在直接安装的数据库及升级后数据库执行，结果不一致，如下：
 **涉及pr:** https://gitee.com/opengauss/openGauss-server/pulls/6616

```
-- 1. 数据类型转换方式缺失
select * from pg_cast where oid in (8299,8298,9297,9296,8295,8294,8285,8284,8283);

-- 2. 函数缺失
select * from pg_proc where oid in (8401,8402,8403,8404,8405,8406,8407,8408,8409,8410,8411,8412,8413,8414,8415,8416,8417,8418,8419,8420,8421,8422,8423,8424,8425,8426,8427,8428,8431,8432,8433,8434,8435,8436,8437,8438,8439,8440,8441,8442,8443,8444,8445,8446,8447,8448,8449,8450,8458,8459,8460,8461,8462,8463,8464,8465,8466,8467,8468,8469,8470,8471,8472,8473,8474,8475,8476,8477,8478,8479,8200,8201,8202,8203,8204,8205,8206,8207,8208,8209,8210,8211,8214,8215,8216,8217,8218,8219,8228,8229,8230,8241,8242);

-- 3. 函数描述存在差异
select * from pg_description where objoid in (8401,8402,8403,8404,8405,8406,8407,8408,8409,8410,8411,8412,8413,8414,8415,8416,8417,8418,8419,8420,8421,8422,8423,8424,8425,8426,8427,8428,8431,8432,8433,8434,8435,8436,8437,8438,8439,8440,8441,8442,8443,8444,8445,8446,8447,8448,8449,8450,8458,8459,8460,8461,8462,8463,8464,8465,8466,8467,8468,8469,8470,8471,8472,8473,8474,8475,8476,8477,8478,8479,8200,8201,8202,8203,8204,8205,8206,8207,8208,8209,8210,8211,8214,8215,8216,8217,8218,8219,8228,8229,8230,8241,8242);

-- 4. 函数访问族缺失
select * from pg_amproc where amprocfamily in (8371,8372,8373,8374,8379,8380,8381,8382,8383,8384,8385,8386,8387,8392,8394,8397);

-- 5. 操作符访问族缺失
select * from pg_amop where amopfamily in (8371,8372,8373,8374,8379,8380,8381,8382,8383,8384,8385,8386,8387,8392,8394,8397);

-- 6. 操作符类缺失
select * from pg_opclass where oid in (8900,8999,8902,8903,8908,8909,8910,8911,8912,8913,8914,8915,8916,8923,8977,8979);

-- 7. 操作符族缺失
https://onebox.huawei.com/v/dfaa23fa0f94b702e790fd1f85a0b9bc?type=0

-- 8. 操作符缺失
select * from pg_operator where oid in (8311,8312,8313,8314,8319,8320,8321,8322,8323,8324,8325,8326,8327,8328,8329,8330,8331,8332,8333,8334,8335,8336,8337,8338,8339,8349);

-- 9. 操作符描述存在差异
select * from pg_description where objoid in (8311,8312,8313,8314,8319,8320,8321,8322,8323,8324,8325,8326,8327,8328,8329,8330,8331,8332,8333,8334,8335,8336,8337,8338,8339,8349);

-- 10. pg_am描述存在差异
select * from pg_description where objoid in（8300,8301）;
```

**实际不一致截图** 详见：https://onebox.huawei.com/v/dfaa23fa0f94b702e790fd1f85a0b9bc?type=0

【原因分析】:
1. 这个问题的根因
2. 问题推断过程
3. 还有哪些原因可能造成类似现象
4. 该问题是否有临时规避措施
5. 问题解决方案
6. 预计修复问题时间

【日志信息】(请附上日志文件、截图、coredump信息):
不涉及
【测试代码】:
不涉及

openGauss/openGauss-server

Content Risk Flag

Comments (5)

openGauss/openGauss-server .gitee-modal { width: 500px !important; }

Content Risk Flag