Sentry: datum.go:5364: comparison of two different versions of enum USER DEFINED ENUM: × oid 100219: versions 3 and 7 (1) assertion failure Wraps: (2) attached stack trace -- stack trace: | githu...

[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/6323243766/?referrer=webhooks_plugin

Panic Message:

datum.go:5364: comparison of two different versions of enum USER DEFINED ENUM: × oid 100219: versions 3 and 7
(1) assertion failure
Wraps: (2) attached stack trace
  -- stack trace:
  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*DEnum).Compare
  | 	pkg/sql/sem/tree/datum.go:5364
  | github.com/cockroachdb/cockroach/pkg/sql/opt/constraint.(*KeyContext).Compare
  | 	pkg/sql/opt/constraint/key.go:329
  | github.com/cockroachdb/cockroach/pkg/sql/opt/constraint.Key.Compare
  | 	pkg/sql/opt/constraint/key.go:113
  | github.com/cockroachdb/cockroach/pkg/sql/opt/constraint.(*Span).StartsAfter
  | 	pkg/sql/opt/constraint/span.go:217
  | github.com/cockroachdb/cockroach/pkg/sql/opt/constraint.(*Constraint).IntersectWith
  | 	pkg/sql/opt/constraint/constraint.go:197
  | github.com/cockroachdb/cockroach/pkg/sql/opt/idxconstraint.(*indexConstraintCtx).makeSpansForAnd
  | 	pkg/sql/opt/idxconstraint/index_constraints.go:800
  | github.com/cockroachdb/cockroach/pkg/sql/opt/idxconstraint.(*indexConstraintCtx).makeSpansForExpr
  | 	pkg/sql/opt/idxconstraint/index_constraints.go:675
  | github.com/cockroachdb/cockroach/pkg/sql/opt/idxconstraint.(*Instance).Init
  | 	pkg/sql/opt/idxconstraint/index_constraints.go:1131
  | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*CustomFuncs).initIdxConstraintForIndex
  | 	pkg/sql/opt/xform/general_funcs.go:197
  | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*CustomFuncs).tryConstrainIndex
  | 	pkg/sql/opt/xform/select_funcs.go:1194
  | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*CustomFuncs).MakeCombinedFiltersConstraint
  | 	pkg/sql/opt/xform/select_funcs.go:295
  | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*CustomFuncs).GenerateConstrainedScans.func1
  | 	pkg/sql/opt/xform/select_funcs.go:447
  | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*scanIndexIter).ForEachStartingAfter
  | 	pkg/sql/opt/xform/scan_index_iter.go:299
  | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*scanIndexIter).ForEach
  | 	pkg/sql/opt/xform/scan_index_iter.go:202
  | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*CustomFuncs).GenerateConstrainedScans
  | 	pkg/sql/opt/xform/select_funcs.go:439
  | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*explorer).exploreSelect
  | 	bazel-out/k8-opt/bin/pkg/sql/opt/xform/explorer.og.go:363
  | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*explorer).exploreGroupMember
  | 	bazel-out/k8-opt/bin/pkg/sql/opt/xform/explorer.og.go:26
  | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*explorer).exploreGroup
  | 	pkg/sql/opt/xform/explorer.go:180
  | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup
  | 	pkg/sql/opt/xform/optimizer.go:559
  | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeExpr
  | 	pkg/sql/opt/xform/optimizer.go:296
  | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember
  | 	pkg/sql/opt/xform/optimizer.go:604
  | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).optimizeGroup
  | 	pkg/sql/opt/xform/optimizer.go:546
  | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).Optimize
  | 	pkg/sql/opt/xform/optimizer.go:266
  | github.com/cockroachdb/cockroach/pkg/sql.(*optPlanningCtx).reuseMemo
  | 	pkg/sql/plan_opt.go:564
  | github.com/cockroachdb/cockroach/pkg/sql.(*optPlanningCtx).fetchPreparedMemo
  | 	pkg/sql/plan_opt.go:765
  | github.com/cockroachdb/cockroach/pkg/sql.(*optPlanningCtx).buildExecMemo
  | 	pkg/sql/plan_opt.go:783
  | github.com/cockroachdb/cockroach/pkg/sql.(*planner).makeOptimizerPlan
  | 	pkg/sql/plan_opt.go:260
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).makeExecPlan
  | 	pkg/sql/conn_executor_exec.go:2310
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).dispatchToExecutionEngine
  | 	pkg/sql/conn_executor_exec.go:1859
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmtInOpenState
  | 	pkg/sql/conn_executor_exec.go:1192
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt.func1
  | 	pkg/sql/conn_executor_exec.go:141
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execWithProfiling
  | 	pkg/sql/conn_executor_exec.go:3456
