【测试类型：SQL功能】【测试版本：3.0.5】【自动化】删除数据库时产生了core，数据库宕机

【标题描述】:
【测试类型：SQL功能】【测试版本：3.0.5】 删除数据库时产生了core，数据库宕机

【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):
CentOS Linux release 7.6.1810 (Core)
Linux kwepwebenv18742 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级联备):
1主2备

【被测功能】:
gin_index+gs_dump+gs_restore

【测试类型】:
功能测试

【数据库版本】(查询命令: gaussdb -V):
gaussdb (openGauss 3.0.5 build 982f0c61) compiled at 2023-08-02 18:20:42 commit 0 last mr

【预置条件】:
1.创建数据库
drop database if exists dbsys_restore_db;create database dbsys_restore_db;

【操作步骤】(请填写详细的操作步骤):
1. 设置参数
SET ENABLE_SEQSCAN=off;
RESET ENABLE_INDEXSCAN;
RESET ENABLE_BITMAPSCAN;
2. 建表插入数据
DROP TABLE IF EXISTS test_gin_2;
CREATE TABLE test_gin_2 (id INT, first_name text, last_name text) WITH (ORIENTATION = COLUMN);
INSERT INTO test_gin_2 SELECT id, md5(random()::text), md5(random()::text) FROM (SELECT * FROM generate_series(1,2000000) AS id) AS x;
INSERT INTO test_gin_2 VALUES(1, 'China, officially the People''s Republic of China (PRC), located in Asia, is the world''s most populous state.', 'China');
INSERT INTO test_gin_2 VALUES(2, 'America is a rock band, formed in England in 1970 by multi-instrumentalists Dewey Bunnell, Dan Peek, and Gerry Beckley.', 'America');
INSERT INTO test_gin_2 VALUES(3, 'England is a country that is part of the United Kingdom. It shares land borders with Scotland to the north and Wales to the west.', 'England');
INSERT INTO test_gin_2 VALUES(4, 'Australia, officially the Commonwealth of Australia, is a country comprising the mainland of the Australian continent, the island of Tasmania, and numerous smaller islands.', 'Australia');
INSERT INTO test_gin_2 VALUES(5, 'Russia, also officially known as the Russian Federation, is a sovereign state in northern Eurasia.', 'Russia');
INSERT INTO test_gin_2 VALUES(6, 'Japan is an island country in East Asia.', 'Japan');
INSERT INTO test_gin_2 VALUES(7, 'Germany, officially the Federal Republic of Germany, is a sovereign state and federal parliamentary republic in central-western Europe.');
INSERT INTO test_gin_2 VALUES(8, 'France, is a sovereign state comprising territory in western Europe and several overseas regions and territories.', 'France');
INSERT INTO test_gin_2 VALUES(9, 'Italy officially the Italian Republic, is a unitary parliamentary republic in Europe.', 'Italy');
INSERT INTO test_gin_2 VALUES(10, 'India, officially the Republic of India, is a country in South Asia.', 'India');
INSERT INTO test_gin_2 VALUES(11, 'Brazil, officially the Federative Republic of Brazil, is the largest country in both South America and Latin America.', 'Brazil');
INSERT INTO test_gin_2 VALUES(12, 'Canada is a country in the northern half of North America.', 'Canada');
INSERT INTO test_gin_2 VALUES(13, 'Mexico, officially the United Mexican States, is a federal republic in the southern part of North America.', 'Mexico');
INSERT INTO test_gin_2 VALUES(13, 'Mexico, officially the United Mexican States, is a federal republic in the southern part of North America.', 'Mexico');
INSERT INTO test_gin_2 VALUES(14, 'Mexico, officially the United Mexican States, is a federal republic in the southern part of North America.', 'Mexicox');
INSERT INTO test_gin_2 VALUES(15, 'Mexico, officially the United Mexican States, is a federal republic in the southern part of North America.', 'Mexicos');
3. 创建GIN索引
CREATE INDEX  test_gin_2_first_name_idx  ON test_gin_2 USING GIN(to_tsvector('english', first_name));
4. dump file
gs_dump dbsys_restore_db -p 51817 -f /data/func_a_0773/cluster/dn1/Opengauss_Gin_Index_0028.tar -F t
5. restore file
gs_restore -U 'tpccuser' -W 'hua@429*Test' -p 51817 -d dbsys_restore_db '/data/func_a_0773/cluster/dn1/Opengauss_Gin_Index_0028.tar' -c
6. 查看GIN索引
\di
7. 查询
SET ENABLE_SEQSCAN=off;SELECT * FROM test_gin_2 WHERE to_tsvector('english', first_name) @@ to_tsquery('english', 'Mexico');explain SELECT * FROM test_gin_2 WHERE to_tsvector('english', first_name) @@ to_tsquery('english', 'Mexico');
8.清理环境
drop table test_gin_2;
drop database dbsys_restore_db;

【预期输出】:
1-8步骤均预期成功

【实际输出】:
1-7步骤执行成功，8步骤执行失败

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

【日志信息】(请附上日志文件、截图、coredump信息):
![输入图片说明](https://foruda.gitee.com/images/1691118414826699060/37e898b4_8772917.png "屏幕截图")

【测试代码】:

openGauss/openGauss-server

内容风险标识

评论 (2)

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

内容风险标识