sentry: *errors.errorString *safedetails.withSafeDetails: parentID %d does not exist (1) structured.go:1544: *withstack.withStack (2) *assert.withAssertionFailure *errutil.withMessage *safedetails.withSafeDetails: get-hashed-pwd (3) internal.go:472: *withstack.withStack (4) *errutil.withMessage *safedetails.withSafeDetails: error looking up user %s (5) user.go:38: *withstack.withStack (6) (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/1501443459/?referrer=webhooks_plugin

Panic message:

*errors.errorString
*safedetails.withSafeDetails: parentID %d does not exist (1)
structured.go:1544: *withstack.withStack (2)
*assert.withAssertionFailure
*errutil.withMessage
*safedetails.withSafeDetails: get-hashed-pwd (3)
internal.go:472: *withstack.withStack (4)
*errutil.withMessage
*safedetails.withSafeDetails: error looking up user %s (5)
user.go:38: *withstack.withStack (6)
(check the extra data payloads)

Stacktrace (expand for inline code snippets):

cockroach/pkg/sql/sqlbase/structured.go

Lines 1543 to 1545 in 3cbd056

	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 1530 to 1532 in 3cbd056

	}
	return desc.validateCrossReferences(ctx, txn)
	}

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

cockroach/pkg/sql/descriptor.go

Lines 182 to 184 in 3cbd056

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

in pkg/sql.getDescriptorByID

cockroach/pkg/sql/physical_schema_accessors.go

