Sentry: partial_index.go:209: unexpected error during partial index predicate type resolution: column × does not exist (1) assertion failure Wraps: (2) attached stack trace -- stack trace: | gith...

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

Panic Message:

partial_index.go:209: unexpected error during partial index predicate type resolution: column × does not exist
(1) assertion failure
Wraps: (2) attached stack trace
  -- stack trace:
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.resolvePartialIndexPredicate.func1
  | 	pkg/sql/opt/optbuilder/partial_index.go:209
  | runtime.gopanic
  | 	GOROOT/src/runtime/panic.go:791
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.wrapColTupleStarPanic
  | 	pkg/sql/opt/optbuilder/scope.go:1765
  | runtime.gopanic
  | 	GOROOT/src/runtime/panic.go:791
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).expandStar
  | 	pkg/sql/opt/optbuilder/util.go:120
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*scope).VisitPre
  | 	pkg/sql/opt/optbuilder/scope.go:1051
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*scope).VisitPre
  | 	pkg/sql/opt/optbuilder/scope.go:1063
  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.WalkExpr
  | 	pkg/sql/sem/tree/walk.go:835
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*scope).walkExprTree
  | 	pkg/sql/opt/optbuilder/scope.go:431
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*scope).resolveType
  | 	pkg/sql/opt/optbuilder/scope.go:470
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).expandStar
  | 	pkg/sql/opt/optbuilder/util.go:62
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*scope).VisitPre
  | 	pkg/sql/opt/optbuilder/scope.go:1051
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*scope).VisitPre.func1
  | 	pkg/sql/opt/optbuilder/scope.go:1079
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*scope).VisitPre
  | 	pkg/sql/opt/optbuilder/scope.go:1080
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*scope).VisitPre
  | 	pkg/sql/opt/optbuilder/scope.go:1063
  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.WalkExpr
  | 	pkg/sql/sem/tree/walk.go:835
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*scope).walkExprTree
  | 	pkg/sql/opt/optbuilder/scope.go:431
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*scope).resolveAndRequireType
  | 	pkg/sql/opt/optbuilder/scope.go:489
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.resolvePartialIndexPredicate
  | 	pkg/sql/opt/optbuilder/partial_index.go:212
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildPartialIndexPredicate
  | 	pkg/sql/opt/optbuilder/partial_index.go:123
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*arbiterPredicateHelper).arbiterFilters
  | 	pkg/sql/opt/optbuilder/mutation_builder_arbiter.go:740
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*arbiterPredicateHelper).predicateIsImpliedByArbiterPredicate
  | 	pkg/sql/opt/optbuilder/mutation_builder_arbiter.go:763
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*mutationBuilder).inferArbitersFromConflictOrds
  | 	pkg/sql/opt/optbuilder/mutation_builder_arbiter.go:209
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*mutationBuilder).findArbiters
  | 	pkg/sql/opt/optbuilder/mutation_builder_arbiter.go:107
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*mutationBuilder).buildInputForUpsert
  | 	pkg/sql/opt/optbuilder/insert.go:874
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildInsert
  | 	pkg/sql/opt/optbuilder/insert.go:376
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildStmt.func2
  | 	pkg/sql/opt/optbuilder/builder.go:395
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).processWiths
  | 	pkg/sql/opt/optbuilder/with.go:110
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildStmt
  | 	pkg/sql/opt/optbuilder/builder.go:394
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildStmtAtRootWithScope
  | 	pkg/sql/opt/optbuilder/builder.go:321
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildStmtAtRoot
  | 	pkg/sql/opt/optbuilder/builder.go:302
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).Build
  | 	pkg/sql/opt/optbuilder/builder.go:281
Wraps: (3) secondary error attachment
  | column × does not exist
  | (1) candidate pg code: 42703
  | Wraps: (2) attached stack trace
  |   -- stack trace:
  |   | github.com/cockroachdb/cockroach/pkg/sql/catalog/colinfo.NewUndefinedColumnError
  |   | 	pkg/sql/catalog/colinfo/column_resolver.go:191
  |   | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*scope).FindSourceProvidingColumn
  |   | 	pkg/sql/opt/optbuilder/scope.go:887
  |   | github.com/cockroachdb/cockroach/pkg/sql/catalog/colinfo.ResolveColumnItem
  |   | 	pkg/sql/catalog/colinfo/column_item_resolver.go:110
  |   | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*scope).VisitPre
  |   | 	pkg/sql/opt/optbuilder/scope.go:1066
  |   | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*scope).VisitPre
  |   | 	pkg/sql/opt/optbuilder/scope.go:1063
  |   | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.WalkExpr
  |   | 	pkg/sql/sem/tree/walk.go:835
  |   | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*scope).walkExprTree
  |   | 	pkg/sql/opt/optbuilder/scope.go:431
  |   | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*scope).resolveAndRequireType
  |   | 	pkg/sql/opt/optbuilder/scope.go:489
  |   | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.resolvePartialIndexPredicate
  |   | 	pkg/sql/opt/optbuilder/partial_index.go:212
  |   | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildPartialIndexPredicate
  |   | 	pkg/sql/opt/optbuilder/partial_index.go:123
  |   | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*arbiterPredicateHelper).arbiterFilters
  |   | 	pkg/sql/opt/optbuilder/mutation_builder_arbiter.go:740
  |   | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*arbiterPredicateHelper).predicateIsImpliedByArbiterPredicate
  |   | 	pkg/sql/opt/optbuilder/mutation_builder_arbiter.go:763
  |   | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*mutationBuilder).inferArbitersFromConflictOrds
  |   | 	pkg/sql/opt/optbuilder/mutation_builder_arbiter.go:209
  |   | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*mutationBuilder).findArbiters
  |   | 	pkg/sql/opt/optbuilder/mutation_builder_arbiter.go:107
  |   | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*mutationBuilder).buildInputForUpsert
  |   | 	pkg/sql/opt/optbuilder/insert.go:874
  |   | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildInsert
  |   | 	pkg/sql/opt/optbuilder/insert.go:376
  |   | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildStmt.func2
  |   | 	pkg/sql/opt/optbuilder/builder.go:395
  |   | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).processWiths
  |   | 	pkg/sql/opt/optbuilder/with.go:110
  |   | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildStmt
  |   | 	pkg/sql/opt/optbuilder/builder.go:394
  |   | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildStmtAtRootWithScope
  |   | 	pkg/sql/opt/optbuilder/builder.go:321
  |   | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildStmtAtRoot
  |   | 	pkg/sql/opt/optbuilder/builder.go:302
  |   | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).Build
  |   | 	pkg/sql/opt/optbuilder/builder.go:281
  |   | github.com/cockroachdb/cockroach/pkg/sql.(*optPlanningCtx).buildReusableMemo
  |   | 	pkg/sql/plan_opt.go:494
  |   | github.com/cockroachdb/cockroach/pkg/sql.(*planner).prepareUsingOptimizer
  |   | 	pkg/sql/plan_opt.go:173
  |   | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).populatePrepared
  |   | 	pkg/sql/conn_executor_prepare.go:339
  |   | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).prepare.func2
  |   | 	pkg/sql/conn_executor_prepare.go:279
  |   | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).prepare
  |   | 	pkg/sql/conn_executor_prepare.go:284
  |   | github.com/cockroachdb/cockroach/pkg/sql.(*connE...

Stacktrace (expand for inline code snippets):

pkg/sql/opt/optbuilder/builder.go#L280-L282
pkg/sql/opt/optbuilder/builder.go#L301-L303
pkg/sql/opt/optbuilder/builder.go#L320-L322
pkg/sql/opt/optbuilder/builder.go#L393-L395
pkg/sql/opt/optbuilder/with.go#L109-L111
pkg/sql/opt/optbuilder/builder.go#L394-L396
pkg/sql/opt/optbuilder/insert.go#L375-L377
pkg/sql/opt/optbuilder/insert.go#L873-L875
pkg/sql/opt/optbuilder/mutation_builder_arbiter.go#L106-L108
pkg/sql/opt/optbuilder/mutation_builder_arbiter.go#L208-L210
pkg/sql/opt/optbuilder/mutation_builder_arbiter.go#L762-L764
pkg/sql/opt/optbuilder/mutation_builder_arbiter.go#L739-L741
pkg/sql/opt/optbuilder/partial_index.go#L122-L124
pkg/sql/opt/optbuilder/partial_index.go#L211-L213
pkg/sql/opt/optbuilder/scope.go#L488-L490
pkg/sql/opt/optbuilder/scope.go#L430-L432
pkg/sql/sem/tree/walk.go#L834-L836
pkg/sql/opt/optbuilder/scope.go#L1062-L1064
pkg/sql/opt/optbuilder/scope.go#L1079-L1081
pkg/sql/opt/optbuilder/scope.go#L1078-L1080
pkg/sql/opt/optbuilder/scope.go#L1050-L1052
pkg/sql/opt/optbuilder/util.go#L61-L63
pkg/sql/opt/optbuilder/scope.go#L469-L471
pkg/sql/opt/optbuilder/scope.go#L430-L432
pkg/sql/sem/tree/walk.go#L834-L836
pkg/sql/opt/optbuilder/scope.go#L1062-L1064
pkg/sql/opt/optbuilder/scope.go#L1050-L1052
pkg/sql/opt/optbuilder/util.go#L119-L121
GOROOT/src/runtime/panic.go#L790-L792
pkg/sql/opt/optbuilder/scope.go#L1764-L1766
GOROOT/src/runtime/panic.go#L790-L792
pkg/sql/opt/optbuilder/partial_index.go#L208-L210

pkg/sql/opt/optbuilder/builder.go in pkg/sql/opt/optbuilder.(*Builder).Build at line 281
pkg/sql/opt/optbuilder/builder.go in pkg/sql/opt/optbuilder.(*Builder).buildStmtAtRoot at line 302
pkg/sql/opt/optbuilder/builder.go in pkg/sql/opt/optbuilder.(*Builder).buildStmtAtRootWithScope at line 321
pkg/sql/opt/optbuilder/builder.go in pkg/sql/opt/optbuilder.(*Builder).buildStmt at line 394
pkg/sql/opt/optbuilder/with.go in pkg/sql/opt/optbuilder.(*Builder).processWiths at line 110
pkg/sql/opt/optbuilder/builder.go in pkg/sql/opt/optbuilder.(*Builder).buildStmt.func2 at line 395
pkg/sql/opt/optbuilder/insert.go in pkg/sql/opt/optbuilder.(*Builder).buildInsert at line 376
pkg/sql/opt/optbuilder/insert.go in pkg/sql/opt/optbuilder.(*mutationBuilder).buildInputForUpsert at line 874
pkg/sql/opt/optbuilder/mutation_builder_arbiter.go in pkg/sql/opt/optbuilder.(*mutationBuilder).findArbiters at line 107
pkg/sql/opt/optbuilder/mutation_builder_arbiter.go in pkg/sql/opt/optbuilder.(*mutationBuilder).inferArbitersFromConflictOrds at line 209
pkg/sql/opt/optbuilder/mutation_builder_arbiter.go in pkg/sql/opt/optbuilder.(*arbiterPredicateHelper).predicateIsImpliedByArbiterPredicate at line 763
pkg/sql/opt/optbuilder/mutation_builder_arbiter.go in pkg/sql/opt/optbuilder.(*arbiterPredicateHelper).arbiterFilters at line 740
pkg/sql/opt/optbuilder/partial_index.go in pkg/sql/opt/optbuilder.(*Builder).buildPartialIndexPredicate at line 123
pkg/sql/opt/optbuilder/partial_index.go in pkg/sql/opt/optbuilder.resolvePartialIndexPredicate at line 212
pkg/sql/opt/optbuilder/scope.go in pkg/sql/opt/optbuilder.(*scope).resolveAndRequireType at line 489
pkg/sql/opt/optbuilder/scope.go in pkg/sql/opt/optbuilder.(*scope).walkExprTree at line 431
pkg/sql/sem/tree/walk.go in pkg/sql/sem/tree.WalkExpr at line 835
pkg/sql/opt/optbuilder/scope.go in pkg/sql/opt/optbuilder.(*scope).VisitPre at line 1063
pkg/sql/opt/optbuilder/scope.go in pkg/sql/opt/optbuilder.(*scope).VisitPre at line 1080
pkg/sql/opt/optbuilder/scope.go in pkg/sql/opt/optbuilder.(*scope).VisitPre.func1 at line 1079
pkg/sql/opt/optbuilder/scope.go in pkg/sql/opt/optbuilder.(*scope).VisitPre at line 1051
pkg/sql/opt/optbuilder/util.go in pkg/sql/opt/optbuilder.(*Builder).expandStar at line 62
pkg/sql/opt/optbuilder/scope.go in pkg/sql/opt/optbuilder.(*scope).resolveType at line 470
pkg/sql/opt/optbuilder/scope.go in pkg/sql/opt/optbuilder.(*scope).walkExprTree at line 431
pkg/sql/sem/tree/walk.go in pkg/sql/sem/tree.WalkExpr at line 835
pkg/sql/opt/optbuilder/scope.go in pkg/sql/opt/optbuilder.(*scope).VisitPre at line 1063
pkg/sql/opt/optbuilder/scope.go in pkg/sql/opt/optbuilder.(*scope).VisitPre at line 1051
pkg/sql/opt/optbuilder/util.go in pkg/sql/opt/optbuilder.(*Builder).expandStar at line 120
GOROOT/src/runtime/panic.go in runtime.gopanic at line 791
pkg/sql/opt/optbuilder/scope.go in pkg/sql/opt/optbuilder.wrapColTupleStarPanic at line 1765
GOROOT/src/runtime/panic.go in runtime.gopanic at line 791
pkg/sql/opt/optbuilder/partial_index.go in pkg/sql/opt/optbuilder.resolvePartialIndexPredicate.func1 at line 209

Tags

Tag	Value
Command	mt start-sql
Environment	v25.2.6
Go Version	go1.23.12 X:nocoverageredesign
Platform	linux amd64
Distribution	CCL
Cockroach Release	v25.2.6
Cockroach SHA	e9b11cf
# of CPUs	16
# of Goroutines	278

Jira issue: CRDB-55866

[blathers-crl]

CC'ing via the CODEOWNERS-based sentry heuristic:

• @cockroachdb/sql-queries

Sentry issue cause: pkg/sql/opt/optbuilder/util.go

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