search

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.
https://www.cockroachlabs.com
Other
30.1k stars 3.81k forks source link

Sentry: error.go:20: unexpected error: forecasted histogram had first bucket with non-zero NumRange or DistinctRange: [{"name":"__forecast__","created_at":"2024-11-01 08:09:36.42883425 +0000 UTC","col... #134031

Open cockroach-sentry opened 6 days ago

cockroach-sentry commented 6 days ago

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

Panic Message:

error.go:20: unexpected error: forecasted histogram had first bucket with non-zero NumRange or DistinctRange: [{"name":"__forecast__","created_at":"2024-11-01 08:09:36.42883425 +0000 UTC","columns":["1"],"row_count":736,"distinct_count":736,"null_count":0,"avg_size":9,"histo_col_type":"INT8","histo_buckets":[{"num_eq":1,"num_range":0,"distinct_range":2.8421709430404e-13,"upper_bound":"_f899139df5e1059396431415e770c6dd"},{"num_eq":1,"num_range":2,"distinct_range":1.6666666666666665,"upper_bound":"_c9e1074f5b3f9fc8ea15d152add07294"},{"num_eq":1,"num_range":37,"distinct_range":37.332640488629686,"upper_bound":"_3d087c2780c5886823ecc7f25321ff48"},{"num_eq":1,"num_range":2,"distinct_range":2.000001418622736,"upper_bound":"_43bf65a6a5fd236610bd7761a249300b"},{"num_eq":1,"num_range":2,"distinct_range":1.999999861337837,"upper_bound":"_71f0b2e1d679fb722d72c71c208d5722"}],"histo_version":3},{"name":"__merged__","created_at":"2024-11-01 08:05:35.503656 +0000 UTC","columns":["1"],"row_count":701,"distinct_count":701,"null_count":0,"avg_size":9,"histo_col_type":"INT8","histo_buckets":[{"num_eq":1,"num_range":0,"distinct_range":2.8421709430404007e-13,"upper_bound":"_f899139df5e1059396431415e770c6dd"},{"num_eq":1,"num_range":2,"distinct_range":1.6666666666666667,"upper_bound":"_c9e1074f5b3f9fc8ea15d152add07294"},{"num_eq":1,"num_range":2,"distinct_range":2.3332740512770016,"upper_bound":"_3d087c2780c5886823ecc7f25321ff48"},{"num_eq":1,"num_range":2,"distinct_range":2.0000006690416345,"upper_bound":"_43bf65a6a5fd236610bd7761a249300b"},{"num_eq":1,"num_range":2,"distinct_range":1.999999229778512,"upper_bound":"_71f0b2e1d679fb722d72c71c208d5722"}],"histo_version":3},{"name":"__auto__","created_at":"2024-11-01 07:56:23.475349 +0000 UTC","columns":["1"],"row_count":633,"distinct_count":633,"null_count":0,"avg_size":9,"histo_col_type":"INT8","histo_buckets":[{"num_eq":0,"num_range":0,"distinct_range":0,"upper_bound":"_e12c22bb0312e7872c49884f8304d882"},{"num_eq":1,"num_range":0,"distinct_range":2.8421709430404007e-13,"upper_bound":"_f899139df5e1059396431415e770c6dd"},{"num_eq":1,"num_range":2,"distinct_range":1.6666666666666667,"upper_bound":"_c9e1074f5b3f9fc8ea15d152add07294"},{"num_eq":1,"num_range":2,"distinct_range":2.3332740512767742,"upper_bound":"_3d087c2780c5886823ecc7f25321ff48"},{"num_eq":1,"num_range":2,"distinct_range":2.0000006690416345,"upper_bound":"_43bf65a6a5fd236610bd7761a249300b"}],"histo_version":3},{"name":"__auto__","created_at":"2024-11-01 07:53:21.834414 +0000 UTC","columns":["1"],"row_count":611,"distinct_count":611,"null_count":0,"avg_size":9,"histo_col_type":"INT8","histo_buckets":[{"num_eq":0,"num_range":0,"distinct_range":0,"upper_bound":"_e12c22bb0312e7872c49884f8304d882"},{"num_eq":1,"num_range":0,"distinct_range":2.2737367544323206e-13,"upper_bound":"_f899139df5e1059396431415e770c6dd"},{"num_eq":1,"num_range":2,"distinct_range":1.6666666666666667,"upper_bound":"_c9e1074f5b3f9fc8ea15d152add07294"},{"num_eq":1,"num_range":2,"distinct_range":2.333193244846421,"upper_bound":"_3d087c2780c5886823ecc7f25321ff48"},{"num_eq":1,"num_range":2,"distinct_range":2.000000669039904,"upper_bound":"_43bf65a6a5fd236610bd7761a249300b"}],"histo_version":3},{"name":"__auto__","created_at":"2024-11-01 07:49:30.126659 +0000 UTC","columns":["1"],"row_count":578,"distinct_count":578,"null_count":0,"avg_size":9,"histo_col_type":"INT8","histo_buckets":[{"num_eq":0,"num_range":0,"distinct_range":0,"upper_bound":"_e12c22bb0312e7872c49884f8304d882"},{"num_eq":1,"num_range":0,"distinct_range":1.1368683772161603e-13,"upper_bound":"_f899139df5e1059396431415e770c6dd"},{"num_eq":1,"num_range":1,"distinct_range":1,"upper_bound":"_6974ce5ac660610b44d9b9fed0ff9548"},{"num_eq":1,"num_range":1,"distinct_range":1,"upper_bound":"_65b9eea6e1cc6bb9f0cd2a47751a186f"},{"num_eq":1,"num_range":1,"distinct_range":1.0000501921926213,"upper_bound":"_3d087c2780c5886823ecc7f25321ff48"}],"histo_version":3},{"name":"__auto__","created_at":"2024-11-01 07:49:14.485717 +0000 UTC","columns":["1"],"row_count":578,"distinct_count":578,"null_count":0,"avg_size":9,"histo_col_type":"INT8","histo_buckets":[{"num_eq":0,"num_range":0,"distinct_range":0,"upper_bound":"_e12c22bb0312e7872c49884f8304d882"},{"num_eq":1,"num_range":0,"distinct_range":1.1368683772161603e-13,"upper_bound":"_f899139df5e1059396431415e770c6dd"},{"num_eq":1,"num_range":1,"distinct_range":1,"upper_bound":"_6974ce5ac660610b44d9b9fed0ff9548"},{"num_eq":1,"num_range":1,"distinct_range":1,"upper_bound":"_65b9eea6e1cc6bb9f0cd2a47751a186f"},{"num_eq":1,"num_range":1,"distinct_range":1.0000501921926213,"upper_bound":"_3d087c2780c5886823ecc7f25321ff48"}],"histo_version":3},{"name":"__auto__","created_at":"2024-11-01 07:40:19.774636 +0000 UTC","columns":["1"],"row_count":501,"distinct_count":501,"null_count":0,"avg_size":9,"histo_col_type":"INT8","histo_buckets":[{"num_eq":1,"num_range":0,"distinct_range":0,"upper_bound":"_f899139df5e1059396431415e770c6dd"},{"num_eq":1,"num_range":1,"distinct_range":0.9999998900910911,"upper_bound":"_6974ce5ac660610b44d9b9fed0ff9548"},{"num_eq":1,"num_range":1,"distinct_range":0.9999998900910911,"upper_bound":"_65b9eea6e1cc6bb9f0cd2a47751a186f"},{"num_eq":1,"num_range":1,"distinct_range":0.9999998900910911,"upper_bound":"_3d087c2780c5886823ecc7f25321ff48"},{"num_eq":1,"num_range":1,"distinct_range":1.0000008743075084,"upper_bound":"_425e2429f4d57338f8285f749e19007e"}],"histo_version":3}]
(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:855
  | github.com/cockroachdb/cockroach/pkg/sql/stats.(*TableStatisticsCache).refreshCacheEntry.func1
  |     pkg/sql/stats/stats_cache.go:502
  | github.com/cockroachdb/cockroach/pkg/sql/stats.(*TableStatisticsCache).refreshCacheEntry
  |     pkg/sql/stats/stats_cache.go:504
  | github.com/cockroachdb/cockroach/pkg/sql/stats.(*TableStatisticsCache).refreshTableStats.func1
  |     pkg/sql/stats/stats_cache.go:530
  | github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunAsyncTaskEx.func2
  |     pkg/util/stop/stopper.go:498
  | runtime.goexit
  |     src/runtime/asm_amd64.s:1695
Wraps: (6) forecasted histogram had first bucket with non-zero NumRange or DistinctRange: [{"name":"__forecast__","created_at":"2024-11-01 08:09:36.42883425 +0000 UTC","columns":["1"],"row_count":736,"distinct_count":736,"null_count":0,"avg_size":9,"histo_col_type":"INT8","histo_buckets":[{"num_eq":1,"num_range":0,"distinct_range":2.8421709430404e-13,"upper_bound":"_f899139df5e1059396431415e770c6dd"},{"num_eq":1,"num_range":2,"distinct_range":1.6666666666666665,"upper_bound":"_c9e1074f5b3f9fc8ea15d152add07294"},{"num_eq":1,"num_range":37,"distinct_range":37.332640488629686,"upper_bound":"_3d087c2780c5886823ecc7f25321ff48"},{"num_eq":1,"num_range":2,"distinct_range":2.000001418622736,"upper_bound":"_43bf65a6a5fd236610bd7761a249300b"},{"num_eq":1,"num_range":2,"distinct_range":1.999999861337837,"upper_bound":"_71f0b2e1d679fb722d72c71c208d5722"}],"histo_version":3},{"name":"__merged__","created_at":"2024-11-01 08:05:35.503656 +0000 UTC","columns":["1"],"row_count":701,"distinct_count":701,"null_count":0,"avg_size":9,"histo_col_type":"INT8","histo_buckets":[{"num_eq":1,"num_range":0,"distinct_range":2.8421709430404007e-13,"upper_bound":"_f899139df5e1059396431415e770c6dd"},{"num_eq":1,"num_range":2,"distinct_range":1.6666666666666667,"upper_bound":"_c9e1074f5b3f9fc8ea15d152add07294"},{"num_eq":1,"num_range":2,"distinct_range":2.3332740512770016,"upper_bound":"_3d087c2780c5886823ecc7f253...
Stacktrace (expand for inline code snippets): [src/runtime/asm_amd64.s#L1694-L1696](src/runtime/asm_amd64.s#L1694-L1696) [pkg/util/stop/stopper.go#L497-L499](pkg/util/stop/stopper.go#L497-L499) [pkg/sql/stats/stats_cache.go#L529-L531](pkg/sql/stats/stats_cache.go#L529-L531) [pkg/sql/stats/stats_cache.go#L503-L505](pkg/sql/stats/stats_cache.go#L503-L505) [pkg/sql/stats/stats_cache.go#L501-L503](pkg/sql/stats/stats_cache.go#L501-L503) [pkg/sql/stats/stats_cache.go#L854-L856](pkg/sql/stats/stats_cache.go#L854-L856) [pkg/sql/stats/forecast.go#L147-L149](pkg/sql/stats/forecast.go#L147-L149) [pkg/sql/stats/forecast.go#L380-L382](pkg/sql/stats/forecast.go#L380-L382) [pkg/util/errorutil/error.go#L20-L22](pkg/util/errorutil/error.go#L20-L22) [src/runtime/asm_amd64.s#L1694-L1696](src/runtime/asm_amd64.s#L1694-L1696) [pkg/util/stop/stopper.go#L497-L499](pkg/util/stop/stopper.go#L497-L499) [pkg/sql/stats/stats_cache.go#L529-L531](pkg/sql/stats/stats_cache.go#L529-L531) [pkg/sql/stats/stats_cache.go#L503-L505](pkg/sql/stats/stats_cache.go#L503-L505) [pkg/sql/stats/stats_cache.go#L501-L503](pkg/sql/stats/stats_cache.go#L501-L503) [pkg/sql/stats/stats_cache.go#L854-L856](pkg/sql/stats/stats_cache.go#L854-L856) [pkg/sql/stats/forecast.go#L147-L149](pkg/sql/stats/forecast.go#L147-L149) [pkg/sql/stats/forecast.go#L380-L382](pkg/sql/stats/forecast.go#L380-L382) [pkg/util/errorutil/error.go#L19-L21](pkg/util/errorutil/error.go#L19-L21) 
src/runtime/asm_amd64.s in runtime.goexit at line 1695
pkg/util/stop/stopper.go in pkg/util/stop.(*Stopper).RunAsyncTaskEx.func2 at line 498
pkg/sql/stats/stats_cache.go in pkg/sql/stats.(*TableStatisticsCache).refreshTableStats.func1 at line 530
pkg/sql/stats/stats_cache.go in pkg/sql/stats.(*TableStatisticsCache).refreshCacheEntry at line 504
pkg/sql/stats/stats_cache.go in pkg/sql/stats.(*TableStatisticsCache).refreshCacheEntry.func1 at line 502
pkg/sql/stats/stats_cache.go in pkg/sql/stats.(*TableStatisticsCache).getTableStatsFromDB at line 855
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/util/stop/stopper.go in pkg/util/stop.(*Stopper).RunAsyncTaskEx.func2 at line 498
pkg/sql/stats/stats_cache.go in pkg/sql/stats.(*TableStatisticsCache).refreshTableStats.func1 at line 530
pkg/sql/stats/stats_cache.go in pkg/sql/stats.(*TableStatisticsCache).refreshCacheEntry at line 504
pkg/sql/stats/stats_cache.go in pkg/sql/stats.(*TableStatisticsCache).refreshCacheEntry.func1 at line 502
pkg/sql/stats/stats_cache.go in pkg/sql/stats.(*TableStatisticsCache).getTableStatsFromDB at line 855
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.0-alpha.3
Go Version go1.22.5fips X:boringcrypto,nocoverageredesign
Platform linux amd64
Distribution CCL
Cockroach Release v24.3.0-alpha.2-861-gf9918d8f81a
Cockroach SHA f9918d8f81a1829df63ac734fd6d21c60141e338
# of CPUs 16
# of Goroutines 906

Jira issue: CRDB-43884

blathers-crl[bot] commented 6 days ago

Hi @cockroach-sentry, please add branch-* labels to identify which branch(es) this C-bug affects.

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