sentry: structured.go:1635: missing fk forward reference × to × from × (un-upgraded foreign key references present) -- *errutil.leafError: missing fk forward reference × to × from × (un-upgraded foreign key references present) (1) structured.go:1635: *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/2260021731/?referrer=webhooks_plugin

Panic message:

structured.go:1635: missing fk forward reference × to × from × (un-upgraded foreign key references present)
--
*errutil.leafError: missing fk forward reference × to × from × (un-upgraded foreign key references present) (1)
structured.go:1635: *withstack.withStack (top exception)
*assert.withAssertionFailure
(check the extra data payloads)

Stacktrace (expand for inline code snippets):

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

Lines 1634 to 1636 in 92d9495

	if unupgradedFKsPresent {
	return errors.AssertionFailedf("missing fk forward reference %q to %q from %q "+
	"(un-upgraded foreign key references present)",

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

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

Lines 1439 to 1441 in 92d9495

	}
	return desc.validateCrossReferences(ctx, dg)
	}

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

cockroach/pkg/sql/catalog/catalogkv/catalogkv.go

Lines 297 to 299 in 92d9495

	}
	if err := immTable.Validate(ctx, dg); err != nil {
	return nil, err

in pkg/sql/catalog/catalogkv.unwrapDescriptor

cockroach/pkg/sql/catalog/catalogkv/catalogkv.go

Lines 389 to 391 in 92d9495

	var err error
	if descs[i], err = unwrapDescriptor(ctx, dg, kv.Value.Timestamp, desc); err != nil {
	return nil, err

in pkg/sql/catalog/catalogkv.GetAllDescriptors

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

Lines 1544 to 1546 in 92d9495

	if tc.allDescriptors == nil {
	descs, err := catalogkv.GetAllDescriptors(ctx, txn, tc.codec())
	if err != nil {

in pkg/sql/catalog/descs.(*Collection).GetAllDescriptors

cockroach/pkg/sql/information_schema.go

Lines 1863 to 1865 in 92d9495

	) error {
	descs, err := p.Descriptors().GetAllDescriptors(ctx, p.txn)
	if err != nil {

in pkg/sql.forEachTableDescWithTableLookupInternal

cockroach/pkg/sql/information_schema.go

Lines 1824 to 1826 in 92d9495

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

in pkg/sql.forEachTableDescWithTableLookup

cockroach/pkg/sql/pg_catalog.go

Lines 929 to 931 in 92d9495

	h := makeOidHasher()
	return forEachTableDescWithTableLookup(ctx, p, dbContext, virtualOpts,
	func(db *dbdesc.Immutable, scName string, table catalog.TableDescriptor, lookup tableLookupFn) error {

in pkg/sql.makeAllRelationsVirtualTableWithDescriptorIDIndex.func1

cockroach/pkg/sql/virtual_schema.go

Lines 491 to 493 in 92d9495

	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 92d9495

	}
	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/structured.go in pkg/sql/catalog/tabledesc.(*Immutable).validateCrossReferences at line 1635
pkg/sql/catalog/tabledesc/structured.go in pkg/sql/catalog/tabledesc.(*Immutable).Validate at line 1440
pkg/sql/catalog/catalogkv/catalogkv.go in pkg/sql/catalog/catalogkv.unwrapDescriptor at line 298
pkg/sql/catalog/catalogkv/catalogkv.go in pkg/sql/catalog/catalogkv.GetAllDescriptors at line 390
pkg/sql/catalog/descs/collection.go in pkg/sql/catalog/descs.(*Collection).GetAllDescriptors at line 1545
pkg/sql/information_schema.go in pkg/sql.forEachTableDescWithTableLookupInternal at line 1864
pkg/sql/information_schema.go in pkg/sql.forEachTableDescWithTableLookup at line 1825
pkg/sql/pg_catalog.go in pkg/sql.makeAllRelationsVirtualTableWithDescriptorIDIndex.func1 at line 930
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.2
Cockroach SHA:	92d9495
Platform	darwin amd64
Distribution	CCL
Environment	v20.2.2
Command	start-single-node
Go Version	``
# of CPUs
# of Goroutines

[yuzefovich]

dup of #57032