sentry: datum.go:3946: expected *DArray, found tree.dNull -- *errutil.leafError: expected *DArray, found tree.dNull (1) datum.go:3946: *withstack.withStack (top exception) *assert.withAssertionFailure (check the extra data payloads)

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

Panic message:

datum.go:3946: expected *DArray, found tree.dNull
--
*errutil.leafError: expected *DArray, found tree.dNull (1)
datum.go:3946: *withstack.withStack (top exception)
*assert.withAssertionFailure
(check the extra data payloads)

Stacktrace (expand for inline code snippets):

cockroach/pkg/sql/sem/tree/datum.go

Lines 3945 to 3947 in c7cfac5

	if !ok {
	panic(errors.AssertionFailedf("expected *DArray, found %T", e))
	}

in pkg/sql/sem/tree.MustBeDArray

cockroach/pkg/sql/sem/tree/eval.go

Lines 2566 to 2568 in c7cfac5

	Fn: func(ctx *EvalContext, left Datum, right Datum) (Datum, error) {
	needles := MustBeDArray(left)
	haystack := MustBeDArray(right)

in pkg/sql/sem/tree.glob..func138

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

Lines 438 to 440 in c7cfac5

	result, err := o.Fn(c.f.evalCtx, lDatum, rDatum)
	if err != nil {

in pkg/sql/opt/norm.(*CustomFuncs).FoldComparison
https://github.com/cockroachdb/cockroach/blob/c7cfac57476f06e3154b2fc38e77982a8bbc64c2/pkg/sql/opt/norm/factory.og.go#L16765-L16767 in pkg/sql/opt/norm.(*Factory).ConstructContainedBy
https://github.com/cockroachdb/cockroach/blob/c7cfac57476f06e3154b2fc38e77982a8bbc64c2/pkg/sql/opt/norm/factory.og.go#L22243-L22245 in pkg/sql/opt/norm.(*Factory).Replace

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

Lines 92 to 94 in c7cfac5

	}
	return c.f.Replace(e, replace)
	}

in pkg/sql/opt/norm.(*CustomFuncs).inlineConstants.func1

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

Lines 94 to 96 in c7cfac5

	}
	return replace(e)
	}

in pkg/sql/opt/norm.(*CustomFuncs).inlineConstants

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

Lines 54 to 56 in c7cfac5

	newProjections[i] = c.f.ConstructProjectionsItem(
	c.inlineConstants(item.Element, input, constCols).(opt.ScalarExpr),
	item.Col,

in pkg/sql/opt/norm.(*CustomFuncs).InlineProjectionConstants
https://github.com/cockroachdb/cockroach/blob/c7cfac57476f06e3154b2fc38e77982a8bbc64c2/pkg/sql/opt/norm/factory.og.go#L1348-L1350 in pkg/sql/opt/norm.(*Factory).ConstructProject

cockroach/pkg/sql/opt/optbuilder/project.go

Lines 60 to 62 in c7cfac5

	return b.factory.ConstructProject(input, projections, passthrough)
	}

in pkg/sql/opt/optbuilder.(*Builder).constructProject

cockroach/pkg/sql/opt/optbuilder/project.go

