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

MaterializedViewRefresh mutation not supported in restore #101075

Closed
rhu713 opened this issue Apr 10, 2023 · 1 comment · Fixed by #102516
Closed

MaterializedViewRefresh mutation not supported in restore #101075

rhu713 opened this issue Apr 10, 2023 · 1 comment · Fixed by #102516
Assignees
@rafiss
Labels
C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)

Comments

@rhu713
Copy link
Contributor

rhu713 commented Apr 10, 2023 •
edited by exalate-issue-sync bot
Loading

Restores that include tables with a MaterializedViewRefresh mutation can fail with an error like

ERROR: unsupported mutation {Descriptor_:<x> State:WRITE_ONLY Direction:ADD MutationID:<x> Rollback:false}, while restoring table name:"<x>"

This type of mutation is currently not handled in the restore schema job creation codepath: https://github.com/cockroachdb/cockroach/blob/v22.2.7/pkg/ccl/backupccl/restore_schema_change_creation.go#L79-L109

Jira issue: CRDB-26791

gz#16626

Epic CRDB-27601
@rhu713 rhu713 added C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. A-disaster-recovery T-sql-schema-deprecated Use T-sql-foundations instead labels Apr 10, 2023
@blathers-crl
Copy link

blathers-crl bot commented Apr 10, 2023

cc @cockroachdb/disaster-recovery

@exalate-issue-sync exalate-issue-sync bot added T-sql-schema-deprecated Use T-sql-foundations instead and removed T-disaster-recovery T-sql-schema-deprecated Use T-sql-foundations instead labels Apr 13, 2023
@rafiss rafiss self-assigned this Apr 25, 2023
@yuzefovich yuzefovich mentioned this issue Apr 29, 2023
Merged
@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
@craig craig bot closed this as completed in 117dc40 May 12, 2023
This was referenced May 12, 2023
Merged
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@rafiss rafiss

Labels
C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
No open projects
Disaster Recovery Backlog
Archived in project
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

backupccl: support materialized view mutation in restore rafiss/cockroach
3 participants
@rafiss @rhu713 @livlobo