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

Enable SQL observability CRDB_INTERNAL table for index usage statistics #70878

Closed
kevin-v-ngo opened this issue Sep 29, 2021 · 2 comments · Fixed by #70966
Closed

Enable SQL observability CRDB_INTERNAL table for index usage statistics #70878

kevin-v-ngo opened this issue Sep 29, 2021 · 2 comments · Fixed by #70966
Assignees
Labels
C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. GA-blocker

Comments

@kevin-v-ngo
Copy link

Related to the following issue. The CRDB_INTERNAL table needs to be supported:

crdb_internal.index_usage_statistics

Epic: CC-4763

@kevin-v-ngo kevin-v-ngo added the C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. label Sep 29, 2021
Azhng added a commit to Azhng/cockroach that referenced this issue Oct 1, 2021
…server

Resolves cockroachdb#70878

Release note (api change): Serverless's IndexUsageStatistics RPC now
returns cluster-wide data.
craig bot pushed a commit that referenced this issue Oct 1, 2021
70361: sql: return an error message when trying to show grants for an invalid user r=jackcwu a=jackcwu

Release justification: None, waiting for 22.1
Release note: None

Resolves #32811

70933: reduce: show original test case output r=mgartner a=mgartner

The `reduce` tool now shows the original test case output in verbose
mode if it is not found to be interesting. This makes it easier for a
user to determine why a reproduction is not producing output that
matches the `--contains` regex.

Release note: None

70966: serverccl: support IndexUsageStatistics RPC fanout for tenant status server r=maryliag a=Azhng

Follow up to #70959

Resolves #70878

Release note (api change): Serverless's IndexUsageStatistics RPC now
returns cluster-wide data.

70994: server: Fix query profiler panic for serverless. r=jaylim-crl a=rimadeodhar

The Query Profiler would panic for serverless clusters under memory
pressure as the session registry was not set. This PR updates the
serverless code to pass in the session registry to the Query Profiler.


Fixes: #70945

Release note (bug fix): The SQL server no longer panics under
memory pressure when the query profiler is enabled.


71000: roachtest/sqlsmith: swallow "no volatility for cast" error r=yuzefovich a=yuzefovich

Touches: #70831.

Release note: None

Co-authored-by: Jack Wu <[email protected]>
Co-authored-by: Marcus Gartner <[email protected]>
Co-authored-by: Azhng <[email protected]>
Co-authored-by: rimadeodhar <[email protected]>
Co-authored-by: Yahor Yuzefovich <[email protected]>
@craig craig bot closed this as completed in e074477 Oct 1, 2021
@Azhng
Copy link
Contributor

Azhng commented Oct 1, 2021

Reopening for backport

@blathers-crl
Copy link

blathers-crl bot commented Oct 1, 2021

Hi @Azhng, please add branch-* labels to identify which branch(es) this release-blocker affects.

🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is otan.

Azhng added a commit to Azhng/cockroach that referenced this issue Oct 1, 2021
…server

Resolves cockroachdb#70878

Release note (api change): Serverless's IndexUsageStatistics RPC now
returns cluster-wide data.
@maryliag maryliag closed this as completed Oct 1, 2021
andy-kimball pushed a commit that referenced this issue Oct 6, 2021
…server

Resolves #70878

Release note (api change): Serverless's IndexUsageStatistics RPC now
returns cluster-wide data.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. GA-blocker
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants