Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Sentry: optimizer.go:276: top-level relational expression cannot have outer columns: (9) (1) assertion failure Wraps: (2) attached stack trace -- stack trace: | github.com/cockroachdb/cockroach/pk... #142046

Closed
cockroach-sentry opened this issue Feb 26, 2025 · 1 comment
Closed

Sentry: optimizer.go:276: top-level relational expression cannot have outer columns: (9) (1) assertion failure Wraps: (2) attached stack trace -- stack trace: | github.com/cockroachdb/cockroach/pk... #142046

cockroach-sentry opened this issue Feb 26, 2025 · 1 comment
Labels
branch-release-24.3 Used to mark GA and release blockers, technical advisories, and bugs for 24.3 C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. O-sentry Originated from an in-the-wild panic report. T-sql-queries SQL Queries Team X-blathers-triaged blathers was able to find an owner

Comments

@cockroach-sentry
Copy link
Collaborator

cockroach-sentry commented Feb 26, 2025 •
edited by cockroach-jira-scripts
Loading

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/6334851500/?referrer=webhooks_plugin

Panic Message:

optimizer.go:276: top-level relational expression cannot have outer columns: (9)
(1) assertion failure
Wraps: (2) attached stack trace
  -- stack trace:
  | github.com/cockroachdb/cockroach/pkg/sql/opt/xform.(*Optimizer).Optimize
  | 	pkg/sql/opt/xform/optimizer.go:276
  | github.com/cockroachdb/cockroach/pkg/sql/opt/exec/execbuilder.(*Builder).buildUDF.(*Builder).buildRoutinePlanGenerator.func2
  | 	pkg/sql/opt/exec/execbuilder/scalar.go:1207
  | github.com/cockroachdb/cockroach/pkg/sql.(*routineGenerator).startInternal
  | 	pkg/sql/routine.go:308
  | github.com/cockroachdb/cockroach/pkg/sql.(*routineGenerator).Start
  | 	pkg/sql/routine.go:258
  | github.com/cockroachdb/cockroach/pkg/sql.(*planner).EvalRoutineExpr
  | 	pkg/sql/routine.go:160
  | github.com/cockroachdb/cockroach/pkg/sql/sem/eval.(*evaluator).EvalRoutineExpr
  | 	pkg/sql/sem/eval/expr.go:630
  | github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*RoutineExpr).Eval
  | 	bazel-out/k8-opt/bin/pkg/sql/sem/tree/eval_expr_generated.go:352
  | github.com/cockroachdb/cockroach/pkg/sql/sem/eval.Expr
  | 	pkg/sql/sem/eval/expr.go:21
  | github.com/cockroachdb/cockroach/pkg/sql.(*callNode).startExec
  | 	pkg/sql/routine.go:40
  | github.com/cockroachdb/cockroach/pkg/sql.startExec.func2
  | 	pkg/sql/plan.go:525
  | github.com/cockroachdb/cockroach/pkg/sql.(*planVisitor).visitInternal.func1
  | 	pkg/sql/walk.go:107
  | github.com/cockroachdb/cockroach/pkg/sql.(*planVisitor).visitInternal
  | 	pkg/sql/walk.go:294
  | github.com/cockroachdb/cockroach/pkg/sql.(*planVisitor).visit
  | 	pkg/sql/walk.go:74
  | github.com/cockroachdb/cockroach/pkg/sql.walkPlan
  | 	pkg/sql/walk.go:38
  | github.com/cockroachdb/cockroach/pkg/sql.startExec
  | 	pkg/sql/plan.go:528
  | github.com/cockroachdb/cockroach/pkg/sql.(*planNodeToRowSource).Start
  | 	pkg/sql/plan_node_to_row_source.go:166
  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*FlowCoordinator).Start.func1
  | 	pkg/sql/colflow/flow_coordinator.go:111
  | github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError
  | 	pkg/sql/colexecerror/error.go:162
  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*FlowCoordinator).Start
  | 	pkg/sql/colflow/flow_coordinator.go:110
  | github.com/cockroachdb/cockroach/pkg/sql/execinfra.(*ProcessorBaseNoHelper).Run
  | 	pkg/sql/execinfra/processorsbase.go:726
  | github.com/cockroachdb/cockroach/pkg/sql/flowinfra.(*FlowBase).Run
  | 	pkg/sql/flowinfra/flow.go:574
  | github.com/cockroachdb/cockroach/pkg/sql/colflow.(*vectorizedFlow).Run
  | 	pkg/sql/colflow/vectorized_flow.go:300
  | github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).Run
  | 	pkg/sql/distsql_running.go:924
  | github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).PlanAndRun
  | 	pkg/sql/distsql_running.go:2017
  | github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).PlanAndRunAll.func3
  | 	pkg/sql/distsql_running.go:1731
  | github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).PlanAndRunAll
  | 	pkg/sql/distsql_running.go:1734
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execWithDistSQLEngine
  | 	pkg/sql/conn_executor_exec.go:2440
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).dispatchToExecutionEngine
  | 	pkg/sql/conn_executor_exec.go:1986
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmtInOpenState
  | 	pkg/sql/conn_executor_exec.go:1192
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt.func1
  | 	pkg/sql/conn_executor_exec.go:141
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execWithProfiling
  | 	pkg/sql/conn_executor_exec.go:3456
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execStmt
  | 	pkg/sql/conn_executor_exec.go:140
