Skip to content

Sentry: validate.go:666: relation × (10558): referenced table × (10554) is dropped (1) keys: [sql.schema.validation_errors.read.forward_references.relation] Wraps: (2) keys: [sql.schema.validation_e... #169935

@cockroach-sentry

Description

@cockroach-sentry

This issue was auto filed by Sentry. It represents a crash or reported error on a live cluster with telemetry enabled.

Sentry Link: https://cockroach-labs.sentry.io/issues/7466245186/?referrer=webhooks_plugin

Panic Message:

validate.go:666: relation × (10558): referenced table × (10554) is dropped
(1) keys: [sql.schema.validation_errors.read.forward_references.relation]
Wraps: (2) keys: [sql.schema.validation_errors.read.forward_references.relation]
Wraps: (3) attached stack trace
  -- stack trace:
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/validate.(*validationErrorAccumulator).decorate
  | 	pkg/sql/catalog/internal/validate/validate.go:246
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/validate.(*validationErrorAccumulator).Report
  | 	pkg/sql/catalog/internal/validate/validate.go:181
  | [...repeated from below...]
Wraps: (4) relation × (10558)
Wraps: (5) assertion failure
Wraps: (6) attached stack trace
  -- stack trace:
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/tabledesc.(*wrapper).validateOutboundFK
  | 	pkg/sql/catalog/tabledesc/validate.go:666
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/tabledesc.(*wrapper).ValidateForwardReferences
  | 	pkg/sql/catalog/tabledesc/validate.go:227
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/validate.Validate.func2
  | 	pkg/sql/catalog/internal/validate/validate.go:98
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/validate.(*validationErrorAccumulator).validateDescriptorsAtLevel
  | 	pkg/sql/catalog/internal/validate/validate.go:197
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/internal/validate.Validate
  | 	pkg/sql/catalog/internal/validate/validate.go:93
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/descs.(*Collection).Validate
  | 	pkg/sql/catalog/descs/validate.go:35
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/descs.(*Collection).finalizeDescriptors
  | 	pkg/sql/catalog/descs/descriptor.go:668
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/descs.getDescriptorsByID
  | 	pkg/sql/catalog/descs/descriptor.go:215
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/descs.getDescriptorByName
  | 	pkg/sql/catalog/descs/descriptor.go:403
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/descs.ByNameGetter.Table
  | 	pkg/sql/catalog/descs/getters.go:302
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/descs.PrefixAndTable
  | 	pkg/sql/catalog/descs/helpers.go:132
  | github.com/cockroachdb/cockroach/pkg/sql.(*schemaResolver).LookupObject
  | 	pkg/sql/schema_resolver.go:166
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/resolver.ResolveExisting
  | 	pkg/sql/catalog/resolver/resolver.go:375
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/resolver.ResolveExistingObject
  | 	pkg/sql/catalog/resolver/resolver.go:179
  | github.com/cockroachdb/cockroach/pkg/sql/catalog/resolver.ResolveExistingTableObject
  | 	pkg/sql/catalog/resolver/resolver.go:103
  | github.com/cockroachdb/cockroach/pkg/sql.(*optCatalog).ResolveDataSource
  | 	pkg/sql/opt_catalog.go:289
  | github.com/cockroachdb/cockroach/pkg/sql/opt.(*Metadata).CheckDependencies
  | 	pkg/sql/opt/metadata.go:474
  | github.com/cockroachdb/cockroach/pkg/sql/opt/memo.(*Memo).IsStale
  | 	pkg/sql/opt/memo/memo.go:522
  | github.com/cockroachdb/cockroach/pkg/sql.(*planner).prepareUsingOptimizer
  | 	pkg/sql/plan_opt.go:143
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).populatePrepared
  | 	pkg/sql/conn_executor_prepare.go:313
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).prepare.func2
  | 	pkg/sql/conn_executor_prepare.go:253
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).prepare
  | 	pkg/sql/conn_executor_prepare.go:258
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).addPreparedStmt
  | 	pkg/sql/conn_executor_prepare.go:116
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execPrepare
  | 	pkg/sql/conn_executor_prepare.go:77
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd
  | 	pkg/sql/conn_executor.go:2515
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).run
  | 	pkg/sql/conn_executor.go:2291
  | github.com/cockroachdb/cockroach/pkg/sql.(*Server).ServeConn
  | 	pkg/sql/conn_executor.go:1067
  | github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).processCommands
  | 	pkg/sql/pgwire/conn.go:253
  | github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*Server).serveImpl.func4
  | 	pkg/sql/pgwire/server.go:1228
  | runtime.goexit
  | 	src/runtime/asm_amd64.s:1700
