sentry: conn_executor.go:521: panic while executing 1 statements: SELECT DISTINCT _._, _._, _._ FROM _ INNER JOIN _ ON _._ = _._ LEFT JOIN _ ON _._ = _._ WHERE (((_._ > $1) AND ((lower(_._) = lower($2)) OR (lower(_._) = lower($3)))) OR ((lower(_._) = lower($4)) OR (lower(_._) = lower($5)))) OR ((_._ ILIKE $6) OR (_._ ILIKE $7)) ORDER BY _._ LIMIT _: caused by <redacted>

[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/933277501/?project=164528&referrer=webhooks_plugin

Panic message:

conn_executor.go:521: panic while executing 1 statements: SELECT DISTINCT ., ., . FROM _ INNER JOIN _ ON . = . LEFT JOIN _ ON . = . WHERE (((. > $1) AND ((lower(.) = lower($2)) OR (lower(.) = lower($3)))) OR ((lower(.) = lower($4)) OR (lower(.) = lower($5)))) OR ((. ILIKE $6) OR (. ILIKE $7)) ORDER BY . LIMIT _: caused by

Stacktrace (expand for inline code snippets):

cockroach/pkg/sql/conn_executor.go

Lines 488 to 490 in d7c9973

	r := recover()
	ex.closeWrapper(ctx, r)
	}()

in pkg/sql.(*Server).ServeConn.func2
/usr/local/go/src/runtime/asm_amd64.s#L572-L574 in runtime.call32
/usr/local/go/src/runtime/panic.go#L504-L506 in runtime.gopanic

cockroach/pkg/util/mon/bytes_usage.go

Lines 605 to 607 in d7c9973

	if mm.mu.curAllocated < sz {
	panic(fmt.Sprintf("%s: no bytes to release, current %d, free %d",
	mm.name, mm.mu.curAllocated, sz))

in pkg/util/mon.(*BytesMonitor).releaseBytes

cockroach/pkg/util/mon/bytes_usage.go

Lines 493 to 495 in d7c9973

	if a := b.allocated(); a > 0 {
	b.mon.releaseBytes(ctx, a)
	}

in pkg/util/mon.(*BoundAccount).Close

cockroach/pkg/sql/distsqlrun/flow.go

Lines 501 to 503 in d7c9973

	// This closes the account and monitor opened in ServerImpl.setupFlow.
	f.EvalCtx.ActiveMemAcc.Close(ctx)
	f.EvalCtx.Stop(ctx)

in pkg/sql/distsqlrun.(*Flow).Cleanup

cockroach/pkg/sql/distsql_running.go

Lines 223 to 225 in d7c9973

	flow.Wait()
	flow.Cleanup(ctx)
	}

in pkg/sql.(*DistSQLPlanner).Run

cockroach/pkg/sql/distsql_running.go

Lines 531 to 533 in d7c9973

	dsp.FinalizePlan(&planCtx, &plan)
	dsp.Run(&planCtx, txn, &plan, recv, evalCtx)
	}

in pkg/sql.(*DistSQLPlanner).PlanAndRun

cockroach/pkg/sql/conn_executor_exec.go

Lines 671 to 673 in d7c9973

	)
	ex.server.cfg.DistSQLPlanner.PlanAndRun(
	ctx, planner.txn, planner.curPlan.plan, recv, planner.ExtendedEvalContext(),

in pkg/sql.(*connExecutor).execWithDistSQLEngine

cockroach/pkg/sql/conn_executor_exec.go

Lines 579 to 581 in d7c9973

	if useDistSQL {
	err = ex.execWithDistSQLEngine(ctx, planner, stmt.AST.StatementType(), res)
	} else {

in pkg/sql.(*connExecutor).dispatchToExecutionEngine

cockroach/pkg/sql/conn_executor_exec.go

Lines 348 to 350 in d7c9973

	p.autoCommit = os.ImplicitTxn.Get() && !ex.server.cfg.TestingKnobs.DisableAutoCommit
	if err := ex.dispatchToExecutionEngine(ctx, stmt, p, res); err != nil {
	return nil, nil, err

in pkg/sql.(*connExecutor).execStmtInOpenState

cockroach/pkg/sql/conn_executor_exec.go

Lines 86 to 88 in d7c9973

	case stateOpen:
	ev, payload, err = ex.execStmtInOpenState(ctx, stmt, pinfo, res)
	case stateAborted, stateRestartWait:

in pkg/sql.(*connExecutor).execStmt

cockroach/pkg/sql/conn_executor.go

Lines 963 to 965 in d7c9973

	ctx := withStatement(ex.Ctx(), ex.curStmt)
	ev, payload, err = ex.execStmt(ctx, curStmt, stmtRes, pinfo, pos)
	if err != nil {

in pkg/sql.(*connExecutor).run

cockroach/pkg/sql/conn_executor.go

Lines 490 to 492 in d7c9973

	}()
	return ex.run(ctx)
	}

in pkg/sql.(*Server).ServeConn

cockroach/pkg/sql/pgwire/conn.go

Lines 259 to 261 in d7c9973

	go func() {
	writerErr = sqlServer.ServeConn(
	processorCtx, c.sessionArgs, c.stmtBuf, c, reserved, &c.metrics.SQLMemMetrics)

in pkg/sql/pgwire.(*conn).serveImpl.func3

pkg/sql/conn_executor.go in pkg/sql.(*Server).ServeConn.func2 at line 489
/usr/local/go/src/runtime/asm_amd64.s in runtime.call32 at line 573
/usr/local/go/src/runtime/panic.go in runtime.gopanic at line 505
pkg/util/mon/bytes_usage.go in pkg/util/mon.(*BytesMonitor).releaseBytes at line 606
pkg/util/mon/bytes_usage.go in pkg/util/mon.(*BoundAccount).Close at line 494
pkg/sql/distsqlrun/flow.go in pkg/sql/distsqlrun.(*Flow).Cleanup at line 502
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).Run at line 224
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).PlanAndRun at line 532
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execWithDistSQLEngine at line 672
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).dispatchToExecutionEngine at line 580
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmtInOpenState at line 349
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmt at line 87
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).run at line 964
pkg/sql/conn_executor.go in pkg/sql.(*Server).ServeConn at line 491
pkg/sql/pgwire/conn.go in pkg/sql/pgwire.(*conn).serveImpl.func3 at line 260

Tag	Value
Cockroach Release	v2.0.4
Cockroach SHA:	d7c9973
Platform	linux amd64
Distribution	CCL
Environment	v2.0.4
Command	server
Go Version	go1.10
# of CPUs	2
# of Goroutines	123

[jordanlewis]

This is fixed by #34935.