sql: v23.1.1: index out of bounds in tree.(*Annotations).Get

[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://cockroach-labs.sentry.io/issues/4190316917/?referrer=webhooks_plugin

Panic message:

conn_executor.go:865: runtime error: index out of range [1] with length 0
(1) attached stack trace
-- stack trace:
| github.com/cockroachdb/cockroach/pkg/sql.(*Server).ServeConn.func1
| github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:865
| [...repeated from below...]
Wraps: (2) attached stack trace
-- stack trace:
| github.com/cockroachdb/cockroach/pkg/sql.(*Server).ServeConn.func1
| github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:865
| runtime.gopanic
| GOROOT/src/runtime/panic.go:884
| runtime.goPanicIndex
| GOROOT/src/runtime/panic.go:113
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*Annotations).Get
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree/annotation.go:53
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree.AnnotatedNode.GetAnnotation
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree/annotation.go:30
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*UnresolvedObjectName).Resolved
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree/object_name.go:180
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*UnresolvedObjectName).Format
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree/object_name.go:201
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*FmtCtx).formatNodeMaybeMarkRedaction
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree/format.go:692
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*FmtCtx).FormatNode
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree/format.go:466
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*FmtCtx).FormatTypeReference
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree/type_name.go:213
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*CastExpr).Format
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree/expr.go:1505
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*FmtCtx).formatNodeMaybeMarkRedaction
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree/format.go:692
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*FmtCtx).FormatNode
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree/format.go:466
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree.exprFmtWithParen
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree/expr.go:135
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree.binExprFmtWithParen
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree/expr.go:168
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*RangeCond).Format
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree/expr.go:537
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*FmtCtx).formatNodeMaybeMarkRedaction
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree/format.go:692
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*FmtCtx).FormatNode
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree/format.go:466
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*Where).Format
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree/select.go:745
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*FmtCtx).formatNodeMaybeMarkRedaction
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree/format.go:692
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*FmtCtx).FormatNode
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree/format.go:466
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*SelectClause).Format
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree/select.go:125
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*FmtCtx).formatNodeMaybeMarkRedaction
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree/format.go:692
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*FmtCtx).FormatNode
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree/format.go:466
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*Select).Format
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree/select.go:57
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*FmtCtx).formatNodeMaybeMarkRedaction
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree/format.go:692
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*FmtCtx).FormatNode
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree/format.go:466
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*CopyTo).Format
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree/copy.go:39
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*FmtCtx).formatNodeMaybeMarkRedaction
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree/format.go:692
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*FmtCtx).FormatNode
| github.com/cockroachdb/cockroach/pkg/sql/sem/tree/format.go:466
| github.com/cockroachdb/cockroach/pkg/sql.formatStmtKeyAsRedactableString
| github.com/cockroachdb/cockroach/pkg/sql/exec_util.go:3600
| github.com/cockroachdb/cockroach/pkg/sql.(*planner).getCommonSQLEventDetails
| github.com/cockroachdb/cockroach/pkg/sql/event_log.go:193
Wraps: (3) runtime error: index out of range [1] with length 0
Error types: (1) *withstack.withStack (2) *withstack.withStack (3) runtime.boundsError
-- report composition:
runtime.boundsError
conn_executor.go:865: *withstack.withStack (top exception)
conn_executor.go:865: *withstack.withStack (1)
(check the extra data payloads)

Stacktrace (expand for inline code snippets):

cockroach/pkg/sql/conn_executor.go

Lines 864 to 866 in 00f65ea

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

in pkg/sql.(*Server).ServeConn.func1
GOROOT/src/runtime/panic.go#L883-L885 in runtime.gopanic
GOROOT/src/runtime/panic.go#L112-L114 in runtime.goPanicIndex

cockroach/pkg/sql/sem/tree/annotation.go

Lines 52 to 54 in 00f65ea

	func (a *Annotations) Get(idx AnnotationIdx) interface{} {
	return (*a)[idx-1]
	}

in pkg/sql/sem/tree.(*Annotations).Get

