【测试类型：SQL功能】【测试版本：5.1.0】exit handler sqlexception场景的core问题

【标题描述】:
【测试类型：SQL功能】【测试版本：5.1.0】exit handler sqlexception场景的core问题

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

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

【被测功能】:

【测试类型】:

【数据库版本】(查询命令: gaussdb -V):
gaussdb (openGauss 5.1.0 build 38fc6f41) compiled at 2023-09-26 09:29:46 commit 0 last mr  debug

【预置条件】:
B库+dolphin插件

【操作步骤】(请填写详细的操作步骤):
```
set dolphin.sql_mode = 'block_return_multi_results,ansi_quotes';
delimiter |

create table t3 (w char unique, x char)|
insert into t3 values ('a', 'b')|

create procedure bug6900_9074(z int)
begin
  declare exit handler for sqlstate '23000' select '23000';

begin
    declare exit handler for sqlexception select 'sqlexception';

if z = 1 then
      insert into t3 values ('a', 'b');
    else
      insert into t3 values ('x', 'y', 'z');
    end if;
  end;
end|

call bug6900_9074(0)|
call bug6900_9074(1)|
delimiter ;
```

【预期输出】:
![输入图片说明](https://foruda.gitee.com/images/1695699283147766671/9c599332_7698900.png "屏幕截图")

【实际输出】:
第二次执行core：
![输入图片说明](https://foruda.gitee.com/images/1695699326953258548/dbf5004f_7698900.png "屏幕截图")

core堆栈：
```
#0  BBOX_CreateCoredump (file_name=0x7f3bed1c27b0 "/data/core//core-gaussdb-3034157-2023_09_26_11_35_07-bbox.lz4") at bbox_create.cpp:404
#1  0x000000000157bec9 in bbox_handler (sig=6, si=0x7f3bed1c2e30, uc=0x7f3bed1c2d00) at gs_bbox.cpp:112
#2  <signal handler called>
#3  0x00007f3d259436eb in raise () from /lib64/libc.so.6
#4  0x00007f3d25944a11 in abort () from /lib64/libc.so.6
#5  0x0000000001253db3 in ExceptionalCondition (conditionName=0x43139a2 "!(list->tail->next == __null)", errorType=0x43138b5 "FailedAssertion",
    fileName=0x43138ac "list.cpp", lineNumber=53) at assert.cpp:46
#6  0x0000000000cefcb3 in check_list_invariants (list=0x7f3beabbf160) at list.cpp:53
#7  0x0000000000cf0be0 in list_concat (list1=0x7f3beabbf160, list2=0x7f3beabbe840) at list.cpp:540
#8  0x000000000262d54d in expand_stmt_block (estate=0x7f3bed1c47b0, stmt=0x7f3beb0185c0, exception_flag=@0x7f3bed1c3fab: false, block_ptr_stack=0x7f3beac5cce0,
    resignal_in_handler=false) at pl_exec.cpp:3494
#9  0x000000000262cce1 in expand_stmts (estate=0x7f3bed1c47b0, stmts=0x7f3beb018788, exception_flag=@0x7f3bed1c3fab: false, block_ptr_stack=0x7f3beac5cce0,
    resignal_in_handler=false) at pl_exec.cpp:3362
#10 0x000000000262cb63 in exec_stmt_block_b_exception (estate=0x7f3bed1c47b0, block=0x7f3beb018838, block_ptr_stack=0x7f3beac5cce0, resignal_in_handler=false)
    at pl_exec.cpp:3336
#11 0x000000000262c1cb in exec_stmt_block (estate=0x7f3bed1c47b0, block=0x7f3beb018838, block_ptr_stack=0x7f3beac5cce0, resignal_in_handler=false) at pl_exec.cpp:3154
#12 0x000000000262e7ac in exec_stmt (estate=0x7f3bed1c47b0, stmt=0x7f3beb018838, resignal_in_handler=false) at pl_exec.cpp:3957
#13 0x000000000262e3d0 in exec_stmts (estate=0x7f3bed1c47b0, stmts=0x7f3beb018b08, resignal_in_handler=false) at pl_exec.cpp:3876
#14 0x000000000262c891 in exec_stmt_block (estate=0x7f3bed1c47b0, block=0x7f3beb018a18, block_ptr_stack=0x0, resignal_in_handler=false) at pl_exec.cpp:3255
#15 0x0000000002627188 in plpgsql_exec_function (func=0x7f3beb420060, fcinfo=0x7f3bed1c4f00, dynexec_anonymous_block=false) at pl_exec.cpp:1501
#16 0x00007f3bea1f9a72 in b_plpgsql_call_handler (fcinfo=0x7f3bed1c4f00) at pl_handler.cpp:876
#17 0x00007f3bea13dc4d in ExecuteCallStmt (stmt=0x7f3beb00f988, params=0x0, atomic=false) at functioncmds.cpp:3495
#18 0x00007f3bea226fdb in standard_ProcessUtility (processutility_cxt=0x7f3bed1c82d0, dest=0x7f3beb00fbf8, sent_to_remote=false, completion_tag=0x7f3bed1c8870 "",
    context=PROCESS_UTILITY_TOPLEVEL, isCTAS=false) at plugin_utility.cpp:5094
#19 0x0000000001a873b6 in standard_ProcessUtility (processutility_cxt=0x7f3bed1c82d0, dest=0x7f3beb00fbf8, sent_to_remote=false, completion_tag=0x7f3bed1c8870 "",
    context=PROCESS_UTILITY_TOPLEVEL, isCTAS=false) at utility.cpp:2564
#20 0x00007f3d25853927 in gsaudit_ProcessUtility_hook (processutility_cxt=0x7f3bed1c82d0, dest=0x7f3beb00fbf8, sentToRemote=false, completionTag=0x7f3bed1c8870 "",
    context=PROCESS_UTILITY_TOPLEVEL, isCTAS=false) at gs_policy_plugin.cpp:819
#21 0x0000000001a9cd57 in pgaudit_ProcessUtility (processutility_cxt=0x7f3bed1c82d0, dest=0x7f3beb00fbf8, sentToRemote=false, completionTag=0x7f3bed1c8870 "",
    context=PROCESS_UTILITY_TOPLEVEL, isCTAS=false) at auditfuncs.cpp:1419
#22 0x0000000001af4e90 in hypo_utility_hook (processutility_cxt=0x7f3bed1c82d0, dest=0x7f3beb00fbf8, sentToRemote=false, completionTag=0x7f3bed1c8870 "",
    context=PROCESS_UTILITY_TOPLEVEL, isCtas=false) at hypopg_index.cpp:167
#23 0x0000000001a85d49 in ProcessUtility (processutility_cxt=0x7f3bed1c82d0, dest=0x7f3beb00fbf8, sent_to_remote=false, completion_tag=0x7f3bed1c8870 "",
    context=PROCESS_UTILITY_TOPLEVEL, isCTAS=false) at utility.cpp:1563
#24 0x0000000001a80b07 in PortalRunUtility (portal=0x7f3beac62060, utilityStmt=0x7f3beb00f988, isTopLevel=true, dest=0x7f3beb00fbf8, completionTag=0x7f3bed1c8870 "")
    at pquery.cpp:1724
#25 0x0000000001a81088 in PortalRunMulti (portal=0x7f3beac62060, isTopLevel=true, dest=0x7f3beb00fbf8, altdest=0x7f3beb00fbf8, completionTag=0x7f3bed1c8870 "")
    at pquery.cpp:1903
#26 0x0000000001a7f4cc in PortalRun (portal=0x7f3beac62060, count=9223372036854775807, isTopLevel=true, dest=0x7f3beb00fbf8, altdest=0x7f3beb00fbf8,
    completionTag=0x7f3bed1c8870 "") at pquery.cpp:1182
#27 0x0000000001a65e49 in exec_simple_query (query_string=0x7f3beb00e060 "call bug6900_9074(1);", messageType=QUERY_MESSAGE, msg=0x7f3bed1c8a80) at postgres.cpp:3000
#28 0x0000000001a736d3 in PostgresMain (argc=1, argv=0x7f3beb1df268, dbname=0x7f3beb1de2a0 "self_b", username=0x7f3beb1de258 "pengjiong") at postgres.cpp:9085
#29 0x00000000019b2987 in BackendRun (port=0x7f3bed1c9270) at postmaster.cpp:9398
#30 0x00000000019c3b19 in GaussDbThreadMain<(knl_thread_role)1> (arg=0x7f3c41846fd8) at postmaster.cpp:13898
#31 0x00000000019bf3a4 in InternalThreadFunc (args=0x7f3c41846fd8) at postmaster.cpp:14521
#32 0x00000000025f4bf6 in ThreadStarterFunc (arg=0x7f3c41846fc8) at gs_thread.cpp:380
#33 0x00007f3d25ad3fed in ?? () from /lib64/libpthread.so.0
#34 0x00007f3d25a0718f in clone () from /lib64/libc.so.6
```

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

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

【测试代码】:

openGauss/openGauss-server

内容风险标识

评论 (5)

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

内容风险标识