sentry: *errors.errorString *safedetails.withSafeDetails: parentID %d does not exist (1) structured.go:1742: *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/1946783010/?referrer=webhooks_plugin

Panic message:

*errors.errorString
*safedetails.withSafeDetails: parentID %d does not exist (1)
structured.go:1742: *withstack.withStack (top exception)
*assert.withAssertionFailure
(check the extra data payloads)

Stacktrace (expand for inline code snippets):

cockroach/pkg/sql/sqlbase/structured.go

Lines 1741 to 1743 in d311992

	if !res.Exists() {
	return errors.AssertionFailedf("parentID %d does not exist", errors.Safe(desc.ParentID))
	}

in pkg/sql/sqlbase.(*TableDescriptor).validateCrossReferences

cockroach/pkg/sql/sqlbase/structured.go

Lines 1726 to 1728 in d311992

	}
	return desc.validateCrossReferences(ctx, txn, codec)
	}

in pkg/sql/sqlbase.(*TableDescriptor).Validate

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

Lines 112 to 114 in d311992

	}
	if err := table.Validate(ctx, txn, codec); err != nil {
	return nil, err

in pkg/sql/catalog/catalogkv.unwrapDescriptor

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

Lines 219 to 221 in d311992

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

in pkg/sql/catalog/catalogkv.GetAllDescriptors

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

Lines 756 to 758 in d311992

	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 1708 to 1710 in d311992

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

in pkg/sql.forEachTableDescWithTableLookupInternal

cockroach/pkg/sql/information_schema.go

Lines 1669 to 1671 in d311992

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

in pkg/sql.forEachTableDescWithTableLookup

cockroach/pkg/sql/pg_catalog.go

Lines 1015 to 1017 in d311992

	h := makeOidHasher()
	return forEachTableDescWithTableLookup(ctx, p, dbContext, virtualOpts,
	func(db *sqlbase.ImmutableDatabaseDescriptor, scName string, table *sqlbase.ImmutableTableDescriptor, lookup tableLookupFn) error {

in pkg/sql.makeAllRelationsVirtualTableWithDescriptorIDIndex.func1

cockroach/pkg/sql/virtual_schema.go

Lines 593 to 595 in d311992

	idxConstraint.Spans.Truncate(currentConstraint + 1)
	return def.populate(ctx, p, dbDesc, addRowIfPassesFilter)
	}

in pkg/sql.virtualDefEntry.makeConstrainedRowsGenerator.func1

cockroach/pkg/sql/virtual_table.go

Lines 296 to 298 in d311992

	// the looked-up rows into v.run.rows.
	if err := genFunc(v); err != nil {
	return false, err

in pkg/sql.(*vTableLookupJoinNode).Next

cockroach/pkg/sql/plan_node_to_row_source.go

Lines 174 to 176 in d311992

	for p.State == execinfra.StateRunning {
	valid, err := p.node.Next(p.params)
	if err != nil || !valid {

in pkg/sql.(*planNodeToRowSource).Next

cockroach/pkg/sql/rowexec/hashjoiner.go

Lines 651 to 653 in d311992

	}
	row, meta := source.Next()
	if meta != nil {

in pkg/sql/rowexec.(*hashJoiner).receiveNext

cockroach/pkg/sql/rowexec/hashjoiner.go

Lines 298 to 300 in d311992

	row, meta, emitDirectly, err := h.receiveNext(side)
	if err != nil {

in pkg/sql/rowexec.(*hashJoiner).build

cockroach/pkg/sql/rowexec/hashjoiner.go

Lines 232 to 234 in d311992

	case hjBuilding:
	h.runningState, row, meta = h.build()
	case hjConsumingStoredSide:

in pkg/sql/rowexec.(*hashJoiner).Next

cockroach/pkg/sql/rowexec/sorter.go

Lines 290 to 292 in d311992

	for {
	row, meta := s.input.Next()
	if meta != nil {

in pkg/sql/rowexec.(*sortAllProcessor).fill

cockroach/pkg/sql/rowexec/sorter.go

Lines 271 to 273 in d311992

	valid, err := s.fill()
	if !valid || err != nil {

in pkg/sql/rowexec.(*sortAllProcessor).Start

cockroach/pkg/sql/execinfra/processorsbase.go

Lines 746 to 748 in d311992

	}
	ctx = pb.self.Start(ctx)
	Run(ctx, pb.self, pb.Out.output)

in pkg/sql/execinfra.(*ProcessorBase).Run

cockroach/pkg/sql/flowinfra/flow.go

Lines 368 to 370 in d311992

	}
	headProc.Run(ctx)
	return nil

in pkg/sql/flowinfra.(*FlowBase).Run

cockroach/pkg/sql/distsql_running.go

Lines 409 to 411 in d311992

	// TODO(radu): this should go through the flow scheduler.
	if err := flow.Run(ctx, func() {}); err != nil {
	log.Fatalf(ctx, "unexpected error from syncFlow.Start(): %s "+

in pkg/sql.(*DistSQLPlanner).Run

cockroach/pkg/sql/distsql_running.go

Lines 996 to 998 in d311992

	recv.expectedRowsRead = int64(physPlan.TotalEstimatedScannedRows)
	return dsp.Run(planCtx, txn, physPlan, recv, evalCtx, nil /* finishedSetupFn */)
	}

in pkg/sql.(*DistSQLPlanner).PlanAndRun

cockroach/pkg/sql/conn_executor_exec.go

Lines 915 to 917 in d311992

	// the planner whether or not to plan remote table readers.
	cleanup := ex.server.cfg.DistSQLPlanner.PlanAndRun(
	ctx, evalCtx, planCtx, planner.txn, planner.curPlan.main, recv,

in pkg/sql.(*connExecutor).execWithDistSQLEngine

cockroach/pkg/sql/conn_executor_exec.go

Lines 812 to 814 in d311992

	ex.sessionTracing.TraceExecStart(ctx, "distributed")
	bytesRead, rowsRead, err := ex.execWithDistSQLEngine(ctx, planner, stmt.AST.StatementType(), res, distributePlan, progAtomic)
	ex.sessionTracing.TraceExecEnd(ctx, res.Err(), res.RowsAffected())

in pkg/sql.(*connExecutor).dispatchToExecutionEngine

cockroach/pkg/sql/conn_executor_exec.go

Lines 499 to 501 in d311992

	p.autoCommit = os.ImplicitTxn.Get() && !ex.server.cfg.TestingKnobs.DisableAutoCommit
	if err := ex.dispatchToExecutionEngine(ctx, p, res); err != nil {
	return nil, nil, err

in pkg/sql.(*connExecutor).execStmtInOpenState

cockroach/pkg/sql/conn_executor_exec.go

Lines 98 to 100 in d311992

	} else {
	ev, payload, err = ex.execStmtInOpenState(ctx, stmt, res, pinfo)
	}

in pkg/sql.(*connExecutor).execStmt

cockroach/pkg/sql/conn_executor.go

Lines 1428 to 1430 in d311992

	stmtCtx := withStatement(ctx, ex.curStmt)
	ev, payload, err = ex.execStmt(stmtCtx, curStmt, stmtRes, pinfo)
	if err != nil {

in pkg/sql.(*connExecutor).execCmd

cockroach/pkg/sql/conn_executor.go

Lines 1295 to 1297 in d311992

	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 490 to 492 in d311992

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

in pkg/sql.(*Server).ServeConn

cockroach/pkg/sql/pgwire/conn.go

Lines 594 to 596 in d311992

	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#L1372-L1374 in runtime.goexit

pkg/sql/sqlbase/structured.go in pkg/sql/sqlbase.(*TableDescriptor).validateCrossReferences at line 1742
pkg/sql/sqlbase/structured.go in pkg/sql/sqlbase.(*TableDescriptor).Validate at line 1727
pkg/sql/catalog/catalogkv/catalogkv.go in pkg/sql/catalog/catalogkv.unwrapDescriptor at line 113
pkg/sql/catalog/catalogkv/catalogkv.go in pkg/sql/catalog/catalogkv.GetAllDescriptors at line 220
pkg/sql/catalog/descs/collection.go in pkg/sql/catalog/descs.(*Collection).GetAllDescriptors at line 757
pkg/sql/information_schema.go in pkg/sql.forEachTableDescWithTableLookupInternal at line 1709
pkg/sql/information_schema.go in pkg/sql.forEachTableDescWithTableLookup at line 1670
pkg/sql/pg_catalog.go in pkg/sql.makeAllRelationsVirtualTableWithDescriptorIDIndex.func1 at line 1016
pkg/sql/virtual_schema.go in pkg/sql.virtualDefEntry.makeConstrainedRowsGenerator.func1 at line 594
pkg/sql/virtual_table.go in pkg/sql.(*vTableLookupJoinNode).Next at line 297
pkg/sql/plan_node_to_row_source.go in pkg/sql.(*planNodeToRowSource).Next at line 175
pkg/sql/rowexec/hashjoiner.go in pkg/sql/rowexec.(*hashJoiner).receiveNext at line 652
pkg/sql/rowexec/hashjoiner.go in pkg/sql/rowexec.(*hashJoiner).build at line 299
pkg/sql/rowexec/hashjoiner.go in pkg/sql/rowexec.(*hashJoiner).Next at line 233
pkg/sql/rowexec/sorter.go in pkg/sql/rowexec.(*sortAllProcessor).fill at line 291
pkg/sql/rowexec/sorter.go in pkg/sql/rowexec.(*sortAllProcessor).Start at line 272
pkg/sql/execinfra/processorsbase.go in pkg/sql/execinfra.(*ProcessorBase).Run at line 747
pkg/sql/flowinfra/flow.go in pkg/sql/flowinfra.(*FlowBase).Run at line 369
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).Run at line 410
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).PlanAndRun at line 997
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execWithDistSQLEngine at line 916
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).dispatchToExecutionEngine at line 813
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmtInOpenState at line 500
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmt at line 99
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).execCmd at line 1429
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).run at line 1296
pkg/sql/conn_executor.go in pkg/sql.(*Server).ServeConn at line 491
pkg/sql/pgwire/conn.go in pkg/sql/pgwire.(*conn).processCommandsAsync.func1 at line 595
/usr/local/go/src/runtime/asm_amd64.s in runtime.goexit at line 1373

Tag	Value
Cockroach Release	v20.2.0-alpha.2
Cockroach SHA:	d311992
Platform	windows amd64
Distribution	CCL
Environment	v20.2.0-alpha.2
Command	start-single-node
Go Version	``
# of CPUs
# of Goroutines

[ajwerner]

Fixed in #50997.