Lines 159 to 161 in 3cbd056

	desc := &sqlbase.TableDescriptor{}
	err = getDescriptorByID(ctx, txn, descID, desc)
	if err != nil {

in pkg/sql.UncachedPhysicalAccessor.GetObjectDesc

cockroach/pkg/sql/table.go

Lines 267 to 269 in 3cbd056

	phyAccessor := UncachedPhysicalAccessor{}
	obj, err := phyAccessor.GetObjectDesc(ctx, txn, tn, flags)
	if obj == nil {

in pkg/sql.(*TableCollection).getTableVersion.func1

cockroach/pkg/sql/table.go

Lines 275 to 277 in 3cbd056

	if avoidCache {
	return readTableFromStore()
	}

in pkg/sql.(*TableCollection).getTableVersion

cockroach/pkg/sql/physical_schema_accessors.go

Lines 237 to 239 in 3cbd056

	}
	table, err := a.tc.getTableVersion(ctx, txn, name, flags)
	if table == nil {

in pkg/sql.(*CachedPhysicalAccessor).GetObjectDesc

cockroach/pkg/sql/logical_schema_accessors.go

Lines 92 to 94 in 3cbd056

	// Fallthrough.
	return l.SchemaAccessor.GetObjectDesc(ctx, txn, name, flags)
	}

in pkg/sql.(*LogicalSchemaAccessor).GetObjectDesc

cockroach/pkg/sql/resolver.go

Lines 292 to 294 in 3cbd056

	lookupFlags.CommonLookupFlags = p.CommonLookupFlags(false /* required */)
	objDesc, err := sc.GetObjectDesc(ctx, p.txn, &p.tableName, lookupFlags)
	return objDesc != nil, objDesc, err

in pkg/sql.(*planner).LookupObject

cockroach/pkg/sql/sem/tree/name_resolution.go

Lines 296 to 298 in 3cbd056

	// No luck so far. Compatibility with CockroachDB v1.1: try D.public.T instead.
	if found, objMeta, err := r.LookupObject(ctx, lookupFlags, t.Schema(), PublicSchema, t.Table()); found || err != nil {
	if err == nil {

in pkg/sql/sem/tree.(*TableName).ResolveExisting

cockroach/pkg/sql/resolver.go

Lines 140 to 142 in 3cbd056

	) (res tree.NameResolutionResult, err error) {
	found, descI, err := tn.ResolveExisting(ctx, sc, lookupFlags, sc.CurrentDatabase(), sc.CurrentSearchPath())
	if err != nil {

in pkg/sql.resolveExistingObjectImpl

cockroach/pkg/sql/resolver.go

Lines 101 to 103 in 3cbd056

	) (res *ImmutableTableDescriptor, err error) {
	desc, err := resolveExistingObjectImpl(ctx, sc, tn, lookupFlags, requiredType)
	if err != nil || desc == nil {

in pkg/sql.ResolveExistingObject

cockroach/pkg/sql/opt_catalog.go

Lines 168 to 170 in 3cbd056

	oc.tn = *name
	desc, err := ResolveExistingObject(ctx, oc.planner, &oc.tn, tree.ObjectLookupFlagsWithRequired(), ResolveAnyDescType)
	if err != nil {

in pkg/sql.(*optCatalog).ResolveDataSource

cockroach/pkg/sql/opt/metadata.go

Lines 219 to 221 in 3cbd056

	// Resolve data source object.
	toCheck, _, err = catalog.ResolveDataSource(ctx, cat.Flags{}, &name.byName)
	}

in pkg/sql/opt.(*Metadata).CheckDependencies

cockroach/pkg/sql/opt/memo/memo.go

Lines 278 to 280 in 3cbd056

	// access the object.
	if depsUpToDate, err := m.Metadata().CheckDependencies(ctx, catalog); err != nil {
	return true, err

in pkg/sql/opt/memo.(*Memo).IsStale

cockroach/pkg/sql/plan_opt.go

Lines 82 to 84 in 3cbd056

	} else {
	isStale, err := cachedData.Memo.IsStale(ctx, p.EvalContext(), &opc.catalog)
	if err != nil {

in pkg/sql.(*planner).prepareUsingOptimizer

cockroach/pkg/sql/conn_executor_prepare.go

Lines 203 to 205 in 3cbd056

	// future.
	flags, err := p.prepareUsingOptimizer(ctx)
	if err != nil {

in pkg/sql.(*connExecutor).populatePrepared

cockroach/pkg/sql/conn_executor_prepare.go

Lines 158 to 160 in 3cbd056

	p.stmt = &stmt
	flags, err := ex.populatePrepared(ctx, txn, placeholderHints, p)
	if err != nil {

in pkg/sql.(*connExecutor).prepare

cockroach/pkg/sql/conn_executor_prepare.go

Lines 96 to 98 in 3cbd056

	// Prepare the query. This completes the typing of placeholders.
	prepared, err := ex.prepare(ctx, stmt, placeholderHints)
	if err != nil {

in pkg/sql.(*connExecutor).addPreparedStmt

cockroach/pkg/sql/conn_executor_prepare.go

Lines 50 to 52 in 3cbd056

	ps, err := ex.addPreparedStmt(
	ctx, parseCmd.Name, Statement{Statement: parseCmd.Statement}, parseCmd.TypeHints,

in pkg/sql.(*connExecutor).execPrepare

cockroach/pkg/sql/conn_executor.go

Lines 1312 to 1314 in 3cbd056

	stmtCtx := withStatement(ctx, ex.curStmt)
	ev, payload = ex.execPrepare(stmtCtx, tcmd)
	case DescribeStmt:

in pkg/sql.(*connExecutor).execCmd

cockroach/pkg/sql/conn_executor.go

Lines 1171 to 1173 in 3cbd056

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

in pkg/sql.(*connExecutor).run

cockroach/pkg/sql/internal.go

Lines 201 to 203 in 3cbd056

	go func() {
	if err := ex.run(ctx, ie.mon, mon.BoundAccount{} /*reserved*/, nil /* cancel */); err != nil {
	ex.recordError(ctx, err)

in pkg/sql.(*internalExecutorImpl).initConnEx.func1
/usr/local/go/src/runtime/asm_amd64.s#L1336-L1338 in runtime.goexit

pkg/sql/sqlbase/structured.go in pkg/sql/sqlbase.(*TableDescriptor).validateCrossReferences at line 1544
pkg/sql/sqlbase/structured.go in pkg/sql/sqlbase.(*TableDescriptor).Validate at line 1531
pkg/sql/descriptor.go in pkg/sql.getDescriptorByID at line 183
pkg/sql/physical_schema_accessors.go in pkg/sql.UncachedPhysicalAccessor.GetObjectDesc at line 160
pkg/sql/table.go in pkg/sql.(*TableCollection).getTableVersion.func1 at line 268
pkg/sql/table.go in pkg/sql.(*TableCollection).getTableVersion at line 276
pkg/sql/physical_schema_accessors.go in pkg/sql.(*CachedPhysicalAccessor).GetObjectDesc at line 238
pkg/sql/logical_schema_accessors.go in pkg/sql.(*LogicalSchemaAccessor).GetObjectDesc at line 93
pkg/sql/resolver.go in pkg/sql.(*planner).LookupObject at line 293
pkg/sql/sem/tree/name_resolution.go in pkg/sql/sem/tree.(*TableName).ResolveExisting at line 297
pkg/sql/resolver.go in pkg/sql.resolveExistingObjectImpl at line 141
pkg/sql/resolver.go in pkg/sql.ResolveExistingObject at line 102
pkg/sql/opt_catalog.go in pkg/sql.(*optCatalog).ResolveDataSource at line 169
pkg/sql/opt/metadata.go in pkg/sql/opt.(*Metadata).CheckDependencies at line 220
pkg/sql/opt/memo/memo.go in pkg/sql/opt/memo.(*Memo).IsStale at line 279
pkg/sql/plan_opt.go in pkg/sql.(*planner).prepareUsingOptimizer at line 83
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).populatePrepared at line 204
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).prepare at line 159
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).addPreparedStmt at line 97
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).execPrepare at line 51
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).execCmd at line 1313
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).run at line 1172
pkg/sql/internal.go in pkg/sql.(*internalExecutorImpl).initConnEx.func1 at line 202
/usr/local/go/src/runtime/asm_amd64.s in runtime.goexit at line 1337

Tag	Value
Cockroach Release	v19.2.2
Cockroach SHA:	3cbd056
Platform	linux amd64
Distribution	CCL
Environment	v19.2.2
Command	server
Go Version	go1.12.12
# of CPUs	8
# of Goroutines	808

[yuzefovich]

Seems like a dup of #44850.