【标题描述】:
【测试类型：存储功能】【测试版本：3.0.0】使用Jmeter工具向行存压缩表插入数据，数据量1G以上时必现失败（5/5），compresstype=2

【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):
openEuler release 20.03 (LTS)
Linux openGauss171 4.19.90-2003.4.0.0036.oe1.aarch64 #1 SMP Mon Mar 23 19:06:43 UTC 2020 aarch64 aarch64 aarch64 GNU/Linux

【测试环境】(单机/1主x备x级联备):单机

【被测功能】:行存压缩

【测试类型】:存储功能

【数据库版本】(查询命令: gaussdb –V):gaussdb (openGauss 2.1.0 build 23ddd1ca) compiled at 2022-01-21 20:03:08 commit 0 last mr

【预置条件】:数据库正常运行

1、创建行存压缩表，parameter compresstype=2;
create table t_rowcompress_0009(
COLUMNONE INTEGER ,
COLUMNTWO CHAR(50) ,
COLUMNTHREE VARCHAR(50) ,
COLUMNFOUR INTEGER ,
COLUMNFIVE CHAR(50) ,
COLUMNSIX VARCHAR(50) ,
COLUMNSEVEN CHAR(50) ,
COLUMNEIGHT CHAR(50) ,
COLUMNNINE VARCHAR(50) ,
COLUMNTEN VARCHAR(50) ,
COLUMNELEVEN CHAR(50) ,
COLUMNTWELVE CHAR(50) ,
COLUMNTHIRTEEN VARCHAR(50) ,
COLUMNFOURTEEN CHAR(50) ,
COLUMNFIFTEEM VARCHAR(50)
) with (compresstype=2);
2、创建非行存压缩表;
create table t_nocompress_0009(
COLUMNONE INTEGER ,
COLUMNTWO CHAR(50) ,
COLUMNTHREE VARCHAR(50) ,
COLUMNFOUR INTEGER ,
COLUMNFIVE CHAR(50) ,
COLUMNSIX VARCHAR(50) ,
COLUMNSEVEN CHAR(50) ,
COLUMNEIGHT CHAR(50) ,
COLUMNNINE VARCHAR(50) ,
COLUMNTEN VARCHAR(50) ,
COLUMNELEVEN CHAR(50) ,
COLUMNTWELVE CHAR(50) ,
COLUMNTHIRTEEN VARCHAR(50) ,
COLUMNFOURTEEN CHAR(50) ,
COLUMNFIFTEEM VARCHAR(50)
);
3、分别往两个表中插入数据
配置Jmeter工具，插入1G以上数据（200并发，10000次）
insert into t_nocompress_0009 values({__Random(1,9,)}, '{__RandomString(50,abcdefghijklmnopqrstuvwxyz,)}', '{__RandomString(50,abcdefghijklmnopqrstuvwxyz,)}',{__Random(1,9,)}, '{__RandomString(50,abcdefghijklmnopqrstuvwxyz,)}', '{__RandomString(50,abcdefghijklmnopqrstuvwxyz,)}', '{__RandomString(50,abcdefghijklmnopqrstuvwxyz,)}', '{__RandomString(50,abcdefghijklmnopqrstuvwxyz,)}', '{__RandomString(50,abcdefghijklmnopqrstuvwxyz,)}', '{__RandomString(50,abcdefghijklmnopqrstuvwxyz,)}', '{__RandomString(50,abcdefghijklmnopqrstuvwxyz,)}', '{__RandomString(50,abcdefghijklmnopqrstuvwxyz,)}', '{__RandomString(50,abcdefghijklmnopqrstuvwxyz,)}', '{__RandomString(50,abcdefghijklmnopqrstuvwxyz,)}', '{__RandomString(50,abcdefghijklmnopqrstuvwxyz,)}');
insert into t_rowcompress_0009 values({__Random(1,9,)}, '{__RandomString(50,abcdefghijklmnopqrstuvwxyz,)}', '{__RandomString(50,abcdefghijklmnopqrstuvwxyz,)}', {__Random(1,9,)}, '{__RandomString(50,abcdefghijklmnopqrstuvwxyz,)}', '{__RandomString(50,abcdefghijklmnopqrstuvwxyz,)}', '{__RandomString(50,abcdefghijklmnopqrstuvwxyz,)}', '{__RandomString(50,abcdefghijklmnopqrstuvwxyz,)}', '{__RandomString(50,abcdefghijklmnopqrstuvwxyz,)}', '{__RandomString(50,abcdefghijklmnopqrstuvwxyz,)}', '{__RandomString(50,abcdefghijklmnopqrstuvwxyz,)}', '{__RandomString(50,abcdefghijklmnopqrstuvwxyz,)}', '{__RandomString(50,abcdefghijklmnopqrstuvwxyz,)}', '{__RandomString(50,abcdefghijklmnopqrstuvwxyz,)}', '{__RandomString(50,abcdefghijklmnopqrstuvwxyz,)}');

【预期输出】:
1、成功
2、成功
3、成功

【实际输出】:
1、成功
2、成功
3、失败，数据库宕机

【原因分析】:

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

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

【测试代码】: