sql/schemachange: reconsider interactions between `DROP TABLE` statements and ongoing jobs

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.

https://www.cockroachlabs.com

Other

30.13k stars 3.81k forks source link

sql/schemachange: reconsider interactions between `DROP TABLE` statements and ongoing jobs #61256

Open ajwerner opened 3 years ago

ajwerner commented 3 years ago

Is your feature request related to a problem? Please describe. In the current iteration of the new schema changer, we prevent DROP TABLE from pre-empting ongoing schema change jobs and return an error. It's not clear that this is good behavior.

Jira issue: CRDB-3048

thoszhang commented 3 years ago

TRUNCATE also presents a similar but different problem.

ajwerner commented 2 years ago

This is something to think about, but, for now, is for the backlog. The good news is that in the new schema changer, all job cancelation should be fast.