查询出现Memory of query_pool exceed limit

[oooooh]

为了更快的定位您的问题，请提供以下信息，谢谢
【详述】问题详细描述
【背景】执行了select count(1) from xxx
【业务影响】
【是否存算分离】是
【StarRocks版本】3.1.2

使用select count(1) from xxx 查询上表，出现了以下问题:

Memory of query_pool exceed limit. Start execute plan fragment. Used: 499217678504, Limit: 196691164434. Mem usage has exceed the limit of query pool

[oooooh]

CREATE TABLE tb_rule_model (
model varchar(255) NOT NULL COMMENT “机型”,
ruleId varchar(255) NOT NULL COMMENT “命中规则”,
updateTime datetime NULL COMMENT “更新时间”
) ENGINE=OLAP
PRIMARY KEY(model, ruleId)
COMMENT “规则命中机型信息”
DISTRIBUTED BY HASH(model, ruleId) BUCKETS 8
PROPERTIES (
“replication_num” = “3”,
“datacache.enable” = “true”,
“storage_volume” = “def_volume”,
“enable_async_write_back” = “false”,
“enable_persistent_index” = “false”,
“compression” = “LZ4”
);

这是建表语句，大概就1000条数据

[yuchen1019]

@U_1676978371406_2563

Mem usage has exceed the limit of query pool

Mem usage has exceed the limit of query pool
是指查询总内存超限了

麻烦打个curl -XGET -s http://BE_IP:BE_HTTP_PORT/metrics | grep “^starrocks_be_.*_mem_bytes” 看下

[jingdan]

show proc ‘/dbs/$db_name/tb_rule_model/partitions’;看下这个结果，这个状态不合理