cockroach-teamcity · 2019-12-27T16:33:59Z

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

Panic message:

(0) scalar_builder.go:148: cannot map variable %d to an indexed var | 7
(1) statement: SELECT ., ., ., . FROM _ AS _ INNER JOIN _ AS _ ON . = . WHERE ((((. = ) AND EXISTS (SELECT . FROM _ AS _ WHERE ((._ = ) OR (._ = )) AND (._ = .))) OR ((. = ) AND EXISTS (SELECT . FROM _ AS _ WHERE ((._ = ) AND (._ = )) AND (._ IS )))) OR ((._ = ) AND (NOT EXISTS (SELECT . FROM _ AS _ WHERE (._ = ) AND (._ = _))))) 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 713 to 715 in 51a6fde

    
           ) (leftPlan, rightPlan execPlan, onExpr tree.TypedExpr, outputCols opt.ColMap, _ error) { 
        
           	leftPlan, err := b.buildRelational(leftChild) 
        
           	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 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 875 to 877 in 51a6fde

    
           } 
        
           input, err := b.buildGroupByInput(distinct) 
        
           if err != nil {

in pkg/sql/opt/exec/execbuilder.(*Builder).buildDistinct

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

Lines 182 to 184 in 51a6fde

    
           case *memo.DistinctOnExpr: 
        
           	ep, err = b.buildDistinct(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 1185 to 1187 in 51a6fde

    
           stmtCtx := withStatement(ex.Ctx(), ex.curStmt) 
        
           ev, payload, err = ex.execStmt(stmtCtx, curStmt, stmtRes, nil /* 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 714
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).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).buildDistinct at line 876
pkg/sql/opt/exec/execbuilder/relational_builder.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildRelational at line 183
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 1186
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	linux amd64
Distribution	CCL
Environment	v19.1.4
Command	server
Go Version	`go1.11.6`
# of CPUs	2
# of Goroutines	913

The text was updated successfully, but these errors were encountered:

yuzefovich · 2019-12-27T16:39:00Z

Dup of #40590.

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 Dec 27, 2019

yuzefovich closed this as completed Dec 27, 2019

knz mentioned this issue Jan 5, 2020

pgwire: clarify the special cases as pre-defined HBA rules #43726

Merged

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

cockroach-teamcity commented Dec 27, 2019

yuzefovich commented Dec 27, 2019

Comments

cockroach-teamcity commented Dec 27, 2019

yuzefovich commented Dec 27, 2019