Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

tpch10000 q5 grace join memlimit. nothing spilled #11412

Open
lll-phill-lll opened this issue Nov 8, 2024 · 2 comments
Open

tpch10000 q5 grace join memlimit. nothing spilled #11412

lll-phill-lll opened this issue Nov 8, 2024 · 2 comments
Assignees
@lll-phill-lll
Labels
area/runtime YDB runtime issues

Comments

@lll-phill-lll
Copy link
Member

lll-phill-lll commented Nov 8, 2024 •
edited
Loading

Got OOM during nighly run in TPCH10000 q5 in grace join: https://proxy.sandbox.yandex-team.ru/7425151036/index.html#suites/fd4dd690a9ee7ddce6d52cd9527face7/13c19cd0b8d96fa6/

According to the svg plan spilling was not spilling
Image
@lll-phill-lll lll-phill-lll self-assigned this Nov 8, 2024
@lll-phill-lll lll-phill-lll added the area/runtime YDB runtime issues label Nov 8, 2024
@lll-phill-lll lll-phill-lll changed the title q5 grace join. OMM no spilling tpch10000 q5 grace join oom. nothing spilled Nov 8, 2024
@lll-phill-lll
Copy link
Member Author

same here:
https://proxy.sandbox.yandex-team.ru/7424952174/index.html#suites/83a7db6541269867a604826f8b4fa5ca/9d2294ec81b4fa25/

@lll-phill-lll
Copy link
Member Author

lll-phill-lll commented Nov 12, 2024 •
edited
Loading

Fresh run: https://proxy.sandbox.yandex-team.ru/7446727520/index.html#suites/fd4dd690a9ee7ddce6d52cd9527face7/191244b9e971da06/

spilling is presented. But still memlimit Image

BT:
https://paste.yandex-team.ru/3cf690d7-207d-4aa2-b6d5-4c7665f9deb1

ydb/yql/essentials/minikql/comp_nodes/mkql_grace_join_imp.cpp

Line 1221 in 519686a

first.insert(first.end(), second.begin(), second.end());

@lll-phill-lll lll-phill-lll changed the title tpch10000 q5 grace join oom. nothing spilled tpch10000 q5 grace join mkql limit. nothing spilled Nov 12, 2024
@lll-phill-lll lll-phill-lll changed the title tpch10000 q5 grace join mkql limit. nothing spilled tpch10000 q5 grace join memlimit. nothing spilled Nov 12, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@lll-phill-lll lll-phill-lll

Labels
area/runtime YDB runtime issues
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@lll-phill-lll