cockroachdb / cockroachdb/cockroach

Sentry: catch.go:24: while building × expression: runtime error: invalid memory address or nil pointer dereference (1) attached stack trace -- stack trace: | github.com/cockroachdb/cockroach/pkg/...

Open
#166,653 5 comments 0 reactions 1 assignee Claimed by @ZhouXing19 View on GitHub
branch-release-25.4 C-bug O-sentry T-sql-queries X-blathers-triaged
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

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/7362360630/?referrer=webhooks_plugin](https://cockroach-labs.sentry.io/issues/7362360630/?referrer=webhooks_plugin)

Panic Message:

```
catch.go:24: while building × expression: runtime error: invalid memory address or nil pointer dereference
(1) attached stack trace
-- stack trace:
| github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder.(*postQueryBuilder).planPostQuery
| pkg/sql/opt/exec/execbuilder/post_queries.go:286
| [...repeated from below...]
Wraps: (2) while building × expression
Wraps: (3) assertion failure
Wraps: (4) attached stack trace
-- stack trace:
| github.com/cockroachdb/cockroach/pkg/util/errorutil.ShouldCatch
| pkg/util/errorutil/catch.go:24
| github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.buildTriggerCascadeHelper.func1
| pkg/sql/opt/optbuilder/fk_cascade.go:1087
| runtime.gopanic
| GOROOT/src/runtime/panic.go:791
| runtime.panicmem
| GOROOT/src/runtime/panic.go:262
| runtime.sigpanic
| GOROOT/src/runtime/signal_unix.go:917
| github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildDeleteCascadeMutationInput
| pkg/sql/opt/optbuilder/fk_cascade.go:677
| github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*onDeleteSetBuilder).Build.func1
| pkg/sql/opt/optbuilder/fk_cascade.go:540
| github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.buildTriggerCascadeHelper
| pkg/sql/opt/optbuilder/fk_cascade.go:1095
| github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*onDeleteSetBuilder).Build
| pkg/sql/opt/optbuilder/fk_cascade.go:521
| github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder.(*postQueryBuilder).planPostQuery
| pkg/sql/opt/exec/execbuilder/post_queries.go:275
| github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder.(*Builder).buildFKCascades.(*postQueryBuilder).setupCascade.func1
| pkg/sql/opt/exec/execbuilder/post_queries.go:166
| github.com/cockroachdb/cockroach/pkg/sql/opt/exec/explain.(*Factory).ConstructPlan.(*Factory).wrapPostQuery.func1
| pkg/sql/opt/exec/explain/explain_factory.go:225
| github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).planAndRunCascadeOrTrigger
| pkg/sql/distsql_running.go:2641
| github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).PlanAndRunPostQueries
| pkg/sql/distsql_running.go:2490
| github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).PlanAndRunAll
| pkg/sql/distsql_running.go:2075
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execWithDistSQLEngine
| pkg/sql/conn_executor_exec.go:3395
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).dispatchToExecutionEngine
| pkg/sql/conn_executor_exec.go:2921
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmtInOpenState
| pkg/sql/conn_executor_exec.go:1067
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt.func2
| pkg/sql/conn_executor_exec.go:175
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execWithProfiling
| pkg/sql/conn_executor_exec.go:4429
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt
| pkg/sql/conn_executor_exec.go:174
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd.func1
| pkg/sql/conn_executor.go:2378
| github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd
| pkg/sql/conn_executor.go:2383
| 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: (5) runtime error: invalid memory address or nil pointer dereference
| -- cause hidden behind barrier
| runtime error: invalid memory address or nil pointer dereference
| (1) runtime error: invalid memory address or nil pointer dereference
| Error types: (1) runtime.errorString
Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *assert.withAssertionFailure (4) *withstack.withStack (5) *barriers.barrierErr
-- report composition:
*barriers.barrierErr: masked error: runtime error: invalid memory address or nil pointer dereference
catch.go:24: *withstack.withStack (top exception)
*assert.withAssertionFailure
*errutil.withPrefix: while building × expression
post_queries.go:286: *withstack.withStack (1)
(check the extra data payloads)
```

Stacktrace (expand for inline code snippets):

[src/runtime/asm_amd64.s#L1699-L1701](src/runtime/asm_amd64.s#L1699-L1701)
[pkg/sql/pgwire/server.go#L1227-L1229](pkg/sql/pgwire/server.go#L1227-L1229)
[pkg/sql/pgwire/conn.go#L252-L254](pkg/sql/pgwire/conn.go#L252-L254)
[pkg/sql/conn_executor.go#L1066-L1068](pkg/sql/conn_executor.go#L1066-L1068)
[pkg/sql/conn_executor.go#L2290-L2292](pkg/sql/conn_executor.go#L2290-L2292)
[pkg/sql/conn_executor.go#L2382-L2384](pkg/sql/conn_executor.go#L2382-L2384)
[pkg/sql/conn_executor.go#L2377-L2379](pkg/sql/conn_executor.go#L2377-L2379)
[pkg/sql/conn_executor_exec.go#L173-L175](pkg/sql/conn_executor_exec.go#L173-L175)
[pkg/sql/conn_executor_exec.go#L4428-L4430](pkg/sql/conn_executor_exec.go#L4428-L4430)
[pkg/sql/conn_executor_exec.go#L174-L176](pkg/sql/conn_executor_exec.go#L174-L176)
[pkg/sql/conn_executor_exec.go#L1066-L1068](pkg/sql/conn_executor_exec.go#L1066-L1068)
[pkg/sql/conn_executor_exec.go#L2920-L2922](pkg/sql/conn_executor_exec.go#L2920-L2922)
[pkg/sql/conn_executor_exec.go#L3394-L3396](pkg/sql/conn_executor_exec.go#L3394-L3396)
[pkg/sql/distsql_running.go#L2074-L2076](pkg/sql/distsql_running.go#L2074-L2076)
[pkg/sql/distsql_running.go#L2489-L2491](pkg/sql/distsql_running.go#L2489-L2491)
[pkg/sql/distsql_running.go#L2640-L2642](pkg/sql/distsql_running.go#L2640-L2642)
[pkg/sql/opt/exec/explain/explain_factory.go#L224-L226](pkg/sql/opt/exec/explain/explain_factory.go#L224-L226)
[pkg/sql/opt/exec/execbuilder/post_queries.go#L165-L167](pkg/sql/opt/exec/execbuilder/post_queries.go#L165-L167)
[pkg/sql/opt/exec/execbuilder/post_queries.go#L285-L287](pkg/sql/opt/exec/execbuilder/post_queries.go#L285-L287)
[src/runtime/asm_amd64.s#L1699-L1701](src/runtime/asm_amd64.s#L1699-L1701)
[pkg/sql/pgwire/server.go#L1227-L1229](pkg/sql/pgwire/server.go#L1227-L1229)
[pkg/sql/pgwire/conn.go#L252-L254](pkg/sql/pgwire/conn.go#L252-L254)
[pkg/sql/conn_executor.go#L1066-L1068](pkg/sql/conn_executor.go#L1066-L1068)
[pkg/sql/conn_executor.go#L2290-L2292](pkg/sql/conn_executor.go#L2290-L2292)
[pkg/sql/conn_executor.go#L2382-L2384](pkg/sql/conn_executor.go#L2382-L2384)
[pkg/sql/conn_executor.go#L2377-L2379](pkg/sql/conn_executor.go#L2377-L2379)
[pkg/sql/conn_executor_exec.go#L173-L175](pkg/sql/conn_executor_exec.go#L173-L175)
[pkg/sql/conn_executor_exec.go#L4428-L4430](pkg/sql/conn_executor_exec.go#L4428-L4430)
[pkg/sql/conn_executor_exec.go#L174-L176](pkg/sql/conn_executor_exec.go#L174-L176)
[pkg/sql/conn_executor_exec.go#L1066-L1068](pkg/sql/conn_executor_exec.go#L1066-L1068)
[pkg/sql/conn_executor_exec.go#L2920-L2922](pkg/sql/conn_executor_exec.go#L2920-L2922)
[pkg/sql/conn_executor_exec.go#L3394-L3396](pkg/sql/conn_executor_exec.go#L3394-L3396)
[pkg/sql/distsql_running.go#L2074-L2076](pkg/sql/distsql_running.go#L2074-L2076)
[pkg/sql/distsql_running.go#L2489-L2491](pkg/sql/distsql_running.go#L2489-L2491)
[pkg/sql/distsql_running.go#L2640-L2642](pkg/sql/distsql_running.go#L2640-L2642)
[pkg/sql/opt/exec/explain/explain_factory.go#L224-L226](pkg/sql/opt/exec/explain/explain_factory.go#L224-L226)
[pkg/sql/opt/exec/execbuilder/post_queries.go#L165-L167](pkg/sql/opt/exec/execbuilder/post_queries.go#L165-L167)
[pkg/sql/opt/exec/execbuilder/post_queries.go#L274-L276](pkg/sql/opt/exec/execbuilder/post_queries.go#L274-L276)
[pkg/sql/opt/optbuilder/fk_cascade.go#L520-L522](pkg/sql/opt/optbuilder/fk_cascade.go#L520-L522)
[pkg/sql/opt/optbuilder/fk_cascade.go#L1094-L1096](pkg/sql/opt/optbuilder/fk_cascade.go#L1094-L1096)
[pkg/sql/opt/optbuilder/fk_cascade.go#L539-L541](pkg/sql/opt/optbuilder/fk_cascade.go#L539-L541)
[pkg/sql/opt/optbuilder/fk_cascade.go#L676-L678](pkg/sql/opt/optbuilder/fk_cascade.go#L676-L678)
[GOROOT/src/runtime/signal_unix.go#L916-L918](GOROOT/src/runtime/signal_unix.go#L916-L918)
[GOROOT/src/runtime/panic.go#L261-L263](GOROOT/src/runtime/panic.go#L261-L263)
[GOROOT/src/runtime/panic.go#L790-L792](GOROOT/src/runtime/panic.go#L790-L792)
[pkg/sql/opt/optbuilder/fk_cascade.go#L1086-L1088](pkg/sql/opt/optbuilder/fk_cascade.go#L1086-L1088)
[pkg/util/errorutil/catch.go#L23-L25](pkg/util/errorutil/catch.go#L23-L25)

```
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 2383
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).execCmd.func1 at line 2378
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmt at line 174
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execWithProfiling at line 4429
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmt.func2 at line 175
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmtInOpenState at line 1067
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).dispatchToExecutionEngine at line 2921
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execWithDistSQLEngine at line 3395
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).PlanAndRunAll at line 2075
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).PlanAndRunPostQueries at line 2490
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).planAndRunCascadeOrTrigger at line 2641
pkg/sql/opt/exec/explain/explain_factory.go in pkg/sql/opt/exec/explain.(*Factory).ConstructPlan.(*Factory).wrapPostQuery.func1 at line 225
pkg/sql/opt/exec/execbuilder/post_queries.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildFKCascades.(*postQueryBuilder).setupCascade.func1 at line 166
pkg/sql/opt/exec/execbuilder/post_queries.go in pkg/sql/opt/exec/execbuilder.(*postQueryBuilder).planPostQuery at line 286
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 2383
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).execCmd.func1 at line 2378
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmt at line 174
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execWithProfiling at line 4429
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmt.func2 at line 175
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmtInOpenState at line 1067
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).dispatchToExecutionEngine at line 2921
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execWithDistSQLEngine at line 3395
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).PlanAndRunAll at line 2075
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).PlanAndRunPostQueries at line 2490
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).planAndRunCascadeOrTrigger at line 2641
pkg/sql/opt/exec/explain/explain_factory.go in pkg/sql/opt/exec/explain.(*Factory).ConstructPlan.(*Factory).wrapPostQuery.func1 at line 225
pkg/sql/opt/exec/execbuilder/post_queries.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildFKCascades.(*postQueryBuilder).setupCascade.func1 at line 166
pkg/sql/opt/exec/execbuilder/post_queries.go in pkg/sql/opt/exec/execbuilder.(*postQueryBuilder).planPostQuery at line 275
pkg/sql/opt/optbuilder/fk_cascade.go in pkg/sql/opt/optbuilder.(*onDeleteSetBuilder).Build at line 521
pkg/sql/opt/optbuilder/fk_cascade.go in pkg/sql/opt/optbuilder.buildTriggerCascadeHelper at line 1095
pkg/sql/opt/optbuilder/fk_cascade.go in pkg/sql/opt/optbuilder.(*onDeleteSetBuilder).Build.func1 at line 540
pkg/sql/opt/optbuilder/fk_cascade.go in pkg/sql/opt/optbuilder.(*Builder).buildDeleteCascadeMutationInput at line 677
GOROOT/src/runtime/signal_unix.go in runtime.sigpanic at line 917
GOROOT/src/runtime/panic.go in runtime.panicmem at line 262
GOROOT/src/runtime/panic.go in runtime.gopanic at line 791
pkg/sql/opt/optbuilder/fk_cascade.go in pkg/sql/opt/optbuilder.buildTriggerCascadeHelper.func1 at line 1087
pkg/util/errorutil/catch.go in pkg/util/errorutil.ShouldCatch at line 24
```

### Tags

| Tag | Value |
| --- | --- |
| Command | mt start-sql |
| Environment | v25.4.5 |
| Go Version | go1.23.12 X:nocoverageredesign |
| Platform | linux amd64 |
| Distribution | CCL |
| Cockroach Release | v25.4.5 |
| Cockroach SHA | a5d3d359798dfbfa7a3cfd129441674afe498592 |
| # of CPUs | 16 |
| # of Goroutines | 317 |

Jira issue: CRDB-62058

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.