Lines 35 to 37 in c7cfac5

	} else {
	projectionsScope.expr = b.constructProject(
	inScope.expr.(memo.RelExpr),

in pkg/sql/opt/optbuilder.(*Builder).constructProjectForScope

cockroach/pkg/sql/opt/optbuilder/mutation_builder.go

Lines 907 to 909 in c7cfac5

	mb.b.constructProjectForScope(mb.outScope, projectionsScope)
	mb.outScope = projectionsScope

in pkg/sql/opt/optbuilder.(*mutationBuilder).addCheckConstraintCols

cockroach/pkg/sql/opt/optbuilder/insert.go

Lines 668 to 670 in c7cfac5

	// Add any check constraint boolean columns to the input.
	mb.addCheckConstraintCols(false /* isUpdate */)

in pkg/sql/opt/optbuilder.(*mutationBuilder).buildInsert

cockroach/pkg/sql/opt/optbuilder/insert.go

Lines 287 to 289 in c7cfac5

	// Build the final insert statement, including any returned expressions.
	mb.buildInsert(returning)

in pkg/sql/opt/optbuilder.(*Builder).buildInsert

cockroach/pkg/sql/opt/optbuilder/builder.go

Lines 292 to 294 in c7cfac5

	return b.processWiths(stmt.With, inScope, func(inScope *scope) *scope {
	return b.buildInsert(stmt, inScope)
	})

in pkg/sql/opt/optbuilder.(*Builder).buildStmt.func2

cockroach/pkg/sql/opt/optbuilder/with.go

Lines 110 to 112 in c7cfac5

	inScope.atRoot = false
	outScope := buildStmt(inScope)
	outScope.expr = b.buildWiths(outScope.expr, correlatedCTEs)

in pkg/sql/opt/optbuilder.(*Builder).processWiths

cockroach/pkg/sql/opt/optbuilder/builder.go

Lines 291 to 293 in c7cfac5

	case *tree.Insert:
	return b.processWiths(stmt.With, inScope, func(inScope *scope) *scope {
	return b.buildInsert(stmt, inScope)

in pkg/sql/opt/optbuilder.(*Builder).buildStmt

cockroach/pkg/sql/opt/optbuilder/builder.go

Lines 240 to 242 in c7cfac5

	b.ctes = nil
	outScope = b.buildStmt(stmt, desiredTypes, inScope)
	// Build With operators for any CTEs hoisted to the top level.

in pkg/sql/opt/optbuilder.(*Builder).buildStmtAtRoot

cockroach/pkg/sql/opt/optbuilder/explain.go

Lines 30 to 32 in c7cfac5

	stmtScope := b.buildStmtAtRoot(explain.Statement, nil /* desiredTypes */)

in pkg/sql/opt/optbuilder.(*Builder).buildExplain

cockroach/pkg/sql/opt/optbuilder/builder.go

Lines 307 to 309 in c7cfac5

	case *tree.Explain:
	return b.buildExplain(stmt, inScope)

in pkg/sql/opt/optbuilder.(*Builder).buildStmt

cockroach/pkg/sql/opt/optbuilder/builder.go

Lines 240 to 242 in c7cfac5

	b.ctes = nil
	outScope = b.buildStmt(stmt, desiredTypes, inScope)
	// Build With operators for any CTEs hoisted to the top level.

in pkg/sql/opt/optbuilder.(*Builder).buildStmtAtRoot

cockroach/pkg/sql/opt/optbuilder/builder.go

Lines 214 to 216 in c7cfac5

	// and physical properties.
	outScope := b.buildStmtAtRoot(b.stmt, nil /* desiredTypes */)

in pkg/sql/opt/optbuilder.(*Builder).Build

cockroach/pkg/sql/plan_opt.go

Lines 520 to 522 in c7cfac5

	bld := optbuilder.New(ctx, &p.semaCtx, p.EvalContext(), &opc.catalog, f, opc.p.stmt.AST)
	if err := bld.Build(); err != nil {
	return nil, err

in pkg/sql.(*optPlanningCtx).buildExecMemo

cockroach/pkg/sql/plan_opt.go

Lines 193 to 195 in c7cfac5

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

in pkg/sql.(*planner).makeOptimizerPlan

cockroach/pkg/sql/conn_executor_exec.go

Lines 1259 to 1261 in c7cfac5

	func (ex *connExecutor) makeExecPlan(ctx context.Context, planner *planner) error {
	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 971 to 973 in c7cfac5

	// 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 708 to 710 in c7cfac5

	if err := ex.dispatchToExecutionEngine(ctx, p, res); err != nil {
	stmtThresholdSpan.Finish()

in pkg/sql.(*connExecutor).execStmtInOpenState

cockroach/pkg/sql/conn_executor_exec.go

Lines 128 to 130 in c7cfac5

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

in pkg/sql.(*connExecutor).execStmt

cockroach/pkg/sql/conn_executor.go

Lines 1704 to 1706 in c7cfac5

	ev, payload, err = ex.execStmt(ctx, tcmd.Statement, nil /* prepared */, nil /* pinfo */, stmtRes)
	return err

in pkg/sql.(*connExecutor).execCmd.func1

cockroach/pkg/sql/conn_executor.go

Lines 1706 to 1708 in c7cfac5

	return err
	}()
	// Note: we write to ex.statsCollector.PhaseTimes, instead of ex.phaseTimes,

in pkg/sql.(*connExecutor).execCmd

cockroach/pkg/sql/conn_executor.go

Lines 1628 to 1630 in c7cfac5

	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 667 to 669 in c7cfac5

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

in pkg/sql.(*Server).ServeConn

pkg/sql/sem/tree/datum.go in pkg/sql/sem/tree.MustBeDArray at line 3946
pkg/sql/sem/tree/eval.go in pkg/sql/sem/tree.glob..func138 at line 2567
pkg/sql/opt/norm/fold_constants_funcs.go in pkg/sql/opt/norm.(*CustomFuncs).FoldComparison at line 439
pkg/sql/opt/norm/factory.og.go in pkg/sql/opt/norm.(*Factory).ConstructContainedBy at line 16766
pkg/sql/opt/norm/factory.og.go in pkg/sql/opt/norm.(*Factory).Replace at line 22244
pkg/sql/opt/norm/inline_funcs.go in pkg/sql/opt/norm.(*CustomFuncs).inlineConstants.func1 at line 93
pkg/sql/opt/norm/inline_funcs.go in pkg/sql/opt/norm.(*CustomFuncs).inlineConstants at line 95
pkg/sql/opt/norm/inline_funcs.go in pkg/sql/opt/norm.(*CustomFuncs).InlineProjectionConstants at line 55
pkg/sql/opt/norm/factory.og.go in pkg/sql/opt/norm.(*Factory).ConstructProject at line 1349
pkg/sql/opt/optbuilder/project.go in pkg/sql/opt/optbuilder.(*Builder).constructProject at line 61
pkg/sql/opt/optbuilder/project.go in pkg/sql/opt/optbuilder.(*Builder).constructProjectForScope at line 36
pkg/sql/opt/optbuilder/mutation_builder.go in pkg/sql/opt/optbuilder.(*mutationBuilder).addCheckConstraintCols at line 908
pkg/sql/opt/optbuilder/insert.go in pkg/sql/opt/optbuilder.(*mutationBuilder).buildInsert at line 669
pkg/sql/opt/optbuilder/insert.go in pkg/sql/opt/optbuilder.(*Builder).buildInsert at line 288
pkg/sql/opt/optbuilder/builder.go in pkg/sql/opt/optbuilder.(*Builder).buildStmt.func2 at line 293
pkg/sql/opt/optbuilder/with.go in pkg/sql/opt/optbuilder.(*Builder).processWiths at line 111
pkg/sql/opt/optbuilder/builder.go in pkg/sql/opt/optbuilder.(*Builder).buildStmt at line 292
pkg/sql/opt/optbuilder/builder.go in pkg/sql/opt/optbuilder.(*Builder).buildStmtAtRoot at line 241
pkg/sql/opt/optbuilder/explain.go in pkg/sql/opt/optbuilder.(*Builder).buildExplain at line 31
pkg/sql/opt/optbuilder/builder.go in pkg/sql/opt/optbuilder.(*Builder).buildStmt at line 308
pkg/sql/opt/optbuilder/builder.go in pkg/sql/opt/optbuilder.(*Builder).buildStmtAtRoot at line 241
pkg/sql/opt/optbuilder/builder.go in pkg/sql/opt/optbuilder.(*Builder).Build at line 215
pkg/sql/plan_opt.go in pkg/sql.(*optPlanningCtx).buildExecMemo at line 521
pkg/sql/plan_opt.go in pkg/sql.(*planner).makeOptimizerPlan at line 194
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).makeExecPlan at line 1260
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).dispatchToExecutionEngine at line 972
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmtInOpenState at line 709
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmt at line 129
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).execCmd.func1 at line 1705
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).execCmd at line 1707
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).run at line 1629
pkg/sql/conn_executor.go in pkg/sql.(*Server).ServeConn at line 668

Tag	Value
Cockroach Release	v21.2.6
Cockroach SHA:	c7cfac5
Platform	linux amd64
Distribution	CCL
Environment	v21.2.6
Command	start-single-node
Go Version	``
# of CPUs
# of Goroutines

Jira issue: CRDB-13872

[yuzefovich]

dup of #77745