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 495: looking up ID 495: descriptor not found (1) assertion failure Wraps: (2) attached stack trace -- stack trace: | github.com/cockroachdb/cockroach... #121170

Closed
cockroach-sentry opened this issue Mar 27, 2024 · 1 comment
Closed

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

cockroach-sentry opened this issue Mar 27, 2024 · 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 Mar 27, 2024 •
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/5104271133/?referrer=webhooks_plugin

Panic Message:

errors.go:91: referenced descriptor ID 495: looking up ID 495: 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/catalog/descs.getObjectPrefix
  | 	github.com/cockroachdb/cockroach/pkg/sql/catalog/descs/helpers.go:102
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/descs.PrefixAndTable
  | 	github.com/cockroachdb/cockroach/pkg/sql/catalog/descs/helpers.go:134
  | github.com/cockroachdb/cockroach/pkg/sql.(*schemaResolver).LookupObject
  | 	github.com/cockroachdb/cockroach/pkg/sql/schema_resolver.go:165
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/resolver.ResolveExisting
  | 	github.com/cockroachdb/cockroach/pkg/sql/catalog/resolver/resolver.go:341
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/resolver.ResolveExistingObject
  | 	github.com/cockroachdb/cockroach/pkg/sql/catalog/resolver/resolver.go:184
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/resolver.ResolveExistingTableObject
  | 	github.com/cockroachdb/cockroach/pkg/sql/catalog/resolver/resolver.go:108
  | github.com/cockroachdb/cockroach/pkg/sql.(*optCatalog).ResolveDataSource
  | 	github.com/cockroachdb/cockroach/pkg/sql/opt_catalog.go:259
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).resolveDataSource
  | 	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/util.go:639
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildDataSource
  | 	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:137
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildDataSource
  | 	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:92
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildFromTablesRightDeep
  | 	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:1296
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildFromTables
  | 	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:1273
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildFrom
  | 	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:1200
  | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildSelectClause
  | 	github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder/select.go:1121
  | 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
Wraps: (3) referenced descriptor ID 495
Wraps: (4) secondary error attachment
  | failed to find descriptor [495]
  | (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/catalog/descs.getObjectPrefix
  |   | 	github.com/cockroachdb/cockroach/pkg/sql/catalog/descs/helpers.go:102
  |   | github.com/cockroachdb/cockroach/pkg/sql/catalog/descs.PrefixAndTable
  |   | 	github.com/cockroachdb/cockroach/pkg/sql/catalog/descs/helpers.go:134
  |   | github.com/cockroachdb/cockroach/pkg/sql.(*schemaResolver).LookupObject
  |   | 	github.com/cockroachdb/cockroach/pkg/sql/schema_resolver.go:165
  |   | github.com/cockroachdb/cockroach/pkg/sql/catalog/resolver.ResolveExisting
  |   | 	github.com/cockroachdb/cockroach/pkg/sql/catalog/resolver/resolver.go:341
  |   | github.com/cockroachdb/cockroach/pkg/sql/catalog/resolver.ResolveExistingObject
  |   | 	github.com/cockroachdb/cockroach/pkg/sql/catalog/resolver/resolver.go:184
  |   | github.com/cockroachdb/cockroach/pkg/sql/catalog/resolver.ResolveExistingTableObject
  |   | 	github.com/cockroachdb/cockroach/pkg/sql/catalog/resolver/resolver.go:108
  |   | github.com/cockroachdb/cockroach/pkg/sql.(*optCatalog).ResolveDataSource
  |   | 	github.com/cockroachdb/cockroach/pkg/sql/opt_catalog.go:259
  |   | github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).resolveDataSource
  |   ...
Stacktrace (expand for inline code snippets):

cockroach/pkg/sql/conn_executor_exec.go

Lines 2027 to 2029 in d7e9824

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 d7e9824

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

cockroach/pkg/sql/plan_opt.go

Lines 575 to 577 in d7e9824

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 d7e9824

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

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

Lines 271 to 273 in d7e9824

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 d7e9824

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

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

Lines 1036 to 1038 in d7e9824

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

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

Lines 115 to 117 in d7e9824

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 d7e9824

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 d7e9824

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

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

Lines 1120 to 1122 in d7e9824

) (outScope *scope) {
fromScope := b.buildFrom(sel.From, locking, inScope)

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

Lines 1199 to 1201 in d7e9824

if len(from.Tables) > 0 {
outScope = b.buildFromTables(from.Tables, locking, inScope)
} else {

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

Lines 1272 to 1274 in d7e9824

}
return b.buildFromTablesRightDeep(tables, locking, inScope)
}

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

Lines 1295 to 1297 in d7e9824

) (outScope *scope) {
outScope = b.buildDataSource(tables[0], nil /* indexFlags */, locking, inScope)

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

Lines 91 to 93 in d7e9824

outScope = b.buildDataSource(source.Expr, indexFlags, locking, inScope)

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

Lines 136 to 138 in d7e9824

ds, depName, resName := b.resolveDataSource(tn, privilege.SELECT)
locking = locking.filter(tn.ObjectName)

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

Lines 638 to 640 in d7e9824

}
ds, resName, err := b.catalog.ResolveDataSource(b.ctx, flags, tn)
if err != nil {

cockroach/pkg/sql/opt_catalog.go

Lines 258 to 260 in d7e9824

}
prefix, desc, err := resolver.ResolveExistingTableObject(ctx, oc.planner, &oc.tn, lflags)
if err != nil {

cockroach/pkg/sql/catalog/resolver/resolver.go

Lines 107 to 109 in d7e9824

un := tn.ToUnresolvedObjectName()
desc, prefix, err := ResolveExistingObject(ctx, sc, un, lookupFlags)
if err != nil || desc == nil {

cockroach/pkg/sql/catalog/resolver/resolver.go

Lines 183 to 185 in d7e9824

) (res catalog.Descriptor, _ catalog.ResolvedObjectPrefix, err error) {
found, prefix, obj, err := ResolveExisting(ctx, un, sc, lookupFlags, sc.CurrentDatabase(), sc.CurrentSearchPath())
if err != nil {

cockroach/pkg/sql/catalog/resolver/resolver.go

Lines 340 to 342 in d7e9824

if isVirtualSchema || curDb != "" {
if found, prefix, result, err = r.LookupObject(
ctx, lookupFlags, curDb, u.Schema(), u.Object(),

cockroach/pkg/sql/schema_resolver.go

Lines 164 to 166 in d7e9824

case tree.TableObject:
prefix, desc, err = descs.PrefixAndTable(ctx, g, &tn)
case tree.TypeObject:

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

Lines 133 to 135 in d7e9824

) (catalog.ResolvedObjectPrefix, catalog.TableDescriptor, error) {
p, err := getObjectPrefix(ctx, g, name.Catalog(), name.Schema())
if err != nil || p.Schema == nil {

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

Lines 101 to 103 in d7e9824

}
prefix.Schema, err = g.Schema(ctx, prefix.Database, scName)
return prefix, err

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

Lines 268 to 270 in d7e9824

) (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 d7e9824

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 d7e9824

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 d7e9824

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 d7e9824

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 d7e9824

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 d7e9824

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

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

Lines 172 to 174 in d7e9824

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

cockroach/pkg/sql/plan_opt.go

Lines 575 to 577 in d7e9824

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 d7e9824

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

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

Lines 271 to 273 in d7e9824

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 d7e9824

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

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

Lines 1036 to 1038 in d7e9824

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

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

Lines 115 to 117 in d7e9824

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 d7e9824

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 d7e9824

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

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

Lines 1120 to 1122 in d7e9824

) (outScope *scope) {
fromScope := b.buildFrom(sel.From, locking, inScope)

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

Lines 1199 to 1201 in d7e9824

if len(from.Tables) > 0 {
outScope = b.buildFromTables(from.Tables, locking, inScope)
} else {

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

Lines 1272 to 1274 in d7e9824

}
return b.buildFromTablesRightDeep(tables, locking, inScope)
}

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

Lines 1295 to 1297 in d7e9824

) (outScope *scope) {
outScope = b.buildDataSource(tables[0], nil /* indexFlags */, locking, inScope)

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

Lines 91 to 93 in d7e9824

outScope = b.buildDataSource(source.Expr, indexFlags, locking, inScope)

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

Lines 136 to 138 in d7e9824

ds, depName, resName := b.resolveDataSource(tn, privilege.SELECT)
locking = locking.filter(tn.ObjectName)

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

Lines 638 to 640 in d7e9824

}
ds, resName, err := b.catalog.ResolveDataSource(b.ctx, flags, tn)
if err != nil {

cockroach/pkg/sql/opt_catalog.go

Lines 258 to 260 in d7e9824

}
prefix, desc, err := resolver.ResolveExistingTableObject(ctx, oc.planner, &oc.tn, lflags)
if err != nil {

cockroach/pkg/sql/catalog/resolver/resolver.go

Lines 107 to 109 in d7e9824

un := tn.ToUnresolvedObjectName()
desc, prefix, err := ResolveExistingObject(ctx, sc, un, lookupFlags)
if err != nil || desc == nil {

cockroach/pkg/sql/catalog/resolver/resolver.go

Lines 183 to 185 in d7e9824

) (res catalog.Descriptor, _ catalog.ResolvedObjectPrefix, err error) {
found, prefix, obj, err := ResolveExisting(ctx, un, sc, lookupFlags, sc.CurrentDatabase(), sc.CurrentSearchPath())
if err != nil {

cockroach/pkg/sql/catalog/resolver/resolver.go

Lines 340 to 342 in d7e9824

if isVirtualSchema || curDb != "" {
if found, prefix, result, err = r.LookupObject(
ctx, lookupFlags, curDb, u.Schema(), u.Object(),

cockroach/pkg/sql/schema_resolver.go

Lines 164 to 166 in d7e9824

case tree.TableObject:
prefix, desc, err = descs.PrefixAndTable(ctx, g, &tn)
case tree.TypeObject:

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

Lines 133 to 135 in d7e9824

) (catalog.ResolvedObjectPrefix, catalog.TableDescriptor, error) {
p, err := getObjectPrefix(ctx, g, name.Catalog(), name.Schema())
if err != nil || p.Schema == nil {

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

Lines 101 to 103 in d7e9824

}
prefix.Schema, err = g.Schema(ctx, prefix.Database, scName)
return prefix, err

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

Lines 268 to 270 in d7e9824

) (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 d7e9824

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 d7e9824

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 d7e9824

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 d7e9824

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 d7e9824

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 d7e9824

}
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 d7e9824

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

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

Lines 216 to 218 in d7e9824

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

cockroach/pkg/sql/catalog/errors.go

Lines 93 to 95 in d7e9824

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

GOROOT/src/runtime/asm_amd64.s#L1593-L1595
GOROOT/src/runtime/proc.go#L232-L234
GOROOT/src/runtime/proc.go#L6326-L6328
GOROOT/src/runtime/proc.go#L6326-L6328
GOROOT/src/runtime/proc.go#L6326-L6328
GOROOT/src/runtime/proc.go#L6326-L6328
GOROOT/src/runtime/proc.go#L6326-L6328
GOROOT/src/runtime/proc.go#L6349-L6351

cockroach/pkg/sql/catalog/errors.go

Lines 90 to 92 in d7e9824

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

pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).makeExecPlan at line 2028
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 1121
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildFrom at line 1200
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildFromTables at line 1273
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildFromTablesRightDeep at line 1296
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildDataSource at line 92
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildDataSource at line 137
pkg/sql/opt/optbuilder/util.go in pkg/sql/opt/optbuilder.(*Builder).resolveDataSource at line 639
pkg/sql/opt_catalog.go in pkg/sql.(*optCatalog).ResolveDataSource at line 259
pkg/sql/catalog/resolver/resolver.go in pkg/sql/catalog/resolver.ResolveExistingTableObject at line 108
pkg/sql/catalog/resolver/resolver.go in pkg/sql/catalog/resolver.ResolveExistingObject at line 184
pkg/sql/catalog/resolver/resolver.go in pkg/sql/catalog/resolver.ResolveExisting at line 341
pkg/sql/schema_resolver.go in pkg/sql.(*schemaResolver).LookupObject at line 165
pkg/sql/catalog/descs/helpers.go in pkg/sql/catalog/descs.PrefixAndTable at line 134
pkg/sql/catalog/descs/helpers.go in pkg/sql/catalog/descs.getObjectPrefix at line 102
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/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 1121
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildFrom at line 1200
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildFromTables at line 1273
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildFromTablesRightDeep at line 1296
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildDataSource at line 92
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildDataSource at line 137
pkg/sql/opt/optbuilder/util.go in pkg/sql/opt/optbuilder.(*Builder).resolveDataSource at line 639
pkg/sql/opt_catalog.go in pkg/sql.(*optCatalog).ResolveDataSource at line 259
pkg/sql/catalog/resolver/resolver.go in pkg/sql/catalog/resolver.ResolveExistingTableObject at line 108
pkg/sql/catalog/resolver/resolver.go in pkg/sql/catalog/resolver.ResolveExistingObject at line 184
pkg/sql/catalog/resolver/resolver.go in pkg/sql/catalog/resolver.ResolveExisting at line 341
pkg/sql/schema_resolver.go in pkg/sql.(*schemaResolver).LookupObject at line 165
pkg/sql/catalog/descs/helpers.go in pkg/sql/catalog/descs.PrefixAndTable at line 134
pkg/sql/catalog/descs/helpers.go in pkg/sql/catalog/descs.getObjectPrefix at line 102
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
GOROOT/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 6327
GOROOT/src/runtime/proc.go in runtime.doInit at line 6327
GOROOT/src/runtime/proc.go in runtime.doInit at line 6327
GOROOT/src/runtime/proc.go in runtime.doInit at line 6327
GOROOT/src/runtime/proc.go in runtime.doInit at line 6327
GOROOT/src/runtime/proc.go in runtime.doInit at line 6350
pkg/sql/catalog/errors.go in pkg/sql/catalog.init at line 91

Tags

Tag Value
Command start-single-node
Environment v23.1.12
Go Version go1.19.13
Platform linux amd64
Distribution CCL
Cockroach Release v23.1.12
Cockroach SHA d7e9824
# of CPUs 4
# of Goroutines 333

Jira issue: CRDB-37107
@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 Mar 27, 2024
@yuzefovich
Copy link
Member

dup of #105257

@exalate-issue-sync exalate-issue-sync bot changed the title Sentry: errors.go:91: referenced descriptor ID 495: looking up ID 495: descriptor not found (1) assertion failure Wraps: (2) attached stack trace -- stack trace: | github.com/cockroachdb/cockroach... Sentry: errors.go:91: referenced descriptor ID 495: looking up ID 495: descriptor not found (1) assertion failure Wraps: (2) attached stack trace -- stack trace: | github.com/cockroachdb/cockroach... May 2, 2024
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