物化视图刷新任务失败,失败原因提示“errCode = 2, detailMessage = (10.74.107.1)[CANCELLED]sync filter size meet error”

Viewed 11

定义了100+个定时刷新的物化视图,每天晚上总会几个物化视图刷新失败,使用以下查看物化视图刷新任务的语句查看结果

SELECT * 
FROM tasks("type"="mv")
WHERE
MvDatabaseName = 'dwd_*****'
ORDER BY  CreateTime DESC;

结果的ErrorMsg字段显示

errCode = 2, detailMessage = (10.74.101.1)[CANCELLED]sync filter size meet error, filter: RuntimeFilter: (id = 1, type = bloomfilter, is_broadcast: false, ignored: true, disabled: false, build_bf_cardinality: true, dependency: HASH_JOIN_SINK_OPERATOR_FINISH_DEPENDENCY: id=4, block task = 0, ready=true, _always_ready=false, count=0, synced_size: -1, has_local_target: false, has_remote_target: true, error_msg: []

执行刷新物化视图的语句(REFRESH MATERIALIZED VIEW mvName COMPLETE;)后,物化视图会立刻刷新成功,服务器也没有down掉的节点,doris版本为2.1.8,请问各位大神是什么原因,如何解决呢?

1 Answers

当前版本可以先set global enable_sync_runtime_filter_size=false规避