Wraps: (3) top-level relational expression cannot have outer columns: (9)
Error types: (1) *assert.withAssertionFailure (2) *withstack.withStack (3) *errutil.leafError
-- report composition:
*errutil.leafError: top-level relational expression cannot have outer columns: (9)
optimizer.go:276: *withstack.withStack (top exception)
*assert.withAssertionFailure
Stacktrace (expand for inline code snippets):

pkg/sql/conn_executor_exec.go#L139-L141
pkg/sql/conn_executor_exec.go#L3455-L3457
pkg/sql/conn_executor_exec.go#L140-L142
pkg/sql/conn_executor_exec.go#L1191-L1193
pkg/sql/conn_executor_exec.go#L1985-L1987
pkg/sql/conn_executor_exec.go#L2439-L2441
pkg/sql/distsql_running.go#L1733-L1735
pkg/sql/distsql_running.go#L1730-L1732
pkg/sql/distsql_running.go#L2016-L2018
pkg/sql/distsql_running.go#L923-L925
pkg/sql/colflow/vectorized_flow.go#L299-L301
pkg/sql/flowinfra/flow.go#L573-L575
pkg/sql/execinfra/processorsbase.go#L725-L727
pkg/sql/colflow/flow_coordinator.go#L109-L111
pkg/sql/colexecerror/error.go#L161-L163
pkg/sql/colflow/flow_coordinator.go#L110-L112
pkg/sql/plan_node_to_row_source.go#L165-L167
pkg/sql/plan.go#L527-L529
pkg/sql/walk.go#L37-L39
pkg/sql/walk.go#L73-L75
pkg/sql/walk.go#L293-L295
pkg/sql/walk.go#L106-L108
pkg/sql/plan.go#L524-L526
pkg/sql/routine.go#L39-L41
pkg/sql/sem/eval/expr.go#L20-L22
bazel-out/k8-opt/bin/pkg/sql/sem/tree/eval_expr_generated.go#L351-L353
pkg/sql/sem/eval/expr.go#L629-L631
pkg/sql/routine.go#L159-L161
pkg/sql/routine.go#L257-L259
pkg/sql/routine.go#L307-L309
pkg/sql/opt/exec/execbuilder/scalar.go#L1206-L1208
pkg/sql/opt/xform/optimizer.go#L275-L277

pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmt at line 140
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execWithProfiling at line 3456
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmt.func1 at line 141
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmtInOpenState at line 1192
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).dispatchToExecutionEngine at line 1986
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execWithDistSQLEngine at line 2440
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).PlanAndRunAll at line 1734
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).PlanAndRunAll.func3 at line 1731
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).PlanAndRun at line 2017
pkg/sql/distsql_running.go in pkg/sql.(*DistSQLPlanner).Run at line 924
pkg/sql/colflow/vectorized_flow.go in pkg/sql/colflow.(*vectorizedFlow).Run at line 300
pkg/sql/flowinfra/flow.go in pkg/sql/flowinfra.(*FlowBase).Run at line 574
pkg/sql/execinfra/processorsbase.go in pkg/sql/execinfra.(*ProcessorBaseNoHelper).Run at line 726
pkg/sql/colflow/flow_coordinator.go in pkg/sql/colflow.(*FlowCoordinator).Start at line 110
pkg/sql/colexecerror/error.go in pkg/sql/colexecerror.CatchVectorizedRuntimeError at line 162
pkg/sql/colflow/flow_coordinator.go in pkg/sql/colflow.(*FlowCoordinator).Start.func1 at line 111
pkg/sql/plan_node_to_row_source.go in pkg/sql.(*planNodeToRowSource).Start at line 166
pkg/sql/plan.go in pkg/sql.startExec at line 528
pkg/sql/walk.go in pkg/sql.walkPlan at line 38
pkg/sql/walk.go in pkg/sql.(*planVisitor).visit at line 74
pkg/sql/walk.go in pkg/sql.(*planVisitor).visitInternal at line 294
pkg/sql/walk.go in pkg/sql.(*planVisitor).visitInternal.func1 at line 107
pkg/sql/plan.go in pkg/sql.startExec.func2 at line 525
pkg/sql/routine.go in pkg/sql.(*callNode).startExec at line 40
pkg/sql/sem/eval/expr.go in pkg/sql/sem/eval.Expr at line 21
bazel-out/k8-opt/bin/pkg/sql/sem/tree/eval_expr_generated.go in pkg/sql/sem/tree.(*RoutineExpr).Eval at line 352
pkg/sql/sem/eval/expr.go in pkg/sql/sem/eval.(*evaluator).EvalRoutineExpr at line 630
pkg/sql/routine.go in pkg/sql.(*planner).EvalRoutineExpr at line 160
pkg/sql/routine.go in pkg/sql.(*routineGenerator).Start at line 258
pkg/sql/routine.go in pkg/sql.(*routineGenerator).startInternal at line 308
pkg/sql/opt/exec/execbuilder/scalar.go in pkg/sql/opt/exec/execbuilder.(*Builder).buildUDF.(*Builder).buildRoutinePlanGenerator.func2 at line 1207
pkg/sql/opt/xform/optimizer.go in pkg/sql/opt/xform.(*Optimizer).Optimize at line 276

Tags

Tag Value
Command start-single-node
Environment v24.3.4
Go Version go1.22.8 X:nocoverageredesign
Platform darwin amd64
Distribution CCL
Cockroach Release v24.3.4
Cockroach SHA 781c478
# of CPUs 16
# of Goroutines 582

Jira issue: CRDB-48139
@cockroach-sentry cockroach-sentry added branch-release-24.3 Used to mark GA and release blockers, technical advisories, and bugs for 24.3 C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. O-sentry Originated from an in-the-wild panic report. labels Feb 26, 2025
@blathers-crl blathers[crl]
Copy link

blathers-crl bot commented Feb 26, 2025

CC'ing via the CODEOWNERS-based sentry heuristic:

  • @cockroachdb/sql-queries

🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is dev-inf.

@blathers-crl blathers-crl bot added T-sql-queries SQL Queries Team X-blathers-triaged blathers was able to find an owner labels Feb 26, 2025
@github-project-automation github-project-automation bot moved this to Triage in SQL Queries Feb 26, 2025
@github-project-automation github-project-automation bot moved this from Triage to Done in SQL Queries Feb 26, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
branch-release-24.3 Used to mark GA and release blockers, technical advisories, and bugs for 24.3 C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. O-sentry Originated from an in-the-wild panic report. T-sql-queries SQL Queries Team X-blathers-triaged blathers was able to find an owner
Projects
SQL Queries
Status: Done
Milestone
No milestone
Development

No branches or pull requests
2 participants
@yuzefovich @cockroach-sentry