In 22.2 we added extra validation for region configs, which made (#100913) the skip_localities options problematic if the primary region of the database being restored no longer exists. While this option will correctly skip the validation of regions for databases, there is no real path for actually fixing the region anymore, since the same validation blocks alter commands. Our options are to either:
- Have restore completely wipe / re-configure the multi-region properties of a database
- Allow ALTER DATABASE SET PRIMARY REGION to work within a transaction to fix this issue
- Have a temporary bypass via a session variable to disable validation for this use case
Jira issue: CRDB-27925
Epic CRDB-27601
In 22.2 we added extra validation for region configs, which made (#100913) the skip_localities options problematic if the primary region of the database being restored no longer exists. While this option will correctly skip the validation of regions for databases, there is no real path for actually fixing the region anymore, since the same validation blocks alter commands. Our options are to either:
Jira issue: CRDB-27925
Epic CRDB-27601