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

hangs on executing Q10 SELECT avg(cnt) FROM (SELECT Year,Month,count(*) AS cnt FROM default.ontime WHERE DepDel15=1 GROUP BY Year,Month) a; #106

Open
flaneur2020 opened this issue Aug 23, 2022 · 5 comments · Fixed by databendlabs/databend#7410
Open

hangs on executing Q10 SELECT avg(cnt) FROM (SELECT Year,Month,count(*) AS cnt FROM default.ontime WHERE DepDel15=1 GROUP BY Year,Month) a; #106

flaneur2020 opened this issue Aug 23, 2022 · 5 comments · Fixed by databendlabs/databend#7410

Comments

@flaneur2020
Copy link
Member

cluster: 2 instances.

hangs on start query , and without query ID returned at all.
@flaneur2020 flaneur2020 changed the title hangs on executing SELECT avg(cnt) FROM (SELECT Year,Month,count(*) AS cnt FROM default.ontime WHERE DepDel15=1 GROUP BY Year,Month) a; hangs on executing Q10 SELECT avg(cnt) FROM (SELECT Year,Month,count(*) AS cnt FROM default.ontime WHERE DepDel15=1 GROUP BY Year,Month) a; Aug 23, 2022
@sundy-li
Copy link
Member

So it's related to cluster query?

@flaneur2020
Copy link
Member Author

So it's related to cluster query?

I guess so, the query get hangs without returns an empty response with query ID.

@flaneur2020 flaneur2020 mentioned this issue Aug 23, 2022
Open
@flaneur2020
Copy link
Member Author

let me upgrade to 0.8.5-nightly and retry again

@flaneur2020
Copy link
Member Author

flaneur2020 commented Aug 23, 2022 •
edited
Loading

the issue still same at 0.8.5-nightly with a 2 instances cluster, also get no query id responded.

@flaneur2020
Copy link
Member Author

maybe related: databendlabs/databend#7280

This was referenced Aug 26, 2022
Merged
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

feat(http_handler): the first request no longer wait for query to start youngsofun/databend
2 participants
@flaneur2020 @sundy-li