pkg/sql/logictest/tests/local-legacy-schema-changer/local-legacy-schema-changer_test: TestLogic_distsql_automatic_partial_stats failed

[cockroach-teamcity]

pkg/sql/logictest/tests/local-legacy-schema-changer/local-legacy-schema-changer_test.TestLogic_distsql_automatic_partial_stats failed on release-25.1 @ 581433a5f096e05cb0654a114120c9f782f06588:

=== RUN   TestLogic_distsql_automatic_partial_stats
    test_log_scope.go:165: test logs captured to: outputs.zip/logTestLogic_distsql_automatic_partial_stats2044078663
    test_log_scope.go:76: use -show-logs to present logs inline
    test_server_shim.go:139: cluster virtualization disabled in global scope due to issue: #76378 (expected label: C-bug)
    logic.go:3050: 
         
        /var/lib/engflow/worker/work/1/exec/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/local-legacy-schema-changer/local-legacy-schema-changer_test_/local-legacy-schema-changer_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/distsql_automatic_partial_stats:48: SELECT DISTINCT ON (statistics_name, column_names) statistics_name, column_names, row_count, distinct_count, null_count, partial_predicate
        FROM [SHOW STATISTICS FOR TABLE data] ORDER BY statistics_name, column_names, created DESC
        expected:
            statistics_name   column_names  row_count  distinct_count  null_count  partial_predicate
            __auto__          {a}           1000       10              0           NULL
            __auto__          {a,b}         1000       100             0           NULL
            __auto__          {a,b,c}       1000       1000            0           NULL
            __auto__          {b}           1000       10              0           NULL
            __auto__          {c}           1000       10              0           NULL
            __auto__          {d}           1000       1               0           NULL
            __auto_partial__  {a}           0          0               0           (a IS NULL) OR ((a < 1:::INT8) OR (a > 10:::INT8))
            __auto_partial__  {c}           0          0               0           (c IS NULL) OR ((c < 1.0:::FLOAT8) OR (c > 10.0:::FLOAT8))
            __auto_partial__  {d}           100        1               0           (d IS NULL) OR ((d < 1:::DECIMAL) OR (d > 1:::DECIMAL))
            
        but found (query options: "colnames,retry") :
            statistics_name  column_names  row_count  distinct_count  null_count  partial_predicate
            __auto__         {a}           1000       10              0           NULL
            __auto__         {a,b}         1000       100             0           NULL
            __auto__         {a,b,c}       1000       1000            0           NULL
            __auto__         {b}           1000       10              0           NULL
            __auto__         {c}           1000       10              0           NULL
            __auto__         {d}           1000       2               0           NULL
            
[15:06:19] --- progress: /var/lib/engflow/worker/work/1/exec/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/local-legacy-schema-changer/local-legacy-schema-changer_test_/local-legacy-schema-changer_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/distsql_automatic_partial_stats: 10 statements
[15:06:19] --- done: /var/lib/engflow/worker/work/1/exec/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/local-legacy-schema-changer/local-legacy-schema-changer_test_/local-legacy-schema-changer_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/distsql_automatic_partial_stats with config local-legacy-schema-changer: 10 tests, 1 failures
    logic.go:4252: 
        /var/lib/engflow/worker/work/1/exec/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/local-legacy-schema-changer/local-legacy-schema-changer_test_/local-legacy-schema-changer_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/distsql_automatic_partial_stats:63: error while processing
    logic.go:4252: /var/lib/engflow/worker/work/1/exec/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/local-legacy-schema-changer/local-legacy-schema-changer_test_/local-legacy-schema-changer_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/distsql_automatic_partial_stats:63: 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_automatic_partial_stats2044078663
--- FAIL: TestLogic_distsql_automatic_partial_stats (46.17s)

Parameters:

• attempt=1
• run=15
• shard=27

Help

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

This test on roachdash | Improve this report!

Jira issue: CRDB-46837