sql: v20.2.0-beta.2: expected expression to have key

[cockroach-teamcity]

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

Sentry link: https://sentry.io/organizations/cockroach-labs/issues/2072622090/?referrer=webhooks_plugin

Panic message:

decorrelate_funcs.go:396: expected expression to have key
--
*errutil.leafError: expected expression to have key (1)
decorrelate_funcs.go:396: *withstack.withStack (top exception)
*assert.withAssertionFailure
(check the extra data payloads)

Stacktrace (expand for inline code snippets):

cockroach/pkg/sql/opt/norm/decorrelate_funcs.go

Lines 395 to 397 in 7ab6963

	if !ok {
	panic(errors.AssertionFailedf("expected expression to have key"))
	}

in pkg/sql/opt/norm.(*CustomFuncs).NonKeyCols
https://github.com/cockroachdb/cockroach/blob/7ab6963f9c48e61df8f138894f69f056fe1aa8f5/pkg/sql/opt/xform/explorer.og.go#L383-L385 in pkg/sql/opt/xform.(*explorer).exploreSelect
https://github.com/cockroachdb/cockroach/blob/7ab6963f9c48e61df8f138894f69f056fe1aa8f5/pkg/sql/opt/xform/explorer.og.go#L19-L21 in pkg/sql/opt/xform.(*explorer).exploreGroupMember

cockroach/pkg/sql/opt/xform/explorer.go

