分区表 drop index concurrently 和 reindex partition 同时执行，在 debug 版本有概率触发 Assert

【标题描述】:
【测试类型：SQL功能/并发】【测试版本：5.0.0】

问题描述： 分区表同时执行表上索引的 concurrently drop 和 reindex index partition 并发执行，有概率触发 Assert

【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):

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

【被测功能】: drop index concurrently 和 reindex index partition

【测试类型】: 功能测试/并发测试

【数据库版本】(查询命令: gaussdb -V): gsql ((openGauss 5.0.2 build 4dec4e00) compiled at 2024-09-03

【预置条件】: 启动单节点或集群，创建测试表和测试索引

【操作步骤】(请填写详细的操作步骤):
1. 建表，插入数据，创建索引
2. 启动两个会话，其中一个执行 drop index concurrently ，另一个执行 reindex index partition 
3. 有概率触发 drop index 中的 Assert 
4. 如果复现概率不高，可以通过在代码中增加 sleep 操作提高问题触发概率

【预期输出】: 预期执行成功或者报错，但进程还在

【实际输出】: 触发 coredump

【原因分析】:
1. drop index concurrently 对表和索引加锁级别为
2. 问题推断过程
3. 还有哪些原因可能造成类似现象
4. 该问题是否有临时规避措施
5. 问题解决方案
6. 预计修复问题时间

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

#0  BBOX_CreateCoredump (file_name=0x7fe3a37c4030 "/data/core//core-gaussdb-15634-2024_09_03_18_28_28-bbox.lz4")
    at bbox_create.cpp:404
#1  0x00000000014cf9ff in bbox_handler (sig=6, si=0x7fe3a37c46b0, uc=0x7fe3a37c4580) at gs_bbox.cpp:112
#2  <signal handler called>
#3  0x00007fe4e26ca387 in raise () from /lib64/libc.so.6
#4  0x00007fe4e26cba78 in abort () from /lib64/libc.so.6
#5  0x00000000011b5c2c in ExceptionalCondition (conditionName=0x415d7ee "!(!indexForm->indisvalid)", 
    errorType=0x415b1d7 "FailedAssertion", fileName=0x415c098 "index.cpp", lineNumber=5119) at assert.cpp:46
#6  0x0000000000b6c4a3 in index_set_state_flags (indexId=16418, action=INDEX_DROP_SET_DEAD) at index.cpp:5119
#7  0x0000000000b6443c in index_concurrently_set_dead (heapId=16384, indexId=16418) at index.cpp:1904
#8  0x0000000000b6537f in index_drop (indexId=16418, concurrent=true, concurrent_lock_mode=false) at index.cpp:2490
#9  0x0000000000b3f1e6 in doDeletion (object=0x7fe3a5fd75d8, flags=2) at dependency.cpp:1248
#10 0x0000000000b3ed91 in deleteOneObject (object=0x7fe3a5fd75d8, depRel=0x7fe3a37c58a0, flags=2)
    at dependency.cpp:1145
#11 0x0000000000b3cdaf in deleteObjectsInList (targetObjects=0x7fe3a7ffcfc0, depRel=0x7fe3a37c58a0, flags=2)
    at dependency.cpp:234
#12 0x0000000000b3d539 in performMultipleDeletions (objects=0x7fe3a7ffcd30, behavior=DROP_RESTRICT, flags=2, 
    isPkgDropTypes=false) at dependency.cpp:489
#13 0x0000000001776d95 in RemoveRelations (drop=0x7fe3a7ced5d0, tmp_queryString=0x7fe3a7ffcc60, 
    exec_type=0x7fe3a37c59e4) at tablecmds.cpp:3775
#14 0x00000000019d97d6 in ExecDropStmt (parse_tree=0x7fe3a7ced5d0, 
    query_string=0x7fe3a7cec060 "drop index concurrently btreeidx_01;", sent_to_remote=false, is_top_level=true)
    at utility.cpp:7066
#15 0x00000000019d876d in ProcessUtilitySlow (parse_tree=0x7fe3a7ced5d0, 
    query_string=0x7fe3a7cec060 "drop index concurrently btreeidx_01;", params=0x0, dest=0x7fe3a7ced6e8, 
    sent_to_remote=false, completion_tag=0x7fe3a37c8b10 "", context=PROCESS_UT
#16 0x00000000019d416a in standard_ProcessUtility (processutility_cxt=0x7fe3a37c8700, dest=0x7fe3a7ced6e8, 
    sent_to_remote=false, completion_tag=0x7fe3a37c8b10 "", context=PROCESS_UTILITY_TOPLEVEL, isCTAS=false)
    at utility.cpp:3019
#17 0x00007fe4d7159901 in gsaudit_ProcessUtility_hook (processutility_cxt=0x7fe3a37c8700, dest=0x7fe3a7ced6e8, 
    sentToRemote=false, completionTag=0x7fe3a37c8b10 "", context=PROCESS_UTILITY_TOPLEVEL, isCTAS=false)
    at gs_policy_plugin.cpp:819
