399 Star 1.4K Fork 1.5K

GVPopenGauss / openGauss-server

 / 详情

【测试类型:SQL功能】【测试版本:master】创建兼容B数据库后,连接该数据库导致数据库状态异常

Accepted
Bug
Opened this issue  
2022-04-06 16:00

【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):
Linux kwepwebenv13868 3.10.0-1062.el7.x86_64 #1 SMP Wed Aug 7 18:08:02 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux
【测试环境】(单机/1主x备x级联备):
1主2备
【被测功能】:
sql
【测试类型】:
功能测试
【数据库版本】(查询命令: gaussdb –V):
gaussdb (openGauss 3.0.0 build 02c14696) compiled at 2022-04-05 20:04:33 commit 0 last mr
【预置条件】:

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

  1. 创建B兼容数据库
    create database db_dump0124_01 dbcompatibility 'B';
  2. 连接数据库
    gsql -d db_dump0124_01 -p 50405 -r -c "drop table if exists t_dump0124;

【预期输出】:
2.连接成功,sql执行成功
【实际输出】:
2. failed to connect /data/func3_0405/cluster/tmp:50405.
且数据库会主动尝试连接改数据库,导致数据库不停down
【原因分析】:

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

【日志信息】(请附上日志文件、截图、coredump信息):
ffic_log:
FIC start time: 1649170628
A fatal error occurred at pc = 0x55fe8b934bc6
pid = 90541, tid = 92193

GaussDB Version:
(openGauss 3.0.0 build 02c14696) compiled at 2022-04-05 20:04:33 commit 0 last mr on x86_64-unknown-linux-gnu, compiled by g++ (GCC) 7.3.0, 64-bit

Fatal signal info:
si_signo = 11 (SIGSEGV), si_code = 1,si_addr = 0x590

Call stack:
[/data/func3_0405/cluster/app/bin/gaussdb + 0xe8dbc6] _Z31RelationIncrementReferenceCountP12RelationData + 0xb6
[/data/func3_0405/cluster/app/bin/gaussdb + 0xea0206] _Z21RelationIdGetRelationj + 0x56
[/data/func3_0405/cluster/app/bin/gaussdb + 0x18009d2] _Z13relation_openjis + 0x222
[/data/func3_0405/cluster/app/bin/gaussdb + 0x1800d3f] _Z9heap_openjis + 0xf
[/data/func3_0405/cluster/app/bin/gaussdb + 0x12ad29e] _Z22CheckIfExtensionExistsPKc + 0x2e
[/data/func3_0405/cluster/app/bin/gaussdb + 0x1463740] _Z26InitBSqlPluginHookIfNeededv + 0x10
[/data/func3_0405/cluster/app/bin/gaussdb + 0x146a069] Z12PostgresMainiPPcPKcS2 + 0x4e9
[/data/func3_0405/cluster/app/bin/gaussdb + 0x13d52ae]0x55fe8be7c2ae
[/data/func3_0405/cluster/app/bin/gaussdb + 0x13f3ab8] _Z17GaussDbThreadMainIL15knl_thread_role1EEiP14knl_thread_arg + 0x2f8
[/data/func3_0405/cluster/app/bin/gaussdb + 0x13d5335]0x55fe8be7c335
[/lib64/libpthread.so.0 + 0x7e65] start_thread + 0xc5
[/lib64/libc.so.6 + 0xfe88d] clone + 0x6d

Two methods for parsing function names are listed here:

1. Using CLI tool such as "c++filt"

$ c++filt

2. Or Using online tool

Two steps for parsing a line number:

1. objcopy --add-gnu-debuglink=

2. addr2line -e

Registers:
RDI = 0x00007fa3861eae40
RSI = 0x00007fa3883c6f90
RBP = 0x00007fa3883c6f70
RBX = 0x00007fa3861eae40
RDX = 0x0000000000000000
RAX = 0x0000000000000000
RCX = 0x0000000000000c07
RSP = 0x00007fa3883c6f60
RIP = 0x000055fe8b934bc6
R8 = 0x0000000000000000
R9 = 0x00007fa3e4b67328
R10 = 0x0000000000000c07
R11 = 0x00007fa50d15b210
R12 = 0xfffffffffffd8de8
R13 = 0x0000000000000c07
R14 = 0x00007fa3867c10f0
R15 = 0x00007fa3883c77b0

Top of stack: (sp = 0x0167fa3883c6f60)

corefile:
[图片上传中…(image-MKQGyPJ42KT8oNhVtSvT)]
pg_log:
2022-04-05 23:44:20.014 624c6390.6131 [unknown] 139654306195200 dn_6001 0 dn_6001_6002_6003 00000 0 [BACKEND] LOG: Could not connect to the db_dump0124_01, the connection info : wait localhost:50405 timeout expired

【测试代码】:

Comments (3)

liumin created缺陷

Hey @liumin, 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.

liumin set assignee to chenxiaobin
liumin set priority to Serious
liumin changed title
liumin changed description
chenxiaobin throughopengauss/openGauss-server Pull Request !1666 changed issue state from 待办的 to 已完成
liumin changed issue state from 已完成 to 测试中
liumin changed issue state from 测试中 to 已验收

gaussdb (openGauss 3.0.0 build 6ba4c95f) compiled at 2022-04-11 20:04:29 commit 0 last mr
已验证

Sign in to comment

Status
Assignees
Projects
Milestones
Pull Requests
Successfully merging a pull request will close this issue.
Branches
Planed to start   -   Planed to end
-
Top level
Priority
Duration (hours)
参与者(3)
5622128 opengauss bot 1581905080
C++
1
https://gitee.com/opengauss/openGauss-server.git
git@gitee.com:opengauss/openGauss-server.git
opengauss
openGauss-server
openGauss-server

Search