matrixone
matrixone copied to clipboard
matrixorigin
[Bug]: 特定SQL查询时间过长
Is there an existing issue for the same bug?
- [X] I have checked the existing issues.
Branch Name
1.2-dev
Commit ID
994f3da
Other Environment Information
- Hardware parameters:
- OS type:
- Others:
aliyun dev环境
Actual Behavior
日志如下：
2024/06/26 07:01:50.466740 +0000 WARN meta/meta.go:95 trace {"elapsed": "20.322383672s", "rows": 1, "sql": "/* cloud_nonuser */SELECT SUM(size) AS size FROM (SELECT mo_table_size(reldatabase, relname) AS size FROM mo_catalog.mo_tables WHERE relkind IN('r', 'e', 'cluster', 'v') AND reldatabase = 'mysql') AS t;"}
2024/06/26 07:01:57.088838 +0000 WARN meta/meta.go:95 trace {"elapsed": "26.944445574s", "rows": 1, "sql": "/* cloud_nonuser */SELECT SUM(size) AS size FROM (SELECT mo_table_size(reldatabase, relname) AS size FROM mo_catalog.mo_tables WHERE relkind IN('r', 'e', 'cluster', 'v') AND reldatabase = 'tpcc_100') AS t;"}
2024/06/26 07:01:57.187651 +0000 WARN meta/meta.go:95 trace {"elapsed": "27.043348178s", "rows": 1, "sql": "/* cloud_nonuser */SELECT SUM(size) AS size FROM (SELECT mo_table_size(reldatabase, relname) AS size FROM mo_catalog.mo_tables WHERE relkind IN('r', 'e', 'cluster', 'v') AND reldatabase = 'system_metrics') AS t;"}
2024/06/26 07:01:57.922575 +0000 WARN meta/meta.go:95 trace {"elapsed": "27.77832579s", "rows": 1, "sql": "/* cloud_nonuser */SELECT SUM(size) AS size FROM (SELECT mo_table_size(reldatabase, relname) AS size FROM mo_catalog.mo_tables WHERE relkind IN('r', 'e', 'cluster', 'v') AND reldatabase = 'tpcc_10') AS t;"}
2024/06/26 07:02:08.899664 +0000 WARN meta/meta.go:95 trace {"elapsed": "38.755162271s", "rows": 1, "sql": "/* cloud_nonuser */SELECT SUM(size) AS size FROM (SELECT mo_table_size(reldatabase, relname) AS size FROM mo_catalog.mo_tables WHERE relkind IN('r', 'e', 'cluster', 'v') AND reldatabase = 'mo_catalog') AS t;"}
2024/06/26 07:02:16.975262 +0000 WARN meta/meta.go:95 trace {"elapsed": "46.830928621s", "rows": 1, "sql": "/* cloud_nonuser */SELECT SUM(size) AS size FROM (SELECT mo_table_size(reldatabase, relname) AS size FROM mo_catalog.mo_tables WHERE relkind IN('r', 'e', 'cluster', 'v') AND reldatabase = 'information_schema') AS t;"}
发生事件为东八区2024/06/26 15:01:50.466740，实例ID为01903344-4d60-7fb3-8a5d-02dafaf20ebc。不稳定复现。
Expected Behavior
正常执行时间，如：
2024/06/26 06:07:59.153671 +0000 WARN meta/meta.go:95 trace {"elapsed": "861.54913ms", "rows": 1, "sql": "/* cloud_nonuser */SELECT SUM(size) AS size FROM (SELECT mo_table_size(reldatabase, relname) AS size FROM mo_catalog.mo_tables WHERE relkind IN('r', 'e', 'cluster', 'v') AND reldatabase = 'mo_sample_data_tpch_sf1') AS t;"}
Steps to Reproduce
不稳定复现
Additional information
No response
The similar issue occurred in Prod env after upgrade MO to v1.2.1-27b34c670-2024-06-28:
2024/07/04 13:35:05.364552 +0000 ERROR meta/meta.go:95 trace {"error": "context canceled", "elapsed": "59.948734333s", "rows": 0, "sql": "/* cloud_nonuser */SELECT SUM(size) AS size FROM (SELECT mo_table_size(reldatabase, relname) AS size FROM mo_catalog.mo_tables WHERE relkind IN('r', 'e', 'cluster', 'v') AND reldatabase = 'write_test_0424') AS t;"}
2024/07/04 13:36:56.815791 +0000 ERROR meta/meta.go:95 trace {"error": "context canceled", "elapsed": "59.948137034s", "rows": 0, "sql": "/* cloud_nonuser */SELECT SUM(size) AS size FROM (SELECT mo_table_size(reldatabase, relname) AS size FROM mo_catalog.mo_tables WHERE relkind IN('r', 'e', 'cluster', 'v') AND reldatabase = 'write_test_0424') AS t;"}
2024/07/04 13:39:55.694969 +0000 WARN models/meta.go:222 trace {"elapsed": "22.750829979s", "rows": 452, "sql": "SHOW TABLE STATUS FROM `test4`"}
2024/07/04 13:40:23.879890 +0000 WARN models/meta.go:222 trace {"elapsed": "18.981660653s", "rows": 452, "sql": "SHOW TABLE STATUS FROM `test`"}
2024/07/04 13:40:29.409728 +0000 WARN models/meta.go:222 trace {"elapsed": "18.671528182s", "rows": 452, "sql": "SHOW TABLE STATUS FROM `test4`"}