Lines 177 to 179 in 7ab6963

	if memberExplored := e.exploreGroupMember(state, member, i); memberExplored {
	// No more rules can ever match this expression, so skip it in

in pkg/sql/opt/xform.(*explorer).exploreGroup

cockroach/pkg/sql/opt/xform/optimizer.go

Lines 462 to 464 in 7ab6963

	// other expressions in this group.
	if o.shouldExplore(required) && !o.explorer.exploreGroup(grp).fullyExplored {
	fullyOptimized = false

in pkg/sql/opt/xform.(*Optimizer).optimizeGroup

cockroach/pkg/sql/opt/xform/optimizer.go

Lines 637 to 639 in 7ab6963

	// enforcer properties.
	innerState := o.optimizeGroup(member, memberProps)
	fullyOptimized = innerState.fullyOptimized

in pkg/sql/opt/xform.(*Optimizer).optimizeEnforcer

cockroach/pkg/sql/opt/xform/optimizer.go

Lines 580 to 582 in 7ab6963

	memberProps := BuildChildPhysicalProps(o.mem, enforcer, 0, required)
	fullyOptimized = o.optimizeEnforcer(state, enforcer, required, member, memberProps)

in pkg/sql/opt/xform.(*Optimizer).enforceProps

cockroach/pkg/sql/opt/xform/optimizer.go

Lines 489 to 491 in 7ab6963

	// of requiring one of the merge join children to be sorted.
	fullyOptimized = o.enforceProps(state, member, required)

in pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember

cockroach/pkg/sql/opt/xform/optimizer.go

Lines 449 to 451 in 7ab6963

	// Optimize the group member with respect to the required properties.
	memberOptimized := o.optimizeGroupMember(state, member, required)

in pkg/sql/opt/xform.(*Optimizer).optimizeGroup

cockroach/pkg/sql/opt/xform/optimizer.go

Lines 249 to 251 in 7ab6963

	case memo.RelExpr:
	state := o.optimizeGroup(t, required)
	return state.cost, state.fullyOptimized

in pkg/sql/opt/xform.(*Optimizer).optimizeExpr

cockroach/pkg/sql/opt/xform/optimizer.go

Lines 504 to 506 in 7ab6963

	// Optimize the child with respect to those properties.
	childCost, childOptimized := o.optimizeExpr(member.Child(i), childRequired)

in pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember

cockroach/pkg/sql/opt/xform/optimizer.go

Lines 449 to 451 in 7ab6963

	// Optimize the group member with respect to the required properties.
	memberOptimized := o.optimizeGroupMember(state, member, required)

in pkg/sql/opt/xform.(*Optimizer).optimizeGroup

cockroach/pkg/sql/opt/xform/optimizer.go

Lines 249 to 251 in 7ab6963

	case memo.RelExpr:
	state := o.optimizeGroup(t, required)
	return state.cost, state.fullyOptimized

in pkg/sql/opt/xform.(*Optimizer).optimizeExpr

cockroach/pkg/sql/opt/xform/optimizer.go

Lines 504 to 506 in 7ab6963

	// Optimize the child with respect to those properties.
	childCost, childOptimized := o.optimizeExpr(member.Child(i), childRequired)

in pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember

cockroach/pkg/sql/opt/xform/optimizer.go

Lines 449 to 451 in 7ab6963

	// Optimize the group member with respect to the required properties.
	memberOptimized := o.optimizeGroupMember(state, member, required)

in pkg/sql/opt/xform.(*Optimizer).optimizeGroup

cockroach/pkg/sql/opt/xform/optimizer.go

Lines 637 to 639 in 7ab6963

	// enforcer properties.
	innerState := o.optimizeGroup(member, memberProps)
	fullyOptimized = innerState.fullyOptimized

in pkg/sql/opt/xform.(*Optimizer).optimizeEnforcer

cockroach/pkg/sql/opt/xform/optimizer.go

Lines 580 to 582 in 7ab6963

	memberProps := BuildChildPhysicalProps(o.mem, enforcer, 0, required)
	fullyOptimized = o.optimizeEnforcer(state, enforcer, required, member, memberProps)

in pkg/sql/opt/xform.(*Optimizer).enforceProps

cockroach/pkg/sql/opt/xform/optimizer.go

Lines 489 to 491 in 7ab6963

	// of requiring one of the merge join children to be sorted.
	fullyOptimized = o.enforceProps(state, member, required)

in pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember

cockroach/pkg/sql/opt/xform/optimizer.go

Lines 449 to 451 in 7ab6963

	// Optimize the group member with respect to the required properties.
	memberOptimized := o.optimizeGroupMember(state, member, required)

in pkg/sql/opt/xform.(*Optimizer).optimizeGroup

cockroach/pkg/sql/opt/xform/optimizer.go

Lines 223 to 225 in 7ab6963

	rootProps := o.mem.RootProps()
	o.optimizeGroup(root, rootProps)

in pkg/sql/opt/xform.(*Optimizer).Optimize

cockroach/pkg/sql/plan_opt.go

Lines 512 to 514 in 7ab6963

	if _, isCanned := opc.p.stmt.AST.(*tree.CannedOptPlan); !isCanned {
	if _, err := opc.optimizer.Optimize(); err != nil {
	return nil, err

in pkg/sql.(*optPlanningCtx).buildExecMemo

cockroach/pkg/sql/plan_opt.go

Lines 194 to 196 in 7ab6963

	execMemo, err := opc.buildExecMemo(ctx)
	if err != nil {

in pkg/sql.(*planner).makeOptimizerPlan

cockroach/pkg/sql/conn_executor_exec.go

Lines 957 to 959 in 7ab6963

	if err := planner.makeOptimizerPlan(ctx); err != nil {
	log.VEventf(ctx, 1, "optimizer plan failed: %v", err)

in pkg/sql.(*connExecutor).makeExecPlan

cockroach/pkg/sql/conn_executor_exec.go

Lines 836 to 838 in 7ab6963

	// between here and there needs to happen even if there's an error.
	err := ex.makeExecPlan(ctx, planner)
	// We'll be closing the plan manually below after execution; this

in pkg/sql.(*connExecutor).dispatchToExecutionEngine

cockroach/pkg/sql/conn_executor_exec.go

Lines 608 to 610 in 7ab6963

	p.autoCommit = os.ImplicitTxn.Get() && !ex.server.cfg.TestingKnobs.DisableAutoCommit
	if err := ex.dispatchToExecutionEngine(ctx, p, res); err != nil {
	return nil, nil, err

in pkg/sql.(*connExecutor).execStmtInOpenState

cockroach/pkg/sql/conn_executor_exec.go

Lines 115 to 117 in 7ab6963

	} else {
	ev, payload, err = ex.execStmtInOpenState(ctx, stmt, res, pinfo)
	}

in pkg/sql.(*connExecutor).execStmt

cockroach/pkg/sql/conn_executor.go

Lines 1458 to 1460 in 7ab6963

	stmtCtx := withStatement(ctx, ex.curStmt)
	ev, payload, err = ex.execStmt(stmtCtx, curStmt, stmtRes, nil /* pinfo */)
	if err != nil {

in pkg/sql.(*connExecutor).execCmd

cockroach/pkg/sql/conn_executor.go

Lines 1387 to 1389 in 7ab6963

	var err error
	if err = ex.execCmd(ex.Ctx()); err != nil {
	if errors.IsAny(err, io.EOF, errDrainingComplete) {

in pkg/sql.(*connExecutor).run

cockroach/pkg/sql/conn_executor.go

Lines 509 to 511 in 7ab6963

	}()
	return h.ex.run(ctx, s.pool, reserved, cancel)
	}

in pkg/sql.(*Server).ServeConn

cockroach/pkg/sql/pgwire/conn.go

Lines 625 to 627 in 7ab6963

	reservedOwned = false // We're about to pass ownership away.
	retErr = sqlServer.ServeConn(ctx, connHandler, reserved, cancelConn)
	}()

in pkg/sql/pgwire.(*conn).processCommandsAsync.func1
/usr/local/go/src/runtime/asm_amd64.s#L1356-L1358 in runtime.goexit

pkg/sql/opt/norm/decorrelate_funcs.go in pkg/sql/opt/norm.(*CustomFuncs).NonKeyCols at line 396
pkg/sql/opt/xform/explorer.og.go in pkg/sql/opt/xform.(*explorer).exploreSelect at line 384
pkg/sql/opt/xform/explorer.og.go in pkg/sql/opt/xform.(*explorer).exploreGroupMember at line 20
pkg/sql/opt/xform/explorer.go in pkg/sql/opt/xform.(*explorer).exploreGroup at line 178
pkg/sql/opt/xform/optimizer.go in pkg/sql/opt/xform.(*Optimizer).optimizeGroup at line 463
pkg/sql/opt/xform/optimizer.go in pkg/sql/opt/xform.(*Optimizer).optimizeEnforcer at line 638
pkg/sql/opt/xform/optimizer.go in pkg/sql/opt/xform.(*Optimizer).enforceProps at line 581
pkg/sql/opt/xform/optimizer.go in pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember at line 490
pkg/sql/opt/xform/optimizer.go in pkg/sql/opt/xform.(*Optimizer).optimizeGroup at line 450
pkg/sql/opt/xform/optimizer.go in pkg/sql/opt/xform.(*Optimizer).optimizeExpr at line 250
pkg/sql/opt/xform/optimizer.go in pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember at line 505
pkg/sql/opt/xform/optimizer.go in pkg/sql/opt/xform.(*Optimizer).optimizeGroup at line 450
pkg/sql/opt/xform/optimizer.go in pkg/sql/opt/xform.(*Optimizer).optimizeExpr at line 250
pkg/sql/opt/xform/optimizer.go in pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember at line 505
pkg/sql/opt/xform/optimizer.go in pkg/sql/opt/xform.(*Optimizer).optimizeGroup at line 450
pkg/sql/opt/xform/optimizer.go in pkg/sql/opt/xform.(*Optimizer).optimizeEnforcer at line 638
pkg/sql/opt/xform/optimizer.go in pkg/sql/opt/xform.(*Optimizer).enforceProps at line 581
pkg/sql/opt/xform/optimizer.go in pkg/sql/opt/xform.(*Optimizer).optimizeGroupMember at line 490
pkg/sql/opt/xform/optimizer.go in pkg/sql/opt/xform.(*Optimizer).optimizeGroup at line 450
pkg/sql/opt/xform/optimizer.go in pkg/sql/opt/xform.(*Optimizer).Optimize at line 224
pkg/sql/plan_opt.go in pkg/sql.(*optPlanningCtx).buildExecMemo at line 513
pkg/sql/plan_opt.go in pkg/sql.(*planner).makeOptimizerPlan at line 195
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).makeExecPlan at line 958
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).dispatchToExecutionEngine at line 837
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmtInOpenState at line 609
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmt at line 116
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).execCmd at line 1459
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).run at line 1388
pkg/sql/conn_executor.go in pkg/sql.(*Server).ServeConn at line 510
pkg/sql/pgwire/conn.go in pkg/sql/pgwire.(*conn).processCommandsAsync.func1 at line 626
/usr/local/go/src/runtime/asm_amd64.s in runtime.goexit at line 1357

Tag	Value
Cockroach Release	v20.2.0-beta.2
Cockroach SHA:	7ab6963
Platform	linux amd64
Distribution	CCL
Environment	v20.2.0-beta.2
Command	start-single-node
Go Version	``
# of CPUs
# of Goroutines

[RaduBerinde]

Same as #58104.