Skip to content

Fix skip_unavailable_shards in case of unavailable hosts#48771

Merged
alexey-milovidov merged 1 commit intoClickHouse:masterfrom
azat:fix-skip_unavailable_shards
Apr 15, 2023
Merged

Fix skip_unavailable_shards in case of unavailable hosts#48771
alexey-milovidov merged 1 commit intoClickHouse:masterfrom
azat:fix-skip_unavailable_shards

Conversation

@azat
Copy link
Copy Markdown
Member

@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 <[email protected]>
@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
@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