已关闭
[Bug]: 索引扫描SMP FailedAssertion("!(((const void*)(&isNull) != __null) && (scankey->sk_attno) > 0)" #8491
Anderles创建于  19 天前关闭于  15 天前
Anderles
19 天前 创建

测试类型

SQL功能

测试版本

7.0.0-RC3

问题描述

操作系统和硬件信息

openEuler release 24.03 (LTS-SP4)

测试环境

轻量版服务器安装

被测功能

实现索引扫描SMP
https://gitcode.com/opengauss/openGauss-server/pull/9321

预置条件

master 315f44e087127a2bb48bf4f16c89dbb45225886d 编译

操作步骤

CREATE TABLE smp_int84_min (k int8 NOT NULL);
INSERT INTO smp_int84_min VALUES (1);
CREATE INDEX smp_int84_min_k_idx ON smp_int84_min(k);
ANALYZE smp_int84_min;

DROP TABLE IF EXISTS smp_int84_min;
CREATE TABLE smp_int84_min (k int8 NOT NULL);
INSERT INTO smp_int84_min VALUES (1);
CREATE INDEX smp_int84_min_k_idx ON smp_int84_min (k);
ANALYZE smp_int84_min;

SET query_dop = 3;
SET enable_force_smp = on;
SET enable_seqscan = off;
SET enable_indexscan = on;
SET enable_indexonlyscan = off;
SET enable_bitmapscan = off;

EXPLAIN (COSTS OFF)
SELECT count(*) FROM smp_int84_min WHERE k >= 1;

SELECT count(*) FROM smp_int84_min WHERE k >= 1;

预期输出

无core

实际输出

openGauss=# SELECT count(*) FROM smp_int84_min WHERE k >= 1;
The connection to the server was lost. Attempting reset: Failed.
!>
!>

日志信息

TRAP: FailedAssertion("!(((const void*)(&isNull) != __null) && (scankey->sk_attno) > 0)", File: "nbtsearch.cpp", Line: 734)

提单组织

联合伙伴

测试代码

likedislike
opengauss_bot
opengauss_bot成员
19 天前 评论:

This issue requires an assignee. Since you haven't specified one, we've assigned TestManager as the default assignee for this issue.

likedislike
opengauss_botopengauss_bot成员
19 天前 将 TestManager 设为负责人
opengauss_bot
opengauss_bot成员
19 天前 评论:

Welcome To openGauss Community

Hey @Anderles , thanks for your contribution to the community.

Bot Usage Manual

I'm the Bot here serving you. You can find the instructions on how to interact with me at Here . That means you can comment below every pull request or issue to trigger Bot Commands. You can self-configure the PR merge rules for this repository. For more details, please refer to Here.

Contact Guide

If you have any questions, please contact the SIG: StorageEngine, AI, CM, CloudNative, SecurityTechnology, SQLEngine ,
and any of the maintainers: @CarrotGo, @chendong76, @chenxiaobin19, @congzhou2603, @dodders, @hwworkholic, @jemappellehc, @libiao2024, @muyulinzhong, @quemingjian, @shenzheng4, @shirley_zhengx, @superlchf, @totaj, @wlff234, @wofanzheng, @ywzq1161327784 ,
and any of the committers: @Igali, @bihua111, @cailei19, @h_ray, @levy53071, @libiao2024, @lihaixiao, @mrzack, @wangfeihuo, @wuyuechuan, @xiong_xjun, @zhangfengzhi123, @zhangxubo, @zhangzq131, @zjh_hw .

likedislike
opengauss_botopengauss_bot成员
19 天前 添加了label:sig/StorageEngine
liuzhen001liuzhen001成员
19 天前 关联了看板:openGauss 7.0.0-LTS
yanghaosyanghaos成员
18 天前 关联了pull request:修复索引smp扫描core问题
ywzq1161327784ywzq1161327784成员
18 天前 issue状态由 待办的 改变为 待回归
sungang14
sungang14成员
15 天前 评论:

【回归人员】sungang14
【回归日期】2026.9.12
【回归版本】openGauss 7.0.0B023
【回归结论】通过
【回归步骤】
CREATE TABLE smp_int84_min (k int8 NOT NULL);
INSERT INTO smp_int84_min VALUES (1);
CREATE INDEX smp_int84_min_k_idx ON smp_int84_min(k);
ANALYZE smp_int84_min;

DROP TABLE IF EXISTS smp_int84_min;
CREATE TABLE smp_int84_min (k int8 NOT NULL);
INSERT INTO smp_int84_min VALUES (1);
CREATE INDEX smp_int84_min_k_idx ON smp_int84_min (k);
ANALYZE smp_int84_min;

SET query_dop = 3;
SET enable_force_smp = on;
SET enable_seqscan = off;
SET enable_indexscan = on;
SET enable_indexonlyscan = off;
SET enable_bitmapscan = off;

EXPLAIN (COSTS OFF)
SELECT count(*) FROM smp_int84_min WHERE k >= 1;

SELECT count(*) FROM smp_int84_min WHERE k >= 1;
image.png

likedislike
sungang14sungang14成员
15 天前 issue状态由 待回归 改变为 已验收
sungang14sungang14成员
15 天前 关闭了 issue