使用tiflash普通聚合查询性能很慢，一直查不出来是什么情况？

[TiDBer_ZHcgATCp]

【 TiDB 使用环境】生产环境 /测试/ Poc
【 TiDB 版本】V7.1.1
【复现路径】普通sum(),count()聚合查询一直查不出数据
【遇到的问题：问题现象及影响】普通sum(),count()聚合查询一直查不出数据，是tikv会有影响它吗？
【资源配置】12台tiflash,内存使用才20%左右
【附件：截图/日志/监控】
[2023/12/12 17:52:27.580 +09:00] [WARN] [CoprocessorHandler.cpp:152] [“RegionException: region 834824106, message: Region error NOT_FOUND: (while creating InputStreams from storage db_2723.t_2816133, table_id: 2816133)”] [source=CoprocessorHandler] [thread_id=1401]
[2023/12/12 17:55:14.300 +09:00] [WARN] [MPPTaskManager.cpp:155] [“Begin to abort query: <query_ts:1702371013846593685, local_query_id:51, server_id:2107318, start_ts:446266347052335112>, abort type: ONCANCELLATION, reason: Receive cancel request from TiDB”] [thread_id=1880]
[2023/12/12 17:55:14.300 +09:00] [WARN] [MPPTaskManager.cpp:165] [“<query_ts:1702371013846593685, local_query_id:51, server_id:2107318, start_ts:446266347052335112> does not found in task manager, skip abort”] [thread_id=1880]
[2023/12/12 17:55:53.685 +09:00] [WARN] [MPPTaskManager.cpp:155] [“Begin to abort query: <query_ts:1702371052955116238, local_query_id:2787, server_id:1097863, start_ts:446266357301903373>, abort type: ONCANCELLATION, reason: Receive cancel request from TiDB”] [thread_id=1872]
[2023/12/12 17:55:53.685 +09:00] [WARN] [MPPTaskManager.cpp:165] [“<query_ts:1702371052955116238, local_query_id:2787, server_id:1097863, start_ts:446266357301903373> does not found in task manager, skip abort”] [thread_id=1872]
[2023/12/12 18:22:08.710 +09:00] [WARN] [] [“region {843088317,28757,517} find error: peer is not leader for region 843088317, leader may Some(id: 846903417 store_id: 7)”] [source=pingcap.tikv] [thread_id=1337]
[2023/12/12 18:22:08.714 +09:00] [WARN] [] [“region {380717924,16445,496} find error: region 380717924 is missing”] [source=pingcap.tikv] [thread_id=1337]
[2023/12/12 18:27:32.047 +09:00] [WARN] [] [“region {843088317,28757,517} find error: region 843088317 is missing”] [source=pingcap.tikv] [thread_id=1335]
[2023/12/12 18:33:41.992 +09:00] [WARN] [] [“region {843088317,28763,517} find error: peer is not leader for region 843088317, leader may Some(id: 846513101 store_id: 4)”] [source=pingcap.tikv] [thread_id=13]
[2023/12/12 18:47:56.956 +09:00] [WARN] [] [“region {834778343,7583,4376} find error: region 834778343 is missing”] [source=pingcap.tikv] [thread_id=1338]
[2023/12/12 18:48:20.521 +09:00] [WARN] [MPPTaskManager.cpp:155] [“Begin to abort query: <query_ts:1702374200389790720, local_query_id:52, server_id:2107318, start_ts:446267182374191109>, abort type: ONCANCELLATION, reason: Receive cancel request from TiDB”] [thread_id=1869]
[2023/12/12 18:48:20.522 +09:00] [WARN] [MPPTaskManager.cpp:165] [“<query_ts:1702374200389790720, local_query_id:52, server_id:2107318, start_ts:446267182374191109> does not found in task manager, skip abort”] [thread_id=1869]
[2023/12/12 18:49:57.834 +09:00] [WARN] [] [“region {843088317,28763,517} find error: peer is not leader for region 843088317, leader may Some(id: 848942155 store_id: 95948980)”] [source=pingcap.tikv] [thread_id=11]
[2023/12/12 19:04:42.311 +09:00] [WARN] [] [“region {843088317,28763,517} find error: region 843088317 is missing”] [source=pingcap.tikv] [thread_id=1335]

[TiDBer_ZHcgATCp]

有大佬了解什么因素会影响到tiflash吗？

[随缘天空 (Ti D Ber Ivw R7o Pj)]

好像是你得查询语句检索的region找不到了，你的服务器上的存储文件有没有损坏或者丢失。同时检查下你的表是否还存在或者有没有写错

[Kongdom]

发一下explain analyze的结果，确认聚合查询是否走了tiflash

[dba远航 (Ti D Ber M Lo7 Bqhk)]

region 834778343 丢失，感觉是数据异常导致查询失败

[andone (Ti D Ber Lq Q Mt Rp V)]

找出实际的sql语句，看一下explain

[tidb菜鸟一只 (小菜一颗)]

建议把对应的表的tiflash副本置为0之后重新置为1试试。

[TiDBer_ZHcgATCp]

因为前天下了几台tikv，然后就检索不到region了，重启tiflash之后就好了。

[TiDBer_ZHcgATCp]

因为前天下了几台tikv，然后就检索不到region了，重启tiflash之后就好了。。

[TiDBer_ZHcgATCp]

因为前天下了几台tikv，然后就检索不到region了，估计查的region是下的那几台tikv上面，重启tiflash之后就好了。

[TiDBer_ZHcgATCp]

试过，也不行，重启tiflash之后才行，重启tiflash之后会重新同步tikv数据？

[随缘天空 (Ti D Ber Ivw R7o Pj)]

嗯，重启后可能数据重新同步到tiflash了

[h5n1]

pd-ctl region 先看下你那几个region状态

[有猫万事足]

有执行计划吗？

Receive cancel request from TiDB

怎么感觉像是查不出来后主动取消的查询。