[Bug] 执行查询出现内存不够 #33565
Description
Search before asking
- I had searched in the issues and found no similar issues.
Version
Doris 2.1
What's Wrong?
执行查询出现以下异常
java.sql.SQLException: errCode = 2, detailMessage = (10.8.6.25)[CANCELLED]Allocator sys memory check failed: Cannot alloc:134217728, consuming tracker:<Query#Id=dbc28f531df44269-a08455b0b412adc3>, peak used 11064400550, current used 11064400550, exec node:<>, process memory used 25.55 GB exceed limit 24.48 GB or sys available memory 3.81 GB less than low water mark 1.60 GB.
或者就是这个异常：
java.sql.SQLException: errCode = 2, detailMessage = (10.8.6.31)[CANCELLED]Process has no memory available, cancel top memory used query: query memory tracker <Query#Id=9e4d70bf37ce40dd-a9db860227aabe6f> consumption 10.84 GB, backend 10.8.6.31 process memory used 25.75 GB exceed limit 24.48 GB or sys available memory 3.61 GB less than low water mark 1.60 GB. Execute again after enough memory, details see be.INFO.
What You Expected?
怎么会出现这种异常呢？我应该如何去避免呢？
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