【测试类型：SQL功能】【测试版本：5.1.0】【自动化】jdbc接口执行json_to_record函数，发生core_dump导致主机挂了

【标题描述】:jdbc接口执行json_to_record函数，发生core_dump导致主机挂了
【测试类型：SQL功能】【测试版本：5.1.0】 【自动化】jdbc接口执行json_to_record函数，发生core_dump导致主机挂了

【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):
openEuler release 20.03 (LTS-SP1)
Linux kwepwebenv15402 4.19.90-2012.5.0.0054.oe1.x86_64 #1 SMP Tue Dec 22 15:58:47 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux
【测试环境】(单机/1主x备x级联备):
1主2备
【被测功能】:
sql功能
【测试类型】:
功能测试
【数据库版本】(查询命令: gaussdb -V):
gaussdb (openGauss 5.0.0 build d4ec129b) compiled at 2023-04-03 17:23:58 commit 0 last mr
【预置条件】:
数据库正常
【操作步骤】(请填写详细的操作步骤):
1.Jdbc连接数据库，执行sql：select * from json_to_record('{"a":1,"b":"foo","d":false}',false) as x(a int, b text, c boolean);

【预期输出】:
执行通过
 a |  b  | c
---+-----+---
 1 | foo |
【实际输出】:
主机挂掉，报错如下：
socket is not closed; Urgent packet sent to backend successfully; An I/O error occured while sending to the backend.detail:EOF Exception;
core 堆栈：
#0  0x00007f5f24c28a17 in ?? () from /data/kyleze/opengauss/install/app/lib/libgcc_s.so.1
#1  0x00007f5f24c2a738 in _Unwind_Backtrace () from /data/kyleze/opengauss/install/app/lib/libgcc_s.so.1
#2  0x00007f5f24b444f8 in backtrace () from /usr/lib64/libc.so.6
#3  0x0000563ce0de0589 in print_call_stack (fd=122, pc=165) at fatal_err.cpp:237
#4  0x0000563ce0de0c13 in gen_err_msg (sig=sig@entry=11, si=si@entry=0x7f5e401975b0, uc=uc@entry=0x7f5e40197480) at fatal_err.cpp:608
#5  0x0000563ce1039d2d in do_ffic (sig=11, si=0x7f5e401975b0, uc=0x7f5e40197480) at gs_bbox.cpp:73
#6  0x0000563ce1039d81 in bbox_handler (sig=<optimized out>, si=<optimized out>, uc=<optimized out>) at gs_bbox.cpp:104
#7  <signal handler called>
#8  0x00000000000000a5 in ?? ()
#9  0x0000563ce0dea9d5 in InputFunctionCall (flinfo=flinfo@entry=0x7f5e41bb9cb8, str=str@entry=0x0, typioparam=3865579652, typmod=-1, can_ignore=can_ignore@entry=false) at fmgr.cpp:2162
#10 0x0000563ce0c13cdb in populate_record_worker (fcinfo=<optimized out>, have_record_arg=<optimized out>) at jsonfuncs.cpp:1993
#11 0x0000563ce14755dc in ExecMakeTableFunctionResult (funcexpr=<optimized out>, econtext=0x7f5e41bb8270, expectedDesc=0x7f5e41bb8e70, randomAccess=false, node=node@entry=0x7f5e41bb8050)
    at execQual.cpp:3188
#12 0x0000563ce14d467e in FunctionNext (node=0x7f5e41bb8050) at nodeFunctionscan.cpp:63
#13 0x0000563ce147e6f8 in ExecScan (node=0x7f5e41bb8050, access_mtd=0x563ce14d4610 <FunctionNext(FunctionScanState*)>,
    recheck_mtd=0x563ce14d45e0 <FunctionRecheck(FunctionScanState*, TupleTableSlot*)>) at execScan.cpp:133
#14 0x0000563ce145b945 in ExecProcNode (node=0x7f5e41bb8050) at ../../../../src/include/executor/executor.h:278
#15 ExecutePlan (motJitContext=0x0, dest=0x7f5e4191a570, direction=<optimized out>, numberTuples=0, sendTuples=true, operation=CMD_SELECT, planstate=0x7f5e41bb8050, estate=0x7f5e407c6050)
    at execMain.cpp:2238
#16 standard_ExecutorRun (queryDesc=0x7f5e41b4ed10, direction=<optimized out>, count=0) at execMain.cpp:642
#17 0x0000563ce12d23b5 in explain_ExecutorRun (queryDesc=0x7f5e41b4ed10, direction=ForwardScanDirection, count=0) at auto_explain.cpp:122
#18 0x0000563ce145babd in ExecutorRun (queryDesc=queryDesc@entry=0x7f5e41b4ed10, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at execMain.cpp:492
#19 0x0000563ce13d286e in PortalRunSelect (portal=portal@entry=0x7f5e41bb4050, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x7f5e4191a570)
    at pquery.cpp:1413
#20 0x0000563ce13d2ed0 in PortalRun (portal=portal@entry=0x7f5e41bb4050, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x7f5e4191a570,
    altdest=altdest@entry=0x7f5e4191a570, completionTag=completionTag@entry=0x7f5e401992a0 "") at pquery.cpp:1149
#21 0x0000563ce13cb869 in exec_execute_message (max_rows=9223372036854775807, portal_name=0x7f5e4191a050 "") at postgres.cpp:5272
#22 PostgresMain (argc=<optimized out>, argv=argv@entry=0x7f5e87459da0, dbname=<optimized out>, username=<optimized out>) at postgres.cpp:9491
#23 0x0000563ce132854e in BackendRun (port=port@entry=0x7f5e40199410) at postmaster.cpp:9217
#24 0x0000563ce134e218 in GaussDbThreadMain<(knl_thread_role)1> (arg=0x7f5e9c43b5a0) at postmaster.cpp:13593
#25 0x0000563ce13285d5 in InternalThreadFunc (args=<optimized out>) at postmaster.cpp:14212
#26 0x00007f5f24bfef2b in ?? () from /usr/lib64/libpthread.so.0
#27 0x00007f5f24b3670f in clone () from /usr/lib64/libc.so.6

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

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

【测试代码】:

openGauss/openGauss-server

内容风险标识

评论 (4)

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

内容风险标识