sentry: table.go:273: error resolving table 4148 referenced in foreign key: × -- *barriers.barrierError: details for github.com/cockroachdb/cockroach/pkg/sql/pgwire/pgerror/*pgerror.withCandidateCode::: (1) *errutil.withPrefix: error resolving table 4148 referenced in foreign key (2) table.go:273: *withstack.withStack (top exception) *assert.withAssertionFailure (check the extra data payloads)

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

Panic message:

table.go:273: error resolving table 4148 referenced in foreign key: ×
--
*barriers.barrierError: details for github.com/cockroachdb/cockroach/pkg/sql/pgwire/pgerror/*pgerror.withCandidateCode::: (1)
*errutil.withPrefix: error resolving table 4148 referenced in foreign key (2)
table.go:273: *withstack.withStack (top exception)
*assert.withAssertionFailure
(check the extra data payloads)

Stacktrace (expand for inline code snippets):

cockroach/pkg/sql/catalog/tabledesc/table.go

Lines 272 to 274 in 150c591

	if err != nil {
	return nil, errors.NewAssertionErrorWithWrappedErrf(err,
	"error resolving table %d referenced in foreign key",

in pkg/sql/catalog/tabledesc.(*Immutable).collectConstraintInfo

cockroach/pkg/sql/catalog/tabledesc/table.go

Lines 194 to 196 in 150c591

	) (map[string]descpb.ConstraintDetail, error) {
	return desc.collectConstraintInfo(tableLookup)
	}

in pkg/sql/catalog/tabledesc.(*Immutable).GetConstraintInfoWithLookup

cockroach/pkg/sql/pg_catalog.go

Lines 1355 to 1357 in 150c591

	}
	conInfo, err := table.GetConstraintInfoWithLookup(tableLookup.getTableByID)
	if err != nil {

in pkg/sql.glob..func100.1

cockroach/pkg/sql/information_schema.go

Lines 1919 to 1921 in 150c591

	}
	if err := fn(dbDesc, scName, table, lCtx); err != nil {
	return err

in pkg/sql.forEachTableDescWithTableLookupInternal

cockroach/pkg/sql/information_schema.go

Lines 1824 to 1826 in 150c591

	) error {
	return forEachTableDescWithTableLookupInternal(ctx, p, dbContext, virtualOpts, false /* allowAdding */, fn)
	}

in pkg/sql.forEachTableDescWithTableLookup

cockroach/pkg/sql/pg_catalog.go

Lines 1332 to 1334 in 150c591

	h := makeOidHasher()
	return forEachTableDescWithTableLookup(ctx, p, dbContext, hideVirtual /*virtual tables have no constraints*/, func(
	db *dbdesc.Immutable,

in pkg/sql.glob..func100

cockroach/pkg/sql/virtual_schema.go

Lines 491 to 493 in 150c591

	generator, cleanup := setupGenerator(ctx, func(pusher rowPusher) error {
	return def.populate(ctx, p, dbDesc, func(row ...tree.Datum) error {
	if err := e.validateRow(row, columns); err != nil {

in pkg/sql.virtualDefEntry.getPlanInfo.func1.1

cockroach/pkg/sql/virtual_table.go

Lines 114 to 116 in 150c591

	}
	err := worker(funcRowPusher(addRow))
	// If the query was canceled, next() will already return a

in pkg/sql.setupGenerator.func2
/usr/local/go/src/runtime/asm_amd64.s#L1356-L1358 in runtime.goexit

pkg/sql/catalog/tabledesc/table.go in pkg/sql/catalog/tabledesc.(*Immutable).collectConstraintInfo at line 273
pkg/sql/catalog/tabledesc/table.go in pkg/sql/catalog/tabledesc.(*Immutable).GetConstraintInfoWithLookup at line 195
pkg/sql/pg_catalog.go in pkg/sql.glob..func100.1 at line 1356
pkg/sql/information_schema.go in pkg/sql.forEachTableDescWithTableLookupInternal at line 1920
pkg/sql/information_schema.go in pkg/sql.forEachTableDescWithTableLookup at line 1825
pkg/sql/pg_catalog.go in pkg/sql.glob..func100 at line 1333
pkg/sql/virtual_schema.go in pkg/sql.virtualDefEntry.getPlanInfo.func1.1 at line 492
pkg/sql/virtual_table.go in pkg/sql.setupGenerator.func2 at line 115
/usr/local/go/src/runtime/asm_amd64.s in runtime.goexit at line 1357

Tag	Value
Cockroach Release	v20.2.0
Cockroach SHA:	150c591
Platform	linux amd64
Distribution	CCL
Environment	v20.2.0
Command	server
Go Version	``
# of CPUs
# of Goroutines

[yuzefovich]

dup of #63237