【详述】执行StreamLoad导入数据时报异常:primary key memory usage exceeds the limit. tablet_id: 255025, consumption: 32384157873, limit: 32172514467. Memory stats of top five tablets: 252806(671M)252781(671M)252881(671M)252911(671M)252391(335M): be:127.0.0.1",
【背景】导入出错后修改表enable_persistent_index=true,问题一样存在
【业务影响】是
【是否存算分离】否
【StarRocks版本】例如:3.2.2
【集群规模】例如:1fe+1be(docker中fe与be混部)
【机器信息】CPU虚拟核/内存/网卡,例如:32C/64G/万兆
【表模型】例如:主键模型
【导入或者导出方式】StreamLoad
表参数:
ENGINE=OLAP
PRIMARY KEY(id
, time_type
)
PARTITION BY (time_type
)
DISTRIBUTED BY HASH(time_type
)
PROPERTIES (
“replication_num” = “1”,
“in_memory” = “false”,
“enable_persistent_index” = “true”,
“replicated_storage” = “true”,
“compression” = “LZ4”
);