Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

sentry: (0) scalar_builder.go:148: cannot map variable %d to an indexed var | 7 (1) statement: SELECT _._, _._, sum(CASE WHEN _._ = _ THEN _ * _._ ELSE _._ END)::INT8, _._, _._ FROM _ AS _ INNER JOIN _ AS _ ON _._ = _._ WHERE ((_._ = $1) AND ((EXISTS (SELECT _._ FROM _ WHERE ((_._ = _) OR (_._ = _)) AND (_._ = _._)) OR EXISTS (SELECT _._ FROM _ WHERE (_._ = _) AND (_._ IS _))) OR (NOT EXISTS (SELECT _._ FROM _ WHERE _._ = _)))) GROUP BY _._, _._, _._, _._ ORDER BY _._, _._, _._ (see stack traces in additional data) #41650

Closed
cockroach-teamcity opened this issue Oct 16, 2019 · 1 comment
Closed

sentry: (0) scalar_builder.go:148: cannot map variable %d to an indexed var | 7 (1) statement: SELECT _._, _._, sum(CASE WHEN _._ = _ THEN _ * _._ ELSE _._ END)::INT8, _._, _._ FROM _ AS _ INNER JOIN _ AS _ ON _._ = _._ WHERE ((_._ = $1) AND ((EXISTS (SELECT _._ FROM _ WHERE ((_._ = _) OR (_._ = _)) AND (_._ = _._)) OR EXISTS (SELECT _._ FROM _ WHERE (_._ = _) AND (_._ IS _))) OR (NOT EXISTS (SELECT _._ FROM _ WHERE _._ = _)))) GROUP BY _._, _._, _._, _._ ORDER BY _._, _._, _._ (see stack traces in additional data) #41650

cockroach-teamcity opened this issue Oct 16, 2019 · 1 comment
Assignees
@RaduBerinde
Labels
C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. O-sentry Originated from an in-the-wild panic report.

Comments

@cockroach-teamcity
Copy link
Member

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

Panic message:

(0) scalar_builder.go:148: cannot map variable %d to an indexed var | 7
(1) statement: SELECT ., ., sum(CASE WHEN . = _ THEN _ * . ELSE . END)::INT8, ., . FROM _ AS _ INNER JOIN _ AS _ ON . = . WHERE ((. = $1) AND ((EXISTS (SELECT . FROM _ WHERE ((. = ) OR (._ = )) AND (._ = .)) OR EXISTS (SELECT . FROM _ WHERE (. = ) AND (._ IS _))) OR (NOT EXISTS (SELECT . FROM _ WHERE . = _)))) GROUP BY ., ., ., . ORDER BY ., ., .
(see stack traces in additional data)

Stacktrace (expand for inline code snippets):

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

Lines 147 to 149 in 51a6fde

}
panic(pgerror.NewAssertionErrorf("cannot map variable %d to an indexed var", log.Safe(colID)))
}
in pkg/sql/opt/exec/execbuilder.(*Builder).indexedVar

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

Lines 136 to 138 in 51a6fde

) (tree.TypedExpr, error) {
return b.indexedVar(ctx, b.mem.Metadata(), *scalar.Private().(*opt.ColumnID)), nil
}
in pkg/sql/opt/exec/execbuilder.(*Builder).buildVariable

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

Lines 93 to 95 in 51a6fde

