-
Notifications
You must be signed in to change notification settings - Fork 4.1k
sql: createPartialStatsPlan failed with 'column a does not have a prior statistic...' #92495
Copy link
Copy link
Labels
C-test-failureBroken test (automatically or manually discovered).Broken test (automatically or manually discovered).O-robotOriginated from a bot.Originated from a bot.T-sql-queriesSQL Queries TeamSQL Queries Teambranch-masterFailures and bugs on the master branch.Failures and bugs on the master branch.branch-release-24.2Used to mark GA and release blockers, technical advisories, and bugs for 24.2Used to mark GA and release blockers, technical advisories, and bugs for 24.2v24.2.1
Milestone
Description
pkg/sql/logictest/tests/5node/5node_test.TestLogic_distsql_stats failed with artifacts on master @ b5be006bedd7d3cedc3fb3d2248df168e3d64be2:
=== RUN TestLogic_distsql_stats
test_log_scope.go:161: test logs captured to: /artifacts/tmp/_tmp/c1120e87cda9b48ae97a6489658fb611/logTestLogic_distsql_stats3660493154
test_log_scope.go:79: use -show-logs to present logs inline
logic.go:2902: let $t_id = 106
logic.go:2902: let $hist_id_1 = 816923368227799041
logic.go:2902: let $json_stats = [{"avg_size": 1, "columns": ["a"], "created_at": "2022-11-25 11:27:07.117892", "distinct_count": 4, "histo_buckets": [{"distinct_range": 0, "num_eq": 64, "num_range": 0, "upper_bound": "1"}, {"distinct_range": 0, "num_eq": 64, "num_range": 0, "upper_bound": "2"}, {"distinct_range": 0, "num_eq": 64, "num_range": 0, "upper_bound": "3"}, {"distinct_range": 0, "num_eq": 64, "num_range": 0, "upper_bound": "4"}], "histo_col_type": "INT8", "histo_version": 2, "name": "s1", "null_count": 0, "row_count": 256}, {"avg_size": 1, "columns": ["b"], "created_at": "2022-11-25 11:27:07.166733", "distinct_count": 4, "histo_buckets": [{"distinct_range": 0, "num_eq": 64, "num_range": 0, "upper_bound": "1"}, {"distinct_range": 0, "num_eq": 64, "num_range": 0, "upper_bound": "2"}, {"distinct_range": 0, "num_eq": 64, "num_range": 0, "upper_bound": "3"}, {"distinct_range": 0, "num_eq": 64, "num_range": 0, "upper_bound": "4"}], "histo_col_type": "INT8", "histo_version": 2, "null_count": 0, "row_count": 256}]
[11:27:08] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/496/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/5node/5node_test_/5node_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/distsql_stats: 48 statements
logic.go:2902: let $hist_id_3 = 816923373418151941
[11:27:10] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/496/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/5node/5node_test_/5node_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/distsql_stats: 102 statements
logic.go:2902: let $hist_id_1 = 816923379274514437
logic.go:2902: let $hist_id_1 = 816923379587874821
logic.go:2902: let $hist_id_1 = 816923379856179205
logic.go:2902: let $hist_id_1 = 816923380624588805
logic.go:2902: let $hist_id_1 = 816923384333041669
logic.go:2902: let $hist_id_1 = 816923384891473925
[11:27:12] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/496/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/5node/5node_test_/5node_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/distsql_stats: 159 statements
logic.go:2902: let $stats = [{"avg_size": 4, "columns": ["x"], "created_at": "2022-11-25 11:27:12.557142", "distinct_count": 1, "histo_buckets": [{"distinct_range": 0, "num_eq": 1, "num_range": 0, "upper_bound": "hi"}], "histo_col_type": "test.public.greeting", "histo_version": 2, "name": "s", "null_count": 0, "row_count": 1}]
logic.go:2902: let $hist_id_1 = 816923386994327557
logic.go:2902: let $hist_id_1 = 816923387248705541
logic.go:2902: let $hist_id_1 = 816923387266990085
[11:27:14] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/496/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/5node/5node_test_/5node_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/distsql_stats: 210 statements
logic.go:2902: let $hist_abcd_a_partial = 816923395317858309
logic.go:2902: let $hist_abcd_c_partial = 816923395395190789
logic.go:2902: let $hist_xy_x_partial = 816923395497558021
logic.go:3182:
/home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/496/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/5node/5node_test_/5node_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/distsql_stats:2091:
expected success, but found
(55000) column a does not have a prior statistic, or the prior histogram has no buckets and a partial statistic cannot be collected
distsql_plan_stats.go:233: in createPartialStatsPlan()
[11:27:15] --- done: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/496/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/5node/5node_test_/5node_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/distsql_stats with config 5node: 243 tests, 1 failures
logic.go:3968:
/home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/496/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/5node/5node_test_/5node_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/distsql_stats:2091: error while processing
logic.go:3968: pq: column a does not have a prior statistic, or the prior histogram has no buckets and a partial statistic cannot be collected
panic.go:522: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/c1120e87cda9b48ae97a6489658fb611/logTestLogic_distsql_stats3660493154
--- FAIL: TestLogic_distsql_stats (10.96s)
Parameters: TAGS=bazel,gss
This test on roachdash | Improve this report!
Jira issue: CRDB-21812
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
C-test-failureBroken test (automatically or manually discovered).Broken test (automatically or manually discovered).O-robotOriginated from a bot.Originated from a bot.T-sql-queriesSQL Queries TeamSQL Queries Teambranch-masterFailures and bugs on the master branch.Failures and bugs on the master branch.branch-release-24.2Used to mark GA and release blockers, technical advisories, and bugs for 24.2Used to mark GA and release blockers, technical advisories, and bugs for 24.2v24.2.1
Type
Projects
Status
Done