【测试类型：SQL功能】【测试版本：7.0.0-RC1】【升级】3.0.6升级至7.0.0-RC1，元数据不一致问题一（pr2119相关）

【标题描述】:3.0.6升级至7.0.0-RC1，元数据不一致问题一（pr2119相关）
【测试类型：SQL功能】【测试版本：7.0.0-RC1】【升级】3.0.6升级至7.0.0-RC1，元数据不一致问题一（pr2119相关）

【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):
CentOS Linux release 7.6.1810 (Core) 
Linux kwemhisprc10436 3.10.0-957.el7.x86_64 #1 SMP Thu Nov 8 23:39:32 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux
【测试环境】(单机/1主x备x级联备):
一主两备
【被测功能】:
升级
【测试类型】:
功能
【数据库版本】(查询命令: gaussdb -V):
openGauss 3.0.6 build d5373801) compiled at 2024-12-02 12:01:31 commit 0 last mr
openGauss 7.0.0-RC1 build 29a1d791) compiled at 2025-01-22 00:08:25 commit 0 last mr
【预置条件】:
数据库状态正常
【操作步骤】(请填写详细的操作步骤):
1. 3.0.6升级至7.0.0-RC1，执行如下sql，对比直接安装7.0.0-RC1执行如下sql

```
select * from pg_proc where oid = 2330;
select * from pg_proc where oid = 9155;
select * from pg_proc where oid = 9156;
select * from pg_proc where oid = 4543;
select * from pg_proc where oid = 4544;
select * from pg_proc where oid = 4545;
select * from pg_description where objoid = 2330;
select * from pg_description where objoid = 9155;
select * from pg_description where objoid = 9156;
select * from pg_description where objoid = 4543;
select * from pg_description where objoid = 4544;
select * from pg_description where objoid = 4545;
select * from pg_description where objoid = 558;
select * from pg_description where objoid = 559;
select * from pg_description where objoid = 560;
select * from pg_index where indexrelid=3480;
select * from pg_description where objoid = 3272;
select * from pg_description where objoid = 4078;
select * from pg_description where objoid = 4079;
select * from pg_description where objoid = 6565;
select * from pg_description where objoid = 6564;
select * from pg_description where objoid = 6563;
select * from pg_description where objoid = 6562;
select * from pg_description where objoid = 6561;
select * from pg_description where objoid = 6560;
select * from pg_description where objoid = 6559;
select * from pg_description where objoid = 6558;
select * from pg_description where objoid = 6557;
select * from pg_description where objoid = 6556;
select * from pg_description where objoid = 6555;
select * from pg_description where objoid = 6554;
select * from pg_description where objoid = 6553;
select * from pg_description where objoid = 6479;
select * from pg_description where objoid = 6478;
select * from pg_description where objoid = 6477;
select * from pg_description where objoid = 6476;
select * from pg_description where objoid = 6475;
select * from pg_description where objoid = 6474;
select * from pg_description where objoid = 6473;
select * from pg_description where objoid = 6472;
select * from pg_description where objoid = 6471;
select * from pg_description where objoid = 6470;
select * from pg_description where objoid = 6469;
select * from pg_description where objoid = 6468;
select * from pg_description where objoid = 6467;
select * from pg_description where objoid = 6466;
select * from pg_description where objoid = 6465;
select * from pg_description where objoid = 6464;
select * from pg_description where objoid = 6463;
select * from pg_description where objoid = 6462;
select * from pg_description where objoid = 6458;
select * from pg_description where objoid = 6457;
select * from pg_description where objoid = 6456;
select * from pg_description where objoid = 6455;
select * from pg_description where objoid = 6454;
select * from pg_description where objoid = 6453;
select * from pg_description where objoid = 6452;
select * from pg_description where objoid = 6451;
select * from pg_description where objoid = 6450;
select * from pg_description where objoid = 6449;
select * from pg_description where objoid = 6448;
select * from pg_description where objoid = 6447;
select * from pg_description where objoid = 6446;
select * from pg_description where objoid = 6445;
select * from pg_description where objoid = 6444;
select * from pg_description where objoid = 6443;
select * from pg_description where objoid = 6442;
select * from pg_description where objoid = 6441;
select * from pg_description where objoid = 6440;
select * from pg_description where objoid = 6439;
select * from pg_description where objoid = 6438;
select * from pg_description where objoid = 6437;
select * from pg_description where objoid = 6436;
select * from pg_description where objoid = 6435;
select * from pg_description where objoid = 1539;
select * from pg_description where objoid = 1538;
select * from pg_description where objoid = 1537;
select * from pg_description where objoid = 1026;
select * from pg_amop where amopfamily = 1995 and (amoplefttype=3272 or amoprighttype=3272);
select * from pg_amop where amopfamily = 1976 and (amoplefttype=3272 or amoprighttype=3272);
select * from pg_amop where amopfamily = 6976 and (amoplefttype=3272 or amoprighttype=3272);
select * from pg_amop where amopfamily = 1977 and (amoplefttype=3272 or amoprighttype=3272);
select * from pg_amop where amopfamily = 8646 and (amoplefttype=3272 or amoprighttype=3272);
select oid,* from pg_operator where oprleft = 'anyset'::regtype or oprright = 'anyset'::regtype;
select oid, * from pg_proc where proname = 'array_count';
select oid, * from pg_proc where proname = 'gs_repair_urq';
select oid, * from pg_proc where proname = 'gs_verify_undo_meta';
select oid, * from pg_proc where proname = 'gs_verify_undo_record';
select oid, * from pg_proc where proname = 'gs_verify_undo_translot';
select oid, * from pg_proc where proname = 'gs_verify_urq';
select oid, * from pg_proc where oid = 2330;
select oid, * from pg_proc where oid = 5721;
select oid, * from pg_proc where oid = 5257;
select oid, * from pg_proc where oid = 9377;
select oid, * from pg_proc where oid = 4772;
select oid, * from pg_proc where oid = 9156;
select oid, * from pg_proc where oid = 4539;
select oid, * from pg_proc where oid = 4540;
select oid, * from pg_proc where oid = 4437;
select oid, * from pg_proc where oid = 4432;
select oid, * from pg_proc where oid = 4433;
select oid, * from pg_proc where oid = 4545;
select oid, * from pg_proc where oid = 4543;
select oid, * from pg_proc where oid = 4544;
select oid, * from pg_proc where oid = 9155;
select oid, * from pg_proc where oid = 1000;
select oid, * from pg_proc where oid = 1001;
select oid, * from pg_proc where oid = 1002;
select oid, * from pg_proc where oid = 1003;
select oid, * from pg_proc where oid = 1005;
select oid, * from pg_proc where oid = 5843;
select oid, * from pg_proc where oid = 5844;
select oid, * from pg_proc where oid = 5845;
select oid, * from pg_proc where oid = 5846;
select oid, * from pg_proc where oid = 3308;
select oid, * from pg_proc where oid = 7429;
select * from pg_class where relname = 'pg_set';
select oid, * from pg_type where typname = 'pg_set';

```

