Skip to content

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

Closed
Closed
sentry: relational.go:110: column 6 not in input (1) assertion failure Wraps: (2) attached stack trace -- stack trace: | github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder.(*execPlan).getNodeCo...#99243
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 Mar 22, 2023

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

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

Panic message:

relational.go:110: column 6 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:110
| github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder.(*execPlan).getNodeColumnOrdinalSet.func1
| github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder/relational.go:118
| 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:117
| 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:345
| 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:1384
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).dispatchToExecutionEngine
| github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1054
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmtInOpenState
| github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:699
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt
| github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:144
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd.func1
| github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1891
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd
| github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:1895
| 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 6 not in input
Error types: (1) *assert.withAssertionFailure (2) *withstack.withStack (3) *errutil.leafError
-- report composition:
*errutil.leafError: column 6 not in input
relational.go:110: *withstack.withStack (top exception)
*assert.withAssertionFailure

Stacktrace (expand for inline code snippets):

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

Lines 109 to 111 in bdcab67

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 117 to 119 in bdcab67

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 bdcab67

// 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/bdcab67f778617515597f1012f37f14f622b15a0/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 bdcab67

// 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 116 to 118 in bdcab67

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 bdcab67

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

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

Lines 344 to 346 in bdcab67

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 bdcab67

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 bdcab67

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 bdcab67

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 bdcab67

// 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 1383 to 1385 in bdcab67

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 1053 to 1055 in bdcab67

// 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 698 to 700 in bdcab67

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

cockroach/pkg/sql/conn_executor_exec.go

Lines 143 to 145 in bdcab67

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

cockroach/pkg/sql/conn_executor.go

Lines 1890 to 1892 in bdcab67

canAutoCommit := ex.implicitTxn() && (tcmd.LastInBatch || !implicitTxnForBatch)
ev, payload, err = ex.execStmt(
ctx, tcmd.Statement, nil /* prepared */, nil /* pinfo */, stmtRes, canAutoCommit,
in pkg/sql.(*connExecutor).execCmd.func1

cockroach/pkg/sql/conn_executor.go

Lines 1894 to 1896 in bdcab67

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 bdcab67

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 bdcab67

}()
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 bdcab67

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 110
pkg/sql/opt/exec/execbuilder/relational.go in pkg/sql/opt/exec/execbuilder.(*execPlan).getNodeColumnOrdinalSet.func1 at line 118
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 117
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 345
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 1384
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).dispatchToExecutionEngine at line 1054
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmtInOpenState at line 699
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmt at line 144
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).execCmd.func1 at line 1891
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).execCmd at line 1895
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.8
Cockroach SHA: bdcab67
Platform linux amd64
Distribution CCL
Environment v22.1.8
Command server
Go Version ``
# of CPUs
# of Goroutines

Jira issue: CRDB-25780

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