Wraps: (7) referenced table × (10554) is dropped
Error types: (1) *telemetrykeys.withTelemetry (2) *telemetrykeys.withTelemetry (3) *withstack.withStack (4) *errutil.withPrefix (5) *assert.withAssertionFailure (6) *withstack.withStack (7) *errutil.leafError
-- report composition:
*errutil.leafError: referenced table × (10554) is dropped
validate.go:666: *withstack.withStack (top exception)
*assert.withAssertionFailure
*errutil.withPrefix: relation × (10558)
validate.go:246: *withstack.withStack (1)
*telemetrykeys.withTelemetry: sql.schema.validation_errors.read.forward_references.relation
*telemetrykeys.withTelemetry: sql.schema.validation_errors.read.forward_references.relation
(check the extra data payloads)
Stacktrace (expand for inline code snippets):

src/runtime/asm_amd64.s#L1699-L1701
pkg/sql/pgwire/server.go#L1227-L1229
pkg/sql/pgwire/conn.go#L252-L254
pkg/sql/conn_executor.go#L1066-L1068
pkg/sql/conn_executor.go#L2290-L2292
pkg/sql/conn_executor.go#L2514-L2516
pkg/sql/conn_executor_prepare.go#L76-L78
pkg/sql/conn_executor_prepare.go#L115-L117
pkg/sql/conn_executor_prepare.go#L257-L259
pkg/sql/conn_executor_prepare.go#L252-L254
pkg/sql/conn_executor_prepare.go#L312-L314
pkg/sql/plan_opt.go#L142-L144
pkg/sql/opt/memo/memo.go#L521-L523
pkg/sql/opt/metadata.go#L473-L475
pkg/sql/opt_catalog.go#L288-L290
pkg/sql/catalog/resolver/resolver.go#L102-L104
pkg/sql/catalog/resolver/resolver.go#L178-L180
pkg/sql/catalog/resolver/resolver.go#L374-L376
pkg/sql/schema_resolver.go#L165-L167
pkg/sql/catalog/descs/helpers.go#L131-L133
pkg/sql/catalog/descs/getters.go#L301-L303
pkg/sql/catalog/descs/descriptor.go#L402-L404
pkg/sql/catalog/descs/descriptor.go#L214-L216
pkg/sql/catalog/descs/descriptor.go#L667-L669
pkg/sql/catalog/descs/validate.go#L34-L36
pkg/sql/catalog/internal/validate/validate.go#L92-L94
pkg/sql/catalog/internal/validate/validate.go#L196-L198
pkg/sql/catalog/internal/validate/validate.go#L97-L99
pkg/sql/catalog/tabledesc/validate.go#L226-L228
pkg/sql/catalog/internal/validate/validate.go#L180-L182
pkg/sql/catalog/internal/validate/validate.go#L245-L247
src/runtime/asm_amd64.s#L1699-L1701
pkg/sql/pgwire/server.go#L1227-L1229
pkg/sql/pgwire/conn.go#L252-L254
pkg/sql/conn_executor.go#L1066-L1068
pkg/sql/conn_executor.go#L2290-L2292
pkg/sql/conn_executor.go#L2514-L2516
pkg/sql/conn_executor_prepare.go#L76-L78
pkg/sql/conn_executor_prepare.go#L115-L117
pkg/sql/conn_executor_prepare.go#L257-L259
pkg/sql/conn_executor_prepare.go#L252-L254
pkg/sql/conn_executor_prepare.go#L312-L314
pkg/sql/plan_opt.go#L142-L144
pkg/sql/opt/memo/memo.go#L521-L523
pkg/sql/opt/metadata.go#L473-L475
pkg/sql/opt_catalog.go#L288-L290
pkg/sql/catalog/resolver/resolver.go#L102-L104
pkg/sql/catalog/resolver/resolver.go#L178-L180
pkg/sql/catalog/resolver/resolver.go#L374-L376
pkg/sql/schema_resolver.go#L165-L167
pkg/sql/catalog/descs/helpers.go#L131-L133
pkg/sql/catalog/descs/getters.go#L301-L303
pkg/sql/catalog/descs/descriptor.go#L402-L404
pkg/sql/catalog/descs/descriptor.go#L214-L216
pkg/sql/catalog/descs/descriptor.go#L667-L669
pkg/sql/catalog/descs/validate.go#L34-L36
pkg/sql/catalog/internal/validate/validate.go#L92-L94
pkg/sql/catalog/internal/validate/validate.go#L196-L198
pkg/sql/catalog/internal/validate/validate.go#L97-L99
pkg/sql/catalog/tabledesc/validate.go#L226-L228
pkg/sql/catalog/tabledesc/validate.go#L665-L667