Wraps: (3) comparison of two different versions of enum USER DEFINED ENUM: × oid 100219: versions 3 and 7
Error types: (1) *assert.withAssertionFailure (2) *withstack.withStack (3) *errutil.leafError
-- report composition:
*errutil.leafError: comparison of two different versions of enum USER DEFINED ENUM: × oid 100219: versions 3 and 7
datum.go:5364: *withstack.withStack (top exception)
*assert.withAssertionFailure

Stacktrace (expand for inline code snippets):

pkg/sql/conn_executor_exec.go#L3455-L3457
pkg/sql/conn_executor_exec.go#L140-L142
pkg/sql/conn_executor_exec.go#L1191-L1193
pkg/sql/conn_executor_exec.go#L1858-L1860
pkg/sql/conn_executor_exec.go#L2309-L2311
pkg/sql/plan_opt.go#L259-L261
pkg/sql/plan_opt.go#L782-L784
pkg/sql/plan_opt.go#L764-L766
pkg/sql/plan_opt.go#L563-L565
pkg/sql/opt/xform/optimizer.go#L265-L267
pkg/sql/opt/xform/optimizer.go#L545-L547
pkg/sql/opt/xform/optimizer.go#L603-L605
pkg/sql/opt/xform/optimizer.go#L295-L297
pkg/sql/opt/xform/optimizer.go#L558-L560
pkg/sql/opt/xform/explorer.go#L179-L181
bazel-out/k8-opt/bin/pkg/sql/opt/xform/explorer.og.go#L25-L27
bazel-out/k8-opt/bin/pkg/sql/opt/xform/explorer.og.go#L362-L364
pkg/sql/opt/xform/select_funcs.go#L438-L440
pkg/sql/opt/xform/scan_index_iter.go#L201-L203
pkg/sql/opt/xform/scan_index_iter.go#L298-L300
pkg/sql/opt/xform/select_funcs.go#L446-L448
pkg/sql/opt/xform/select_funcs.go#L294-L296
pkg/sql/opt/xform/select_funcs.go#L1193-L1195
pkg/sql/opt/xform/general_funcs.go#L196-L198
pkg/sql/opt/idxconstraint/index_constraints.go#L1130-L1132
pkg/sql/opt/idxconstraint/index_constraints.go#L674-L676
pkg/sql/opt/idxconstraint/index_constraints.go#L799-L801
pkg/sql/opt/constraint/constraint.go#L196-L198
pkg/sql/opt/constraint/span.go#L216-L218
pkg/sql/opt/constraint/key.go#L112-L114
pkg/sql/opt/constraint/key.go#L328-L330
pkg/sql/sem/tree/datum.go#L5363-L5365

pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execWithProfiling at line 3456
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmt.func1 at line 141
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmtInOpenState at line 1192
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).dispatchToExecutionEngine at line 1859
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).makeExecPlan at line 2310
pkg/sql/plan_opt.go in pkg/sql.(*planner).makeOptimizerPlan at line 260
pkg/sql/plan_opt.go in pkg/sql.(*optPlanningCtx).buildExecMemo at line 783
pkg/sql/plan_opt.go in pkg/sql.(*optPlanningCtx).fetchPreparedMemo at line 765
pkg/sql/plan_opt.go in pkg/sql.(*optPlanningCtx).reuseMemo at line 564
pkg/sql/opt/xform/optimizer.go in pkg/sql/opt/xform.(*Optimizer).Optimize at line 266
pkg/sql/opt/xform/optimizer.go in pkg/sql/opt/xform.(*Optimizer).optimizeGroup at line 546
pkg/sql/opt/xform/optimizer.go in pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember at line 604
pkg/sql/opt/xform/optimizer.go in pkg/sql/opt/xform.(*Optimizer).optimizeExpr at line 296
pkg/sql/opt/xform/optimizer.go in pkg/sql/opt/xform.(*Optimizer).optimizeGroup at line 559
pkg/sql/opt/xform/explorer.go in pkg/sql/opt/xform.(*explorer).exploreGroup at line 180
bazel-out/k8-opt/bin/pkg/sql/opt/xform/explorer.og.go in pkg/sql/opt/xform.(*explorer).exploreGroupMember at line 26
bazel-out/k8-opt/bin/pkg/sql/opt/xform/explorer.og.go in pkg/sql/opt/xform.(*explorer).exploreSelect at line 363
pkg/sql/opt/xform/select_funcs.go in pkg/sql/opt/xform.(*CustomFuncs).GenerateConstrainedScans at line 439
pkg/sql/opt/xform/scan_index_iter.go in pkg/sql/opt/xform.(*scanIndexIter).ForEach at line 202
pkg/sql/opt/xform/scan_index_iter.go in pkg/sql/opt/xform.(*scanIndexIter).ForEachStartingAfter at line 299
pkg/sql/opt/xform/select_funcs.go in pkg/sql/opt/xform.(*CustomFuncs).GenerateConstrainedScans.func1 at line 447
pkg/sql/opt/xform/select_funcs.go in pkg/sql/opt/xform.(*CustomFuncs).MakeCombinedFiltersConstraint at line 295
pkg/sql/opt/xform/select_funcs.go in pkg/sql/opt/xform.(*CustomFuncs).tryConstrainIndex at line 1194
pkg/sql/opt/xform/general_funcs.go in pkg/sql/opt/xform.(*CustomFuncs).initIdxConstraintForIndex at line 197
pkg/sql/opt/idxconstraint/index_constraints.go in pkg/sql/opt/idxconstraint.(*Instance).Init at line 1131
pkg/sql/opt/idxconstraint/index_constraints.go in pkg/sql/opt/idxconstraint.(*indexConstraintCtx).makeSpansForExpr at line 675
pkg/sql/opt/idxconstraint/index_constraints.go in pkg/sql/opt/idxconstraint.(*indexConstraintCtx).makeSpansForAnd at line 800
pkg/sql/opt/constraint/constraint.go in pkg/sql/opt/constraint.(*Constraint).IntersectWith at line 197
pkg/sql/opt/constraint/span.go in pkg/sql/opt/constraint.(*Span).StartsAfter at line 217
pkg/sql/opt/constraint/key.go in pkg/sql/opt/constraint.Key.Compare at line 113
pkg/sql/opt/constraint/key.go in pkg/sql/opt/constraint.(*KeyContext).Compare at line 329
pkg/sql/sem/tree/datum.go in pkg/sql/sem/tree.(*DEnum).Compare at line 5364

Tags

Tag	Value
Command	server
Environment	v24.3.6
Go Version	go1.22.8 X:nocoverageredesign
Platform	linux amd64
Distribution	CCL
Cockroach Release	v24.3.6
Cockroach SHA	5df3704
# of CPUs	4
# of Goroutines	580

Jira issue: CRDB-48052

[blathers-crl]

CC'ing via the CODEOWNERS-based sentry heuristic:

• @cockroachdb/sql-foundations

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