Skip to content

logictest: indeterministic result for partial stats logictest #92559

@cockroach-teamcity

Description

@cockroach-teamcity

pkg/sql/logictest/tests/5node/5node_test.TestLogic_distsql_stats failed with artifacts on master @ 1a6e9f885baa124d5ff2996adb966ea15a1a9b2b:

=== RUN   TestLogic_distsql_stats
    test_log_scope.go:161: test logs captured to: /artifacts/tmp/_tmp/c1120e87cda9b48ae97a6489658fb611/logTestLogic_distsql_stats358301138
    test_log_scope.go:79: use -show-logs to present logs inline
[10:53:25] setting distsql_workmem='65444B';
    logic.go:2902: let $t_id = 106
    logic.go:2902: let $hist_id_1 = 817766095148318721
    logic.go:2902: let $json_stats = [{"avg_size": 1, "columns": ["a"], "created_at": "2022-11-28 10:53:26.963539", "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-28 10:53:27.013829", "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}]
[10:53:28] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/1836/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: 45 statements
    logic.go:2902: let $hist_id_3 = 817766101048885253
[10:53:30] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/1836/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: 75 statements
    logic.go:2902: let $hist_id_1 = 817766107839987717
    logic.go:2902: let $hist_id_1 = 817766108170289157
    logic.go:2902: let $hist_id_1 = 817766108475916293
    logic.go:2902: let $hist_id_1 = 817766109416816645
[10:53:32] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/1836/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: 137 statements
    logic.go:2902: let $hist_id_1 = 817766113966129157
    logic.go:2902: let $hist_id_1 = 817766114679422981
    logic.go:2902: let $stats = [{"avg_size": 4, "columns": ["x"], "created_at": "2022-11-28 10:53:33.392827", "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 = 817766117873778693
    logic.go:2902: let $hist_id_1 = 817766118189105157
    logic.go:2902: let $hist_id_1 = 817766118205587461
[10:53:34] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/1836/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: 197 statements
[10:53:37] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/1836/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: 212 statements
    logic.go:2902: let $hist_abcd_a_partial = 817766132580777989
    logic.go:2902: let $hist_abcd_c_partial = 817766132693008389
    logic.go:2902: let $hist_xy_x_partial = 817766132809990149
    logic.go:2902: let $hist_a_null_stat_partial = 817766133559164933
    logic.go:2902: let $hist_d_desc = 817766133914796037
    logic.go:2856: 
         
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/1836/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:2152: SELECT "statistics_name", "partial_predicate", "row_count", "null_count" FROM [SHOW STATISTICS FOR TABLE d_desc];
        expected:
            statistics_name  partial_predicate            row_count  null_count
            sdn              NULL                         8          2
            sdnp             a < 0 OR a > 5 OR a is NULL  2          2
            
        but found (query options: "colnames") :
            statistics_name  partial_predicate            row_count  null_count
            sdn              NULL                         8          2
            sdnp             a < 1 OR a > 4 OR a is NULL  4          2
[10:53:38] --- done: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/1836/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: 257 tests, 1 failures
    logic.go:3968: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/1836/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:2159: error while processing
    logic.go:3968: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/1836/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:2159: too many errors encountered, skipping the rest of the input
    panic.go:522: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/c1120e87cda9b48ae97a6489658fb611/logTestLogic_distsql_stats358301138
--- FAIL: TestLogic_distsql_stats (14.86s)

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-21864

Metadata

Metadata

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.

Type

No type

Projects

Status

Done

Relationships

None yet

Development

No branches or pull requests

Issue actions