opt: v20.1.0-rc.2: assertion failed: estimated row count must be non-zero

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

Panic message:

>*errors.errorString
*safedetails.withSafeDetails: estimated row count must be non-zero (1)
statistics_builder.go:2301: *withstack.withStack (2)
*assert.withAssertionFailure
(check the extra data payloads)


<details>
<summary>Stacktrace (expand for inline code snippets):</summary>

https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/opt/memo/statistics_builder.go#L2300-L2302 in pkg/sql/opt/memo.(*statisticsBuilder).finalizeFromCardinality
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/opt/memo/statistics_builder.go#L2135-L2137 in pkg/sql/opt/memo.(*statisticsBuilder).buildWithScan
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/opt/memo/logical_props_builder.go#L799-L801 in pkg/sql/opt/memo.(*logicalPropsBuilder).buildWithScanProps
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/opt/memo/expr.og.go#L16550-L16552 in pkg/sql/opt/memo.(*Memo).MemoizeWithScan
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/opt/norm/factory.og.go#L8535-L8537 in pkg/sql/opt/norm.(*Factory).ConstructWithScan
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/opt/optbuilder/select.go#L95-L97 in pkg/sql/opt/optbuilder.(*Builder).buildDataSource
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/opt/optbuilder/select.go#L62-L64 in pkg/sql/opt/optbuilder.(*Builder).buildDataSource
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/opt/optbuilder/select.go#L1094-L1096 in pkg/sql/opt/optbuilder.(*Builder).buildFromTablesRightDeep
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/opt/optbuilder/select.go#L1101-L1103 in pkg/sql/opt/optbuilder.(*Builder).buildFromTablesRightDeep
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/opt/optbuilder/select.go#L1071-L1073 in pkg/sql/opt/optbuilder.(*Builder).buildFromTables
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/opt/optbuilder/select.go#L998-L1000 in pkg/sql/opt/optbuilder.(*Builder).buildFrom
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/opt/optbuilder/select.go#L920-L922 in pkg/sql/opt/optbuilder.(*Builder).buildSelectClause
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/opt/optbuilder/select.go#L868-L870 in pkg/sql/opt/optbuilder.(*Builder).buildSelectStmtWithoutParens
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/opt/optbuilder/select.go#L841-L843 in pkg/sql/opt/optbuilder.(*Builder).buildSelect.func1
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/opt/optbuilder/with.go#L28-L30 in pkg/sql/opt/optbuilder.(*Builder).processWiths
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/opt/optbuilder/select.go#L840-L842 in pkg/sql/opt/optbuilder.(*Builder).buildSelect
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/opt/optbuilder/builder.go#L252-L254 in pkg/sql/opt/optbuilder.(*Builder).buildStmt
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/opt/optbuilder/with.go#L157-L159 in pkg/sql/opt/optbuilder.(*Builder).buildCTE
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/opt/optbuilder/select.go#L680-L682 in pkg/sql/opt/optbuilder.(*Builder).buildCTEs
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/opt/optbuilder/with.go#L25-L27 in pkg/sql/opt/optbuilder.(*Builder).processWiths
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/opt/optbuilder/select.go#L840-L842 in pkg/sql/opt/optbuilder.(*Builder).buildSelect
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/opt/optbuilder/builder.go#L252-L254 in pkg/sql/opt/optbuilder.(*Builder).buildStmt
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/opt/optbuilder/builder.go#L216-L218 in pkg/sql/opt/optbuilder.(*Builder).buildStmtAtRoot
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/opt/optbuilder/builder.go#L187-L189 in pkg/sql/opt/optbuilder.(*Builder).Build
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/plan_opt.go#L432-L434 in pkg/sql.(*optPlanningCtx).buildExecMemo
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/plan_opt.go#L168-L170 in pkg/sql.(*planner).makeOptimizerPlan
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/conn_executor_exec.go#L800-L802 in pkg/sql.(*connExecutor).makeExecPlan
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/conn_executor_exec.go#L690-L692 in pkg/sql.(*connExecutor).dispatchToExecutionEngine
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/conn_executor_exec.go#L480-L482 in pkg/sql.(*connExecutor).execStmtInOpenState
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/conn_executor_exec.go#L95-L97 in pkg/sql.(*connExecutor).execStmt
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/conn_executor.go#L1367-L1369 in pkg/sql.(*connExecutor).execCmd
https://github.com/cockroachdb/cockroach/blob/c0f00d2a156295a1cb79ed960940c167cb03ccbc/pkg/sql/conn_executor.go#L1296-L1298 in pkg/sql.(*connExecutor).run
</details>

