401 Star 1.3K Fork 1.5K

GVPopenGauss / openGauss-server

 / 详情

【测试类型:SQL功能】【测试版本:5.0.1】【自动化】执行hash索引相关用例后,备机重启异常,产生core

已验收
缺陷
创建于  
2023-11-30 16:37

【标题描述】: 执行hash索引相关用例后,备机重启异常,产生core
【测试类型:SQL功能】【测试版本:5.0.1】 执行hash索引相关用例后,备机重启异常,产生core

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

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

【被测功能】:
hash索引

【测试类型】:
功能测试

【数据库版本】(查询命令: gaussdb -V):
gaussdb (openGauss 5.0.1 build d855a18f) compiled at 2023-11-28 19:42:55 commit 0 last mr

【预置条件】:
数据库功能正常

【操作步骤】(请填写详细的操作步骤):

  1. 执行hash索引相关用例
  2. 重启数据库

【预期输出】:

  1. 执行hash索引相关用例
  2. 重启数据库成功

【实际输出】:

  1. 执行hash索引相关用例
  2. 重启数据库失败,产生core

【原因分析】:

  1. 优化引入

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

#0  BBOX_CreateCoredump (file_name=file_name@entry=0x0) at bbox_create.cpp:404
#1  0x0000557b1f63cf09 in bbox_handler (sig=<optimized out>, si=<optimized out>, uc=<optimized out>) at gs_bbox.cpp:112
#2  <signal handler called>
#3  pg_atomic_read_u64 (ptr=0x8) at ../../../../src/include/utils/atomic.h:293
#4  MarkBufferDirty (buffer=159680) at bufmgr.cpp:3258
#5  0x0000557b1fe4d35f in hash_xlog_squeeze_page (record=0x7fa207098d90) at hash_xlog.cpp:434
#6  0x0000557b1fe4d69f in hash_redo (record=0x7fa207098d90) at hash_xlog.cpp:831
#7  0x0000557b1fdc6a05 in ApplyRedoRecord (record=record@entry=0x7fa207098d90) at multi_redo_api.cpp:403
#8  0x0000557b1fd77117 in parallel_recovery::ApplySinglePageRecord (item=0x7fa207098d50, replayUndo=<optimized out>) at page_redo.cpp:565
#9  0x0000557b1fd78824 in parallel_recovery::ApplyAndFreeRedoItem (item=0x7fa207098d50) at page_redo.cpp:500
#10 parallel_recovery::ApplyProcHead (head=0x0, head@entry=0x7fa207098d50) at page_redo.cpp:417
#11 0x0000557b1fd79010 in parallel_recovery::ApplyRedoLoop () at page_redo.cpp:440
#12 parallel_recovery::PageRedoWorkerMain () at page_redo.cpp:328
#13 0x0000557b1fdc6316 in MultiRedoMain () at multi_redo_api.cpp:222
#14 0x0000557b1f958750 in GaussDbAuxiliaryThreadMain<(knl_thread_role)22> (arg=arg@entry=0x7fa248c33388) at postmaster.cpp:13351
#15 0x0000557b1f958a5b in GaussDbThreadMain<(knl_thread_role)22> (arg=0x7fa248c33388) at postmaster.cpp:13716
#16 0x0000557b1f92bcc5 in InternalThreadFunc (args=<optimized out>) at postmaster.cpp:14298
#17 0x00007fa2c4bce32a in ?? () from /usr/lib64/libc.so.6
#18 0x00007fa2c4c50370 in ?? () from /usr/lib64/libc.so.6


【测试代码】:

评论 (3)

裴琳倩 创建了缺陷
裴琳倩 添加协作者周斌
展开全部操作日志

Hey @裴琳倩, Welcome to openGauss Community.
All of the projects in openGauss Community are maintained by @opengauss_bot.
That means the developers can comment below every pull request or issue to trigger Bot Commands.
Please follow instructions at Here to find the details.

Hi @裴琳倩, please use the command /sig xxx to add a SIG label to this issue.
For example: /sig sqlengine or /sig storageengine or /sig om or /sig ai and so on.
You can find more SIG labels from Here.
If you have no idea about that, please contact with @xiangxinyong , @zhangxubo .

jiexiao1413 取消协作者周斌
jiexiao1413 添加协作者陈栋
裴琳倩 修改了标题
zhengxue 任务状态待办的 修改为已确认
zhengxue 任务状态已确认 修改为修复中
周斌 修改了备注
zhengxue 任务状态修复中 修改为已完成
zhengxue 任务状态已完成 修改为待回归
jiexiao1413 任务状态待回归 修改为测试中

验收日期:2023-12-15
验收版本:gaussdb (openGauss 5.0.1 build a882b4b1) compiled at 2023-12-07 11:55:05 commit 0 last mr
验收结论:通过
验收截图:之前HASH索引用例会执行失败,现在执行成功
输入图片说明

裴琳倩 任务状态测试中 修改为已验收

登录 后才可以发表评论

状态
负责人
项目
里程碑
Pull Requests
关联的 Pull Requests 被合并后可能会关闭此 issue
分支
开始日期   -   截止日期
-
置顶选项
优先级
预计工期 (小时)
参与者(3)
13084139 opengauss bot 1686829535
C++
1
https://gitee.com/opengauss/openGauss-server.git
git@gitee.com:opengauss/openGauss-server.git
opengauss
openGauss-server
openGauss-server

搜索帮助