Skip to content

cluster-ui: fix replicas and regions query for the database details API#107893

Merged
craig[bot] merged 1 commit intocockroachdb:masterfrom
THardy98:fix_replica_range_query_db_details
Aug 2, 2023
Merged

cluster-ui: fix replicas and regions query for the database details API#107893
craig[bot] merged 1 commit intocockroachdb:masterfrom
THardy98:fix_replica_range_query_db_details

Conversation

@THardy98
Copy link
Copy Markdown

@THardy98 THardy98 commented Jul 31, 2023

Epic: None

A change in #105582 caused the regions/replicas query to return incorrect, unexpected results (instead of reducing the returned rows from the CTE to a single row, the cross join caused the number of rows to square, resulting in x^2 rows) causing the endpoint to never resolve properly, which in turn, caused an infinite loading state. This change fixes the regions/replicas query for the database details API.

Release note (ui change): fix a broken query for the database details page that was causing an infinite loading state.

@THardy98 THardy98 added the backport-23.1.x PAST MAINTENANCE SUPPORT: 23.1 patch releases via ER request only label Jul 31, 2023
@THardy98 THardy98 requested review from a team July 31, 2023 17:40
@cockroach-teamcity
Copy link
Copy Markdown
Member

This change is Reviewable

A change in cockroachdb#105582 caused the regions/replicas query to return
incorrect, unexpected results causing the endpoint to never resolve
properly, which in turn, caused an infinite loading state. This change
fixes the regions/replicas query for the database details API.

Release note (ui change): fix a broken query for the database details
page that was causing an infinite loading state.
@THardy98 THardy98 force-pushed the fix_replica_range_query_db_details branch from abee236 to 8d8db98 Compare July 31, 2023 22:05
Copy link
Copy Markdown
Contributor

@maryliag maryliag left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

:lgtm:

Reviewed 1 of 1 files at r1, all commit messages.
Reviewable status: :shipit: complete! 1 of 0 LGTMs obtained (waiting on @mgartner)

@THardy98
Copy link
Copy Markdown
Author

THardy98 commented Aug 2, 2023

bors r+

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Aug 2, 2023

Build failed (retrying...):

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Aug 2, 2023

Build succeeded:

@craig craig bot merged commit 54a3a38 into cockroachdb:master Aug 2, 2023
@blathers-crl
Copy link
Copy Markdown

blathers-crl bot commented Aug 2, 2023

Encountered an error creating backports. Some common things that can go wrong:

  1. The backport branch might have already existed.
  2. There was a merge conflict.
  3. The backport branch contained merge commits.

You might need to create your backport manually using the backport tool.


error creating merge commit from 8d8db98 to blathers/backport-release-23.1-107893: POST https://api.github.com/repos/cockroachdb/cockroach/merges: 409 Merge conflict []

you may need to manually resolve merge conflicts with the backport tool.

Backport to branch 23.1.x failed. See errors above.


🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is dev-inf.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

backport-23.1.x PAST MAINTENANCE SUPPORT: 23.1 patch releases via ER request only

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants