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: error.go:20: unexpected error: forecasted histogram had first bucket with non-zero NumRange or DistinctRange: (1) × Wraps: (2) issue #93892 Wraps: (3) attached stack trace -- stack trace: ... #141711

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

Sentry: error.go:20: unexpected error: forecasted histogram had first bucket with non-zero NumRange or DistinctRange: (1) × Wraps: (2) issue #93892 Wraps: (3) attached stack trace -- stack trace: ... #141711

cockroach-sentry opened this issue Feb 19, 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 19, 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/6313977902/?referrer=webhooks_plugin

Panic Message:

error.go:20: unexpected error: forecasted histogram had first bucket with non-zero NumRange or DistinctRange: 
(1) ×
Wraps: (2) issue #93892
Wraps: (3) attached stack trace
  -- stack trace:
  | github.com/cockroachdb/cockroach/pkg/util/errorutil.UnexpectedWithIssueErrorf
  | 	pkg/util/errorutil/error.go:21
  | [...repeated from below...]
Wraps: (4) unexpected error
Wraps: (5) attached stack trace
  -- stack trace:
  | github.com/cockroachdb/cockroach/pkg/util/errorutil.UnexpectedWithIssueErrorf
  | 	pkg/util/errorutil/error.go:20
  | github.com/cockroachdb/cockroach/pkg/sql/stats.forecastColumnStatistics
  | 	pkg/sql/stats/forecast.go:381
  | github.com/cockroachdb/cockroach/pkg/sql/stats.ForecastTableStatistics
  | 	pkg/sql/stats/forecast.go:148
  | github.com/cockroachdb/cockroach/pkg/sql/stats.(*TableStatisticsCache).getTableStatsFromDB
  | 	pkg/sql/stats/stats_cache.go:875
  | github.com/cockroachdb/cockroach/pkg/sql/stats.(*TableStatisticsCache).addCacheEntryLocked.func1
  | 	pkg/sql/stats/stats_cache.go:423
  | github.com/cockroachdb/cockroach/pkg/sql/stats.(*TableStatisticsCache).addCacheEntryLocked
  | 	pkg/sql/stats/stats_cache.go:425
  | github.com/cockroachdb/cockroach/pkg/sql/stats.(*TableStatisticsCache).getTableStatsFromCache
  | 	pkg/sql/stats/stats_cache.go:330
  | github.com/cockroachdb/cockroach/pkg/sql/stats.(*TableStatisticsCache).GetTableStats
  | 	pkg/sql/stats/stats_cache.go:229
  | github.com/cockroachdb/cockroach/pkg/sql.(*optCatalog).dataSourceForTable
  | 	pkg/sql/opt_catalog.go:571
  | github.com/cockroachdb/cockroach/pkg/sql.(*optCatalog).dataSourceForDesc
  | 	pkg/sql/opt_catalog.go:531
  | github.com/cockroachdb/cockroach/pkg/sql.(*optCatalog).ResolveDataSource
  | 	pkg/sql/opt_catalog.go:265
  | github.com/cockroachdb/cockroach/pkg/sql/opt.(*Metadata).CheckDependencies
  | 	pkg/sql/opt/metadata.go:388
  | github.com/cockroachdb/cockroach/pkg/sql/opt/memo.(*Memo).IsStale
  | 	pkg/sql/opt/memo/memo.go:467
  | github.com/cockroachdb/cockroach/pkg/sql.(*planner).prepareUsingOptimizer
  | 	pkg/sql/plan_opt.go:142
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).populatePrepared
  | 	pkg/sql/conn_executor_prepare.go:339
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).prepare.func2
  | 	pkg/sql/conn_executor_prepare.go:279
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).prepare
  | 	pkg/sql/conn_executor_prepare.go:284
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).addPreparedStmt
  | 	pkg/sql/conn_executor_prepare.go:117
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execPrepare
  | 	pkg/sql/conn_executor_prepare.go:78
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd
  | 	pkg/sql/conn_executor.go:2472
  | github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).run
  | 	pkg/sql/conn_executor.go:2263
  | github.com/cockroachdb/cockroach/pkg/sql.(*Server).ServeConn
  | 	pkg/sql/conn_executor.go:963
  | github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).processCommands
  | 	pkg/sql/pgwire/conn.go:251
  | github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*Server).serveImpl.func4
  | 	pkg/sql/pgwire/server.go:1196
  | runtime.goexit
  | 	src/runtime/asm_amd64.s:1695