cockroach/pkg/sql/sem/tree/annotation.go

Lines 29 to 31 in 00f65ea

	}
	return ann.Get(n.AnnIdx)
	}

in pkg/sql/sem/tree.AnnotatedNode.GetAnnotation

cockroach/pkg/sql/sem/tree/object_name.go

Lines 179 to 181 in 00f65ea

	func (u *UnresolvedObjectName) Resolved(ann *Annotations) ObjectName {
	r := u.GetAnnotation(ann)
	if r == nil {

in pkg/sql/sem/tree.(*UnresolvedObjectName).Resolved

cockroach/pkg/sql/sem/tree/object_name.go

Lines 200 to 202 in 00f65ea

	if n := u.Resolved(ctx.ann); n != nil {
	n.Format(ctx)

in pkg/sql/sem/tree.(*UnresolvedObjectName).Format

cockroach/pkg/sql/sem/tree/format.go

Lines 691 to 693 in 00f65ea

	}
	n.Format(ctx)
	}

in pkg/sql/sem/tree.(*FmtCtx).formatNodeMaybeMarkRedaction

cockroach/pkg/sql/sem/tree/format.go

Lines 465 to 467 in 00f65ea

	if f.HasFlags(FmtMarkRedactionNode) {
	ctx.formatNodeMaybeMarkRedaction(n)
	} else {

in pkg/sql/sem/tree.(*FmtCtx).FormatNode

cockroach/pkg/sql/sem/tree/type_name.go

Lines 212 to 214 in 00f65ea

	case NodeFormatter:
	ctx.FormatNode(t)

in pkg/sql/sem/tree.(*FmtCtx).FormatTypeReference

cockroach/pkg/sql/sem/tree/expr.go

Lines 1504 to 1506 in 00f65ea

	ctx.WriteString("::")
	ctx.FormatTypeReference(node.Type)
	default:

in pkg/sql/sem/tree.(*CastExpr).Format

cockroach/pkg/sql/sem/tree/format.go

Lines 691 to 693 in 00f65ea

	}
	n.Format(ctx)
	}

in pkg/sql/sem/tree.(*FmtCtx).formatNodeMaybeMarkRedaction

cockroach/pkg/sql/sem/tree/format.go

Lines 465 to 467 in 00f65ea

	if f.HasFlags(FmtMarkRedactionNode) {
	ctx.formatNodeMaybeMarkRedaction(n)
	} else {

in pkg/sql/sem/tree.(*FmtCtx).FormatNode

cockroach/pkg/sql/sem/tree/expr.go

Lines 134 to 136 in 00f65ea

	} else {
	ctx.FormatNode(e)
	}

in pkg/sql/sem/tree.exprFmtWithParen

cockroach/pkg/sql/sem/tree/expr.go

Lines 167 to 169 in 00f65ea

	func binExprFmtWithParen(ctx *FmtCtx, e1 Expr, op string, e2 Expr, pad bool) {
	exprFmtWithParen(ctx, e1)
	if pad {

in pkg/sql/sem/tree.binExprFmtWithParen

cockroach/pkg/sql/sem/tree/expr.go

Lines 536 to 538 in 00f65ea

	}
	binExprFmtWithParen(ctx, node.From, "AND", node.To, true)
	}

in pkg/sql/sem/tree.(*RangeCond).Format

cockroach/pkg/sql/sem/tree/format.go

Lines 691 to 693 in 00f65ea

	}
	n.Format(ctx)
	}

in pkg/sql/sem/tree.(*FmtCtx).formatNodeMaybeMarkRedaction

cockroach/pkg/sql/sem/tree/format.go

Lines 465 to 467 in 00f65ea

	if f.HasFlags(FmtMarkRedactionNode) {
	ctx.formatNodeMaybeMarkRedaction(n)
	} else {

in pkg/sql/sem/tree.(*FmtCtx).FormatNode

cockroach/pkg/sql/sem/tree/select.go

Lines 744 to 746 in 00f65ea

	ctx.WriteByte(' ')
	ctx.FormatNode(node.Expr)
	}

in pkg/sql/sem/tree.(*Where).Format

cockroach/pkg/sql/sem/tree/format.go

Lines 691 to 693 in 00f65ea

	}
	n.Format(ctx)
	}

in pkg/sql/sem/tree.(*FmtCtx).formatNodeMaybeMarkRedaction

cockroach/pkg/sql/sem/tree/format.go

Lines 465 to 467 in 00f65ea

	if f.HasFlags(FmtMarkRedactionNode) {
	ctx.formatNodeMaybeMarkRedaction(n)
	} else {

in pkg/sql/sem/tree.(*FmtCtx).FormatNode

cockroach/pkg/sql/sem/tree/select.go

Lines 124 to 126 in 00f65ea

	ctx.WriteByte(' ')
	ctx.FormatNode(node.Where)
	}

in pkg/sql/sem/tree.(*SelectClause).Format

cockroach/pkg/sql/sem/tree/format.go

Lines 691 to 693 in 00f65ea

	}
	n.Format(ctx)
	}

in pkg/sql/sem/tree.(*FmtCtx).formatNodeMaybeMarkRedaction

cockroach/pkg/sql/sem/tree/format.go

Lines 465 to 467 in 00f65ea

	if f.HasFlags(FmtMarkRedactionNode) {
	ctx.formatNodeMaybeMarkRedaction(n)
	} else {

in pkg/sql/sem/tree.(*FmtCtx).FormatNode

cockroach/pkg/sql/sem/tree/select.go

Lines 56 to 58 in 00f65ea

	ctx.FormatNode(node.With)
	ctx.FormatNode(node.Select)
	if len(node.OrderBy) > 0 {

in pkg/sql/sem/tree.(*Select).Format

cockroach/pkg/sql/sem/tree/format.go

Lines 691 to 693 in 00f65ea

	}
	n.Format(ctx)
	}

in pkg/sql/sem/tree.(*FmtCtx).formatNodeMaybeMarkRedaction

cockroach/pkg/sql/sem/tree/format.go

Lines 465 to 467 in 00f65ea

	if f.HasFlags(FmtMarkRedactionNode) {
	ctx.formatNodeMaybeMarkRedaction(n)
	} else {

in pkg/sql/sem/tree.(*FmtCtx).FormatNode

cockroach/pkg/sql/sem/tree/copy.go

Lines 38 to 40 in 00f65ea

	ctx.WriteString("(")
	ctx.FormatNode(node.Statement)
	ctx.WriteString(")")

in pkg/sql/sem/tree.(*CopyTo).Format

cockroach/pkg/sql/sem/tree/format.go

Lines 691 to 693 in 00f65ea

	}
	n.Format(ctx)
	}

in pkg/sql/sem/tree.(*FmtCtx).formatNodeMaybeMarkRedaction

cockroach/pkg/sql/sem/tree/format.go

Lines 465 to 467 in 00f65ea

	if f.HasFlags(FmtMarkRedactionNode) {
	ctx.formatNodeMaybeMarkRedaction(n)
	} else {

in pkg/sql/sem/tree.(*FmtCtx).FormatNode

cockroach/pkg/sql/exec_util.go

Lines 3599 to 3601 in 00f65ea

	tree.FmtReformatTableNames(hideNonVirtualTableNameFunc(vt, ns)))
	f.FormatNode(rootAST)
	formattedRedactableStatementString := f.CloseAndGetString()

in pkg/sql.formatStmtKeyAsRedactableString

cockroach/pkg/sql/event_log.go

