pkg/sql/logictest/tests/5node/5node_test: TestLogic_distsql_stats failed

[cockroach-teamcity]

pkg/sql/logictest/tests/5node/5node_test.TestLogic_distsql_stats failed on release-24.3 @ 5be83d7c3461add218e04a15e158139ef945ea6c:

    logic.go:3107: let $json_stats = [{"avg_size": 4, "columns": ["x"], "created_at": "2025-02-25 10:07:40.686857", "distinct_count": 3, "histo_buckets": [{"distinct_range": 0, "num_eq": 1, "num_range": 0, "upper_bound": "hello"}, {"distinct_range": 0, "num_eq": 1, "num_range": 0, "upper_bound": "howdy"}, {"distinct_range": 0, "num_eq": 1, "num_range": 0, "upper_bound": "hi"}], "histo_col_type": "test.public.e", "histo_version": 3, "id": 1049911822550073349, "name": "s", "null_count": 0, "row_count": 3}, {"avg_size": 3, "columns": ["y"], "created_at": "2025-02-25 10:07:40.686857", "distinct_count": 3, "histo_buckets": [{"distinct_range": 0, "num_eq": 1, "num_range": 0, "upper_bound": "hello"}, {"distinct_range": 0, "num_eq": 1, "num_range": 0, "upper_bound": "howdy"}, {"distinct_range": 0, "num_eq": 1, "num_range": 0, "upper_bound": "hi"}], "histo_col_type": "test.public.e", "histo_version": 3, "id": 1049911822561509381, "name": "s", "null_count": 0, "row_count": 3}, {"avg_size": 7, "columns": ["z"], "created_at": "2025-02-25 10:07:40.686857", "distinct_count": 3, "histo_buckets": [{"distinct_range": 0, "num_eq": 1, "num_range": 0, "upper_bound": "ARRAY['hello':::test.public.e]"}, {"distinct_range": 1, "num_eq": 1, "num_range": 1, "upper_bound": "ARRAY['hi':::test.public.e]"}], "histo_col_type": "test.public.e[]", "histo_version": 3, "id": 1049911822573797381, "name": "s", "null_count": 0, "row_count": 3}]
    logic.go:3107: let $hist_id_1 = 1049911823609757701
    logic.go:3107: let $hist_id_1 = 1049911823893725189
    logic.go:3107: let $hist_id_1 = 1049911824286089221
    logic.go:3107: let $hist_id_1 = 1049911825088184325
[10:07:41] --- progress: /var/lib/engflow/worker/work/2/exec/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: 179 statements
    logic.go:3107: let $hist_id_1 = 1049911829132214277
    logic.go:3107: let $hist_id_1 = 1049911829726330885
    logic.go:3107: let $stats = [{"avg_size": 4, "columns": ["x"], "created_at": "2025-02-25 10:07:43.312118", "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": 3, "id": 1049911831150690309, "name": "s", "null_count": 0, "row_count": 1}]
    logic.go:3107: let $db = test
[10:07:43] --- progress: /var/lib/engflow/worker/work/2/exec/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: 228 statements
    logic.go:3107: let $hist_id_1 = 1049911833622052869
    logic.go:3107: let $hist_id_1 = 1049911833849331717
    logic.go:3107: let $hist_id_1 = 1049911833859817477
[10:07:45] --- progress: /var/lib/engflow/worker/work/2/exec/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: 276 statements
    logic.go:3107: let $hist_abcd_a_partial = 1049911839857344517
    logic.go:3107: let $hist_abcd_c_partial = 1049911839992512517
    logic.go:3107: let $hist_xy_x_partial = 1049911840138559493
    logic.go:3107: let $statistics_id = 1049911839711657989
    logic.go:3107: let $hist_a_null_stat_partial = 1049911840818888709
    logic.go:3107: let $hist_d_desc = 1049911841209810949
    logic.go:3107: let $hist_id_1 = 1049911844322017285
[10:07:47] --- progress: /var/lib/engflow/worker/work/2/exec/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: 355 statements
    logic.go:3107: let $hist_d = 1049911846657490949
    logic.go:3107: let $hist_e = 1049911846821527557
    logic.go:3107: let $hist_f = 1049911846996279301
    logic.go:3107: let $hist_crdb_internal_idx_expr = 1049911848322760709
    logic.go:3107: let $hist_d = 1049911848525266949
    logic.go:3107: let $hist_e = 1049911848681897989
    logic.go:3107: let $hist_crdb_internal_idx_expr = 1049911848843411461
    logic.go:3107: let $hist_id_int_outer_buckets_full = 1049911849477668869
    logic.go:3107: let $hist_id_timestamp_outer_buckets_full = 1049911850448715781
[10:08:03] --- progress: /var/lib/engflow/worker/work/2/exec/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: 425 statements
    logic.go:3107: let $job = 1049911851842666497
[10:08:29] --- progress: /var/lib/engflow/worker/work/2/exec/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: 430 statements
    logic.go:3107: let $hist_status = 1049911983507832834
[10:08:46] --- progress: /var/lib/engflow/worker/work/2/exec/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: 454 statements
    logic.go:3107: let $job = 1049911984075735041
[10:08:53] --- progress: /var/lib/engflow/worker/work/2/exec/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: 458 statements
[10:08:53] --- done: /var/lib/engflow/worker/work/2/exec/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: 462 tests, 0 failures
    logic.go:4247: 
        /var/lib/engflow/worker/work/2/exec/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:3600: error while processing
    logic.go:4247: 
        /var/lib/engflow/worker/work/2/exec/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:3600: 
        expected success, but found
        (55000) column a does not have a prior statistic
        distsql_plan_stats.go:375: in createPartialStatsPlan()
    panic.go:626: -- test log scope end --
test logs left over in: outputs.zip/logTestLogic_distsql_stats558396296
--- FAIL: TestLogic_distsql_stats (81.85s)

Parameters:

• attempt=1
• run=4
• shard=11

Help

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

Same failure on other branches

• pkg/sql/logictest/tests/5node/5node_test: TestLogic_distsql_stats failed #140353 pkg/sql/logictest/tests/5node/5node_test: TestLogic_distsql_stats failed [C-test-failure O-robot T-sql-queries branch-release-24.1]

This test on roachdash | Improve this report!

Jira issue: CRDB-48106