【预期输出】:
执行结果一致
【实际输出】:
执行结果不一致，如下：
 **左图为直装，右图为升级后数据库** 
![输入图片说明](https://foruda.gitee.com/images/1738829559564581675/65a4e94f_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1738829609035954231/ea10d63f_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1738829625748726944/1a6c18aa_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1738829660089219357/f1dc5ee6_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1738829672617988954/045a6d82_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1738829688011630977/6d2c891f_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1738829705663646788/d2d39e70_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1738829720544521562/4b1abee2_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1738829738802590457/5837057a_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1738829759726997726/977e18fb_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1738829779256501064/979706fc_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1738829798319183803/f8c0b14a_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1738829818439478128/0f50de56_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1738829872876457721/d441708a_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1738829912803976311/c22739a4_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1738829921751861777/0fcae9df_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1738829934183217724/11e06e90_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1738829945377220420/09b9a143_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1738829958048106501/1170f917_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1738830008756158972/3c65ca66_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1738830018021671927/a335d66a_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1738830043473923039/8489d9e3_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1738830055650149783/644651af_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1738830069333540068/12c0b258_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1738830080603717772/a4436293_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1738830106220602036/59954397_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1738830118981984633/d29de1c7_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1738830132762883216/b3001248_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1738830146574451851/d0d06c55_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1738830158232139894/40f4393e_10357626.png "屏幕截图")

**涉及pr:** 
https://gitee.com/opengauss/openGauss-server/pulls/2119/

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

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

openGauss/openGauss-server

Content Risk Flag

Comments (8)

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

Content Risk Flag