src/runtime/asm_amd64.s in runtime.goexit at line 1700
pkg/sql/pgwire/server.go in pkg/sql/pgwire.(*Server).serveImpl.func4 at line 1228
pkg/sql/pgwire/conn.go in pkg/sql/pgwire.(*conn).processCommands at line 253
pkg/sql/conn_executor.go in pkg/sql.(*Server).ServeConn at line 1067
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).run at line 2291
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).execCmd at line 2515
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).execPrepare at line 77
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).addPreparedStmt at line 116
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).prepare at line 258
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).prepare.func2 at line 253
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).populatePrepared at line 313
pkg/sql/plan_opt.go in pkg/sql.(*planner).prepareUsingOptimizer at line 143
pkg/sql/opt/memo/memo.go in pkg/sql/opt/memo.(*Memo).IsStale at line 522
pkg/sql/opt/metadata.go in pkg/sql/opt.(*Metadata).CheckDependencies at line 474
pkg/sql/opt_catalog.go in pkg/sql.(*optCatalog).ResolveDataSource at line 289
pkg/sql/catalog/resolver/resolver.go in pkg/sql/catalog/resolver.ResolveExistingTableObject at line 103
pkg/sql/catalog/resolver/resolver.go in pkg/sql/catalog/resolver.ResolveExistingObject at line 179
pkg/sql/catalog/resolver/resolver.go in pkg/sql/catalog/resolver.ResolveExisting at line 375
pkg/sql/schema_resolver.go in pkg/sql.(*schemaResolver).LookupObject at line 166
pkg/sql/catalog/descs/helpers.go in pkg/sql/catalog/descs.PrefixAndTable at line 132
pkg/sql/catalog/descs/getters.go in pkg/sql/catalog/descs.ByNameGetter.Table at line 302
pkg/sql/catalog/descs/descriptor.go in pkg/sql/catalog/descs.getDescriptorByName at line 403
pkg/sql/catalog/descs/descriptor.go in pkg/sql/catalog/descs.getDescriptorsByID at line 215
pkg/sql/catalog/descs/descriptor.go in pkg/sql/catalog/descs.(*Collection).finalizeDescriptors at line 668
pkg/sql/catalog/descs/validate.go in pkg/sql/catalog/descs.(*Collection).Validate at line 35
pkg/sql/catalog/internal/validate/validate.go in pkg/sql/catalog/internal/validate.Validate at line 93
pkg/sql/catalog/internal/validate/validate.go in pkg/sql/catalog/internal/validate.(*validationErrorAccumulator).validateDescriptorsAtLevel at line 197
pkg/sql/catalog/internal/validate/validate.go in pkg/sql/catalog/internal/validate.Validate.func2 at line 98
pkg/sql/catalog/tabledesc/validate.go in pkg/sql/catalog/tabledesc.(*wrapper).ValidateForwardReferences at line 227
pkg/sql/catalog/internal/validate/validate.go in pkg/sql/catalog/internal/validate.(*validationErrorAccumulator).Report at line 181
pkg/sql/catalog/internal/validate/validate.go in pkg/sql/catalog/internal/validate.(*validationErrorAccumulator).decorate at line 246
src/runtime/asm_amd64.s in runtime.goexit at line 1700
pkg/sql/pgwire/server.go in pkg/sql/pgwire.(*Server).serveImpl.func4 at line 1228
pkg/sql/pgwire/conn.go in pkg/sql/pgwire.(*conn).processCommands at line 253
pkg/sql/conn_executor.go in pkg/sql.(*Server).ServeConn at line 1067
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).run at line 2291
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).execCmd at line 2515
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).execPrepare at line 77
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).addPreparedStmt at line 116
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).prepare at line 258
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).prepare.func2 at line 253
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).populatePrepared at line 313
pkg/sql/plan_opt.go in pkg/sql.(*planner).prepareUsingOptimizer at line 143
pkg/sql/opt/memo/memo.go in pkg/sql/opt/memo.(*Memo).IsStale at line 522
pkg/sql/opt/metadata.go in pkg/sql/opt.(*Metadata).CheckDependencies at line 474
pkg/sql/opt_catalog.go in pkg/sql.(*optCatalog).ResolveDataSource at line 289
pkg/sql/catalog/resolver/resolver.go in pkg/sql/catalog/resolver.ResolveExistingTableObject at line 103
pkg/sql/catalog/resolver/resolver.go in pkg/sql/catalog/resolver.ResolveExistingObject at line 179
pkg/sql/catalog/resolver/resolver.go in pkg/sql/catalog/resolver.ResolveExisting at line 375
pkg/sql/schema_resolver.go in pkg/sql.(*schemaResolver).LookupObject at line 166
pkg/sql/catalog/descs/helpers.go in pkg/sql/catalog/descs.PrefixAndTable at line 132
pkg/sql/catalog/descs/getters.go in pkg/sql/catalog/descs.ByNameGetter.Table at line 302
pkg/sql/catalog/descs/descriptor.go in pkg/sql/catalog/descs.getDescriptorByName at line 403
pkg/sql/catalog/descs/descriptor.go in pkg/sql/catalog/descs.getDescriptorsByID at line 215
pkg/sql/catalog/descs/descriptor.go in pkg/sql/catalog/descs.(*Collection).finalizeDescriptors at line 668
pkg/sql/catalog/descs/validate.go in pkg/sql/catalog/descs.(*Collection).Validate at line 35
pkg/sql/catalog/internal/validate/validate.go in pkg/sql/catalog/internal/validate.Validate at line 93
pkg/sql/catalog/internal/validate/validate.go in pkg/sql/catalog/internal/validate.(*validationErrorAccumulator).validateDescriptorsAtLevel at line 197
pkg/sql/catalog/internal/validate/validate.go in pkg/sql/catalog/internal/validate.Validate.func2 at line 98
pkg/sql/catalog/tabledesc/validate.go in pkg/sql/catalog/tabledesc.(*wrapper).ValidateForwardReferences at line 227
pkg/sql/catalog/tabledesc/validate.go in pkg/sql/catalog/tabledesc.(*wrapper).validateOutboundFK at line 666

Tags

Tag Value
Command start-single-node
Environment v25.4.2
Go Version go1.23.12 X:nocoverageredesign
Platform linux amd64
Distribution CCL
Cockroach Release v25.4.2
Cockroach SHA 2c80e22
# of CPUs 8
# of Goroutines 941

Jira issue: CRDB-63719

Metadata

Metadata

Assignees

No one assigned

    Labels

    C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.O-sentryOriginated from an in-the-wild panic report.T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)X-blathers-triagedblathers was able to find an ownerbranch-release-25.4Used to mark GA and release blockers and technical advisories for 25.4

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions