【测试类型：SQL功能】【测试版本：6.0.0】设置autocommit=0后设置transaction_isolation后进行show数据库core

【标题描述】:设置autocommit=0后设置transaction_isolation后进行show数据库core
【测试类型：SQL功能】【测试版本：6.0.0】 问题描述
设置autocommit=0后设置transaction_isolation后进行show数据库core
【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):
openEuler release 20.03 (LTS)
Linux dggpopel00002 4.19.90-2003.4.0.0036.oe1.x86_64 #1 SMP Mon Mar 23 19:10:41 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux
【测试环境】(单机/1主x备x级联备):
1主2备
【被测功能】:
autocommit
【测试类型】:
SQL功能
【数据库版本】(查询命令: gaussdb -V):
gaussdb (openGauss 6.0.0 build 0450b00f) compiled at 2024-06-13 00:08:46 commit 0 last mr
【预置条件】:
兼容B下执行
【操作步骤】(请填写详细的操作步骤):
1. set autocommit=0;
set local transaction isolation level read committed read only;
show transaction_isolation;

【预期输出】:
1.成功

【实际输出】:
1.失败 数据库core
(gdb) bt
#0  BBOX_CreateCoredump (file_name=file_name@entry=0x0) at bbox_create.cpp:404
#1  0x000056520fc08e11 in bbox_handler (sig=<optimized out>, si=<optimized out>, uc=<optimized out>) at gs_bbox.cpp:116
#2  bbox_handler (sig=<optimized out>, si=<optimized out>, uc=<optimized out>) at gs_bbox.cpp:103
#3  <signal handler called>
#4  RedirectManager::get_remote_excute (this=0x0) at ../../../../src/include/replication/libpqsw.h:286
#5  libpqsw_skip_check_readonly () at libpqsw.cpp:574
#6  0x00007f5e761a5d55 in check_xact_readonly (parse_tree=0x7f5e774bab80) at plugin_utility.cpp:446
#7  standard_ProcessUtility (processutility_cxt=processutility_cxt@entry=0x7f5e7a1b6110, dest=dest@entry=0x7f5e786261c8,
    sent_to_remote=<optimized out>, completion_tag=completion_tag@entry=0x7f5e7a1b6180 "", context=context@entry=PROCESS_UTILITY_TOPLEVEL,
    isCTAS=<optimized out>) at plugin_utility.cpp:2660
#8  0x000056520ffd6784 in standard_ProcessUtility (processutility_cxt=processutility_cxt@entry=0x7f5e7a1b6110, dest=dest@entry=0x7f5e786261c8,
    sent_to_remote=<optimized out>, completion_tag=completion_tag@entry=0x7f5e7a1b6180 "", context=context@entry=PROCESS_UTILITY_TOPLEVEL,
    isCTAS=<optimized out>) at utility.cpp:2567
#9  0x00007f6018ab82d1 in gsaudit_ProcessUtility_hook (processutility_cxt=0x7f5e7a1b6110, dest=0x7f5e786261c8, sentToRemote=<optimized out>,
    completionTag=0x7f5e7a1b6180 "", context=PROCESS_UTILITY_TOPLEVEL, isCTAS=<optimized out>) at gs_policy_plugin.cpp:819
#10 0x000056520ffdf50f in pgaudit_ProcessUtility (processutility_cxt=0x7f5e7a1b6110, dest=<optimized out>, sentToRemote=<optimized out>,
    completionTag=<optimized out>, context=<optimized out>, isCTAS=<optimized out>) at auditfuncs.cpp:1419
#11 0x000056520ffda51b in ProcessUtility (processutility_cxt=processutility_cxt@entry=0x7f5e7a1b6110, dest=dest@entry=0x7f5e786261c8,
    sent_to_remote=sent_to_remote@entry=false, completion_tag=completion_tag@entry=0x7f5e7a1b6180 "",
    context=context@entry=PROCESS_UTILITY_TOPLEVEL, isCTAS=isCTAS@entry=false) at utility.cpp:1565
#12 0x000056520ffcbd35 in PortalRunUtility (portal=portal@entry=0x7f5e77c16050, utilityStmt=0x7f5e774bab80, isTopLevel=isTopLevel@entry=true,
    dest=dest@entry=0x7f5e786261c8, completionTag=completionTag@entry=0x7f5e7a1b6180 "") at pquery.cpp:1740
#13 0x000056520ffcfa2e in FillPortalStore (portal=0x7f5e77c16050, isTopLevel=<optimized out>) at ../../../../src/include/nodes/pg_list.h:96
#14 0x000056520ffd0b96 in PortalRun (portal=portal@entry=0x7f5e77c16050, count=count@entry=9223372036854775807,
    isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x7f5e774bac30, altdest=altdest@entry=0x7f5e774bac30,
    completionTag=completionTag@entry=0x7f5e7a1b64f0 "") at pquery.cpp:1150
#15 0x000056520ffbd3fc in exec_simple_query (query_string=<optimized out>, messageType=<optimized out>, msg=<optimized out>)
    at postgres.cpp:3095
#16 0x000056520ffc243e in PostgresMain (argc=<optimized out>, argv=argv@entry=0x7f5ec7559d90, dbname=<optimized out>, username=<optimized out>)
    at postgres.cpp:9262
#17 0x000056520ff127c5 in BackendRun (port=port@entry=0x7f5e7a1b8100) at postmaster.cpp:9655
#18 0x000056520ff42168 in GaussDbThreadMain<(knl_thread_role)1> (arg=0x7f5ee3f7b278) at postmaster.cpp:12029
#19 0x000056520ff12855 in InternalThreadFunc (args=<optimized out>) at postmaster.cpp:14891
#20 0x00007f601a233fed in ?? () from /lib64/libpthread.so.0
#21 0x00007f601a16718f in clone () from /lib64/libc.so.6

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

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

【测试代码】:

openGauss/Plugin

内容风险标识

评论 (2)

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

内容风险标识