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.

Sign up for GitHub

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

Jump to bottom

Transactional schema change - support/error handling #97157

Closed
filacouris opened this issue Feb 15, 2023 · 1 comment
Closed

Transactional schema change - support/error handling #97157

filacouris opened this issue Feb 15, 2023 · 1 comment
Labels
A-schema-changes C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)

Comments

@filacouris
Copy link

filacouris commented Feb 15, 2023 •
edited by cockroach-jira-scripts
Loading

Executing multiple ddl statements within a transaction results in the following:

  • high likelihood of retry errors
  • lack of atomicity

Present day this can lead to friction in migration patterns and schema operations.

Request: better support for transactional schema changes or clearer errors/hints to eliminate friction

Jira issue: CRDB-24545
@filacouris filacouris added C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) A-schema-changes T-sql-schema-deprecated Use T-sql-foundations instead labels Feb 15, 2023
@ajwerner
Copy link
Contributor

The lack of atomicity is tracked in #42061 and lots of work in underway as we implement https://github.com/cockroachdb/cockroach/blob/master/docs/RFCS/20200909_transactional_schema_changes.md and https://github.com/cockroachdb/cockroach/blob/master/docs/RFCS/20200909_transactional_schema_changes.md.

As for the starvation, it is actively being worked on in #96840 and #95764.

@exalate-issue-sync exalate-issue-sync bot added T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) and removed T-sql-schema-deprecated Use T-sql-foundations instead labels May 10, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
A-schema-changes C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@ajwerner @filacouris