Sentry: datum.go:5323: comparison of two different versions of enum USER DEFINED ENUM: × oid 105165: versions 11 and 10, gist "" (1) assertion failure Wraps: (2) attached stack trace -- stack trace...

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

Panic Message:

datum.go:5323: comparison of two different versions of enum USER DEFINED ENUM: × oid 105165: versions 11 and 10, gist ""
(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:5323
  | 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/props.(*Histogram).filter
  | 	pkg/sql/opt/props/histogram.go:428
  | github.com/cockroachdb/cockroach/pkg/sql/opt/props.(*Histogram).Filter
  | 	pkg/sql/opt/props/histogram.go:591
  | github.com/cockroachdb/cockroach/pkg/sql/opt/memo.(*statisticsBuilder).updateHistogram
  | 	pkg/sql/opt/memo/statistics_builder.go:4065
  | github.com/cockroachdb/cockroach/pkg/sql/opt/memo.(*statisticsBuilder).applyConstraintSet
  | 	pkg/sql/opt/memo/statistics_builder.go:3880
  | github.com/cockroachdb/cockroach/pkg/sql/opt/memo.(*statisticsBuilder).applyFiltersItem
  | 	pkg/sql/opt/memo/statistics_builder.go:3613
  | github.com/cockroachdb/cockroach/pkg/sql/opt/memo.(*statisticsBuilder).applyFilters
  | 	pkg/sql/opt/memo/statistics_builder.go:3496
  | github.com/cockroachdb/cockroach/pkg/sql/opt/memo.(*statisticsBuilder).filterRelExpr
  | 	pkg/sql/opt/memo/statistics_builder.go:3445
  | github.com/cockroachdb/cockroach/pkg/sql/opt/memo.(*statisticsBuilder).buildSelect
  | 	pkg/sql/opt/memo/statistics_builder.go:1146
  | github.com/cockroachdb/cockroach/pkg/sql/opt/memo.(*logicalPropsBuilder).buildSelectProps
  | 	pkg/sql/opt/memo/logical_props_builder.go:315
  | github.com/cockroachdb/cockroach/pkg/sql/opt/memo.(*Memo).MemoizeSelect
  | 	bazel-out/k8-opt/bin/pkg/sql/opt/memo/expr.og.go:20624
  | github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructSelect
  | 	bazel-out/k8-opt/bin/pkg/sql/opt/norm/factory.og.go:1762
  | github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).CopyAndReplaceDefault
  | 	bazel-out/k8-opt/bin/pkg/sql/opt/norm/factory.og.go:25882
  | github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).AssignPlaceholders.func2
  | 	pkg/sql/opt/norm/factory.go:421
  | github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).invokeReplace
  | 	bazel-out/k8-opt/bin/pkg/sql/opt/norm/factory.og.go:27312
  | github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).CopyAndReplaceDefault
  | 	bazel-out/k8-opt/bin/pkg/sql/opt/norm/factory.og.go:25889
  | github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).AssignPlaceholders.func2
  | 	pkg/sql/opt/norm/factory.go:421
  | github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).invokeReplace
  | 	bazel-out/k8-opt/bin/pkg/sql/opt/norm/factory.og.go:27312
  | github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).CopyAndReplace
  | 	pkg/sql/opt/norm/factory.go:306
  | github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).AssignPlaceholders
  | 	pkg/sql/opt/norm/factory.go:423
  | github.com/cockroachdb/cockroach/pkg/sql.(*optPlanningCtx).reuseMemo
  | 	pkg/sql/plan_opt.go:593
  | github.com/cockroachdb/cockroach/pkg/sql.(*optPlanningCtx).fetchPreparedMemo
  | 	pkg/sql/plan_opt.go:806
  | github.com/cockroachdb/cockroach/pkg/sql.(*optPlanningCtx).buildExecMemo
  | 	pkg/sql/plan_opt.go:824
  | github.com/cockroachdb/cockroach/pkg/sql.(*planner).makeOptimizerPlan
  | 	pkg/sql/plan_opt.go:261
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).makeExecPlan
  | 	pkg/sql/conn_executor_exec.go:3205
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).dispatchToExecutionEngine
  | 	pkg/sql/conn_executor_exec.go:2785
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmtInOpenState
  | 	pkg/sql/conn_executor_exec.go:1067
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt.func2
  | 	pkg/sql/conn_executor_exec.go:175
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execWithProfiling
  | 	pkg/sql/conn_executor_exec.go:4415
Wraps: (3) comparison of two different versions of enum USER DEFINED ENUM: × oid 105165: versions 11 and 10, gist ""
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 105165: versions 11 and 10, gist ""
datum.go:5323: *withstack.withStack (top exception)
*assert.withAssertionFailure

Stacktrace (expand for inline code snippets):

pkg/sql/conn_executor_exec.go#L4414-L4416
pkg/sql/conn_executor_exec.go#L174-L176
pkg/sql/conn_executor_exec.go#L1066-L1068
pkg/sql/conn_executor_exec.go#L2784-L2786
pkg/sql/conn_executor_exec.go#L3204-L3206
pkg/sql/plan_opt.go#L260-L262
pkg/sql/plan_opt.go#L823-L825
pkg/sql/plan_opt.go#L805-L807
pkg/sql/plan_opt.go#L592-L594
pkg/sql/opt/norm/factory.go#L422-L424
pkg/sql/opt/norm/factory.go#L305-L307
bazel-out/k8-opt/bin/pkg/sql/opt/norm/factory.og.go#L27311-L27313
pkg/sql/opt/norm/factory.go#L420-L422
bazel-out/k8-opt/bin/pkg/sql/opt/norm/factory.og.go#L25888-L25890
bazel-out/k8-opt/bin/pkg/sql/opt/norm/factory.og.go#L27311-L27313
pkg/sql/opt/norm/factory.go#L420-L422
bazel-out/k8-opt/bin/pkg/sql/opt/norm/factory.og.go#L25881-L25883
bazel-out/k8-opt/bin/pkg/sql/opt/norm/factory.og.go#L1761-L1763
bazel-out/k8-opt/bin/pkg/sql/opt/memo/expr.og.go#L20623-L20625
pkg/sql/opt/memo/logical_props_builder.go#L314-L316
pkg/sql/opt/memo/statistics_builder.go#L1145-L1147
pkg/sql/opt/memo/statistics_builder.go#L3444-L3446
pkg/sql/opt/memo/statistics_builder.go#L3495-L3497
pkg/sql/opt/memo/statistics_builder.go#L3612-L3614
pkg/sql/opt/memo/statistics_builder.go#L3879-L3881
pkg/sql/opt/memo/statistics_builder.go#L4064-L4066
pkg/sql/opt/props/histogram.go#L590-L592
pkg/sql/opt/props/histogram.go#L427-L429
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#L5322-L5324

pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execWithProfiling at line 4415
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmt.func2 at line 175
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmtInOpenState at line 1067
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).dispatchToExecutionEngine at line 2785
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).makeExecPlan at line 3205
pkg/sql/plan_opt.go in pkg/sql.(*planner).makeOptimizerPlan at line 261
pkg/sql/plan_opt.go in pkg/sql.(*optPlanningCtx).buildExecMemo at line 824
pkg/sql/plan_opt.go in pkg/sql.(*optPlanningCtx).fetchPreparedMemo at line 806
pkg/sql/plan_opt.go in pkg/sql.(*optPlanningCtx).reuseMemo at line 593
pkg/sql/opt/norm/factory.go in pkg/sql/opt/norm.(*Factory).AssignPlaceholders at line 423
pkg/sql/opt/norm/factory.go in pkg/sql/opt/norm.(*Factory).CopyAndReplace at line 306
bazel-out/k8-opt/bin/pkg/sql/opt/norm/factory.og.go in pkg/sql/opt/norm.(*Factory).invokeReplace at line 27312
pkg/sql/opt/norm/factory.go in pkg/sql/opt/norm.(*Factory).AssignPlaceholders.func2 at line 421
bazel-out/k8-opt/bin/pkg/sql/opt/norm/factory.og.go in pkg/sql/opt/norm.(*Factory).CopyAndReplaceDefault at line 25889
bazel-out/k8-opt/bin/pkg/sql/opt/norm/factory.og.go in pkg/sql/opt/norm.(*Factory).invokeReplace at line 27312
pkg/sql/opt/norm/factory.go in pkg/sql/opt/norm.(*Factory).AssignPlaceholders.func2 at line 421
bazel-out/k8-opt/bin/pkg/sql/opt/norm/factory.og.go in pkg/sql/opt/norm.(*Factory).CopyAndReplaceDefault at line 25882
bazel-out/k8-opt/bin/pkg/sql/opt/norm/factory.og.go in pkg/sql/opt/norm.(*Factory).ConstructSelect at line 1762
bazel-out/k8-opt/bin/pkg/sql/opt/memo/expr.og.go in pkg/sql/opt/memo.(*Memo).MemoizeSelect at line 20624
pkg/sql/opt/memo/logical_props_builder.go in pkg/sql/opt/memo.(*logicalPropsBuilder).buildSelectProps at line 315
pkg/sql/opt/memo/statistics_builder.go in pkg/sql/opt/memo.(*statisticsBuilder).buildSelect at line 1146
pkg/sql/opt/memo/statistics_builder.go in pkg/sql/opt/memo.(*statisticsBuilder).filterRelExpr at line 3445
pkg/sql/opt/memo/statistics_builder.go in pkg/sql/opt/memo.(*statisticsBuilder).applyFilters at line 3496
pkg/sql/opt/memo/statistics_builder.go in pkg/sql/opt/memo.(*statisticsBuilder).applyFiltersItem at line 3613
pkg/sql/opt/memo/statistics_builder.go in pkg/sql/opt/memo.(*statisticsBuilder).applyConstraintSet at line 3880
pkg/sql/opt/memo/statistics_builder.go in pkg/sql/opt/memo.(*statisticsBuilder).updateHistogram at line 4065
pkg/sql/opt/props/histogram.go in pkg/sql/opt/props.(*Histogram).Filter at line 591
pkg/sql/opt/props/histogram.go in pkg/sql/opt/props.(*Histogram).filter at line 428
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 5323

Tags

Tag	Value
Command	mt start-sql
Environment	v25.4.1
Go Version	go1.23.12 X:nocoverageredesign
Platform	linux amd64
Distribution	CCL
Cockroach Release	v25.4.1
Cockroach SHA	60d802b
# of CPUs	32
# of Goroutines	386

Jira issue: CRDB-57838

[blathers-crl]

CC'ing via the CODEOWNERS-based sentry heuristic:

• @cockroachdb/sql-foundations

Sentry issue cause: pkg/sql/sem/tree/datum.go

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