sentry: fetcher.go:1538: transaction committed but schema change aborted with error: (×): Non-nullable column "×:×" with no value! Index scanned was × with the index key columns (×) and the values (×) -- *errutil.leafError: Non-nullable column "×:×" with no value! Index scanned was × with the index key columns (×) and the values (×) (1) fetcher.go:1538: *withstack.withStack (top exception) *assert.withAssertionFailure *contexttags.withContext: n4 (2) *contexttags.withContext: n1 (3) *errutil.withPrefix: transaction committed but schema change aborted with error: (×) (4) conn_executor.go:2291: *withstack.withStack (5) *pgerror.withCandidateCode: XXA00 (6) *hintdetail.withHint *issuelink.withIssueLink: https://github.com/cockroachdb/cockroach/issues/42061 (7) (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/2430493442/?referrer=webhooks_plugin

Panic message:

fetcher.go:1538: transaction committed but schema change aborted with error: (×): Non-nullable column "×:×" with no value! Index scanned was × with the index key columns (×) and the values (×)
--
*errutil.leafError: Non-nullable column "×:×" with no value! Index scanned was × with the index key columns (×) and the values (×) (1)
fetcher.go:1538: *withstack.withStack (top exception)
*assert.withAssertionFailure
*contexttags.withContext: n4 (2)
*contexttags.withContext: n1 (3)
*errutil.withPrefix: transaction committed but schema change aborted with error: (×) (4)
conn_executor.go:2291: *withstack.withStack (5)
*pgerror.withCandidateCode: XXA00 (6)
*hintdetail.withHint
*issuelink.withIssueLink: #42061 (7)
(check the extra data payloads)

Stacktrace (expand for inline code snippets):

cockroach/pkg/sql/conn_executor.go

Lines 2290 to 2292 in c9d5466

	// 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 c9d5466

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

in pkg/sql.(*connExecutor).txnStateTransitionsApplyWrapper

cockroach/pkg/sql/conn_executor.go

Lines 1609 to 1611 in c9d5466

	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 c9d5466

	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 c9d5466

	}()
	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 c9d5466

	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.9
Cockroach SHA:	c9d5466
Platform	linux amd64
Distribution	CCL
Environment	v20.2.9
Command	server
Go Version	``
# of CPUs
# of Goroutines

[yuzefovich]

closing as unactionable