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

spanconfig: add helpful crdb_internal builtins #80148

Closed
2 of 5 tasks
Tracked by #81009
irfansharif opened this issue Apr 19, 2022 · 3 comments
Closed
2 of 5 tasks
Tracked by #81009

spanconfig: add helpful crdb_internal builtins #80148

irfansharif opened this issue Apr 19, 2022 · 3 comments
Labels
A-zone-configs C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) no-issue-activity T-kv KV Team X-stale

Comments

@irfansharif
Copy link
Contributor

irfansharif commented Apr 19, 2022

Is your feature request related to a problem? Please describe.

The following builtins may prove to be useful to have around if diagnosing issues with span configs infrastructure. The ability to:

  • recompute tenant-side limit (system.span_count)
  • force restart the reconciliation job
  • disable the reconciliation job
  • force restart the kvsubscriber process
  • introspect the kvsubscriber cache

Jira issue: CRDB-15833

@irfansharif irfansharif added C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) A-zone-configs labels Apr 19, 2022
@irfansharif irfansharif self-assigned this Apr 19, 2022
@blathers-crl blathers-crl bot added the T-kv KV Team label Apr 19, 2022
@irfansharif
Copy link
Contributor Author

To force restart the reconciliation job and disable the reconciliation job, you can just use the jobs infra.

SELECT job_id FROM [SHOW AUTOMATIC JOBS]
   WHERE job_type = 'AUTO SPAN CONFIG RECONCILIATION'

PAUSE JOB $job_id
RESUME JOB $job_id

@irfansharif
Copy link
Contributor Author

Tracking in #81009, gonna be best-effort/friday work from now.

@jlinder jlinder added sync-me and removed sync-me labels May 20, 2022
Copy link

We have marked this issue as stale because it has been inactive for
18 months. If this issue is still relevant, removing the stale label
or adding a comment will keep it active. Otherwise, we'll close it in
10 days to keep the issue queue tidy. Thank you for your contribution
to CockroachDB!

@github-actions github-actions bot closed this as not planned Won't fix, can't repro, duplicate, stale Nov 27, 2023
@github-project-automation github-project-automation bot moved this to Closed in KV Aug 28, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-zone-configs C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) no-issue-activity T-kv KV Team X-stale
Projects
No open projects
Archived in project
Development

No branches or pull requests

2 participants