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 master @ 64bd4bbac8f8d27a2fe4968404cc3d048480375f:

    logic.go:3014: let $j_stats = [{"avg_size": 18, "columns": ["j"], "created_at": "2024-05-31 04:35:57.392866", "distinct_count": 3, "histo_buckets": [{"distinct_range": 0, "num_eq": 1, "num_range": 0, "upper_bound": "{\"1\": \"10\"}"}, {"distinct_range": 0, "num_eq": 1, "num_range": 0, "upper_bound": "{\"2\": \"20\"}"}, {"distinct_range": 0, "num_eq": 1, "num_range": 0, "upper_bound": "{\"3\": \"30\"}"}], "histo_col_type": "JSONB", "histo_version": 3, "name": "j_full", "null_count": 0, "row_count": 3}]
    logic.go:3014: let $only_null_stat = [{"avg_size": 0, "columns": ["a"], "created_at": "2024-05-31 04:35:57.698666", "distinct_count": 1, "histo_col_type": "INT8", "histo_version": 3, "name": "only_null_stat", "null_count": 3, "row_count": 3}]
    logic.go:3014: let $hist_id_1 = 973405415552942085
    logic.go:3014: let $hist_d = 973405416421851141
    logic.go:3014: let $hist_e = 973405416576811013
    logic.go:3014: let $hist_f = 973405416726626309
    logic.go:3014: let $hist_crdb_internal_idx_expr = 973405418215931909
    logic.go:3014: let $hist_d = 973405418407362565
    logic.go:3014: let $hist_e = 973405418572513285
    logic.go:3014: let $hist_crdb_internal_idx_expr = 973405418733076485
[04:36:18] --- progress: /var/lib/engflow/worker/work/1/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: 357 statements
    logic.go:2968: 
         
        /var/lib/engflow/worker/work/1/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:2810: EXPLAIN SELECT * FROM mno WHERE n = 1 AND o = 9
        expected:
            distribution: full
            vectorized: true
            ·
            • render
            │
            └── • filter
                │ estimated row count: 0
                │ filter: n = 1
                │
                └── • scan
                      estimated row count: 18 (1.8% of the table; stats collected <hidden> ago)
                      table: mno@mno_o_idx
                      spans: [/9 - /9]
            
        but found (query options: "") :
            distribution: full
            vectorized: true
            ·
            • render
            │
            └── • filter
                │ filter: sqrt(m::FLOAT8)::INT8 = 9
                │
                └── • scan
                      missing stats
                      table: mno@mno_n_idx
                      spans: [/1 - /1]
            
[04:36:18] --- done: /var/lib/engflow/worker/work/1/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: 366 tests, 1 failures
    logic.go:4135: 
        /var/lib/engflow/worker/work/1/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:2827: error while processing
    logic.go:4135: /var/lib/engflow/worker/work/1/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:2827: too many errors encountered, skipping the rest of the input
    panic.go:626: -- test log scope end --
test logs left over in: outputs.zip/logTestLogic_distsql_stats677399404
--- FAIL: TestLogic_distsql_stats (35.91s)

Parameters:

• attempt=1
• run=22
• shard=11

Help

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

This test on roachdash | Improve this report!

Jira issue: CRDB-39130

[DrewKimball]

Dupe of #121424