sentry: structured.go:1635: transaction committed but schema change aborted with error: (×): 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 *errutil.withPrefix: transaction committed but schema change aborted with error: (×) (2) conn_executor.go:2291: *withstack.withStack (3) *pgerror.withCandidateCode: XXA00 (4) *hintdetail.withHint *issuelink.withIssueLink: https://github.com/cockroachdb/cockroach/issues/42061 (5) (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/2210736029/?referrer=webhooks_plugin

Panic message:

structured.go:1635: transaction committed but schema change aborted with error: (×): 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
*errutil.withPrefix: transaction committed but schema change aborted with error: (×) (2)
conn_executor.go:2291: *withstack.withStack (3)
*pgerror.withCandidateCode: XXA00 (4)
*hintdetail.withHint
*issuelink.withIssueLink: #42061 (5)
(check the extra data payloads)

Stacktrace (expand for inline code snippets):

cockroach/pkg/sql/conn_executor.go

Lines 2290 to 2292 in 92d9495

	// error message, in case it was a serious error.
	newErr := pgerror.Wrapf(err,
	pgcode.TransactionCommittedWithSchemaChangeFailure,

in pkg/sql.(*connExecutor).txnStateTransitionsApplyWrapper.func1

cockroach/pkg/sql/conn_executor.go

Lines 2309 to 2311 in 92d9495

	ex.extraTxnState.jobs); err != nil {
	handleErr(err)
	}

in pkg/sql.(*connExecutor).txnStateTransitionsApplyWrapper

cockroach/pkg/sql/conn_executor.go

Lines 1609 to 1611 in 92d9495

	var err error
	advInfo, err = ex.txnStateTransitionsApplyWrapper(ev, payload, res, pos)
	if err != nil {

in pkg/sql.(*connExecutor).execCmd

cockroach/pkg/sql/conn_executor.go

Lines 1390 to 1392 in 92d9495

	var err error
	if err = ex.execCmd(ex.Ctx()); err != nil {
	if errors.IsAny(err, io.EOF, errDrainingComplete) {

in pkg/sql.(*connExecutor).run

cockroach/pkg/sql/conn_executor.go

Lines 507 to 509 in 92d9495

	}()
	return h.ex.run(ctx, s.pool, reserved, cancel)
	}

in pkg/sql.(*Server).ServeConn

cockroach/pkg/sql/pgwire/conn.go

Lines 625 to 627 in 92d9495

	reservedOwned = false // We're about to pass ownership away.
	retErr = sqlServer.ServeConn(ctx, connHandler, reserved, cancelConn)
	}()

in pkg/sql/pgwire.(*conn).processCommandsAsync.func1
/usr/local/go/src/runtime/asm_amd64.s#L1356-L1358 in runtime.goexit

pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).txnStateTransitionsApplyWrapper.func1 at line 2291
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).txnStateTransitionsApplyWrapper at line 2310
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).execCmd at line 1610
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).run at line 1391
pkg/sql/conn_executor.go in pkg/sql.(*Server).ServeConn at line 508
pkg/sql/pgwire/conn.go in pkg/sql/pgwire.(*conn).processCommandsAsync.func1 at line 626
/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