-
Notifications
You must be signed in to change notification settings - Fork 3.9k
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
sql: No way to get insight into VALIDATE CONSTRAINT progress #26639
Comments
Issue encountered on gitter by @lkarlslund today |
If validate wait times scale with database sizes, this UX problem is going to come up more frequently as we market scalability. I've been waiting for several minutes for my current ALTER and it's not clear if I should kill the job or wait longer. @vivekmenezes is there a workaround for determining if this is slow or just stuck? cc @awoods187 |
Hey @vivekmenezes - this is coming up again and a customer is asking how to determine whether or not validation is progressing. Is there a method available? |
On the latest alpha
And there is still no job that says what's happening. To reproduce, just follow the steps to load the 1M movr dataset here: https://github.com/cockroachdb/movr |
Thanks Nate! Fortunately @lucy-zhang has been able to reproduce the problem with it hanging. She's investigating the issue. Once she's done with fixing it she can run the steps here and double check that they work. We don't necessarily need a job for this since the query execution is happening as part of the validation (just like any distsql query), the problem here really is the query hanging. |
Zendesk ticket #3020 has been linked to this issue. |
Quick update: Some of the performance issues related to VALIDATE CONSTRAINT alluded to above have been fixed, but the fact remains that currently there's no good way to give progress updates on VALIDATE since we're just running a select query to find invalid rows. We'd need some way to get query progress. So this is on hold for the foreseeable future. |
btw: #42518 |
A note that a client recently would have benefited from this (meaningful progress during schema validation). Conversation in Slack, you can ping me if interested. |
After running
alter table vehicles validate constraint fk_owner_id_ref_users;
, I assumed it should be possible to track the execution status, but neitherSHOW CLUSTER QUERIES
norSHOW JOBS
represented it.I think there should be a way to get insight into this via the CLI or Admin UI.
cc: @knz
Jira issue: CRDB-4992
The text was updated successfully, but these errors were encountered: