Sentry: catch.go:24: interface conversion: tree.TypeList is nil, not tree.ParamTypes (1) assertion failure Wraps: (2) attached stack trace -- stack trace: | github.com/cockroachdb/cockroach/pkg/ut...

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

Panic Message:

catch.go:24: interface conversion: tree.TypeList is nil, not tree.ParamTypes
(1) assertion failure
Wraps: (2) attached stack trace
  -- stack trace:
  | github.com/cockroachdb/cockroach/pkg/util/errorutil.ShouldCatch
  | 	pkg/util/errorutil/catch.go:24
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).Build.func1
  | 	pkg/sql/opt/optbuilder/builder.go:241
  | runtime.gopanic
  | 	GOROOT/src/runtime/panic.go:770
  | runtime.panicdottypeE
  | 	GOROOT/src/runtime/iface.go:262
  | runtime.panicdottypeI
  | 	GOROOT/src/runtime/iface.go:272
  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs.func6
  | 	pkg/sql/sem/tree/overload.go:1082
  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.filterOverloads
  | 	pkg/sql/sem/tree/overload.go:1626
  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs
  | 	pkg/sql/sem/tree/overload.go:1073
  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*FuncExpr).TypeCheck.func2
  | 	pkg/sql/sem/tree/type_check.go:1235
  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*FuncExpr).typeCheckWithFuncAncestor
  | 	pkg/sql/sem/tree/type_check.go:1174
  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*FuncExpr).TypeCheck
  | 	pkg/sql/sem/tree/type_check.go:1234
  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.TypeCheck
  | 	pkg/sql/sem/tree/type_check.go:355
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*scope).resolveType
  | 	pkg/sql/opt/optbuilder/scope.go:471
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*scope).resolveTypeAndReject
  | 	pkg/sql/opt/optbuilder/scope.go:505
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).resolveProcedureDefinition
  | 	pkg/sql/opt/optbuilder/routine.go:152
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildProcedure
  | 	pkg/sql/opt/optbuilder/routine.go:120
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildStmt
  | 	pkg/sql/opt/optbuilder/builder.go:410
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildStmtAtRootWithScope
  | 	pkg/sql/opt/optbuilder/builder.go:315
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildStmtAtRoot
  | 	pkg/sql/opt/optbuilder/builder.go:296
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).Build
  | 	pkg/sql/opt/optbuilder/builder.go:275
  | github.com/cockroachdb/cockroach/pkg/sql.(*optPlanningCtx).buildExecMemo
  | 	pkg/sql/plan_opt.go:839
  | 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:1869
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmtInOpenState
  | 	pkg/sql/conn_executor_exec.go:1202
  | 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:3471
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt
  | 	pkg/sql/conn_executor_exec.go:140
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd.func1
  | 	pkg/sql/conn_executor.go:2343
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd
  | 	pkg/sql/conn_executor.go:2348
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).run
  | 	pkg/sql/conn_executor.go:2265
  | github.com/cockroachdb/cockroach/pkg/sql.(*Server).ServeConn
  | 	pkg/sql/conn_executor.go:965
Wraps: (3) interface conversion: tree.TypeList is nil, not tree.ParamTypes
  | -- cause hidden behind barrier
  | interface conversion: tree.TypeList is nil, not tree.ParamTypes
  | (1) interface conversion: tree.TypeList is nil, not tree.ParamTypes
  | Error types: (1) *runtime.TypeAssertionError
Error types: (1) *assert.withAssertionFailure (2) *withstack.withStack (3) *barriers.barrierErr
-- report composition:
*barriers.barrierErr: masked error: interface conversion: tree.TypeList is nil, not tree.ParamTypes
catch.go:24: *withstack.withStack (top exception)
*assert.withAssertionFailure

Stacktrace (expand for inline code snippets):

pkg/sql/conn_executor.go#L964-L966
pkg/sql/conn_executor.go#L2264-L2266
pkg/sql/conn_executor.go#L2347-L2349
pkg/sql/conn_executor.go#L2342-L2344
pkg/sql/conn_executor_exec.go#L139-L141
pkg/sql/conn_executor_exec.go#L3470-L3472
pkg/sql/conn_executor_exec.go#L140-L142
pkg/sql/conn_executor_exec.go#L1201-L1203
pkg/sql/conn_executor_exec.go#L1868-L1870
pkg/sql/conn_executor_exec.go#L2309-L2311
pkg/sql/plan_opt.go#L259-L261
pkg/sql/plan_opt.go#L838-L840
pkg/sql/opt/optbuilder/builder.go#L274-L276
pkg/sql/opt/optbuilder/builder.go#L295-L297
pkg/sql/opt/optbuilder/builder.go#L314-L316
pkg/sql/opt/optbuilder/builder.go#L409-L411
pkg/sql/opt/optbuilder/routine.go#L119-L121
pkg/sql/opt/optbuilder/routine.go#L151-L153
pkg/sql/opt/optbuilder/scope.go#L504-L506
pkg/sql/opt/optbuilder/scope.go#L470-L472
pkg/sql/sem/tree/type_check.go#L354-L356
pkg/sql/sem/tree/type_check.go#L1233-L1235
pkg/sql/sem/tree/type_check.go#L1173-L1175
pkg/sql/sem/tree/type_check.go#L1234-L1236
pkg/sql/sem/tree/overload.go#L1072-L1074
pkg/sql/sem/tree/overload.go#L1625-L1627
pkg/sql/sem/tree/overload.go#L1081-L1083
GOROOT/src/runtime/iface.go#L271-L273
GOROOT/src/runtime/iface.go#L261-L263
GOROOT/src/runtime/panic.go#L769-L771
pkg/sql/opt/optbuilder/builder.go#L240-L242
pkg/util/errorutil/catch.go#L23-L25

pkg/sql/conn_executor.go in pkg/sql.(*Server).ServeConn at line 965
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).run at line 2265
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).execCmd at line 2348
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).execCmd.func1 at line 2343
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmt at line 140
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execWithProfiling at line 3471
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 1202
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).dispatchToExecutionEngine at line 1869
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 839
pkg/sql/opt/optbuilder/builder.go in pkg/sql/opt/optbuilder.(*Builder).Build at line 275
pkg/sql/opt/optbuilder/builder.go in pkg/sql/opt/optbuilder.(*Builder).buildStmtAtRoot at line 296
pkg/sql/opt/optbuilder/builder.go in pkg/sql/opt/optbuilder.(*Builder).buildStmtAtRootWithScope at line 315
pkg/sql/opt/optbuilder/builder.go in pkg/sql/opt/optbuilder.(*Builder).buildStmt at line 410
pkg/sql/opt/optbuilder/routine.go in pkg/sql/opt/optbuilder.(*Builder).buildProcedure at line 120
pkg/sql/opt/optbuilder/routine.go in pkg/sql/opt/optbuilder.(*Builder).resolveProcedureDefinition at line 152
pkg/sql/opt/optbuilder/scope.go in pkg/sql/opt/optbuilder.(*scope).resolveTypeAndReject at line 505
pkg/sql/opt/optbuilder/scope.go in pkg/sql/opt/optbuilder.(*scope).resolveType at line 471
pkg/sql/sem/tree/type_check.go in pkg/sql/sem/tree.TypeCheck at line 355
pkg/sql/sem/tree/type_check.go in pkg/sql/sem/tree.(*FuncExpr).TypeCheck at line 1234
pkg/sql/sem/tree/type_check.go in pkg/sql/sem/tree.(*FuncExpr).typeCheckWithFuncAncestor at line 1174
pkg/sql/sem/tree/type_check.go in pkg/sql/sem/tree.(*FuncExpr).TypeCheck.func2 at line 1235
pkg/sql/sem/tree/overload.go in pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs at line 1073
pkg/sql/sem/tree/overload.go in pkg/sql/sem/tree.filterOverloads at line 1626
pkg/sql/sem/tree/overload.go in pkg/sql/sem/tree.(*overloadTypeChecker).typeCheckOverloadedExprs.func6 at line 1082
GOROOT/src/runtime/iface.go in runtime.panicdottypeI at line 272
GOROOT/src/runtime/iface.go in runtime.panicdottypeE at line 262
GOROOT/src/runtime/panic.go in runtime.gopanic at line 770
pkg/sql/opt/optbuilder/builder.go in pkg/sql/opt/optbuilder.(*Builder).Build.func1 at line 241
pkg/util/errorutil/catch.go in pkg/util/errorutil.ShouldCatch at line 24

Tags

Tag	Value
Command	server
Environment	v24.3.14
Go Version	go1.22.8 X:nocoverageredesign
Platform	linux arm64
Distribution	CCL
Cockroach Release	v24.3.14
Cockroach SHA	ea12d57
# of CPUs	4
# of Goroutines	468

Jira issue: CRDB-51367

[blathers-crl]

CC'ing via the CODEOWNERS-based sentry heuristic:

• @cockroachdb/sql-foundations

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

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

[fqazi]

This is linked to the overload type checker, moving this over to queries.