[Bug] 2.1.2版本内存随着时间增大

[RaymondFishWang]

Search before asking

• I had searched in the issues and found no similar issues.

Version

5.1期间从2.0.7升到了2.1.2

What's Wrong?

内存的使用率逐渐增大，整体配置，3 fe 3be ,2台内存占到60%，一台内存占到了 90%， 三台fe 内存8g左右，2个be 30G，1个be 占到了42G

What You Expected?

保持稳定，如2.0.7

How to Reproduce?

No response

Anything Else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[zh0122]

select * from information_schema.backend_active_tasks  order by TASK_TIME_MS desc 

执行这个SQL查看BE上是否有大量长时间task没有结束, 如果是相同问题, 在2.1.4 已修复

[SoyMeng]

@zh0122 咨询一下，backend_active_tasks中存在的query_id不在active_queries表中，这种情况是否是正常的？

[RaymondFishWang]

这个sql 查询的结果从500-1300条记录，不等，同时active_queries只有一条，而且奇怪的是我们有三台be, 差不多除了2条在2个be节点，其他全部都在另外一个节点上