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: errors.go:91: referenced descriptor ID 1268: looking up ID 1268: descriptor not found (1) assertion failure Wraps: (2) attached stack trace -- stack trace: | github.com/cockroachdb/cockroa... #112802

Closed
cockroach-sentry opened this issue Oct 20, 2023 · 1 comment
Closed

Sentry: errors.go:91: referenced descriptor ID 1268: looking up ID 1268: descriptor not found (1) assertion failure Wraps: (2) attached stack trace -- stack trace: | github.com/cockroachdb/cockroa... #112802

cockroach-sentry opened this issue Oct 20, 2023 · 1 comment
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-sentry
Copy link
Collaborator

cockroach-sentry commented Oct 20, 2023 •
edited by cockroach-jira-scripts
Loading

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

Sentry Link: https://cockroach-labs.sentry.io/issues/4562345958/?referrer=webhooks_plugin

Panic Message:

errors.go:91: referenced descriptor ID 1268: looking up ID 1268: descriptor not found
(1) assertion failure
Wraps: (2) attached stack trace
  -- stack trace:
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/catkv.wrapError
  | 	github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/catkv/catalog_query.go:173
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/catkv.catalogQuery.processDescriptorResultRow
  | 	github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/catkv/catalog_query.go:116
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/catkv.catalogQuery.query
  | 	github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/catkv/catalog_query.go:75
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/catkv.catalogReader.GetByIDs
  | 	github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/catkv/catalog_reader.go:277
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/catkv.(*cachedCatalogReader).GetByIDs
  | 	github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/catkv/catalog_reader_cached.go:340
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/descs.getDescriptorsByID
  | 	github.com/cockroachdb/cockroach/pkg/sql/catalog/descs/descriptor.go:207
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/descs.getDescriptorByName
  | 	github.com/cockroachdb/cockroach/pkg/sql/catalog/descs/descriptor.go:406
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/descs.ByNameGetter.Schema
  | 	github.com/cockroachdb/cockroach/pkg/sql/catalog/descs/getters.go:269
  | github.com/cockroachdb/cockroach/pkg/sql.(*schemaResolver).LookupSchema
  | 	github.com/cockroachdb/cockroach/pkg/sql/schema_resolver.go:196
  | github.com/cockroachdb/cockroach/pkg/sql.maybeLookUpUDF
  | 	github.com/cockroachdb/cockroach/pkg/sql/schema_resolver.go:545
  | github.com/cockroachdb/cockroach/pkg/sql.(*schemaResolver).ResolveFunction
  | 	github.com/cockroachdb/cockroach/pkg/sql/schema_resolver.go:450
  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*ResolvableFunctionReference).Resolve
  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/function_name.go:113
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*scope).VisitPre
  | 	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/scope.go:1061
  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.WalkExpr
  | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:831
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*scope).walkExprTree
  | 	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/scope.go:428
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*scope).resolveType
  | 	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/scope.go:467
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).analyzeSelectList
  | 	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/project.go:179
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).analyzeProjectionList
  | 	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/project.go:95
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelectClause
  | 	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:1132
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelectStmtWithoutParens
  | 	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:1069
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelect.func1
  | 	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:1038
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).processWiths
  | 	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/with.go:116
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelect
  | 	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:1037
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildStmt
  | 	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/builder.go:332
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildStmtAtRoot
  | 	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/builder.go:272
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).Build
  | 	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/builder.go:246
  | github.com/cockroachdb/cockroach/pkg/sql.(*optPlanningCtx).buildExecMemo
  | 	github.com/cockroachdb/cockroach/pkg/sql/plan_opt.go:576
  | github.com/cockroachdb/cockroach/pkg/sql.(*planner).makeOptimizerPlan
  | 	github.com/cockroachdb/cockroach/pkg/sql/plan_opt.go:240
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).makeExecPlan
  | 	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:2030
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).dispatchToExecutionEngine
  | 	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1539
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmtInOpenState
  | 	github.com/cockroachdb/cockroach/pkg/sql/conn_executor_exec.go:1036
Wraps: (3) referenced descriptor ID 1268
Wraps: (4) secondary error attachment
  | failed to find descriptor [1268]
  | (1) attached stack trace
  |   -- stack trace:
  |   | github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/catkv.requiredError
  |   | 	github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/catkv/catalog_query.go:215
  |   | github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/catkv.build
  |   | 	github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/catkv/catalog_query.go:187
  |   | github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/catkv.catalogQuery.processDescriptorResultRow
  |   | 	github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/catkv/catalog_query.go:114
  |   | github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/catkv.catalogQuery.query
  |   | 	github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/catkv/catalog_query.go:75
  |   | github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/catkv.catalogReader.GetByIDs
  |   | 	github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/catkv/catalog_reader.go:277
  |   | github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/catkv.(*cachedCatalogReader).GetByIDs
  |   | 	github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/catkv/catalog_reader_cached.go:340
  |   | github.com/cockroachdb/cockroach/pkg/sql/catalog/descs.getDescriptorsByID
  |   | 	github.com/cockroachdb/cockroach/pkg/sql/catalog/descs/descriptor.go:207
  |   | github.com/cockroachdb/cockroach/pkg/sql/catalog/descs.getDescriptorByName
  |   | 	github.com/cockroachdb/cockroach/pkg/sql/catalog/descs/descriptor.go:406
  |   | github.com/cockroachdb/cockroach/pkg/sql/catalog/descs.ByNameGetter.Schema
  |   | 	github.com/cockroachdb/cockroach/pkg/sql/catalog/descs/getters.go:269
  |   | github.com/cockroachdb/cockroach/pkg/sql.(*schemaResolver).LookupSchema
  |   | 	github.com/cockroachdb/cockroach/pkg/sql/schema_resolver.go:196
  |   | github.com/cockroachdb/cockroach/pkg/sql.maybeLookUpUDF
  |   | 	github.com/cockroachdb/cockroach/pkg/sql/schema_resolver.go:545
  |   | github.com/cockroachdb/cockroach/pkg/sql.(*schemaResolver).ResolveFunction
  |   | 	github.com/cockroachdb/cockroach/pkg/sql/schema_resolver.go:450
  |   | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*ResolvableFunctionReference).Resolve
  |   | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/function_name.go:113
  |   | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*scope).VisitPre
  |   | 	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/scope.go:1061
  |   | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.WalkExpr
  |   | 	github.com/cockroachdb/cockroach/pkg/sql/sem/tree/walk.go:831
  |   | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*scope).walkExprTree
  |   | 	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/scope.go:428
  |   | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*scope).resolveType
  |   | 	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/scope.go:467
  |   | github.com/cockroachdb/cockroach/pkg/sql...
Stacktrace (expand for inline code snippets):

cockroach/pkg/sql/conn_executor_exec.go

Lines 141 to 143 in 28b2e76

