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.

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

Fix skip_unavailable_shards in case of unavailable hosts #48771

Merged

Conversation

azat
Copy link
Collaborator

@azat azat commented Apr 14, 2023

Changelog category (leave one):

  • Bug Fix (user-visible misbehavior in an official stable release)

Changelog entry (a user-readable short description of the changes that goes to CHANGELOG.md):

Fix skip_unavailable_shards in case of unavailable hosts

In #26658 only one excessive connect had been removed, but due to RemoteQueryExecutor will execute query again in read(), there is one more, fix this by correctly mark connection in sendQuery()

But note, that there still will be excessive connections due to separate connections for obtaining structure.

Follow-up for: #26658
Fixes: #48728 (cc @SaltTan @den-crane )

@robot-ch-test-poll robot-ch-test-poll added the pr-bugfix Pull request with bugfix, not backported by default label Apr 14, 2023
@alexey-milovidov alexey-milovidov self-assigned this Apr 14, 2023
@azat azat force-pushed the fix-skip_unavailable_shards branch 2 times, most recently from c073fee to 3d61a32 Compare April 14, 2023 10:53
In ClickHouse#26658 only one excessive connect had been removed, but due to
RemoteQueryExecutor will execute query again in read(), there is one
more, fix this by correctly mark connection in sendQuery()

But note, that there still will be excessive connections due to separate
connections for obtaining structure.

Follow-up for: ClickHouse#26658
Fixes: ClickHouse#48728
Signed-off-by: Azat Khuzhin <a.khuzhin@semrush.com>
@azat azat force-pushed the fix-skip_unavailable_shards branch from 3d61a32 to 9f694a3 Compare April 14, 2023 12:16
@alexey-milovidov alexey-milovidov merged commit a2793fc into ClickHouse:master Apr 15, 2023
136 checks passed
@azat azat deleted the fix-skip_unavailable_shards branch April 16, 2023 20:19
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
pr-bugfix Pull request with bugfix, not backported by default
Projects
None yet
Development

Successfully merging this pull request may close these issues.

AGAIN skip_unavailable_shards=1 makes 6 tries if a shard is unavailable
3 participants