Wraps: (6) forecasted histogram had first bucket with non-zero NumRange or DistinctRange: 
Error types: (1) *hintdetail.withHint (2) *safedetails.withSafeDetails (3) *withstack.withStack (4) *errutil.withPrefix (5) *withstack.withStack (6) *errutil.leafError
-- report composition:
*errutil.leafError: forecasted histogram had first bucket with non-zero NumRange or DistinctRange: 
error.go:20: *withstack.withStack (top exception)
*errutil.withPrefix: unexpected error
error.go:21: *withstack.withStack (1)
*safedetails.withSafeDetails: issue #93892
*hintdetail.withHint
(check the extra data payloads)
Stacktrace (expand for inline code snippets):

src/runtime/asm_amd64.s#L1694-L1696
pkg/sql/pgwire/server.go#L1195-L1197
pkg/sql/pgwire/conn.go#L250-L252
pkg/sql/conn_executor.go#L962-L964
pkg/sql/conn_executor.go#L2262-L2264
pkg/sql/conn_executor.go#L2471-L2473
pkg/sql/conn_executor_prepare.go#L77-L79
pkg/sql/conn_executor_prepare.go#L116-L118
pkg/sql/conn_executor_prepare.go#L283-L285
pkg/sql/conn_executor_prepare.go#L278-L280
pkg/sql/conn_executor_prepare.go#L338-L340
pkg/sql/plan_opt.go#L141-L143
pkg/sql/opt/memo/memo.go#L466-L468
pkg/sql/opt/metadata.go#L387-L389
pkg/sql/opt_catalog.go#L264-L266
pkg/sql/opt_catalog.go#L530-L532
pkg/sql/opt_catalog.go#L570-L572
pkg/sql/stats/stats_cache.go#L228-L230
pkg/sql/stats/stats_cache.go#L329-L331
pkg/sql/stats/stats_cache.go#L424-L426
pkg/sql/stats/stats_cache.go#L422-L424
pkg/sql/stats/stats_cache.go#L874-L876
pkg/sql/stats/forecast.go#L147-L149
pkg/sql/stats/forecast.go#L380-L382
pkg/util/errorutil/error.go#L20-L22
src/runtime/asm_amd64.s#L1694-L1696
pkg/sql/pgwire/server.go#L1195-L1197
pkg/sql/pgwire/conn.go#L250-L252
pkg/sql/conn_executor.go#L962-L964
pkg/sql/conn_executor.go#L2262-L2264
pkg/sql/conn_executor.go#L2471-L2473
pkg/sql/conn_executor_prepare.go#L77-L79
pkg/sql/conn_executor_prepare.go#L116-L118
pkg/sql/conn_executor_prepare.go#L283-L285
pkg/sql/conn_executor_prepare.go#L278-L280
pkg/sql/conn_executor_prepare.go#L338-L340
pkg/sql/plan_opt.go#L141-L143
pkg/sql/opt/memo/memo.go#L466-L468
pkg/sql/opt/metadata.go#L387-L389
pkg/sql/opt_catalog.go#L264-L266
pkg/sql/opt_catalog.go#L530-L532
pkg/sql/opt_catalog.go#L570-L572
pkg/sql/stats/stats_cache.go#L228-L230
pkg/sql/stats/stats_cache.go#L329-L331
pkg/sql/stats/stats_cache.go#L424-L426
pkg/sql/stats/stats_cache.go#L422-L424
pkg/sql/stats/stats_cache.go#L874-L876
pkg/sql/stats/forecast.go#L147-L149
pkg/sql/stats/forecast.go#L380-L382
pkg/util/errorutil/error.go#L19-L21