Lines 192 to 194 in 00f65ea

	func (p *planner) getCommonSQLEventDetails(opt redactionOptions) eventpb.CommonSQLEventDetails {
	redactableStmt := formatStmtKeyAsRedactableString(
	p.extendedEvalCtx.VirtualSchemas, p.stmt.AST,

in pkg/sql.(*planner).getCommonSQLEventDetails

pkg/sql/conn_executor.go in pkg/sql.(*Server).ServeConn.func1 at line 865
GOROOT/src/runtime/panic.go in runtime.gopanic at line 884
GOROOT/src/runtime/panic.go in runtime.goPanicIndex at line 113
pkg/sql/sem/tree/annotation.go in pkg/sql/sem/tree.(*Annotations).Get at line 53
pkg/sql/sem/tree/annotation.go in pkg/sql/sem/tree.AnnotatedNode.GetAnnotation at line 30
pkg/sql/sem/tree/object_name.go in pkg/sql/sem/tree.(*UnresolvedObjectName).Resolved at line 180
pkg/sql/sem/tree/object_name.go in pkg/sql/sem/tree.(*UnresolvedObjectName).Format at line 201
pkg/sql/sem/tree/format.go in pkg/sql/sem/tree.(*FmtCtx).formatNodeMaybeMarkRedaction at line 692
pkg/sql/sem/tree/format.go in pkg/sql/sem/tree.(*FmtCtx).FormatNode at line 466
pkg/sql/sem/tree/type_name.go in pkg/sql/sem/tree.(*FmtCtx).FormatTypeReference at line 213
pkg/sql/sem/tree/expr.go in pkg/sql/sem/tree.(*CastExpr).Format at line 1505
pkg/sql/sem/tree/format.go in pkg/sql/sem/tree.(*FmtCtx).formatNodeMaybeMarkRedaction at line 692
pkg/sql/sem/tree/format.go in pkg/sql/sem/tree.(*FmtCtx).FormatNode at line 466
pkg/sql/sem/tree/expr.go in pkg/sql/sem/tree.exprFmtWithParen at line 135
pkg/sql/sem/tree/expr.go in pkg/sql/sem/tree.binExprFmtWithParen at line 168
pkg/sql/sem/tree/expr.go in pkg/sql/sem/tree.(*RangeCond).Format at line 537
pkg/sql/sem/tree/format.go in pkg/sql/sem/tree.(*FmtCtx).formatNodeMaybeMarkRedaction at line 692
pkg/sql/sem/tree/format.go in pkg/sql/sem/tree.(*FmtCtx).FormatNode at line 466
pkg/sql/sem/tree/select.go in pkg/sql/sem/tree.(*Where).Format at line 745
pkg/sql/sem/tree/format.go in pkg/sql/sem/tree.(*FmtCtx).formatNodeMaybeMarkRedaction at line 692
pkg/sql/sem/tree/format.go in pkg/sql/sem/tree.(*FmtCtx).FormatNode at line 466
pkg/sql/sem/tree/select.go in pkg/sql/sem/tree.(*SelectClause).Format at line 125
pkg/sql/sem/tree/format.go in pkg/sql/sem/tree.(*FmtCtx).formatNodeMaybeMarkRedaction at line 692
pkg/sql/sem/tree/format.go in pkg/sql/sem/tree.(*FmtCtx).FormatNode at line 466
pkg/sql/sem/tree/select.go in pkg/sql/sem/tree.(*Select).Format at line 57
pkg/sql/sem/tree/format.go in pkg/sql/sem/tree.(*FmtCtx).formatNodeMaybeMarkRedaction at line 692
pkg/sql/sem/tree/format.go in pkg/sql/sem/tree.(*FmtCtx).FormatNode at line 466
pkg/sql/sem/tree/copy.go in pkg/sql/sem/tree.(*CopyTo).Format at line 39
pkg/sql/sem/tree/format.go in pkg/sql/sem/tree.(*FmtCtx).formatNodeMaybeMarkRedaction at line 692
pkg/sql/sem/tree/format.go in pkg/sql/sem/tree.(*FmtCtx).FormatNode at line 466
pkg/sql/exec_util.go in pkg/sql.formatStmtKeyAsRedactableString at line 3600
pkg/sql/event_log.go in pkg/sql.(*planner).getCommonSQLEventDetails at line 193

Tag	Value
Cockroach Release	v23.1.1
Cockroach SHA:	00f65ea
Platform	linux amd64
Distribution	CCL
Environment	v23.1.1
Command	server
Go Version	``
# of CPUs
# of Goroutines

Jira issue: CRDB-28068