Skip to content

sql: createPartialStatsPlan failed with 'column a does not have a prior statistic...' #92495

@cockroach-teamcity

Description

@cockroach-teamcity

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

Help

See also: How To Investigate a Go Test Failure (internal)

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-21812

Metadata

Metadata

Assignees

No one assigned

    Labels

    C-test-failureBroken test (automatically or manually discovered).O-robotOriginated from a bot.T-sql-queriesSQL Queries Teambranch-masterFailures and bugs on the master branch.branch-release-24.2Used to mark GA and release blockers, technical advisories, and bugs for 24.2v24.2.1

    Type

    No type

    Projects

    Status

    Done

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions