tiflash report "DB::TiFlashException: Failed to register MPP Task MPP" during query

[seiya-annie]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

when the query has a non-correlated subquery and the non-correlated subquery will end early. then tiflash will return this error:

[2023/07/04 01:14:02.527 +08:00] [ERROR] [upgrade_test.go:217] ["check consistence error"] [error="Error 1105: DB
::TiFlashException: Failed to register MPP Task MPP<query:<query_ts:1688404441135806359, local_query_id:167, serv
er_id:912316, start_ts:442605093804572686>,task_id:3>, reason: query is being aborted, error message = Receive ca
ncel request from TiDB"] [sql="\nselect d, count(*) as order_count, max(d) as m\nfrom t\nwhere jj >= '2007-01-02
00:00:00.000000'and jj < '2032-01-02 00:00:00.000000'and exists (select * from t where jj >= kk) and d > m - 1\ng
roup by d\norder by d limit 1000\n"]

2. What did you expect to see? (Required)

query execute successfully

3. What did you see instead (Required)

[2023/07/03 17:14:02.522 +00:00] [ERROR] [MPPHandler.cpp:97] ["dispatch task meet error : DB::TiFlashException: Failed to register MPP Task MPP<query:<query_ts:1688404441135806359, local_query_id:167, server_id:912316, start_ts:442605093804572686>,task_id:3>, reason: query is being aborted, error message = Receive cancel request from TiDB"] [thread_id=177]
[2023/07/03 17:14:02.522 +00:00] [WARN] [MPPTaskManager.cpp:187] ["Begin to abort query: <query_ts:1688404441135806359, local_query_id:167, server_id:912316, start_ts:442605093804572686>, abort type: ONERROR, reason: From MPP<query:<query_ts:1688404441135806359, local_query_id:167, server_id:912316, start_ts:442605093804572686>,task_id:3>: DB::TiFlashException: Failed to register MPP Task MPP<query:<query_ts:1688404441135806359, local_query_id:167, server_id:912316, start_ts:442605093804572686>,task_id:3>, reason: query is being aborted, error message = Receive cancel request from TiDB"] [thread_id=177]
[2023/07/03 17:14:02.522 +00:00] [WARN] [MPPTaskManager.cpp:204] ["<query_ts:1688404441135806359, local_query_id:167, server_id:912316, start_ts:442605093804572686> already in abort process, skip abort"] [thread_id=177]
[2023/07/03 17:14:02.522 +00:00] [ERROR] [MPPHandler.cpp:97] ["dispatch task meet error : DB::TiFlashException: Failed to register MPP Task MPP<query:<query_ts:1688404441135806359, local_query_id:167, server_id:912316, start_ts:442605093804572686>,task_id:2>, reason: query is being aborted, error message = Receive cancel request from TiDB"] [thread_id=175]
[2023/07/03 17:14:02.522 +00:00] [WARN] [MPPTask.cpp:658] ["Begin abort task: MPP<query:<query_ts:1688404441135806359, local_query_id:167, server_id:912316, start_ts:442605093804572686>,task_id:3>, abort type: ONERROR"] [source="MPP<query:<query_ts:1688404441135806359, local_query_id:167, server_id:912316, start_ts:442605093804572686>,task_id:3>"] [thread_id=177]

4. What is your TiFlash version? (Required)

master

[seiya-annie]

server.log.gz

[windtalker]

will be fixed when #7746 is done

[mstao]

error message:

2023-07-12 09:08:40.839 [TID:b347b0e6a06343deaf4a7e6e6e692608.1402.16891241155189171] [XNIO-1 task-9] ERROR i.s.r.d.s.s.c.AbstractTableMetaCache -get table meta of the table `wat_check_delivery_bill_detail_record` error: DB::TiFlashException: Failed to register MPP Task MPP<query:442793752507187236,task:30>, reason: query is being aborted, error message = Receive cancel request from TiDB
java.sql.SQLException: DB::TiFlashException: Failed to register MPP Task MPP<query:442793752507187236,task:30>, reason: query is being aborted, error message = Receive cancel request from TiDB

sql:

SELECT * FROM wat_check_delivery_bill_detail_record LIMIT 1

TiDB v6.5.2 TiFlash v6.5.2