Skip to content

pkg/sql/opt/exec/execbuilder/tests/local/local_test: TestExecBuild_sql_statistics_persisted failed #99118

@cockroach-teamcity

Description

@cockroach-teamcity

pkg/sql/opt/exec/execbuilder/tests/local/local_test.TestExecBuild_sql_statistics_persisted failed with artifacts on master @ 5f5cf265a8717da8ee327f41c0d06836d11ac8ec:

=== RUN   TestExecBuild_sql_statistics_persisted
    test_log_scope.go:161: test logs captured to: /artifacts/tmp/_tmp/9986f69167dd2633633c749cd542ec4c/logTestExecBuild_sql_statistics_persisted2954968955
    test_log_scope.go:79: use -show-logs to present logs inline
    logic.go:2874: 
         
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/11604/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-fastbuild/bin/pkg/sql/opt/exec/execbuilder/tests/local/local_test_/local_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/opt/exec/execbuilder/testdata/sql_statistics_persisted:73: EXPLAIN (VERBOSE)
        SELECT
          aggregated_ts,
          fingerprint_id,
          app_name,
          node_id,
          agg_interval,
          metadata,
          statistics
        FROM
          system.transaction_statistics
        expected:
              distribution: local
              vectorized: true
            ·
              • scan
                columns: (aggregated_ts, fingerprint_id, app_name, node_id, agg_interval, metadata, statistics)
                estimated row count: 1,000 (missing stats)
                table: transaction_statistics@primary
                spans: FULL SCAN
            
        but found (query options: "") :
            distribution: local
            vectorized: true
            ·
            • scan
              columns: (aggregated_ts, fingerprint_id, app_name, node_id, agg_interval, metadata, statistics)
              estimated row count: 1 (100% of the table; stats collected <hidden> ago)
              table: transaction_statistics@primary
              spans: FULL SCAN
[13:34:23] --- done: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/11604/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-fastbuild/bin/pkg/sql/opt/exec/execbuilder/tests/local/local_test_/local_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/opt/exec/execbuilder/testdata/sql_statistics_persisted with config local: 3 tests, 1 failures
    logic.go:3972: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/11604/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-fastbuild/bin/pkg/sql/opt/exec/execbuilder/tests/local/local_test_/local_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/opt/exec/execbuilder/testdata/sql_statistics_persisted:95: error while processing
    logic.go:3972: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/11604/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-fastbuild/bin/pkg/sql/opt/exec/execbuilder/tests/local/local_test_/local_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/opt/exec/execbuilder/testdata/sql_statistics_persisted:95: 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/9986f69167dd2633633c749cd542ec4c/logTestExecBuild_sql_statistics_persisted2954968955
--- FAIL: TestExecBuild_sql_statistics_persisted (2.43s)
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-25709

Metadata

Metadata

Assignees

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