src/runtime/asm_amd64.s in runtime.goexit at line 1695
pkg/sql/pgwire/server.go in pkg/sql/pgwire.(*Server).serveImpl.func4 at line 1196
pkg/sql/pgwire/conn.go in pkg/sql/pgwire.(*conn).processCommands at line 251
pkg/sql/conn_executor.go in pkg/sql.(*Server).ServeConn at line 963
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).run at line 2263
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).execCmd at line 2472
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).execPrepare at line 78
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).addPreparedStmt at line 117
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).prepare at line 284
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).prepare.func2 at line 279
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).populatePrepared at line 339
pkg/sql/plan_opt.go in pkg/sql.(*planner).prepareUsingOptimizer at line 142
pkg/sql/opt/memo/memo.go in pkg/sql/opt/memo.(*Memo).IsStale at line 467
pkg/sql/opt/metadata.go in pkg/sql/opt.(*Metadata).CheckDependencies at line 388
pkg/sql/opt_catalog.go in pkg/sql.(*optCatalog).ResolveDataSource at line 265
pkg/sql/opt_catalog.go in pkg/sql.(*optCatalog).dataSourceForDesc at line 531
pkg/sql/opt_catalog.go in pkg/sql.(*optCatalog).dataSourceForTable at line 571
pkg/sql/stats/stats_cache.go in pkg/sql/stats.(*TableStatisticsCache).GetTableStats at line 229
pkg/sql/stats/stats_cache.go in pkg/sql/stats.(*TableStatisticsCache).getTableStatsFromCache at line 330
pkg/sql/stats/stats_cache.go in pkg/sql/stats.(*TableStatisticsCache).addCacheEntryLocked at line 425
pkg/sql/stats/stats_cache.go in pkg/sql/stats.(*TableStatisticsCache).addCacheEntryLocked.func1 at line 423
pkg/sql/stats/stats_cache.go in pkg/sql/stats.(*TableStatisticsCache).getTableStatsFromDB at line 875
pkg/sql/stats/forecast.go in pkg/sql/stats.ForecastTableStatistics at line 148
pkg/sql/stats/forecast.go in pkg/sql/stats.forecastColumnStatistics at line 381
pkg/util/errorutil/error.go in pkg/util/errorutil.UnexpectedWithIssueErrorf at line 21
src/runtime/asm_amd64.s in runtime.goexit at line 1695
pkg/sql/pgwire/server.go in pkg/sql/pgwire.(*Server).serveImpl.func4 at line 1196
pkg/sql/pgwire/conn.go in pkg/sql/pgwire.(*conn).processCommands at line 251
pkg/sql/conn_executor.go in pkg/sql.(*Server).ServeConn at line 963
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).run at line 2263
pkg/sql/conn_executor.go in pkg/sql.(*connExecutor).execCmd at line 2472
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).execPrepare at line 78
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).addPreparedStmt at line 117
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).prepare at line 284
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).prepare.func2 at line 279
pkg/sql/conn_executor_prepare.go in pkg/sql.(*connExecutor).populatePrepared at line 339
pkg/sql/plan_opt.go in pkg/sql.(*planner).prepareUsingOptimizer at line 142
pkg/sql/opt/memo/memo.go in pkg/sql/opt/memo.(*Memo).IsStale at line 467
pkg/sql/opt/metadata.go in pkg/sql/opt.(*Metadata).CheckDependencies at line 388
pkg/sql/opt_catalog.go in pkg/sql.(*optCatalog).ResolveDataSource at line 265
pkg/sql/opt_catalog.go in pkg/sql.(*optCatalog).dataSourceForDesc at line 531
pkg/sql/opt_catalog.go in pkg/sql.(*optCatalog).dataSourceForTable at line 571
pkg/sql/stats/stats_cache.go in pkg/sql/stats.(*TableStatisticsCache).GetTableStats at line 229
pkg/sql/stats/stats_cache.go in pkg/sql/stats.(*TableStatisticsCache).getTableStatsFromCache at line 330
pkg/sql/stats/stats_cache.go in pkg/sql/stats.(*TableStatisticsCache).addCacheEntryLocked at line 425
pkg/sql/stats/stats_cache.go in pkg/sql/stats.(*TableStatisticsCache).addCacheEntryLocked.func1 at line 423
pkg/sql/stats/stats_cache.go in pkg/sql/stats.(*TableStatisticsCache).getTableStatsFromDB at line 875
pkg/sql/stats/forecast.go in pkg/sql/stats.ForecastTableStatistics at line 148
pkg/sql/stats/forecast.go in pkg/sql/stats.forecastColumnStatistics at line 381
pkg/util/errorutil/error.go in pkg/util/errorutil.UnexpectedWithIssueErrorf at line 20

Tags

Tag Value
Command server
Environment v24.3.4
Go Version go1.22.8 X:nocoverageredesign
Platform linux amd64
Distribution CCL
Cockroach Release v24.3.4
Cockroach SHA 781c478
# of CPUs 4
# of Goroutines 927

Jira issue: CRDB-47970
@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 19, 2025
@blathers-crl blathers[crl]
Copy link

blathers-crl bot commented Feb 19, 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 19, 2025
@github-project-automation github-project-automation bot moved this to Triage in SQL Queries Feb 19, 2025
@github-project-automation github-project-automation bot moved this from Triage to Done in SQL Queries Feb 21, 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