You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2022/06/06 14:47:46 UTC
[GitHub] [incubator-doris] SWJTU-ZhangLei opened a new issue, #9978: [Bug] tpcds_sf1/brown/limit/window_functions query failed
SWJTU-ZhangLei opened a new issue, #9978:
URL: https://github.com/apache/incubator-doris/issues/9978
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
### Version
master branch
tr unk DEBUG (build git://regtest-15-bj/mnt/hdd01/repo_center/selectdb_master/selectdb/be/../@32a210f426f9422a971a1e0157a349c6f88c9dcd)
### What's Wrong?
1、query exception
Exception in window_functions/sql/rowsIdenticalWindows.sql:
java.sql.SQLException: errCode = 2, detailMessage = Memory exceed limit. fragment=5520ba3bfe5643cd-ab39c6f9d65b745b, details=vsort, while open., on backend=172.21.16.15. Memory left in process limit=6.42 GB. current tracker <label=RuntimeState:instance:5520ba3bfe5643cd-ab39c6f9d65b745b:queryId=5520ba3bfe5643cd-ab39c6f9d65b7456, used=16384, limit=10737418240, failed alloc size=-1.00 B>. If this is a query, can change the limit by session variable exec_mem_limit.
2、maybe memory leak
root@regtest-15-bj:/mnt/hdd01/regression# top
top - 22:43:31 up 46 days, 23:38, 19 users, load average: 2.64, 2.72, 3.35
Tasks: 425 total, 1 running, 424 sleeping, 0 stopped, 0 zombie
%Cpu(s): 8.0 us, 0.1 sy, 0.0 ni, 91.7 id, 0.1 wa, 0.0 hi, 0.0 si, 0.0 st
MiB Mem : 126298.6 total, 5794.1 free, 114729.9 used, 5774.6 buff/cache
MiB Swap: 0.0 total, 0.0 free, 0.0 used. 10355.4 avail Mem
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
2478239 root 20 0 20.1t 60.3g 24344 S 22.6 48.9 2843:09 palo_be
### What You Expected?
tpch_sf1 can return correct result.
### How to Reproduce?
run regression-test
### Anything Else?
_No response_
### Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org