if fn := scalarBuildFuncMap[scalar.Op()]; fn != nil {
texpr, err := fn(b, ctx, scalar)
if err != nil {
in pkg/sql/opt/exec/execbuilder.(*Builder).buildScalar

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

Lines 228 to 230 in 51a6fde

}
right, err := b.buildScalar(ctx, scalar.Child(1).(opt.ScalarExpr))
if err != nil {
in pkg/sql/opt/exec/execbuilder.(*Builder).buildComparison

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

Lines 93 to 95 in 51a6fde

if fn := scalarBuildFuncMap[scalar.Op()]; fn != nil {
texpr, err := fn(b, ctx, scalar)
if err != nil {
in pkg/sql/opt/exec/execbuilder.(*Builder).buildScalar

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

Lines 211 to 213 in 51a6fde

case opt.FiltersItemOp:
return b.buildScalar(ctx, scalar.Child(0).(opt.ScalarExpr))
in pkg/sql/opt/exec/execbuilder.(*Builder).buildBoolean

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

Lines 93 to 95 in 51a6fde

if fn := scalarBuildFuncMap[scalar.Op()]; fn != nil {
texpr, err := fn(b, ctx, scalar)
if err != nil {
in pkg/sql/opt/exec/execbuilder.(*Builder).buildScalar

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

Lines 185 to 187 in 51a6fde

for i, n := 1, scalar.ChildCount(); i < n; i++ {
right, err := b.buildScalar(ctx, scalar.Child(i).(opt.ScalarExpr))
if err != nil {
in pkg/sql/opt/exec/execbuilder.(*Builder).buildBoolean

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

Lines 93 to 95 in 51a6fde

if fn := scalarBuildFuncMap[scalar.Op()]; fn != nil {
texpr, err := fn(b, ctx, scalar)
if err != nil {
in pkg/sql/opt/exec/execbuilder.(*Builder).buildScalar

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

Lines 424 to 426 in 51a6fde

ctx := input.makeBuildScalarCtx()
filter, err := b.buildScalar(&ctx, &sel.Filters)
if err != nil {
in pkg/sql/opt/exec/execbuilder.(*Builder).buildSelect

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

Lines 173 to 175 in 51a6fde

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

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

Lines 461 to 463 in 51a6fde

md := b.mem.Metadata()
input, err := b.buildRelational(prj.Input)
if err != nil {
in pkg/sql/opt/exec/execbuilder.(*Builder).buildProject

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

Lines 176 to 178 in 51a6fde

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

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

Lines 717 to 719 in 51a6fde

}
rightPlan, err = b.buildRelational(rightChild)
if err != nil {
in pkg/sql/opt/exec/execbuilder.(*Builder).initJoinBuild

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

Lines 648 to 650 in 51a6fde

left, right, onExpr, outputCols, err := b.initJoinBuild(
leftExpr,
in pkg/sql/opt/exec/execbuilder.(*Builder).buildHashJoin

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

Lines 241 to 243 in 51a6fde

if opt.IsJoinNonApplyOp(e) {
ep, err = b.buildHashJoin(e)
break
in pkg/sql/opt/exec/execbuilder.(*Builder).buildRelational

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

Lines 907 to 909 in 51a6fde

groupByInput := groupBy.Child(0).(memo.RelExpr)
input, err := b.buildRelational(groupByInput)
if err != nil {
in pkg/sql/opt/exec/execbuilder.(*Builder).buildGroupByInput

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

Lines 780 to 782 in 51a6fde

func (b *Builder) buildGroupBy(groupBy memo.RelExpr) (execPlan, error) {
input, err := b.buildGroupByInput(groupBy)
if err != nil {
in pkg/sql/opt/exec/execbuilder.(*Builder).buildGroupBy

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

Lines 179 to 181 in 51a6fde

case *memo.GroupByExpr, *memo.ScalarGroupByExpr:
ep, err = b.buildGroupBy(e)
in pkg/sql/opt/exec/execbuilder.(*Builder).buildRelational

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

Lines 419 to 421 in 51a6fde

func (b *Builder) buildSelect(sel *memo.SelectExpr) (execPlan, error) {
input, err := b.buildRelational(sel.Input)
if err != nil {
in pkg/sql/opt/exec/execbuilder.(*Builder).buildSelect

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

Lines 173 to 175 in 51a6fde

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

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

Lines 717 to 719 in 51a6fde

}
rightPlan, err = b.buildRelational(rightChild)
if err != nil {
in pkg/sql/opt/exec/execbuilder.(*Builder).initJoinBuild

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

Lines 648 to 650 in 51a6fde

left, right, onExpr, outputCols, err := b.initJoinBuild(
leftExpr,
in pkg/sql/opt/exec/execbuilder.(*Builder).buildHashJoin

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

Lines 241 to 243 in 51a6fde

if opt.IsJoinNonApplyOp(e) {
ep, err = b.buildHashJoin(e)
break
in pkg/sql/opt/exec/execbuilder.(*Builder).buildRelational

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

Lines 461 to 463 in 51a6fde

md := b.mem.Metadata()
input, err := b.buildRelational(prj.Input)
if err != nil {
in pkg/sql/opt/exec/execbuilder.(*Builder).buildProject

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

Lines 176 to 178 in 51a6fde

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

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

Lines 1062 to 1064 in 51a6fde

func (b *Builder) buildSort(sort *memo.SortExpr) (execPlan, error) {
input, err := b.buildRelational(sort.Input)
if err != nil {
in pkg/sql/opt/exec/execbuilder.(*Builder).buildSort

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

Lines 188 to 190 in 51a6fde

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

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

Lines 907 to 909 in 51a6fde

groupByInput := groupBy.Child(0).(memo.RelExpr)
input, err := b.buildRelational(groupByInput)
if err != nil {
in pkg/sql/opt/exec/execbuilder.(*Builder).buildGroupByInput

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

Lines 780 to 782 in 51a6fde

func (b *Builder) buildGroupBy(groupBy memo.RelExpr) (execPlan, error) {
input, err := b.buildGroupByInput(groupBy)
if err != nil {
in pkg/sql/opt/exec/execbuilder.(*Builder).buildGroupBy

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

Lines 179 to 181 in 51a6fde

case *memo.GroupByExpr, *memo.ScalarGroupByExpr:
ep, err = b.buildGroupBy(e)
in pkg/sql/opt/exec/execbuilder.(*Builder).buildRelational

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

Lines 461 to 463 in 51a6fde

md := b.mem.Metadata()
input, err := b.buildRelational(prj.Input)
if err != nil {
in pkg/sql/opt/exec/execbuilder.(*Builder).buildProject

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

Lines 176 to 178 in 51a6fde

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

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

Lines 88 to 90 in 51a6fde

}
plan, err := b.buildRelational(rel)
if err != nil {
in pkg/sql/opt/exec/execbuilder.(*Builder).build

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

Lines 76 to 78 in 51a6fde

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

cockroach/pkg/sql/plan_opt.go

Lines 162 to 164 in 51a6fde

execFactory := makeExecFactory(p)
plan, err := execbuilder.New(&execFactory, execMemo, root, p.EvalContext()).Build()
if err != nil {
in pkg/sql.(*planner).makeOptimizerPlan

cockroach/pkg/sql/conn_executor_exec.go

Lines 990 to 992 in 51a6fde

var err error
result, isCorrelated, err = planner.makeOptimizerPlan(ctx)
if err == nil {
in pkg/sql.(*connExecutor).makeExecPlan

cockroach/pkg/sql/conn_executor_exec.go

Lines 864 to 866 in 51a6fde

// 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 455 to 457 in 51a6fde

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 101 to 103 in 51a6fde

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

cockroach/pkg/sql/conn_executor.go

Lines 1245 to 1247 in 51a6fde

stmtCtx := withStatement(ex.Ctx(), ex.curStmt)
ev, payload, err = ex.execStmt(stmtCtx, curStmt, stmtRes, pinfo)
if err != nil {
in pkg/sql.(*connExecutor).run

cockroach/pkg/sql/conn_executor.go

Lines 435 to 437 in 51a6fde

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

cockroach/pkg/sql/pgwire/conn.go

Lines 579 to 581 in 51a6fde

reservedOwned = false // We're about to pass ownership away.
retErr = sqlServer.ServeConn(ctx, connHandler, reserved, cancelConn)
}()
in pkg/sql/pgwire.(*conn).processCommandsAsync.func1

pkg/sql/opt/exec/execbuilder/scalar_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).indexedVar at line 148
pkg/sql/opt/exec/execbuilder/scalar_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildVariable at line 137
pkg/sql/opt/exec/execbuilder/scalar_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildScalar at line 94
pkg/sql/opt/exec/execbuilder/scalar_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildComparison at line 229
pkg/sql/opt/exec/execbuilder/scalar_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildScalar at line 94
pkg/sql/opt/exec/execbuilder/scalar_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildBoolean at line 212
pkg/sql/opt/exec/execbuilder/scalar_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildScalar at line 94
pkg/sql/opt/exec/execbuilder/scalar_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildBoolean at line 186
pkg/sql/opt/exec/execbuilder/scalar_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildScalar at line 94
pkg/sql/opt/exec/execbuilder/relational_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildSelect at line 425
pkg/sql/opt/exec/execbuilder/relational_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildRelational at line 174
pkg/sql/opt/exec/execbuilder/relational_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildProject at line 462
pkg/sql/opt/exec/execbuilder/relational_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildRelational at line 177
pkg/sql/opt/exec/execbuilder/relational_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).initJoinBuild at line 718
pkg/sql/opt/exec/execbuilder/relational_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildHashJoin at line 649
pkg/sql/opt/exec/execbuilder/relational_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildRelational at line 242
pkg/sql/opt/exec/execbuilder/relational_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildGroupByInput at line 908
pkg/sql/opt/exec/execbuilder/relational_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildGroupBy at line 781
pkg/sql/opt/exec/execbuilder/relational_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildRelational at line 180
pkg/sql/opt/exec/execbuilder/relational_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildSelect at line 420
pkg/sql/opt/exec/execbuilder/relational_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildRelational at line 174
pkg/sql/opt/exec/execbuilder/relational_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).initJoinBuild at line 718
pkg/sql/opt/exec/execbuilder/relational_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildHashJoin at line 649
pkg/sql/opt/exec/execbuilder/relational_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildRelational at line 242
pkg/sql/opt/exec/execbuilder/relational_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildProject at line 462
pkg/sql/opt/exec/execbuilder/relational_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildRelational at line 177
pkg/sql/opt/exec/execbuilder/relational_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildSort at line 1063
pkg/sql/opt/exec/execbuilder/relational_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildRelational at line 189
pkg/sql/opt/exec/execbuilder/relational_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildGroupByInput at line 908
pkg/sql/opt/exec/execbuilder/relational_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildGroupBy at line 781
pkg/sql/opt/exec/execbuilder/relational_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildRelational at line 180
pkg/sql/opt/exec/execbuilder/relational_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildProject at line 462
pkg/sql/opt/exec/execbuilder/relational_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildRelational at line 177
pkg/sql/opt/exec/execbuilder/builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).build at line 89
pkg/sql/opt/exec/execbuilder/builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).Build at line 77
pkg/sql/plan_opt.go in pkg/sql.(*planner).makeOptimizerPlan at line 163
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).makeExecPlan at line 991
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).dispatchToExecutionEngine at line 865
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmtInOpenState at line 456
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmt at line 102
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).run at line 1246
pkg/sql/conn_executor.go in pkg/sql.(*Server).ServeConn at line 436
pkg/sql/pgwire/conn.go in pkg/sql/pgwire.(*conn).processCommandsAsync.func1 at line 580
Tag Value
Cockroach Release v19.1.4
Cockroach SHA: 51a6fde
Platform darwin amd64
Distribution CCL
Environment v19.1.4
Command server
Go Version go1.11.6
# of CPUs 12
# of Goroutines 247
@cockroach-teamcity cockroach-teamcity added C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. O-sentry Originated from an in-the-wild panic report. labels Oct 16, 2019
@RaduBerinde
Copy link
Member

Probably dup of #40590. Opened #41666 to backport that fix to 19.1.

@RaduBerinde RaduBerinde mentioned this issue Oct 29, 2019
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@RaduBerinde RaduBerinde

Labels
C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. O-sentry Originated from an in-the-wild panic report.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@RaduBerinde @cockroach-teamcity