Sentry: validate_table.go:125: relation × (147): invalid locality config: expected no region Enum ID to be referenced by a GLOBAL TABLE: × but found: 107 (1) Wraps: (2) attached stack trace -- sta...

[cockroach-sentry]

This issue was auto filed by Sentry. It represents a crash or reported error on a live cluster with telemetry enabled.

Sentry Link: https://cockroach-labs.sentry.io/issues/6823933556/?referrer=webhooks_plugin

Panic Message:

validate_table.go:125: relation × (147): invalid locality config: expected no region Enum ID to be referenced by a GLOBAL TABLE: × but found: 107
(1)
Wraps: (2) attached stack trace
  -- stack trace:
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/validate.(*validationErrorAccumulator).decorate
  | 	pkg/sql/catalog/internal/validate/validate.go:246
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/validate.(*validationErrorAccumulator).Report
  | 	pkg/sql/catalog/internal/validate/validate.go:181
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/tabledesc.(*wrapper).ValidateForwardReferences
  | 	pkg/sql/catalog/tabledesc/validate.go:193
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/validate.Validate.func2
  | 	pkg/sql/catalog/internal/validate/validate.go:98
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/validate.(*validationErrorAccumulator).validateDescriptorsAtLevel
  | 	pkg/sql/catalog/internal/validate/validate.go:197
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/validate.Validate
  | 	pkg/sql/catalog/internal/validate/validate.go:93
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/descs.(*Collection).Validate
  | 	pkg/sql/catalog/descs/validate.go:35
  | github.com/cockroachdb/cockroach/pkg/sql.validateDescriptor
  | 	pkg/sql/planner.go:826
  | github.com/cockroachdb/cockroach/pkg/sql.(*createViewNode).startExec.func1.1
  | 	pkg/sql/create_view.go:347
  | github.com/cockroachdb/cockroach/pkg/sql.(*createViewNode).startExec.func1
  | 	pkg/sql/create_view.go:379
  | github.com/cockroachdb/cockroach/pkg/sql.(*schemaResolver).runWithOptions
  | 	pkg/sql/schema_resolver.go:439
  | github.com/cockroachdb/cockroach/pkg/sql.(*createViewNode).startExec
  | 	pkg/sql/create_view.go:192
  | github.com/cockroachdb/cockroach/pkg/sql.startExec
  | 	pkg/sql/plan.go:578
  | github.com/cockroachdb/cockroach/pkg/sql.(*planNodeToRowSource).Start
  | 	pkg/sql/plan_node_to_row_source.go:181
  | github.com/cockroachdb/cockroach/pkg/sql/colexec.(*Columnarizer).Init
  | 	pkg/sql/colexec/columnarizer.go:178
  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*batchInfoCollector).init
  | 	pkg/sql/colflow/stats.go:96
  | github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError
  | 	pkg/sql/colexecerror/error.go:162
  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*batchInfoCollector).Init
  | 	pkg/sql/colflow/stats.go:105
  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*BatchFlowCoordinator).Run.(*BatchFlowCoordinator).init.func2
  | 	pkg/sql/colflow/flow_coordinator.go:236
  | github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError
  | 	pkg/sql/colexecerror/error.go:162
  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*BatchFlowCoordinator).init
  | 	pkg/sql/colflow/flow_coordinator.go:235
  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*BatchFlowCoordinator).Run
  | 	pkg/sql/colflow/flow_coordinator.go:269
  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*vectorizedFlow).Run
  | 	pkg/sql/colflow/vectorized_flow.go:316
  | github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).Run
  | 	pkg/sql/distsql_running.go:991
  | github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).PlanAndRun
  | 	pkg/sql/distsql_running.go:2094
  | github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).PlanAndRunAll.func3
  | 	pkg/sql/distsql_running.go:1798
  | github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).PlanAndRunAll
  | 	pkg/sql/distsql_running.go:1801
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execWithDistSQLEngine
  | 	pkg/sql/conn_executor_exec.go:3482
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).dispatchToExecutionEngine
  | 	pkg/sql/conn_executor_exec.go:2997
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmtInOpenState
  | 	pkg/sql/conn_executor_exec.go:1086
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt.func2
  | 	pkg/sql/conn_executor_exec.go:171
Wraps: (3) relation × (147)
Wraps: (4) attached stack trace
  -- stack trace:
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/tabledesc.(*wrapper).ValidateForwardReferences
  | 	pkg/sql/catalog/tabledesc/validate.go:193
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/validate.Validate.func2
  | 	pkg/sql/catalog/internal/validate/validate.go:98
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/validate.(*validationErrorAccumulator).validateDescriptorsAtLevel
  | 	pkg/sql/catalog/internal/validate/validate.go:197
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/validate.Validate
  | 	pkg/sql/catalog/internal/validate/validate.go:93
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/descs.(*Collection).Validate
  | 	pkg/sql/catalog/descs/validate.go:35
  | github.com/cockroachdb/cockroach/pkg/sql.validateDescriptor
  | 	pkg/sql/planner.go:826
  | github.com/cockroachdb/cockroach/pkg/sql.(*createViewNode).startExec.func1.1
  | 	pkg/sql/create_view.go:347
  | github.com/cockroachdb/cockroach/pkg/sql.(*createViewNode).startExec.func1
  | 	pkg/sql/create_view.go:379
  | github.com/cockroachdb/cockroach/pkg/sql.(*schemaResolver).runWithOptions
  | 	pkg/sql/schema_resolver.go:439
  | github.com/cockroachdb/cockroach/pkg/sql.(*createViewNode).startExec
  | 	pkg/sql/create_view.go:192
  | github.com/cockroachdb/cockroach/pkg/sql.startExec
  | 	pkg/sql/plan.go:578
  | github.com/cockroachdb/cockroach/pkg/sql.(*planNodeToRowSource).Start
  | 	pkg/sql/plan_node_to_row_source.go:181
  | github.com/cockroachdb/cockroach/pkg/sql/colexec.(*Columnarizer).Init
  | 	pkg/sql/colexec/columnarizer.go:178
  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*batchInfoCollector).init
  | 	pkg/sql/colflow/stats.go:96
  | github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError
  | 	pkg/sql/colexecerror/error.go:162
  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*batchInfoCollector).Init
  | 	pkg/sql/colflow/stats.go:105
  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*BatchFlowCoordinator).Run.(*BatchFlowCoordinator).init.func2
  | 	pkg/sql/colflow/flow_coordinator.go:236
  | github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError
  | 	pkg/sql/colexecerror/error.go:162
  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*BatchFlowCoordinator).init
  | 	pkg/sql/colflow/flow_coordinator.go:235
  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*BatchFlowCoordinator).Run
  | 	pkg/sql/colflow/flow_coordinator.go:269
  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*vectorizedFlow).Run
  | 	pkg/sql/colflow/vectorized_flow.go:316
  | github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).Run
  | 	pkg/sql/distsql_running.go:991
  | github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).PlanAndRun
  | 	pkg/sql/distsql_running.go:2094
  | github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).PlanAndRunAll.func3
  | 	pkg/sql/distsql_running.go:1798
  | github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).PlanAndRunAll
  | 	pkg/sql/distsql_running.go:1801
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execWithDistSQLEngine
  | 	pkg/sql/conn_executor_exec.go:3482
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).dispatchToExecutionEngine
  | 	pkg/sql/conn_executor_exec.go:2997
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmtInOpenState
  | 	pkg/sql/conn_executor_exec.go:1086
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt.func2
  | 	pkg/sql/conn_executor_exec.go:171
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execWithProfiling
  | 	pkg/sql/conn_executor_exec.go:4493
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt
  | 	pkg/sql/conn_executor_exec.go:170
