【测试类型：SQL功能】极致RTO参数仅备机配置场景下，主机创建向量索引成功，备机需要进行功能约束，即使开了enable_indexscan，也无法使用索引进行查询。

【标题描述】:极致RTO参数仅备机配置场景下，主机创建向量索引成功，备机需要进行功能约束，即使开了enable_indexscan，也无法使用索引进行查询。
【测试类型：SQL功能】极致RTO参数仅备机配置场景下，主机创建向量索引成功，备机需要进行功能约束，即使开了enable_indexscan，也无法使用索引进行查询。

【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):
CentOS Linux release 7.7.1908 (Core)

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

【被测功能】:
极致RTO场景下向量功能

【测试类型】:
功能测试

【数据库版本】(查询命令: gaussdb -V):
gaussdb (openGauss 7.0.0-RC1 build e878db40) compiled at 2025-03-17 21:35:20 commit 0 last mr

【预置条件】:
一主一备功能正常

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

```
--step3:备机打开极致RTO备机读开关; expect：成功
gs_guc set -D {dn1} -c "hot_standby=on" &&
gs_guc set -D {dn1} -c "recovery_parse_workers=4" &&
gs_guc set -D {dn1} -c "recovery_redo_workers=4" &&
gs_guc set -D {dn1} -c "exrto_standby_read_opt=off"
gs_om -t restart

--step4: 创建表; expect: 成功
drop table if exists t_datavec_pq_case0152;
create table t_datavec_pq_case0152 (id bigserial primary key, val vector(160));

--step5: 插入大量数据; expect: 成功
do $$
declare
    vector_dim int := 160; -- 自定义向量的维度
    vector_value float[];
    record_num int := 5000; -- 自定义插入的记录数量
    i int;
    j int;
begin
    for j in 1..record_num loop
    for i in 1..vector_dim loop
        vector_value[i] :=  ROUND(RANDOM() * 100, 2); -- 使用随机数填充向量
    end loop;
    insert into t_datavec_pq_case0152 (val) values (vector_value);
    end loop;
end $$;

--step6: 创建索引，主备分别配置查询计划进行查询; expect: 主机使用索引，备机未使用索引
create index idx_t_datavec_pq_case0152 on t_datavec_pq_case0152 using ivfflat (val vector_l2_ops) with(lists=200,enable_pq=off);
set enable_indexscan=on;
set enable_seqscan=off;
select id,val<->'[33.91,98.59,85.29,15.32,4.9,78.51,15.83,1.63,39.63,52,40.46,74.03,16.95,95.42,15.85,56.45,28.41,69.76,55.21,68.63,53.24,75.3,5.87,42.23,26.98,81.97,89.8,58.99,0.04,85.03,73.05,1.27,59.57,79.81,87.65,81.77,34,3.57,6.12,34.42,43.21,93.49,81.3,64.9,87.38,0.36,2.03,2.05,54.29,43.58,62.91,76.71,47.7,14.25,6.93,9.56,8.46,23.97,24.78,84.65,86.24,55.93,2.43,50,73.33,23.49,15.29,44.7,94.62,56.72,8.84,36.69,50.54,69.76,62.04,41.83,84.16,64.97,53.27,22.08,22.78,83.52,85.29,54.41,68.86,47.64,42.35,65.58,59.54,64.85,61.89,21.02,9.73,89.1,87.04,82.73,15.58,93.47,3.27,46.71,45.06,91.6,49.84,80.88,35.7,14.65,78.72,97.65,70,73.04,23.79,62.36,0.7,99.44,50.06,98.07,56.67,25.9,6.77,55.16,10.47,13.38,82.87,61.39,25.64,48.81,4.9,13.26,2.41,1.46,65.29,58.76,89.64,86.72,84.13,13.96,45.98,98.53,95.92,52.29,90.25,19.42,90.89,68.13,37.44,4.48,99.26,98.01,40.22,18.98,78.94,50.45,42.93,21.05,89.19,53.91,65.14,56.68,12.69,51.74]' from t_datavec_pq_case0152 order by val<->'[33.91,98.59,85.29,15.32,4.9,78.51,15.83,1.63,39.63,52,40.46,74.03,16.95,95.42,15.85,56.45,28.41,69.76,55.21,68.63,53.24,75.3,5.87,42.23,26.98,81.97,89.8,58.99,0.04,85.03,73.05,1.27,59.57,79.81,87.65,81.77,34,3.57,6.12,34.42,43.21,93.49,81.3,64.9,87.38,0.36,2.03,2.05,54.29,43.58,62.91,76.71,47.7,14.25,6.93,9.56,8.46,23.97,24.78,84.65,86.24,55.93,2.43,50,73.33,23.49,15.29,44.7,94.62,56.72,8.84,36.69,50.54,69.76,62.04,41.83,84.16,64.97,53.27,22.08,22.78,83.52,85.29,54.41,68.86,47.64,42.35,65.58,59.54,64.85,61.89,21.02,9.73,89.1,87.04,82.73,15.58,93.47,3.27,46.71,45.06,91.6,49.84,80.88,35.7,14.65,78.72,97.65,70,73.04,23.79,62.36,0.7,99.44,50.06,98.07,56.67,25.9,6.77,55.16,10.47,13.38,82.87,61.39,25.64,48.81,4.9,13.26,2.41,1.46,65.29,58.76,89.64,86.72,84.13,13.96,45.98,98.53,95.92,52.29,90.25,19.42,90.89,68.13,37.44,4.48,99.26,98.01,40.22,18.98,78.94,50.45,42.93,21.05,89.19,53.91,65.14,56.68,12.69,51.74]' limit 10;

--step7: 增删改查; expect: 成功
update t_datavec_pq_case0152 set val = val + array_fill(10,array[160])::vector where id<=100;
update t_datavec_pq_case0152 set val = (val::vector + '{1:5,2:6,17:12,20:22,150:19}/160'::sparsevec::vector) where val<->'{1:49,2:40,3:49,4:40,5:40}/160'::sparsevec::vector>723;
delete from t_datavec_pq_case0152 where val<->'{1:49,2:40,3:49,4:40,5:40}/160'::sparsevec::vector<723;

--step8：主备分别配置查询计划进行查询  expect：主机使用索引，备机未使用索引
set enable_indexscan=on;
set enable_seqscan=off;
select id,val<->'[33.91,98.59,85.29,15.32,4.9,78.51,15.83,1.63,39.63,52,40.46,74.03,16.95,95.42,15.85,56.45,28.41,69.76,55.21,68.63,53.24,75.3,5.87,42.23,26.98,81.97,89.8,58.99,0.04,85.03,73.05,1.27,59.57,79.81,87.65,81.77,34,3.57,6.12,34.42,43.21,93.49,81.3,64.9,87.38,0.36,2.03,2.05,54.29,43.58,62.91,76.71,47.7,14.25,6.93,9.56,8.46,23.97,24.78,84.65,86.24,55.93,2.43,50,73.33,23.49,15.29,44.7,94.62,56.72,8.84,36.69,50.54,69.76,62.04,41.83,84.16,64.97,53.27,22.08,22.78,83.52,85.29,54.41,68.86,47.64,42.35,65.58,59.54,64.85,61.89,21.02,9.73,89.1,87.04,82.73,15.58,93.47,3.27,46.71,45.06,91.6,49.84,80.88,35.7,14.65,78.72,97.65,70,73.04,23.79,62.36,0.7,99.44,50.06,98.07,56.67,25.9,6.77,55.16,10.47,13.38,82.87,61.39,25.64,48.81,4.9,13.26,2.41,1.46,65.29,58.76,89.64,86.72,84.13,13.96,45.98,98.53,95.92,52.29,90.25,19.42,90.89,68.13,37.44,4.48,99.26,98.01,40.22,18.98,78.94,50.45,42.93,21.05,89.19,53.91,65.14,56.68,12.69,51.74]' from t_datavec_pq_case0152 order by val<->'[33.91,98.59,85.29,15.32,4.9,78.51,15.83,1.63,39.63,52,40.46,74.03,16.95,95.42,15.85,56.45,28.41,69.76,55.21,68.63,53.24,75.3,5.87,42.23,26.98,81.97,89.8,58.99,0.04,85.03,73.05,1.27,59.57,79.81,87.65,81.77,34,3.57,6.12,34.42,43.21,93.49,81.3,64.9,87.38,0.36,2.03,2.05,54.29,43.58,62.91,76.71,47.7,14.25,6.93,9.56,8.46,23.97,24.78,84.65,86.24,55.93,2.43,50,73.33,23.49,15.29,44.7,94.62,56.72,8.84,36.69,50.54,69.76,62.04,41.83,84.16,64.97,53.27,22.08,22.78,83.52,85.29,54.41,68.86,47.64,42.35,65.58,59.54,64.85,61.89,21.02,9.73,89.1,87.04,82.73,15.58,93.47,3.27,46.71,45.06,91.6,49.84,80.88,35.7,14.65,78.72,97.65,70,73.04,23.79,62.36,0.7,99.44,50.06,98.07,56.67,25.9,6.77,55.16,10.47,13.38,82.87,61.39,25.64,48.81,4.9,13.26,2.41,1.46,65.29,58.76,89.64,86.72,84.13,13.96,45.98,98.53,95.92,52.29,90.25,19.42,90.89,68.13,37.44,4.48,99.26,98.01,40.22,18.98,78.94,50.45,42.93,21.05,89.19,53.91,65.14,56.68,12.69,51.74]' limit 10;
‘
```

【预期输出】:
见测试步骤

【实际输出】:
备机使用索引查询core，现在需要进行功能约束

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

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

【测试代码】:

openGauss/openGauss-server

内容风险标识

评论 (5)

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

内容风险标识