## **Doris问题汇总** ##### <blockquote class="danger"><p>问题1：SQL执行超时异常，报错信息</p></blockquote> ``` SQLSTATE[HY000]: General error: 1105 errCode = 2, detailMessage = 11588 have no queryable replicas. err: 99007523's backend 99004315 does not exist or not alive, 99007697's backend 6482429 does not exist or not alive, 6490239's backend 1059880 does not exist or not alive (SQL: select count(*) as aggregate from (select round(sum(lt.price)/100,2) as price, round(sum(lt.spend)/100,2) as cost, ANY_VALUE(v.name) as video_name, ANY_VALUE(lt.video_id) as video_id, ANY_VALUE(v.third_video_id) as third_video_id from `channel_stat_link_pay_money_trend` as `lt` left join `videos` as `v` on `v`.`id` = `lt`.`video_id` left join `novel`.`fq_channel_link` as `c` on `c`.`id` = `lt`.`link_id` where `lt`.`app_id` = 5 and `lt`.`channel_id` = 63 and `lt`.`event_date` between 20250408 and 20250414 and `c`.`uid` = 553 and `lt`.`event_date` between 20250408 and 20250414 group by `lt`.`video_id`) as `aggregate_table`) ```