Wraps: (5) invalid locality config
Wraps: (6) assertion failure
Wraps: (7) attached stack trace
  -- stack trace:
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/multiregion.ValidateTableLocalityConfig
  | 	pkg/sql/catalog/multiregion/validate_table.go:125
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/...

Stacktrace (expand for inline code snippets):

pkg/sql/conn_executor_exec.go#L4492-L4494
pkg/sql/conn_executor_exec.go#L170-L172
pkg/sql/conn_executor_exec.go#L1085-L1087
pkg/sql/conn_executor_exec.go#L2996-L2998
pkg/sql/conn_executor_exec.go#L3481-L3483
pkg/sql/distsql_running.go#L1800-L1802
pkg/sql/distsql_running.go#L1797-L1799
pkg/sql/distsql_running.go#L2093-L2095
pkg/sql/distsql_running.go#L990-L992
pkg/sql/colflow/vectorized_flow.go#L315-L317
pkg/sql/colflow/flow_coordinator.go#L268-L270
pkg/sql/colflow/flow_coordinator.go#L234-L236
pkg/sql/colexecerror/error.go#L161-L163
pkg/sql/colflow/flow_coordinator.go#L235-L237
pkg/sql/colflow/stats.go#L104-L106
pkg/sql/colexecerror/error.go#L161-L163
pkg/sql/colflow/stats.go#L95-L97
pkg/sql/colexec/columnarizer.go#L177-L179
pkg/sql/plan_node_to_row_source.go#L180-L182
pkg/sql/plan.go#L577-L579
pkg/sql/create_view.go#L191-L193
pkg/sql/schema_resolver.go#L438-L440
pkg/sql/create_view.go#L378-L380
pkg/sql/create_view.go#L346-L348
pkg/sql/planner.go#L825-L827
pkg/sql/catalog/descs/validate.go#L34-L36
pkg/sql/catalog/internal/validate/validate.go#L92-L94
pkg/sql/catalog/internal/validate/validate.go#L196-L198
pkg/sql/catalog/internal/validate/validate.go#L97-L99
pkg/sql/catalog/tabledesc/validate.go#L192-L194
pkg/sql/catalog/internal/validate/validate.go#L180-L182
pkg/sql/catalog/internal/validate/validate.go#L245-L247
pkg/sql/conn_executor_exec.go#L320-L322
pkg/sql/conn_executor_exec.go#L169-L171
pkg/sql/conn_executor_exec.go#L4492-L4494
pkg/sql/conn_executor_exec.go#L170-L172
pkg/sql/conn_executor_exec.go#L1085-L1087
pkg/sql/conn_executor_exec.go#L2996-L2998
pkg/sql/conn_executor_exec.go#L3481-L3483
pkg/sql/distsql_running.go#L1800-L1802
pkg/sql/distsql_running.go#L1797-L1799
pkg/sql/distsql_running.go#L2093-L2095
pkg/sql/distsql_running.go#L990-L992
pkg/sql/colflow/vectorized_flow.go#L315-L317
pkg/sql/colflow/flow_coordinator.go#L268-L270
pkg/sql/colflow/flow_coordinator.go#L234-L236
pkg/sql/colexecerror/error.go#L161-L163
pkg/sql/colflow/flow_coordinator.go#L235-L237
pkg/sql/colflow/stats.go#L104-L106
pkg/sql/colexecerror/error.go#L161-L163
pkg/sql/colflow/stats.go#L95-L97
pkg/sql/colexec/columnarizer.go#L177-L179
pkg/sql/plan_node_to_row_source.go#L180-L182
pkg/sql/plan.go#L577-L579
pkg/sql/create_view.go#L191-L193
pkg/sql/schema_resolver.go#L438-L440
pkg/sql/create_view.go#L378-L380
pkg/sql/create_view.go#L346-L348
pkg/sql/planner.go#L825-L827
pkg/sql/catalog/descs/validate.go#L34-L36
pkg/sql/catalog/internal/validate/validate.go#L92-L94
pkg/sql/catalog/internal/validate/validate.go#L196-L198
pkg/sql/catalog/internal/validate/validate.go#L97-L99
pkg/sql/catalog/tabledesc/validate.go#L192-L194
pkg/sql/conn_executor_exec.go#L169-L171
pkg/sql/conn_executor_exec.go#L4492-L4494
pkg/sql/conn_executor_exec.go#L170-L172
pkg/sql/conn_executor_exec.go#L1085-L1087
pkg/sql/conn_executor_exec.go#L2996-L2998
pkg/sql/conn_executor_exec.go#L3481-L3483
pkg/sql/distsql_running.go#L1800-L1802
pkg/sql/distsql_running.go#L1797-L1799
pkg/sql/distsql_running.go#L2093-L2095
pkg/sql/distsql_running.go#L990-L992
pkg/sql/colflow/vectorized_flow.go#L315-L317
pkg/sql/colflow/flow_coordinator.go#L268-L270
pkg/sql/colflow/flow_coordinator.go#L234-L236
pkg/sql/colexecerror/error.go#L161-L163
pkg/sql/colflow/flow_coordinator.go#L235-L237
pkg/sql/colflow/stats.go#L104-L106
pkg/sql/colexecerror/error.go#L161-L163
pkg/sql/colflow/stats.go#L95-L97
pkg/sql/colexec/columnarizer.go#L177-L179
pkg/sql/plan_node_to_row_source.go#L180-L182
pkg/sql/plan.go#L577-L579
pkg/sql/create_view.go#L191-L193
pkg/sql/schema_resolver.go#L438-L440
pkg/sql/create_view.go#L378-L380
pkg/sql/create_view.go#L346-L348
pkg/sql/planner.go#L825-L827
pkg/sql/catalog/descs/validate.go#L34-L36
pkg/sql/catalog/internal/validate/validate.go#L92-L94
pkg/sql/catalog/internal/validate/validate.go#L196-L198
pkg/sql/catalog/internal/validate/validate.go#L97-L99
pkg/sql/catalog/tabledesc/validate.go#L191-L193
pkg/sql/catalog/multiregion/validate_table.go#L124-L126

pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execWithProfiling at line 4493
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmt.func2 at line 171
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmtInOpenState at line 1086
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).dispatchToExecutionEngine at line 2997
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execWithDistSQLEngine at line 3482
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).PlanAndRunAll at line 1801
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).PlanAndRunAll.func3 at line 1798
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).PlanAndRun at line 2094
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).Run at line 991
pkg/sql/colflow/vectorized_flow.go in pkg/sql/colflow.(*vectorizedFlow).Run at line 316
pkg/sql/colflow/flow_coordinator.go in pkg/sql/colflow.(*BatchFlowCoordinator).Run at line 269
pkg/sql/colflow/flow_coordinator.go in pkg/sql/colflow.(*BatchFlowCoordinator).init at line 235
pkg/sql/colexecerror/error.go in pkg/sql/colexecerror.CatchVectorizedRuntimeError at line 162
pkg/sql/colflow/flow_coordinator.go in pkg/sql/colflow.(*BatchFlowCoordinator).Run.(*BatchFlowCoordinator).init.func2 at line 236
pkg/sql/colflow/stats.go in pkg/sql/colflow.(*batchInfoCollector).Init at line 105
pkg/sql/colexecerror/error.go in pkg/sql/colexecerror.CatchVectorizedRuntimeError at line 162
pkg/sql/colflow/stats.go in pkg/sql/colflow.(*batchInfoCollector).init at line 96
pkg/sql/colexec/columnarizer.go in pkg/sql/colexec.(*Columnarizer).Init at line 178
pkg/sql/plan_node_to_row_source.go in pkg/sql.(*planNodeToRowSource).Start at line 181
pkg/sql/plan.go in pkg/sql.startExec at line 578
pkg/sql/create_view.go in pkg/sql.(*createViewNode).startExec at line 192
pkg/sql/schema_resolver.go in pkg/sql.(*schemaResolver).runWithOptions at line 439
pkg/sql/create_view.go in pkg/sql.(*createViewNode).startExec.func1 at line 379
pkg/sql/create_view.go in pkg/sql.(*createViewNode).startExec.func1.1 at line 347
pkg/sql/planner.go in pkg/sql.validateDescriptor at line 826
pkg/sql/catalog/descs/validate.go in pkg/sql/catalog/descs.(*Collection).Validate at line 35
pkg/sql/catalog/internal/validate/validate.go in pkg/sql/catalog/internal/validate.Validate at line 93
pkg/sql/catalog/internal/validate/validate.go in pkg/sql/catalog/internal/validate.(*validationErrorAccumulator).validateDescriptorsAtLevel at line 197
pkg/sql/catalog/internal/validate/validate.go in pkg/sql/catalog/internal/validate.Validate.func2 at line 98
pkg/sql/catalog/tabledesc/validate.go in pkg/sql/catalog/tabledesc.(*wrapper).ValidateForwardReferences at line 193
pkg/sql/catalog/internal/validate/validate.go in pkg/sql/catalog/internal/validate.(*validationErrorAccumulator).Report at line 181
pkg/sql/catalog/internal/validate/validate.go in pkg/sql/catalog/internal/validate.(*validationErrorAccumulator).decorate at line 246
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execPortal at line 321
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmt at line 170
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execWithProfiling at line 4493
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmt.func2 at line 171
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmtInOpenState at line 1086
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).dispatchToExecutionEngine at line 2997
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execWithDistSQLEngine at line 3482
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).PlanAndRunAll at line 1801
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).PlanAndRunAll.func3 at line 1798
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).PlanAndRun at line 2094
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).Run at line 991
pkg/sql/colflow/vectorized_flow.go in pkg/sql/colflow.(*vectorizedFlow).Run at line 316
pkg/sql/colflow/flow_coordinator.go in pkg/sql/colflow.(*BatchFlowCoordinator).Run at line 269
pkg/sql/colflow/flow_coordinator.go in pkg/sql/colflow.(*BatchFlowCoordinator).init at line 235
pkg/sql/colexecerror/error.go in pkg/sql/colexecerror.CatchVectorizedRuntimeError at line 162
pkg/sql/colflow/flow_coordinator.go in pkg/sql/colflow.(*BatchFlowCoordinator).Run.(*BatchFlowCoordinator).init.func2 at line 236
pkg/sql/colflow/stats.go in pkg/sql/colflow.(*batchInfoCollector).Init at line 105
pkg/sql/colexecerror/error.go in pkg/sql/colexecerror.CatchVectorizedRuntimeError at line 162
pkg/sql/colflow/stats.go in pkg/sql/colflow.(*batchInfoCollector).init at line 96
pkg/sql/colexec/columnarizer.go in pkg/sql/colexec.(*Columnarizer).Init at line 178
pkg/sql/plan_node_to_row_source.go in pkg/sql.(*planNodeToRowSource).Start at line 181
pkg/sql/plan.go in pkg/sql.startExec at line 578
pkg/sql/create_view.go in pkg/sql.(*createViewNode).startExec at line 192
pkg/sql/schema_resolver.go in pkg/sql.(*schemaResolver).runWithOptions at line 439
pkg/sql/create_view.go in pkg/sql.(*createViewNode).startExec.func1 at line 379
pkg/sql/create_view.go in pkg/sql.(*createViewNode).startExec.func1.1 at line 347
pkg/sql/planner.go in pkg/sql.validateDescriptor at line 826
pkg/sql/catalog/descs/validate.go in pkg/sql/catalog/descs.(*Collection).Validate at line 35
pkg/sql/catalog/internal/validate/validate.go in pkg/sql/catalog/internal/validate.Validate at line 93
pkg/sql/catalog/internal/validate/validate.go in pkg/sql/catalog/internal/validate.(*validationErrorAccumulator).validateDescriptorsAtLevel at line 197
pkg/sql/catalog/internal/validate/validate.go in pkg/sql/catalog/internal/validate.Validate.func2 at line 98
pkg/sql/catalog/tabledesc/validate.go in pkg/sql/catalog/tabledesc.(*wrapper).ValidateForwardReferences at line 193
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmt at line 170
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execWithProfiling at line 4493
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmt.func2 at line 171
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmtInOpenState at line 1086
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).dispatchToExecutionEngine at line 2997
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execWithDistSQLEngine at line 3482
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).PlanAndRunAll at line 1801
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).PlanAndRunAll.func3 at line 1798
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).PlanAndRun at line 2094
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).Run at line 991
pkg/sql/colflow/vectorized_flow.go in pkg/sql/colflow.(*vectorizedFlow).Run at line 316
pkg/sql/colflow/flow_coordinator.go in pkg/sql/colflow.(*BatchFlowCoordinator).Run at line 269
pkg/sql/colflow/flow_coordinator.go in pkg/sql/colflow.(*BatchFlowCoordinator).init at line 235
pkg/sql/colexecerror/error.go in pkg/sql/colexecerror.CatchVectorizedRuntimeError at line 162
pkg/sql/colflow/flow_coordinator.go in pkg/sql/colflow.(*BatchFlowCoordinator).Run.(*BatchFlowCoordinator).init.func2 at line 236
pkg/sql/colflow/stats.go in pkg/sql/colflow.(*batchInfoCollector).Init at line 105
pkg/sql/colexecerror/error.go in pkg/sql/colexecerror.CatchVectorizedRuntimeError at line 162
pkg/sql/colflow/stats.go in pkg/sql/colflow.(*batchInfoCollector).init at line 96
pkg/sql/colexec/columnarizer.go in pkg/sql/colexec.(*Columnarizer).Init at line 178
pkg/sql/plan_node_to_row_source.go in pkg/sql.(*planNodeToRowSource).Start at line 181
pkg/sql/plan.go in pkg/sql.startExec at line 578
pkg/sql/create_view.go in pkg/sql.(*createViewNode).startExec at line 192
pkg/sql/schema_resolver.go in pkg/sql.(*schemaResolver).runWithOptions at line 439
pkg/sql/create_view.go in pkg/sql.(*createViewNode).startExec.func1 at line 379
pkg/sql/create_view.go in pkg/sql.(*createViewNode).startExec.func1.1 at line 347
pkg/sql/planner.go in pkg/sql.validateDescriptor at line 826
pkg/sql/catalog/descs/validate.go in pkg/sql/catalog/descs.(*Collection).Validate at line 35
pkg/sql/catalog/internal/validate/validate.go in pkg/sql/catalog/internal/validate.Validate at line 93
pkg/sql/catalog/internal/validate/validate.go in pkg/sql/catalog/internal/validate.(*validationErrorAccumulator).validateDescriptorsAtLevel at line 197
pkg/sql/catalog/internal/validate/validate.go in pkg/sql/catalog/internal/validate.Validate.func2 at line 98
pkg/sql/catalog/tabledesc/validate.go in pkg/sql/catalog/tabledesc.(*wrapper).ValidateForwardReferences at line 192
pkg/sql/catalog/multiregion/validate_table.go in pkg/sql/catalog/multiregion.ValidateTableLocalityConfig at line 125