err = ex.execWithProfiling(ctx, ast, preparedStmt, func(ctx context.Context) error {
ev, payload, err = ex.execStmtInOpenState(ctx, parserStmt, portal, pinfo, res, canAutoCommit)
return err

cockroach/pkg/sql/conn_executor_exec.go

Lines 1035 to 1037 in 28b2e76

if err = ex.dispatchToExecutionEngine(stmtCtx, p, res); err != nil {
stmtThresholdSpan.Finish()

cockroach/pkg/sql/conn_executor_exec.go

Lines 1538 to 1540 in 28b2e76

// between here and there needs to happen even if there's an error.
err = ex.makeExecPlan(ctx, planner)
defer planner.curPlan.close(ctx)

cockroach/pkg/sql/conn_executor_exec.go

Lines 2029 to 2031 in 28b2e76

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)

cockroach/pkg/sql/plan_opt.go

Lines 239 to 241 in 28b2e76

execMemo, err := opc.buildExecMemo(ctx)
if err != nil {

cockroach/pkg/sql/plan_opt.go

Lines 575 to 577 in 28b2e76

bld := optbuilder.New(ctx, &p.semaCtx, p.EvalContext(), opc.catalog, f, opc.p.stmt.AST)
if err := bld.Build(); err != nil {
return nil, err

cockroach/pkg/sql/opt/optbuilder/builder.go

Lines 245 to 247 in 28b2e76

// and physical properties.
outScope := b.buildStmtAtRoot(b.stmt, nil /* desiredTypes */)

cockroach/pkg/sql/opt/optbuilder/builder.go

Lines 271 to 273 in 28b2e76

b.ctes = nil
outScope = b.buildStmt(stmt, desiredTypes, inScope)
// Build With operators for any CTEs hoisted to the top level.

cockroach/pkg/sql/opt/optbuilder/builder.go

Lines 331 to 333 in 28b2e76

case *tree.Select:
return b.buildSelect(stmt, noRowLocking, desiredTypes, inScope)

cockroach/pkg/sql/opt/optbuilder/select.go

Lines 1036 to 1038 in 28b2e76

return b.processWiths(with, inScope, func(inScope *scope) *scope {
return b.buildSelectStmtWithoutParens(

cockroach/pkg/sql/opt/optbuilder/with.go

Lines 115 to 117 in 28b2e76

inScope.atRoot = false
outScope := buildStmt(inScope)
outScope.expr = b.buildWiths(outScope.expr, correlatedCTEs)

cockroach/pkg/sql/opt/optbuilder/select.go

Lines 1037 to 1039 in 28b2e76

return b.processWiths(with, inScope, func(inScope *scope) *scope {
return b.buildSelectStmtWithoutParens(
wrapped, orderBy, limit, locking, desiredTypes, inScope,

cockroach/pkg/sql/opt/optbuilder/select.go

Lines 1068 to 1070 in 28b2e76

case *tree.SelectClause:
outScope = b.buildSelectClause(t, orderBy, locking, desiredTypes, inScope)

cockroach/pkg/sql/opt/optbuilder/select.go

Lines 1131 to 1133 in 28b2e76

// aggInScope and aggOutScope.
b.analyzeProjectionList(&sel.Exprs, desiredTypes, fromScope, projectionsScope)

cockroach/pkg/sql/opt/optbuilder/project.go

Lines 94 to 96 in 28b2e76

b.analyzeSelectList(selects, desiredTypes, inScope, outScope)
}

cockroach/pkg/sql/opt/optbuilder/project.go

Lines 178 to 180 in 28b2e76

texpr = inScope.resolveType(e.Expr, desired)
}

cockroach/pkg/sql/opt/optbuilder/scope.go

Lines 466 to 468 in 28b2e76

func (s *scope) resolveType(expr tree.Expr, desired *types.T) tree.TypedExpr {
expr = s.walkExprTree(expr)
texpr, err := tree.TypeCheck(s.builder.ctx, expr, s.builder.semaCtx, desired)

cockroach/pkg/sql/opt/optbuilder/scope.go

Lines 427 to 429 in 28b2e76

expr, _ = tree.WalkExpr(s, expr)
s.builder.semaCtx.IVarContainer = s

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

Lines 830 to 832 in 28b2e76

func WalkExpr(v Visitor, expr Expr) (newExpr Expr, changed bool) {
recurse, newExpr := v.VisitPre(expr)

cockroach/pkg/sql/opt/optbuilder/scope.go

Lines 1060 to 1062 in 28b2e76

// can handle overloads with the same name.
def, err := t.Func.Resolve(s.builder.ctx, semaCtx.SearchPath, semaCtx.FunctionResolver)
if err != nil {

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

Lines 112 to 114 in 28b2e76

// Use the resolver if it is provided.
fd, err := resolver.ResolveFunction(ctx, t, path)
if err != nil {

cockroach/pkg/sql/schema_resolver.go

Lines 449 to 451 in 28b2e76

}
udfDef, err := maybeLookUpUDF(ctx, sr, path, fn)
if err != nil {

cockroach/pkg/sql/schema_resolver.go

Lines 544 to 546 in 28b2e76

schema := path.GetSchema(i)
found, prefix, err := sr.LookupSchema(ctx, sr.CurrentDatabase(), schema)
if err != nil {

cockroach/pkg/sql/schema_resolver.go

Lines 195 to 197 in 28b2e76

}
sc, err := g.Schema(ctx, db, scName)
if err != nil || sc == nil {

cockroach/pkg/sql/catalog/descs/getters.go

Lines 268 to 270 in 28b2e76

) (catalog.SchemaDescriptor, error) {
desc, err := getDescriptorByName(
ctx, g.KV(), g.Descriptors(), db, nil /* sc */, name, g.flags, catalog.Schema,

cockroach/pkg/sql/catalog/descs/descriptor.go

Lines 405 to 407 in 28b2e76

var arr [1]catalog.Descriptor
err = getDescriptorsByID(ctx, tc, txn, flags, arr[:], id)
if err == nil {

cockroach/pkg/sql/catalog/descs/descriptor.go

Lines 206 to 208 in 28b2e76

const isDescriptorRequired = true
read, err := tc.cr.GetByIDs(ctx, txn, readIDs.Ordered(), isDescriptorRequired, catalog.Any)
if err != nil {

cockroach/pkg/sql/catalog/internal/catkv/catalog_reader_cached.go

Lines 339 to 341 in 28b2e76

uncachedIDs := ids[:numUncached]
read, err := c.cr.GetByIDs(ctx, txn, uncachedIDs, isDescriptorRequired, expectedType)
if err != nil {

cockroach/pkg/sql/catalog/internal/catkv/catalog_reader.go

Lines 276 to 278 in 28b2e76

err := cq.query(ctx, txn, &mc, func(codec keys.SQLCodec, b *kv.Batch) {
// Attempt to generate a optimal set of requests by extracting

cockroach/pkg/sql/catalog/internal/catkv/catalog_query.go

Lines 74 to 76 in 28b2e76

case keys.DescriptorTableID:
err = cq.processDescriptorResultRow(row, out)
case keys.CommentsTableID:

cockroach/pkg/sql/catalog/internal/catkv/catalog_query.go

Lines 115 to 117 in 28b2e76

if err != nil {
return wrapError(expectedType, id, err)
}

cockroach/pkg/sql/catalog/internal/catkv/catalog_query.go

Lines 172 to 174 in 28b2e76

}
return errors.Wrapf(err, "referenced descriptor ID %d", id)
}

cockroach/pkg/sql/conn_executor_exec.go

Lines 1538 to 1540 in 28b2e76

// between here and there needs to happen even if there's an error.
err = ex.makeExecPlan(ctx, planner)
defer planner.curPlan.close(ctx)

cockroach/pkg/sql/conn_executor_exec.go

Lines 2029 to 2031 in 28b2e76

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)

cockroach/pkg/sql/plan_opt.go

Lines 239 to 241 in 28b2e76

execMemo, err := opc.buildExecMemo(ctx)
if err != nil {

cockroach/pkg/sql/plan_opt.go

Lines 575 to 577 in 28b2e76

bld := optbuilder.New(ctx, &p.semaCtx, p.EvalContext(), opc.catalog, f, opc.p.stmt.AST)
if err := bld.Build(); err != nil {
return nil, err

cockroach/pkg/sql/opt/optbuilder/builder.go

Lines 245 to 247 in 28b2e76

// and physical properties.
outScope := b.buildStmtAtRoot(b.stmt, nil /* desiredTypes */)

cockroach/pkg/sql/opt/optbuilder/builder.go

Lines 271 to 273 in 28b2e76

b.ctes = nil
outScope = b.buildStmt(stmt, desiredTypes, inScope)
// Build With operators for any CTEs hoisted to the top level.

cockroach/pkg/sql/opt/optbuilder/builder.go

Lines 331 to 333 in 28b2e76

case *tree.Select:
return b.buildSelect(stmt, noRowLocking, desiredTypes, inScope)

cockroach/pkg/sql/opt/optbuilder/select.go

Lines 1036 to 1038 in 28b2e76

return b.processWiths(with, inScope, func(inScope *scope) *scope {
return b.buildSelectStmtWithoutParens(

cockroach/pkg/sql/opt/optbuilder/with.go

Lines 115 to 117 in 28b2e76

inScope.atRoot = false
outScope := buildStmt(inScope)
outScope.expr = b.buildWiths(outScope.expr, correlatedCTEs)

cockroach/pkg/sql/opt/optbuilder/select.go

Lines 1037 to 1039 in 28b2e76

return b.processWiths(with, inScope, func(inScope *scope) *scope {
return b.buildSelectStmtWithoutParens(
wrapped, orderBy, limit, locking, desiredTypes, inScope,

cockroach/pkg/sql/opt/optbuilder/select.go

Lines 1068 to 1070 in 28b2e76

case *tree.SelectClause:
outScope = b.buildSelectClause(t, orderBy, locking, desiredTypes, inScope)

cockroach/pkg/sql/opt/optbuilder/select.go

Lines 1131 to 1133 in 28b2e76

// aggInScope and aggOutScope.
b.analyzeProjectionList(&sel.Exprs, desiredTypes, fromScope, projectionsScope)

cockroach/pkg/sql/opt/optbuilder/project.go

Lines 94 to 96 in 28b2e76

b.analyzeSelectList(selects, desiredTypes, inScope, outScope)
}

cockroach/pkg/sql/opt/optbuilder/project.go

Lines 178 to 180 in 28b2e76

texpr = inScope.resolveType(e.Expr, desired)
}

cockroach/pkg/sql/opt/optbuilder/scope.go

Lines 466 to 468 in 28b2e76

func (s *scope) resolveType(expr tree.Expr, desired *types.T) tree.TypedExpr {
expr = s.walkExprTree(expr)
texpr, err := tree.TypeCheck(s.builder.ctx, expr, s.builder.semaCtx, desired)

cockroach/pkg/sql/opt/optbuilder/scope.go

Lines 427 to 429 in 28b2e76

expr, _ = tree.WalkExpr(s, expr)
s.builder.semaCtx.IVarContainer = s

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

Lines 830 to 832 in 28b2e76

func WalkExpr(v Visitor, expr Expr) (newExpr Expr, changed bool) {
recurse, newExpr := v.VisitPre(expr)

cockroach/pkg/sql/opt/optbuilder/scope.go

Lines 1060 to 1062 in 28b2e76

// can handle overloads with the same name.
def, err := t.Func.Resolve(s.builder.ctx, semaCtx.SearchPath, semaCtx.FunctionResolver)
if err != nil {

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

Lines 112 to 114 in 28b2e76

// Use the resolver if it is provided.
fd, err := resolver.ResolveFunction(ctx, t, path)
if err != nil {

cockroach/pkg/sql/schema_resolver.go

Lines 449 to 451 in 28b2e76

}
udfDef, err := maybeLookUpUDF(ctx, sr, path, fn)
if err != nil {

cockroach/pkg/sql/schema_resolver.go

Lines 544 to 546 in 28b2e76

schema := path.GetSchema(i)
found, prefix, err := sr.LookupSchema(ctx, sr.CurrentDatabase(), schema)
if err != nil {

cockroach/pkg/sql/schema_resolver.go

Lines 195 to 197 in 28b2e76

}
sc, err := g.Schema(ctx, db, scName)
if err != nil || sc == nil {

cockroach/pkg/sql/catalog/descs/getters.go

Lines 268 to 270 in 28b2e76

) (catalog.SchemaDescriptor, error) {
desc, err := getDescriptorByName(
ctx, g.KV(), g.Descriptors(), db, nil /* sc */, name, g.flags, catalog.Schema,

cockroach/pkg/sql/catalog/descs/descriptor.go

Lines 405 to 407 in 28b2e76

var arr [1]catalog.Descriptor
err = getDescriptorsByID(ctx, tc, txn, flags, arr[:], id)
if err == nil {

cockroach/pkg/sql/catalog/descs/descriptor.go

Lines 206 to 208 in 28b2e76

const isDescriptorRequired = true
read, err := tc.cr.GetByIDs(ctx, txn, readIDs.Ordered(), isDescriptorRequired, catalog.Any)
if err != nil {

cockroach/pkg/sql/catalog/internal/catkv/catalog_reader_cached.go

Lines 339 to 341 in 28b2e76

uncachedIDs := ids[:numUncached]
read, err := c.cr.GetByIDs(ctx, txn, uncachedIDs, isDescriptorRequired, expectedType)
if err != nil {

cockroach/pkg/sql/catalog/internal/catkv/catalog_reader.go

Lines 276 to 278 in 28b2e76

err := cq.query(ctx, txn, &mc, func(codec keys.SQLCodec, b *kv.Batch) {
// Attempt to generate a optimal set of requests by extracting

cockroach/pkg/sql/catalog/internal/catkv/catalog_query.go

Lines 74 to 76 in 28b2e76

case keys.DescriptorTableID:
err = cq.processDescriptorResultRow(row, out)
case keys.CommentsTableID:

cockroach/pkg/sql/catalog/internal/catkv/catalog_query.go

Lines 113 to 115 in 28b2e76

}
desc, err := build(expectedType, id, row.Value, cq.isDescriptorRequired)
if err != nil {

cockroach/pkg/sql/catalog/internal/catkv/catalog_query.go

Lines 186 to 188 in 28b2e76

if isRequired {
return nil, requiredError(expectedType, id)
}

cockroach/pkg/sql/catalog/internal/catkv/catalog_query.go

Lines 216 to 218 in 28b2e76

}
return errors.CombineErrors(catalog.NewDescriptorNotFoundError(id), err)
}

cockroach/pkg/sql/catalog/errors.go

Lines 93 to 95 in 28b2e76

func NewDescriptorNotFoundError(id descpb.ID) error {
return errors.Wrapf(ErrDescriptorNotFound, "looking up ID %d", errors.Safe(id))
}

src/runtime/asm_amd64.s#L1593-L1595
GOROOT/src/runtime/proc.go#L232-L234
GOROOT/src/runtime/proc.go#L6325-L6327
GOROOT/src/runtime/proc.go#L6325-L6327
GOROOT/src/runtime/proc.go#L6325-L6327
GOROOT/src/runtime/proc.go#L6325-L6327
GOROOT/src/runtime/proc.go#L6325-L6327
GOROOT/src/runtime/proc.go#L6348-L6350

cockroach/pkg/sql/catalog/errors.go

Lines 90 to 92 in 28b2e76

// found with the given id.
var ErrDescriptorNotFound = errors.New("descriptor not found") 

pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmt.func1 at line 142
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmtInOpenState at line 1036
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).dispatchToExecutionEngine at line 1539
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).makeExecPlan at line 2030
pkg/sql/plan_opt.go in pkg/sql.(*planner).makeOptimizerPlan at line 240
pkg/sql/plan_opt.go in pkg/sql.(*optPlanningCtx).buildExecMemo at line 576
pkg/sql/opt/optbuilder/builder.go in pkg/sql/opt/optbuilder.(*Builder).Build at line 246
pkg/sql/opt/optbuilder/builder.go in pkg/sql/opt/optbuilder.(*Builder).buildStmtAtRoot at line 272
pkg/sql/opt/optbuilder/builder.go in pkg/sql/opt/optbuilder.(*Builder).buildStmt at line 332
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildSelect at line 1037
pkg/sql/opt/optbuilder/with.go in pkg/sql/opt/optbuilder.(*Builder).processWiths at line 116
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildSelect.func1 at line 1038
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildSelectStmtWithoutParens at line 1069
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildSelectClause at line 1132
pkg/sql/opt/optbuilder/project.go in pkg/sql/opt/optbuilder.(*Builder).analyzeProjectionList at line 95
pkg/sql/opt/optbuilder/project.go in pkg/sql/opt/optbuilder.(*Builder).analyzeSelectList at line 179
pkg/sql/opt/optbuilder/scope.go in pkg/sql/opt/optbuilder.(*scope).resolveType at line 467
pkg/sql/opt/optbuilder/scope.go in pkg/sql/opt/optbuilder.(*scope).walkExprTree at line 428
pkg/sql/sem/tree/walk.go in pkg/sql/sem/tree.WalkExpr at line 831
pkg/sql/opt/optbuilder/scope.go in pkg/sql/opt/optbuilder.(*scope).VisitPre at line 1061
pkg/sql/sem/tree/function_name.go in pkg/sql/sem/tree.(*ResolvableFunctionReference).Resolve at line 113
pkg/sql/schema_resolver.go in pkg/sql.(*schemaResolver).ResolveFunction at line 450
pkg/sql/schema_resolver.go in pkg/sql.maybeLookUpUDF at line 545
pkg/sql/schema_resolver.go in pkg/sql.(*schemaResolver).LookupSchema at line 196
pkg/sql/catalog/descs/getters.go in pkg/sql/catalog/descs.ByNameGetter.Schema at line 269
pkg/sql/catalog/descs/descriptor.go in pkg/sql/catalog/descs.getDescriptorByName at line 406
pkg/sql/catalog/descs/descriptor.go in pkg/sql/catalog/descs.getDescriptorsByID at line 207
pkg/sql/catalog/internal/catkv/catalog_reader_cached.go in pkg/sql/catalog/internal/catkv.(*cachedCatalogReader).GetByIDs at line 340
pkg/sql/catalog/internal/catkv/catalog_reader.go in pkg/sql/catalog/internal/catkv.catalogReader.GetByIDs at line 277
pkg/sql/catalog/internal/catkv/catalog_query.go in pkg/sql/catalog/internal/catkv.catalogQuery.query at line 75
pkg/sql/catalog/internal/catkv/catalog_query.go in pkg/sql/catalog/internal/catkv.catalogQuery.processDescriptorResultRow at line 116
pkg/sql/catalog/internal/catkv/catalog_query.go in pkg/sql/catalog/internal/catkv.wrapError at line 173
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).dispatchToExecutionEngine at line 1539
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).makeExecPlan at line 2030
pkg/sql/plan_opt.go in pkg/sql.(*planner).makeOptimizerPlan at line 240
pkg/sql/plan_opt.go in pkg/sql.(*optPlanningCtx).buildExecMemo at line 576
pkg/sql/opt/optbuilder/builder.go in pkg/sql/opt/optbuilder.(*Builder).Build at line 246
pkg/sql/opt/optbuilder/builder.go in pkg/sql/opt/optbuilder.(*Builder).buildStmtAtRoot at line 272
pkg/sql/opt/optbuilder/builder.go in pkg/sql/opt/optbuilder.(*Builder).buildStmt at line 332
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildSelect at line 1037
pkg/sql/opt/optbuilder/with.go in pkg/sql/opt/optbuilder.(*Builder).processWiths at line 116
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildSelect.func1 at line 1038
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildSelectStmtWithoutParens at line 1069
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildSelectClause at line 1132
pkg/sql/opt/optbuilder/project.go in pkg/sql/opt/optbuilder.(*Builder).analyzeProjectionList at line 95
pkg/sql/opt/optbuilder/project.go in pkg/sql/opt/optbuilder.(*Builder).analyzeSelectList at line 179
pkg/sql/opt/optbuilder/scope.go in pkg/sql/opt/optbuilder.(*scope).resolveType at line 467
pkg/sql/opt/optbuilder/scope.go in pkg/sql/opt/optbuilder.(*scope).walkExprTree at line 428
pkg/sql/sem/tree/walk.go in pkg/sql/sem/tree.WalkExpr at line 831
pkg/sql/opt/optbuilder/scope.go in pkg/sql/opt/optbuilder.(*scope).VisitPre at line 1061
pkg/sql/sem/tree/function_name.go in pkg/sql/sem/tree.(*ResolvableFunctionReference).Resolve at line 113
pkg/sql/schema_resolver.go in pkg/sql.(*schemaResolver).ResolveFunction at line 450
pkg/sql/schema_resolver.go in pkg/sql.maybeLookUpUDF at line 545
pkg/sql/schema_resolver.go in pkg/sql.(*schemaResolver).LookupSchema at line 196
pkg/sql/catalog/descs/getters.go in pkg/sql/catalog/descs.ByNameGetter.Schema at line 269
pkg/sql/catalog/descs/descriptor.go in pkg/sql/catalog/descs.getDescriptorByName at line 406
pkg/sql/catalog/descs/descriptor.go in pkg/sql/catalog/descs.getDescriptorsByID at line 207
pkg/sql/catalog/internal/catkv/catalog_reader_cached.go in pkg/sql/catalog/internal/catkv.(*cachedCatalogReader).GetByIDs at line 340
pkg/sql/catalog/internal/catkv/catalog_reader.go in pkg/sql/catalog/internal/catkv.catalogReader.GetByIDs at line 277
pkg/sql/catalog/internal/catkv/catalog_query.go in pkg/sql/catalog/internal/catkv.catalogQuery.query at line 75
pkg/sql/catalog/internal/catkv/catalog_query.go in pkg/sql/catalog/internal/catkv.catalogQuery.processDescriptorResultRow at line 114
pkg/sql/catalog/internal/catkv/catalog_query.go in pkg/sql/catalog/internal/catkv.build at line 187
pkg/sql/catalog/internal/catkv/catalog_query.go in pkg/sql/catalog/internal/catkv.requiredError at line 217
pkg/sql/catalog/errors.go in pkg/sql/catalog.NewDescriptorNotFoundError at line 94
src/runtime/asm_amd64.s in runtime.goexit at line 1594
GOROOT/src/runtime/proc.go in runtime.main at line 233
GOROOT/src/runtime/proc.go in runtime.doInit at line 6326
GOROOT/src/runtime/proc.go in runtime.doInit at line 6326
GOROOT/src/runtime/proc.go in runtime.doInit at line 6326
GOROOT/src/runtime/proc.go in runtime.doInit at line 6326
GOROOT/src/runtime/proc.go in runtime.doInit at line 6326
GOROOT/src/runtime/proc.go in runtime.doInit at line 6349
pkg/sql/catalog/errors.go in pkg/sql/catalog.init at line 91

Tags

Tag Value
Command demo
Environment v23.1.9
Go Version go1.19.10
Platform darwin amd64
Distribution CCL
Cockroach Release v23.1.9
Cockroach SHA 28b2e76
# of CPUs 16
# of Goroutines 475

Jira issue: CRDB-32600
@cockroach-sentry cockroach-sentry added O-sentry Originated from an in-the-wild panic report. C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. labels Oct 20, 2023
@yuzefovich
Copy link
Member

dup of #105257

@exalate-issue-sync exalate-issue-sync bot changed the title Sentry: errors.go:91: referenced descriptor ID 1268: looking up ID 1268: descriptor not found (1) assertion failure Wraps: (2) attached stack trace -- stack trace: | github.com/cockroachdb/cockroa... Sentry: errors.go:91: referenced descriptor ID 1268: looking up ID 1268: descriptor not found (1) assertion failure Wraps: (2) attached stack trace -- stack trace: | github.com/cockroachdb/cockroa... Nov 18, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
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
@yuzefovich @cockroach-sentry