【测试类型：工具功能】【测试版本：6.0.0】【升级】5.0.1-6.0.0 灰度升级_回滚报错cannot drop extension "dolphin"

【标题描述】:5.0.1-6.0.0 灰度升级_回滚报错cannot drop extension "dolphin"
【测试类型：工具功能】【测试版本：6.0.0】【升级】5.0.1-6.0.0 灰度升级_回滚报错cannot drop extension "dolphin"

【操作系统和硬件信息】(查询命令: 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):
gsql (openGauss 5.0.1 build 33b035fd) compiled at 2023-12-15 20:19:06 commit 0 last mr
gsql (openGauss 6.0.0 build e70c8948) compiled at 2024-03-13 00:10:17 commit 0 last mr
【预置条件】:
无
【操作步骤】(请填写详细的操作步骤):
1. CI部署升级如下路径：
5.0.1-6.0.0 灰度升级_回滚_升级提交
5.0.1-6.0.0 灰度升级_强制回滚_升级提交

【预期输出】:
成功
【实际输出】:
5.0.1-6.0.0 灰度升级_回滚_升级提交      回滚报错
![输入图片说明](https://foruda.gitee.com/images/1710756461658610417/59b3d191_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1710756481257900956/399782f0_10357626.png "屏幕截图")

5.0.1-6.0.0 灰度升级_强制回滚_升级提交   强制回滚成功，再升级报错：
![输入图片说明](https://foruda.gitee.com/images/1710756563943584118/d5f72c91_10357626.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1710756581715018254/b351d47b_10357626.png "屏幕截图")
【原因分析】:
1. 这个问题的根因
2. 问题推断过程
3. 还有哪些原因可能造成类似现象
4. 该问题是否有临时规避措施
5. 问题解决方案
6. 预计修复问题时间

【日志信息】(请附上日志文件、截图、coredump信息):
主机pg_log:

```
2024-03-16 07:16:41.017 65f4d6d8.5059 db_testb_in 140298432673536 gsql 135961 dn_6001_6002_6003 00000  1125899906846077 [BACKEND] CONTEXT:  SQL statement "ALTER EXTENSION dolphin UPDATE TO '2.0'"
	PL/pgSQL function inline_code_block line 8 at SQL statement
2024-03-16 07:16:41.066 65f4d6d8.5059 db_testb_in 140298432673536 gsql 135961 dn_6001_6002_6003 00000  1125899906846077 [BACKEND] LOG:  Delete object 1255/13341/0
2024-03-16 07:16:41.066 65f4d6d8.5059 db_testb_in 140298432673536 gsql 135961 dn_6001_6002_6003 00000  1125899906846077 [BACKEND] CONTEXT:  SQL statement "ALTER EXTENSION dolphin UPDATE TO '2.0'"
	PL/pgSQL function inline_code_block line 8 at SQL statement
2024-03-16 07:16:41.193 65f4d6d8.5059 db_testb_in 140298432673536 gsql 135961 dn_6001_6002_6003 55000  1125899906846077 [BACKEND] ERROR:  cannot drop extension "dolphin" because it is being modified
2024-03-16 07:16:41.193 65f4d6d8.5059 db_testb_in 140298432673536 gsql 135961 dn_6001_6002_6003 55000  1125899906846077 [BACKEND] CONTEXT:  SQL statement "ALTER EXTENSION dolphin UPDATE TO '2.0'"
	PL/pgSQL function inline_code_block line 8 at SQL statement
2024-03-16 07:16:41.195 65f4d6d8.5059 db_testb_in 140298432673536 gsql 135961 dn_6001_6002_6003 55000  1125899906846077 [BACKEND] STATEMENT:  DECLARE
	    cnt int;
	BEGIN
	    select count(*) into cnt from pg_type where oid = 4408;
	    if cnt = 1 then
	            DROP FUNCTION IF EXISTS pg_catalog.undefinedin(cstring) CASCADE;
	            DROP FUNCTION IF EXISTS pg_catalog.undefinedout(undefined) CASCADE;
	            DROP FUNCTION IF EXISTS pg_catalog.undefinedrecv(internal) CASCADE;
	            DROP FUNCTION IF EXISTS pg_catalog.undefinedsend(undefined) CASCADE;
	    end if;
	END;
	DROP TYPE IF EXISTS pg_catalog.undefined CASCADE;
	DO $DO$
	DECLARE
	ans boolean;
	BEGIN
	select case when count(*) = 1 then true else false end as ans from (select nspname from pg_namespace where nspname='dbe_perf' limit 1) into ans;
	IF ans = true then
	DROP FUNCTION IF EXISTS DBE_PERF.get_global_full_sql_by_timestamp();
	DROP FUNCTION IF EXISTS DBE_PERF.get_global_slow_sql_by_timestamp();
	DROP VIEW IF EXISTS DBE_PERF.statement_history;
	END IF;
	END $DO$;
	
```

【测试代码】:
不涉及

openGauss/openGauss-server

内容风险标识

评论 (5)

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

内容风险标识