---Type <return> to continue, or q <return> to quit---
#18 0x00000000019e89b5 in pgaudit_ProcessUtility (processutility_cxt=0x7fe3a37c8700, dest=0x7fe3a7ced6e8, 
    sentToRemote=false, completionTag=0x7fe3a37c8b10 "", context=PROCESS_UTILITY_TOPLEVEL, isCTAS=false)
    at auditfuncs.cpp:1419
#19 0x0000000001a3fbba in hypo_utility_hook (processutility_cxt=0x7fe3a37c8700, dest=0x7fe3a7ced6e8, 
    sentToRemote=false, completionTag=0x7fe3a37c8b10 "", context=PROCESS_UTILITY_TOPLEVEL, isCtas=false)
    at hypopg_index.cpp:167
#20 0x00000000019d1af8 in ProcessUtility (processutility_cxt=0x7fe3a37c8700, dest=0x7fe3a7ced6e8, 
    sent_to_remote=false, completion_tag=0x7fe3a37c8b10 "", context=PROCESS_UTILITY_TOPLEVEL, isCTAS=false)
    at utility.cpp:1563
#21 0x00000000019cc9da in PortalRunUtility (portal=0x7fe3a66e2060, utilityStmt=0x7fe3a7ced5d0, isTopLevel=true, 
    dest=0x7fe3a7ced6e8, completionTag=0x7fe3a37c8b10 "") at pquery.cpp:1723
#22 0x00000000019ccf33 in PortalRunMulti (portal=0x7fe3a66e2060, isTopLevel=true, dest=0x7fe3a7ced6e8, 
    altdest=0x7fe3a7ced6e8, completionTag=0x7fe3a37c8b10 "") at pquery.cpp:1901
#23 0x00000000019cb3cf in PortalRun (portal=0x7fe3a66e2060, count=9223372036854775807, isTopLevel=true, 
    dest=0x7fe3a7ced6e8, altdest=0x7fe3a7ced6e8, completionTag=0x7fe3a37c8b10 "") at pquery.cpp:1181
#24 0x00000000019b2132 in exec_simple_query (query_string=0x7fe3a7cec060 "drop index concurrently btreeidx_01;", 
    messageType=QUERY_MESSAGE, msg=0x7fe3a37c8d20) at postgres.cpp:2970
#25 0x00000000019bf93a in PostgresMain (argc=1, argv=0x7fe3a7407268, dbname=0x7fe3a74062a0 "postgres", 
    username=0x7fe3a7406258 "wusong") at postgres.cpp:9074
#26 0x00000000019000aa in BackendRun (port=0x7fe3a37c9210) at postmaster.cpp:9249
#27 0x0000000001910fbf in GaussDbThreadMain<(knl_thread_role)1> (arg=0x7fe402886fa0) at postmaster.cpp:13686
#28 0x000000000190c88c in InternalThreadFunc (args=0x7fe402886fa0) at postmaster.cpp:14307
#29 0x00000000024e2ff9 in ThreadStarterFunc (arg=0x7fe402886f90) at gs_thread.cpp:382
#30 0x00007fe4e2a69ea5 in start_thread () from /lib64/libpthread.so.0
#31 0x00007fe4e2792b0d in clone () from /lib64/libc.so.6

【测试代码】:

create table btreeindex_t1(c1 int,c2 int,c3 int,c4 text,c5 text,c6 text,c7 int)
partition by range(c1) subpartition by list(c7)
(
  partition btreeindex_t1_p1 values less than (20001)
  (
    subpartition btreeindex_t1_p1_1 values (1),
    subpartition btreeindex_t1_p1_2 values (2)
  ),
  partition btreeindex_t1_p2 values less than (40000)
  (
    subpartition btreeindex_t1_p2_1 values (3),
    subpartition btreeindex_t1_p2_2 values (4)
  )
);

insert into btreeindex_t1 select a,a,a,a || 'MOG',a || 'DB',a || 'YYY',1 from generate_series(1,10000) as a;
insert into btreeindex_t1 select a,a,a,a || 'MOG',a || 'DB',a || 'YYY',2 from generate_series(10001,20000) as a;
insert into btreeindex_t1 select a,a,a,a || 'MOG',a || 'DB',a || 'YYY',3 from generate_series(20001,30000) as a;
insert into btreeindex_t1 select a,a,a,a || 'MOG',a || 'DB',a || 'YYY',4 from generate_series(30001,38000) as a;

create index btreeidx_01 on btreeindex_t1 using btree(c1,c2,c3,c4,c5,c6,c7) local;

-- 2. 一个会话执行 drop index concurrently
drop index concurrently btreeidx_01;

-- 3. 另一个会话执行
reindex index btreeidx_01 partition btreeindex_t1_p1_1_c1_c2_c3_c4_c5_c6_c7_idx;

openGauss/openGauss-server

内容风险标识

评论 (7)

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

内容风险标识