【测试类型：工具功能】【测试版本：7.0.0-RC1】【timescaledb】timescaledb插件下执行sql,数据库异常退出

【标题描述】:timescaledb插件下执行sql,数据库异常退出
【测试类型：SQL功能】【测试版本：7.0.0】 问题描述：timescaledb插件下执行sql,数据库异常退出

【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):
Linux sdr-0001 3.10.0-1160.92.1.el7.x86_64 #1 SMP Tue Jun 20 11:48:01 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux
【测试环境】(单机/1主x备x级联备):
单机
【被测功能】:
sql功能
【测试类型】:
功能测试
【数据库版本】(查询命令: gaussdb -V):
gsql (openGauss 7.0.0-RC1 build d47a8b78) compiled at 2025-03-05 00:08:52 commit 0 last mr
【预置条件】:
pg兼容库下create database format_pg DBCOMPATIBILITY 'b' encoding='utf8';
postgresql.conf修改参数shared_preload_libraries = '$libdir/timescaledb'
【操作步骤】(请填写详细的操作步骤):
1. 登陆pg兼容库，create extension timescaledb;
2. 创建表
CREATE TABLE business (
    "time" timestamp with time zone NOT NULL,
    protocol integer,
    request_total bigint,
    request_a bigint,
    request_aaaa bigint,
    request_a6 bigint,
    request_ptr bigint,
    request_mx bigint,
    request_ns bigint,
    request_cname bigint,
    request_srv bigint,
    request_soa bigint,
    request_any bigint,
    request_txt bigint,
    request_other bigint,
    request_svcb bigint,
    request_https bigint,
    response_total bigint,
    response_noerror bigint,
    response_servfail bigint,
    response_nxdomain bigint,
    response_refused bigint,
    response_other bigint,
    filter_total bigint,
    filter_exception_ip bigint,
    filter_exception_dns bigint,
    filter_exception_udp bigint,
    filter_self_check bigint,
    filter_limit_ip bigint,
    filter_limit_domain bigint,
    filter_limit_acl bigint,
    filter_limit_source_ip bigint,
    filter_limit_business_ip bigint,
    filter_limit_request bigint,
    filter_limit_notrust_domain bigint,
    filter_attack_amplify bigint,
    filter_tcp_flood_sync bigint,
    filter_tcp_flood_ack bigint,
    filter_udp_flood bigint,
    filter_icmp_flood bigint,
    filter_limit_inter_network_blacklist bigint,
    business_force bigint,
    business_cache_answer bigint,
    business_recursion_delay bigint,
    business_nxr bigint,
    business_malicious_domain_hijack bigint,
    business_smart_resolve bigint,
    business_othernetwork_resolve bigint,
    business_recursion_request bigint,
    business_recursion_answer bigint,
    business_proxy_request bigint,
    business_proxy_answer bigint,
    business_forward_request bigint,
    business_forward_answer bigint,
    business_edns_process bigint,
    business_edns_other bigint,
    backend_cache_bypass bigint,
    backend_cache_unhit bigint,
    backend_cache_smart_update bigint,
    backend_cache_ttl_update bigint,
    backend_drop_limit bigint,
    backend_cache_update_limit bigint,
    business_edns_process_success bigint,
    business_othernetwork_resolve_success bigint,
    business_edns_answer bigint,
    business_edns_forward_request bigint,
    business_edns_forward_answer bigint,
    deviceid integer,
    nodeid integer,
    _host text NOT NULL,
    _raw text NOT NULL,
    _source text NOT NULL,
    _time timestamp with time zone DEFAULT now() NOT NULL
)
WITH (orientation=row, compression=no);

SELECT create_hypertable('business','time',chunk_time_interval => interval '1 day');

CREATE TABLE device_network (
    "time" timestamp with time zone NOT NULL,
    network_in_speed double precision,
    network_out_speed double precision,
    deviceid integer,
    nodeid integer,
    _host text NOT NULL,
    _raw text NOT NULL,
    _source text NOT NULL,
    _time timestamp with time zone DEFAULT now() NOT NULL
)
WITH (orientation=row, compression=no);
SELECT create_hypertable('device_network','time',chunk_time_interval => interval '1 day');

3.执行sql查询：
select TIME_BUCKET('1 minute',time::TIMESTAMP) AS timestamp,trunc(SUM(request_total*60)/60) as request_total,trunc(SUM(response_total*60)/60) as response_total,trunc(SUM(business_recursion_request*60)/60) as recursion_request from business WHERE time >= '2025-03-13T10:05:00+08:00' AND time <= '2025-03-13T11:05:00+08:00' AND nodeid in (3,2)    group by timestamp order by timestamp asc ;
【预期输出】:
第三步：sql执行无问题
【实际输出】:
第三步：数据库宕机
第一次执行无问题，退出后重新执行宕机
![输入图片说明](https://foruda.gitee.com/images/1741850385770183577/ddaff659_8040627.png "屏幕截图")
重启后重复执行，宕机
![输入图片说明](https://foruda.gitee.com/images/1741850468618203977/714cc87c_8040627.png "屏幕截图")
【原因分析】:
1. 这个问题的根因
2. 问题推断过程
3. 还有哪些原因可能造成类似现象
4. 该问题是否有临时规避措施
5. 问题解决方案
6. 预计修复问题时间

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

【测试代码】:

openGauss/Plugin

内容风险标识

评论 (3)

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

内容风险标识