【没有做存算分离】
【StarRocks版本】3.3.5
【集群规模】3fe（1 follower+2observer）+3be（后端节点都正常）
【机器信息】CPU虚拟核/内存/网卡
【详述】one_alarm_info表按照日期已经分区过，然后做了物化视图；但是通过sql查询报错
CREATE MATERIALIZED VIEW mv_one_alarm_level_analysis
DISTRIBUTED BY HASH(alarm_level) BUCKETS 16
REFRESH DEFERRED
ASYNC
START (“2025-07-01 19:00:00”)
EVERY (INTERVAL 50 MINUTE)
PARTITION BY m_alarm_time
AS
SELECT
date_trunc(‘month’, alarm_time) AS m_alarm_time,
alarm_level,
COUNT(source_id) AS count
FROM one_alarm_info
GROUP BY m_alarm_time, alarm_level;
执行sql:
SELECT
date_trunc(‘month’, alarm_time) AS m_alarm_time,
alarm_level,
COUNT(source_id) AS count
FROM one_alarm_info
GROUP BY m_alarm_time, alarm_level;
报错：
1064 - failed to get tablet. tablet_id=705127, with schema_hash=303374244, reason=tablet does not exist backend [id=10299] [
之前查询该sql没有问题，现在报：tablet does not exist backend，为什么？如何修复。
SELECT
date_trunc(‘month’, alarm_time) AS m_alarm_time,
alarm_level,
COUNT(source_id) AS count
FROM one_alarm_info
GROUP BY m_alarm_time, alarm_level;
但是查询物化视图不报错