Tags

Tag	Value
Command	server
Environment	v25.2.2
Go Version	go1.23.7 X:nocoverageredesign
Platform	linux arm64
Distribution	CCL
Cockroach Release	v25.2.2
Cockroach SHA	0780d51
# of CPUs	12
# of Goroutines	656

Jira issue: CRDB-53703

Epic CRDB-49398

[blathers-crl]

CC'ing via the CODEOWNERS-based sentry heuristic:

• @cockroachdb/sql-foundations

Sentry issue cause: pkg/sql/catalog/multiregion/validate_table.go

_{🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is dev-inf.}

[rafiss]

Not sure exactly how to reproduce, but this is something similar:

demo@127.0.0.1:26257/demoapp/movr> create table t (a int primary key, b int) locality global;
CREATE TABLE

demo@127.0.0.1:26257/demoapp/movr> alter table t add column d text as ('us-east1'::crdb_internal_region::text) stored;
ALTER TABLE

demo@127.0.0.1:26257/demoapp/movr> create view v as select * from t;
ERROR: internal error: relation "v" (116): invalid locality config: expected no region Enum ID to be referenced by a REGIONAL BY TABLE: "v" homed in the primary region, but found: 112
SQLSTATE: XX000
DETAIL: stack trace:
pkg/sql/catalog/multiregion/validate_table.go:238: ValidateTableLocalityConfig()
pkg/sql/catalog/tabledesc/validate.go:192: ValidateForwardReferences()
pkg/sql/catalog/internal/validate/validate.go:98: func2()
pkg/sql/catalog/internal/validate/validate.go:197: validateDescriptorsAtLevel()
pkg/sql/catalog/internal/validate/validate.go:93: Validate()
pkg/sql/catalog/descs/validate.go:35: Validate()
pkg/sql/planner.go:841: validateDescriptor()
pkg/sql/create_view.go:373: 1()
pkg/sql/create_view.go:405: func1()
pkg/sql/schema_resolver.go:439: runWithOptions()
pkg/sql/create_view.go:203: startExec()
pkg/sql/plan.go:583: startExec()
pkg/sql/plan_node_to_row_source.go:181: Start()
pkg/sql/colexec/columnarizer.go:178: Init()
pkg/sql/colflow/stats.go:96: init()
pkg/sql/colexecerror/error.go:162: CatchVectorizedRuntimeError()
pkg/sql/colflow/stats.go:105: Init()
pkg/sql/colflow/flow_coordinator.go:236: func2()
pkg/sql/colexecerror/error.go:162: CatchVectorizedRuntimeError()
pkg/sql/colflow/flow_coordinator.go:235: init()
pkg/sql/colflow/flow_coordinator.go:269: Run()
pkg/sql/colflow/vectorized_flow.go:316: Run()
pkg/sql/distsql_running.go:1003: Run()
pkg/sql/distsql_running.go:2106: PlanAndRun()
pkg/sql/distsql_running.go:1810: func3()
pkg/sql/distsql_running.go:1813: PlanAndRunAll()
pkg/sql/conn_executor_exec.go:3370: execWithDistSQLEngine()
pkg/sql/conn_executor_exec.go:2911: dispatchToExecutionEngine()
pkg/sql/conn_executor_exec.go:1071: execStmtInOpenState()
pkg/sql/conn_executor_exec.go:173: func2()
pkg/sql/conn_executor_exec.go:4400: execWithProfiling()
pkg/sql/conn_executor_exec.go:172: execStmt()

This assertion may be overly aggressive. In general it seems fine for any table to reference the region enum if a user specified a column that way.

[spilchen]

The GLOBAL TABLE error message is specific to MQTs. Here is a repro:

-- cockroach demo --nodes=6 --demo-locality=region=us-east1,zone=us-east1-a:region=us-east1,zone=us-east1-b:region=us-central1,zone=us-central1-a:region=us-central1,zone=us-central1-b:region=us-west1,zone=us-west1-a:region=us-west1,zone=us-west1-b --no-example-database -f 

CREATE DATABASE bank PRIMARY REGION "us-east1" REGIONS "us-east1", "us-central1", "us-west1" SURVIVE REGION FAILURE;
USE bank;
CREATE TABLE t1 (c1 INT) LOCALITY REGIONAL BY ROW;
CREATE MATERIALIZED VIEW mv1 AS SELECT c1, CASE WHEN crdb_region = 'us-east1' THEN 'east' ELSE 'other' END AS region_type FROM t1;