sentry: lease.go:440: transaction committed but schema change aborted with error: (×): ×: ×: unable to read descriptor (127, 1647537501.076645470,2) found descriptor with modificationTime 1647537501.076645470,1 -- *errutil.leafError: unable to read descriptor (127, 1647537501.076645470,2) found descriptor with modificationTime 1647537501.076645470,1 (1) lease.go:440: *withstack.withStack (top exception) *assert.withAssertionFailure *errutil.withPrefix: × (2) util.go:603: *withstack.withStack (3) *pgerror.withCandidateCode: 42704 (4) *errutil.withPrefix: × (5) internal.go:658: *withstack.withStack (6) *errutil.withPrefix: transaction committed but schema change aborted with error: (×) (7) conn_executor.go:2383: *withstack.withStack (8) *pgerror.withCandidateCode: XXA00 (9) *hintdetail.withHint *issuelink.withIssueLink: https://github.com/cockroachdb/cockroach/issues/42061 (10) (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/3111460390/?referrer=webhooks_plugin

Panic message:

lease.go:440: transaction committed but schema change aborted with error: (×): ×: ×: unable to read descriptor (127, 1647537501.076645470,2) found descriptor with modificationTime 1647537501.076645470,1
--
*errutil.leafError: unable to read descriptor (127, 1647537501.076645470,2) found descriptor with modificationTime 1647537501.076645470,1 (1)
lease.go:440: *withstack.withStack (top exception)
*assert.withAssertionFailure
*errutil.withPrefix: × (2)
util.go:603: *withstack.withStack (3)
*pgerror.withCandidateCode: 42704 (4)
*errutil.withPrefix: × (5)
internal.go:658: *withstack.withStack (6)
*errutil.withPrefix: transaction committed but schema change aborted with error: (×) (7)
conn_executor.go:2383: *withstack.withStack (8)
*pgerror.withCandidateCode: XXA00 (9)
*hintdetail.withHint
*issuelink.withIssueLink: #42061 (10)
(check the extra data payloads)

Stacktrace (expand for inline code snippets):

cockroach/pkg/sql/conn_executor.go

Lines 2382 to 2384 in 1fac61a

	// 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 2402 to 2404 in 1fac61a

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

in pkg/sql.(*connExecutor).txnStateTransitionsApplyWrapper

cockroach/pkg/sql/conn_executor.go

Lines 1678 to 1680 in 1fac61a

	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 1449 to 1451 in 1fac61a

	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 483 to 485 in 1fac61a

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

in pkg/sql.(*Server).ServeConn

cockroach/pkg/sql/pgwire/conn.go

Lines 627 to 629 in 1fac61a

	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#L1373-L1375 in runtime.goexit

pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).txnStateTransitionsApplyWrapper.func1 at line 2383
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).txnStateTransitionsApplyWrapper at line 2403
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).execCmd at line 1679
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).run at line 1450
pkg/sql/conn_executor.go in pkg/sql.(*Server).ServeConn at line 484
pkg/sql/pgwire/conn.go in pkg/sql/pgwire.(*conn).processCommandsAsync.func1 at line 628
/usr/local/go/src/runtime/asm_amd64.s in runtime.goexit at line 1374

Tag	Value
Cockroach Release	v21.1.7
Cockroach SHA:	1fac61a
Platform	linux amd64
Distribution	CCL
Environment	development
Command	start-single-node
Go Version	``
# of CPUs
# of Goroutines

[yuzefovich]

dup of #76976