Skip to content

sentry: relational.go:112: column 11 not in input (1) assertion failure Wraps: (2) attached stack trace -- stack trace: | github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder.(*execPlan).getNodeC... #92730

Closed
Closed
sentry: relational.go:112: column 11 not in input (1) assertion failure Wraps: (2) attached stack trace -- stack trace: | github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder.(*execPlan).getNodeC...#92730
Labels
C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.O-sentryOriginated from an in-the-wild panic report.
@cockroach-teamcity

Description

@cockroach-teamcity
cockroach-teamcity
opened on Nov 30, 2022

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

Panic message:

relational.go:112: column 11 not in input
(1) assertion failure
Wraps: (2) attached stack trace
-- stack trace:
| github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder.(*execPlan).getNodeColumnOrdinal
| github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder/relational.go:112
| github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder.(*execPlan).getNodeColumnOrdinalSet.func1
| github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder/relational.go:120
| github.com/cockroachdb/cockroach/pkg/sql/opt.ColSet.ForEach.func1
| github.com/cockroachdb/cockroach/pkg/sql/opt/colset.go:79
| github.com/cockroachdb/cockroach/pkg/util.FastIntSet.ForEach
| github.com/cockroachdb/cockroach/pkg/util/pkg/util/fast_int_set.go:174
| github.com/cockroachdb/cockroach/pkg/sql/opt.ColSet.ForEach
| github.com/cockroachdb/cockroach/pkg/sql/opt/colset.go:79
| github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder.(*execPlan).getNodeColumnOrdinalSet
| github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder/relational.go:119
| github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder.(*Builder).buildExport
| github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder/statement.go:361
| github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder.(*Builder).buildRelational
| github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder/relational.go:347
| github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder.(*Builder).build
| github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder/builder.go:234
| github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder.(*Builder).Build
| github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder/builder.go:194
| github.com/cockroachdb/cockroach/pkg/sql.(*optPlanningCtx).runExecBuilder
| github.com/cockroachdb/cockroach/pkg/sql/plan_opt.go:616
| github.com/cockroachdb/cockroach/pkg/sql.(*planner).makeOptimizerPlan
| github.com/cockroachdb/cockroach/pkg/sql/plan_opt.go:294
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).makeExecPlan
| github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1433
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).dispatchToExecutionEngine
| github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1103
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmtInOpenState
| github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:747
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt
| github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:179
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execPortal
| github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:267
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd.func2
| github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1969
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd
| github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1971
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).run
| github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1817
| github.com/cockroachdb/cockroach/pkg/sql.(*Server).ServeConn
| github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:763
| github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).processCommandsAsync.func1
| github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:728
| runtime.goexit
| GOROOT/src/runtime/asm_amd64.s:1581
Wraps: (3) column 11 not in input
Error types: (1) *assert.withAssertionFailure (2) *withstack.withStack (3) *errutil.leafError
-- report composition:
*errutil.leafError: column 11 not in input
relational.go:112: *withstack.withStack (top exception)
*assert.withAssertionFailure

Stacktrace (expand for inline code snippets):

cockroach/pkg/sql/opt/exec/execbuilder/relational.go

Lines 111 to 113 in 22fa382

if !ok {
panic(errors.AssertionFailedf("column %d not in input", redact.Safe(col)))
}
in pkg/sql/opt/exec/execbuilder.(*execPlan).getNodeColumnOrdinal

cockroach/pkg/sql/opt/exec/execbuilder/relational.go

Lines 119 to 121 in 22fa382

cols.ForEach(func(colID opt.ColumnID) {
res.Add(int(ep.getNodeColumnOrdinal(colID)))
})
in pkg/sql/opt/exec/execbuilder.(*execPlan).getNodeColumnOrdinalSet.func1

cockroach/pkg/sql/opt/colset.go

Lines 78 to 80 in 22fa382

// ForEach calls a function for each column in the set (in increasing order).
func (s ColSet) ForEach(f func(col ColumnID)) { s.set.ForEach(func(i int) { f(retVal(i)) }) }
in pkg/sql/opt.ColSet.ForEach.func1
https://github.com/cockroachdb/cockroach/blob/22fa382362ff4ec680d82eef28dcbbaa932942ae/pkg/util/pkg/util/fast_int_set.go#L173-L175 in pkg/util.FastIntSet.ForEach

cockroach/pkg/sql/opt/colset.go

Lines 78 to 80 in 22fa382

// ForEach calls a function for each column in the set (in increasing order).
func (s ColSet) ForEach(f func(col ColumnID)) { s.set.ForEach(func(i int) { f(retVal(i)) }) }
in pkg/sql/opt.ColSet.ForEach

cockroach/pkg/sql/opt/exec/execbuilder/relational.go

Lines 118 to 120 in 22fa382

var res exec.NodeColumnOrdinalSet
cols.ForEach(func(colID opt.ColumnID) {
res.Add(int(ep.getNodeColumnOrdinal(colID)))
in pkg/sql/opt/exec/execbuilder.(*execPlan).getNodeColumnOrdinalSet

cockroach/pkg/sql/opt/exec/execbuilder/statement.go

Lines 360 to 362 in 22fa382

}
notNullColsSet := input.getNodeColumnOrdinalSet(export.Input.Relational().NotNullCols)
in pkg/sql/opt/exec/execbuilder.(*Builder).buildExport

cockroach/pkg/sql/opt/exec/execbuilder/relational.go

Lines 346 to 348 in 22fa382

case *memo.ExportExpr:
ep, err = b.buildExport(t)
in pkg/sql/opt/exec/execbuilder.(*Builder).buildRelational

cockroach/pkg/sql/opt/exec/execbuilder/builder.go

Lines 233 to 235 in 22fa382

return b.buildRelational(rel)
}
in pkg/sql/opt/exec/execbuilder.(*Builder).build

cockroach/pkg/sql/opt/exec/execbuilder/builder.go

Lines 193 to 195 in 22fa382

func (b *Builder) Build() (_ exec.Plan, err error) {
plan, err := b.build(b.e)
if err != nil {
in pkg/sql/opt/exec/execbuilder.(*Builder).Build

cockroach/pkg/sql/plan_opt.go

Lines 615 to 617 in 22fa382

bld := execbuilder.New(f, &opc.optimizer, mem, &opc.catalog, mem.RootExpr(), evalCtx, allowAutoCommit)
plan, err := bld.Build()
if err != nil {
in pkg/sql.(*optPlanningCtx).runExecBuilder

cockroach/pkg/sql/plan_opt.go

Lines 293 to 295 in 22fa382

// If we got here, we did not create a plan above.
return opc.runExecBuilder(
&p.curPlan,
in pkg/sql.(*planner).makeOptimizerPlan

cockroach/pkg/sql/conn_executor_exec.go

Lines 1432 to 1434 in 22fa382

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 1102 to 1104 in 22fa382

// 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 746 to 748 in 22fa382

if err := ex.dispatchToExecutionEngine(stmtCtx, p, res); err != nil {
stmtThresholdSpan.Finish()
in pkg/sql.(*connExecutor).execStmtInOpenState

cockroach/pkg/sql/conn_executor_exec.go

Lines 178 to 180 in 22fa382

} else {
ev, payload, err = ex.execStmtInOpenState(ctx, parserStmt, prepared, pinfo, res, canAutoCommit)
}
in pkg/sql.(*connExecutor).execStmt

cockroach/pkg/sql/conn_executor_exec.go

Lines 266 to 268 in 22fa382

}
ev, payload, err = ex.execStmt(ctx, portal.Stmt.Statement, portal.Stmt, pinfo, stmtRes, canAutoCommit)
// Portal suspension is supported via a "side" state machine
in pkg/sql.(*connExecutor).execPortal

cockroach/pkg/sql/conn_executor.go

Lines 1968 to 1970 in 22fa382

canAutoCommit := ex.implicitTxn() && tcmd.FollowedBySync
ev, payload, err = ex.execPortal(ctx, portal, portalName, stmtRes, pinfo, canAutoCommit)
return err
in pkg/sql.(*connExecutor).execCmd.func2

cockroach/pkg/sql/conn_executor.go

Lines 1970 to 1972 in 22fa382

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 1816 to 1818 in 22fa382

var err error
if err = ex.execCmd(); err != nil {
if errors.IsAny(err, io.EOF, errDrainingComplete) {
in pkg/sql.(*connExecutor).run

cockroach/pkg/sql/conn_executor.go

Lines 762 to 764 in 22fa382

}()
return h.ex.run(ctx, s.pool, reserved, cancel)
}
in pkg/sql.(*Server).ServeConn

cockroach/pkg/sql/pgwire/conn.go

Lines 727 to 729 in 22fa382

reservedOwned = false // We're about to pass ownership away.
retErr = sqlServer.ServeConn(ctx, connHandler, reserved, cancelConn)
}()
in pkg/sql/pgwire.(*conn).processCommandsAsync.func1
GOROOT/src/runtime/asm_amd64.s#L1580-L1582 in runtime.goexit

pkg/sql/opt/exec/execbuilder/relational.go in pkg/sql/opt/exec/execbuilder.(*execPlan).getNodeColumnOrdinal at line 112
pkg/sql/opt/exec/execbuilder/relational.go in pkg/sql/opt/exec/execbuilder.(*execPlan).getNodeColumnOrdinalSet.func1 at line 120
pkg/sql/opt/colset.go in pkg/sql/opt.ColSet.ForEach.func1 at line 79
pkg/util/pkg/util/fast_int_set.go in pkg/util.FastIntSet.ForEach at line 174
pkg/sql/opt/colset.go in pkg/sql/opt.ColSet.ForEach at line 79
pkg/sql/opt/exec/execbuilder/relational.go in pkg/sql/opt/exec/execbuilder.(*execPlan).getNodeColumnOrdinalSet at line 119
pkg/sql/opt/exec/execbuilder/statement.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildExport at line 361
pkg/sql/opt/exec/execbuilder/relational.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildRelational at line 347
pkg/sql/opt/exec/execbuilder/builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).build at line 234
pkg/sql/opt/exec/execbuilder/builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).Build at line 194
pkg/sql/plan_opt.go in pkg/sql.(*optPlanningCtx).runExecBuilder at line 616
pkg/sql/plan_opt.go in pkg/sql.(*planner).makeOptimizerPlan at line 294
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).makeExecPlan at line 1433
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).dispatchToExecutionEngine at line 1103
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmtInOpenState at line 747
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmt at line 179
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execPortal at line 267
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).execCmd.func2 at line 1969
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).execCmd at line 1971
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).run at line 1817
pkg/sql/conn_executor.go in pkg/sql.(*Server).ServeConn at line 763
pkg/sql/pgwire/conn.go in pkg/sql/pgwire.(*conn).processCommandsAsync.func1 at line 728
GOROOT/src/runtime/asm_amd64.s in runtime.goexit at line 1581
Tag Value
Cockroach Release v22.1.11
Cockroach SHA: 22fa382
Platform linux amd64
Distribution CCL
Environment v22.1.11
Command server
Go Version ``
# of CPUs
# of Goroutines

Jira issue: CRDB-21937

Metadata

Metadata

Assignees

No one assigned

    Labels

    C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.O-sentryOriginated from an in-the-wild panic report.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions