[Bug]: [date 5.10]tke regression:tpcc 500warehouses test ConsistencyCheck Read timed out

[heni02]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Branch Name

main

Commit ID

6003d83

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

job：https://github.com/matrixorigin/mo-nightly-regression/actions/runs/9033818759/job/24827047410

另外两个500仓1000并发，1000仓1000并发也有同样的问题
超时sql：select ol_w_id, ol_d_id, ol_o_id, ol_number,count(1) from bmsql_order_line group by ol_w_id, ol_d_id, ol_o_id, ol_number having count(1) > 1 limit 10

超时sql报错日志：

mo log：
https://grafana.ci.matrixorigin.cn/explore?panes=%7B%22hHs%22:%7B%22datasource%22:%22loki%22,%22queries%22:%5B%7B%22refId%22:%22A%22,%22expr%22:%22%7Bnamespace%3D%5C%22mo-nightly-regression-20240510%5C%22%7D%20%7C%3D%20%60from%20bmsql_order_line%60%22,%22queryType%22:%22range%22,%22datasource%22:%7B%22type%22:%22loki%22,%22uid%22:%22loki%22%7D,%22editorMode%22:%22builder%22%7D%5D,%22range%22:%7B%22from%22:%221715363822488%22,%22to%22:%221715368093583%22%7D%7D%7D&schemaVersion=1&orgId=1

profile:
plz contact me

Expected Behavior

No response

Steps to Reproduce

tpcc 500warehouses 500threads test

Additional information

No response

[ouyuanning]

看着像是agg溢出了

[m-schen]

agg所有group合起来超过1g的问题还未处理。

[m-schen]

在处理中

[m-schen]

用这个分支跟踪这个agg结果超过1g的问题：

https://github.com/m-schen/matrixone/tree/opt-agg-result

[m-schen]

还没做完，这两天都在处理hung住的问题。

[heni02]

date 6.2 regression tpcc 500仓也出现了read timed out，和之前的sql不一样
sql：(select o_w_id, o_d_id, sum(o_ol_cnt) from bmsql_oorder group by o_w_id, o_d_id) except (select ol_w_id, ol_d_id, count(ol_o_id) from bmsql_order_line group by ol_w_id, ol_d_id);
https://github.com/matrixorigin/mo-nightly-regression/actions/runs/9339030269/job/25706499669

mo log：
https://grafana.ci.matrixorigin.cn/explore?panes=%7B%22_0q%22:%7B%22datasource%22:%22loki%22,%22queries%22:%5B%7B%22refId%22:%22A%22,%22expr%22:%22%7Bnamespace%3D%5C%22mo-nightly-regression-20240602%5C%22%7D%20%7C%3D%20%60%60%22,%22queryType%22:%22range%22,%22datasource%22:%7B%22type%22:%22loki%22,%22uid%22:%22loki%22%7D,%22editorMode%22:%22builder%22%7D%5D,%22range%22:%7B%22from%22:%221717339017217%22,%22to%22:%221717382217217%22%7D%7D%7D&schemaVersion=1&orgId=1

[m-schen]

上一个回复搜不到相关sql的日志，但是先关联在这里吧，总之也和聚合group by有些关系。