```
pkg/sql/opt/memo/statistics_builder.go in pkg/sql/opt/memo.(*statisticsBuilder).finalizeFromCardinality at line 2301
pkg/sql/opt/memo/statistics_builder.go in pkg/sql/opt/memo.(*statisticsBuilder).buildWithScan at line 2136
pkg/sql/opt/memo/logical_props_builder.go in pkg/sql/opt/memo.(*logicalPropsBuilder).buildWithScanProps at line 800
pkg/sql/opt/memo/expr.og.go in pkg/sql/opt/memo.(*Memo).MemoizeWithScan at line 16551
pkg/sql/opt/norm/factory.og.go in pkg/sql/opt/norm.(*Factory).ConstructWithScan at line 8536
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildDataSource at line 96
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildDataSource at line 63
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildFromTablesRightDeep at line 1095
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildFromTablesRightDeep at line 1102
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildFromTables at line 1072
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildFrom at line 999
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildSelectClause at line 921
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildSelectStmtWithoutParens at line 869
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildSelect.func1 at line 842
pkg/sql/opt/optbuilder/with.go in pkg/sql/opt/optbuilder.(*Builder).processWiths at line 29
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildSelect at line 841
pkg/sql/opt/optbuilder/builder.go in pkg/sql/opt/optbuilder.(*Builder).buildStmt at line 253
pkg/sql/opt/optbuilder/with.go in pkg/sql/opt/optbuilder.(*Builder).buildCTE at line 158
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildCTEs at line 681
pkg/sql/opt/optbuilder/with.go in pkg/sql/opt/optbuilder.(*Builder).processWiths at line 26
pkg/sql/opt/optbuilder/select.go in pkg/sql/opt/optbuilder.(*Builder).buildSelect at line 841
pkg/sql/opt/optbuilder/builder.go in pkg/sql/opt/optbuilder.(*Builder).buildStmt at line 253
pkg/sql/opt/optbuilder/builder.go in pkg/sql/opt/optbuilder.(*Builder).buildStmtAtRoot at line 217
pkg/sql/opt/optbuilder/builder.go in pkg/sql/opt/optbuilder.(*Builder).Build at line 188
pkg/sql/plan_opt.go in pkg/sql.(*optPlanningCtx).buildExecMemo at line 433
pkg/sql/plan_opt.go in pkg/sql.(*planner).makeOptimizerPlan at line 169
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).makeExecPlan at line 801
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).dispatchToExecutionEngine at line 691
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmtInOpenState at line 481
pkg/sql/conn_executor_exec.go in pkg/sql.(*connExecutor).execStmt at line 96
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).execCmd at line 1368
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).run at line 1297
```

| Tag | Value |
|---|---|
| Cockroach Release | `v20.1.0-rc.2` |
| Cockroach SHA: | c0f00d2a156295a1cb79ed960940c167cb03ccbc |
| Platform | linux amd64 |
| Distribution | CCL |
| Environment | v20.1.0-rc.2 |
| Command | server |
| Go Version | `go1.13.9`|
| # of CPUs |8 |
| # of Goroutines |197 |


Provide feedback

Saved searches

Use saved searches to filter your results more quickly

opt: v20.1.0-rc.2: assertion failed: estimated row count must be non-zero #49911

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

	if s.RowCount <= 0 && relProps.Cardinality.Max > 0 {
	panic(errors.AssertionFailedf("estimated row count must be non-zero"))
	}

	s.RowCount = inputStats.RowCount
	sb.finalizeFromCardinality(relProps)
	}


	outScope.expr = b.factory.ConstructWithScan(&memo.WithScanPrivate{
	With: cte.id,


	outScope = b.buildDataSource(source.Expr, indexFlags, locking, inScope)

	) (outScope *scope) {
	outScope = b.buildDataSource(tables[0], nil /* indexFlags */, locking, inScope)

	}
	tableScope := b.buildFromTablesRightDeep(tables, locking, inScope)

	}
	return b.buildFromTablesRightDeep(tables, locking, inScope)
	}

	if len(from.Tables) > 0 {
	outScope = b.buildFromTables(from.Tables, locking, inScope)
	} else {

	) (outScope *scope) {
	fromScope := b.buildFrom(sel.From, locking, inScope)
	b.processWindowDefs(sel, fromScope)

	case *tree.SelectClause:
	outScope = b.buildSelectClause(t, orderBy, locking, desiredTypes, inScope)

	if !b.disableStats {
	b.sb.buildWithScan(withScan, rel)
	}

	return b.processWiths(with, inScope, func(inScope scope) scope {
	return b.buildSelectStmtWithoutParens(
	wrapped, orderBy, limit, locking, desiredTypes, inScope,

	inScope.atRoot = false
	outScope := buildStmt(inScope)
	inScope.atRoot = prevAtRoot


	return b.processWiths(with, inScope, func(inScope scope) scope {
	return b.buildSelectStmtWithoutParens(

	case *tree.Select:
	return b.buildSelect(stmt, noRowLocking, desiredTypes, inScope)

	b.pushWithFrame()
	recursiveScope := b.buildStmt(recursive, initialTypes /* desiredTypes */, cteScope)
	b.popWithFrame(recursiveScope)

	hasRecursive = hasRecursive \|\| with.Recursive
	cteExpr, cteCols := b.buildCTE(cte, outScope, with.Recursive)

	) *scope {
	inScope = b.buildCTEs(with, inScope)
	prevAtRoot := inScope.atRoot

	// and physical properties.
	outScope := b.buildStmtAtRoot(b.stmt, nil /* desiredTypes */, b.allocScope())

	bld := optbuilder.New(ctx, &p.semaCtx, p.EvalContext(), &opc.catalog, f, opc.p.stmt.AST)
	if err := bld.Build(); err != nil {
	return nil, err


	if err := planner.makeOptimizerPlan(ctx); err != nil {
	log.VEventf(ctx, 1, "optimizer plan failed: %v", err)

	// between here and there needs to happen even if there's an error.
	err := ex.makeExecPlan(ctx, planner)
	// We'll be closing the plan manually below after execution; this

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

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

opt: v20.1.0-rc.2: assertion failed: estimated row count must be non-zero #49911

Description

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions

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

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

Tag	Value
Cockroach Release	`v20.1.0-rc.2`
Cockroach SHA:	`c0f00d2`
Platform	linux amd64
Distribution	CCL
Environment	v20.1.0-rc.2
Command	server
Go Version	`go1.13.9`
# of CPUs	8
# of Goroutines	197