Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

pkg/sql/logictest/tests/fakedist-disk/fakedist-disk_test: TestLogic_distsql_automatic_stats failed #100386

Closed
cockroach-teamcity opened this issue Apr 1, 2023 · 2 comments
Closed

pkg/sql/logictest/tests/fakedist-disk/fakedist-disk_test: TestLogic_distsql_automatic_stats failed #100386

cockroach-teamcity opened this issue Apr 1, 2023 · 2 comments
Labels
branch-release-23.1 Used to mark GA and release blockers, technical advisories, and bugs for 23.1 C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. T-sql-queries SQL Queries Team
Milestone
23.1

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Apr 1, 2023 •
edited by cockroach-jira-scripts
Loading

pkg/sql/logictest/tests/fakedist-disk/fakedist-disk_test.TestLogic_distsql_automatic_stats failed with artifacts on release-23.1 @ 5d5abe704b0551556c35d51aa673d3162f493aa8:

      npageslabs: 0 huge, 0 nonhuge
      nactive: 0 huge, 0 nonhuge 
      ndirty: 0 huge, 0 nonhuge 
      nretained: 0 huge, 0 nonhuge 
  In empty slabs:
      npageslabs: 0 huge, 0 nonhuge
      nactive: 0 huge, 0 nonhuge 
      ndirty: 0 huge, 0 nonhuge 
      nretained: 0 huge, 0 nonhuge 

                size ind npageslabs_huge    nactive_huge     ndirty_huge  npageslabs_nonhuge     nactive_nonhuge      ndirty_nonhuge   nretained_nonhuge
                     ---
--- End jemalloc statistics ---
[07:12:38] SELECT DISTINCT ON (column_names) statistics_name, column_names, row_count, distinct_count, null_count
FROM [SHOW STATISTICS FOR TABLE data] ORDER BY column_names, created DESC;
[07:12:39] SELECT DISTINCT ON (column_names) statistics_name, column_names, row_count, distinct_count, null_count
FROM [SHOW STATISTICS FOR TABLE data] ORDER BY column_names, created DESC;
[07:12:40] SELECT DISTINCT ON (column_names) statistics_name, column_names, row_count, distinct_count, null_count
FROM [SHOW STATISTICS FOR TABLE data] ORDER BY column_names, created DESC;
[07:12:41] SELECT DISTINCT ON (column_names) statistics_name, column_names, row_count, distinct_count, null_count
FROM [SHOW STATISTICS FOR TABLE data] ORDER BY column_names, created DESC;
[07:12:42] SELECT DISTINCT ON (column_names) statistics_name, column_names, row_count, distinct_count, null_count
FROM [SHOW STATISTICS FOR TABLE data] ORDER BY column_names, created DESC;
[07:12:43] SELECT DISTINCT ON (column_names) statistics_name, column_names, row_count, distinct_count, null_count
FROM [SHOW STATISTICS FOR TABLE data] ORDER BY column_names, created DESC;
[07:12:44] 	-- FAIL
    logic.go:2829: 
         
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3929/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/fakedist-disk/fakedist-disk_test_/fakedist-disk_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/distsql_automatic_stats:25: SELECT DISTINCT ON (column_names) statistics_name, column_names, row_count, distinct_count, null_count
        FROM [SHOW STATISTICS FOR TABLE data] ORDER BY column_names, created DESC
        expected:
            statistics_name  column_names  row_count  distinct_count  null_count
            __auto__         {a}           1000       10              0
            __auto__         {a,b}         1000       100             0
            __auto__         {a,b,c}       1000       1000            0
            __auto__         {b}           1000       10              0
            __auto__         {c}           1000       10              0
            __auto__         {d}           1000       1               1000
            
        but found (query options: "colnames,retry") :
            statistics_name  column_names  row_count  distinct_count  null_count
[07:12:44] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3929/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/fakedist-disk/fakedist-disk_test_/fakedist-disk_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/distsql_automatic_stats: 5 statements
[07:12:44] --- done: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3929/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/fakedist-disk/fakedist-disk_test_/fakedist-disk_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/distsql_automatic_stats with config fakedist-disk: 5 tests, 1 failures

    logic.go:3945: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3929/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/fakedist-disk/fakedist-disk_test_/fakedist-disk_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/distsql_automatic_stats:37: error while processing
    logic.go:3945: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3929/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/fakedist-disk/fakedist-disk_test_/fakedist-disk_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/distsql_automatic_stats:37: 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/cf735ddba09cf0809445609b7a34ef45/logTestLogic_distsql_automatic_stats3200443811
--- FAIL: TestLogic_distsql_automatic_stats (56.64s)
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-26401
@cockroach-teamcity cockroach-teamcity added branch-release-23.1 Used to mark GA and release blockers, technical advisories, and bugs for 23.1 C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. labels Apr 1, 2023
@cockroach-teamcity cockroach-teamcity added this to the 23.1 milestone Apr 1, 2023
@blathers-crl blathers-crl bot added the T-sql-queries SQL Queries Team label Apr 1, 2023
@cockroach-teamcity cockroach-teamcity mentioned this issue Apr 1, 2023
Closed
@cockroach-teamcity
Copy link
Member Author

pkg/sql/logictest/tests/fakedist-disk/fakedist-disk_test.TestLogic_distsql_automatic_stats failed with artifacts on release-23.1 @ 63b683eab3e0ebfff812bb54fdac936c101d9383:

      ndirty: 0 huge, 0 nonhuge 
      nretained: 0 huge, 0 nonhuge 
  In empty slabs:
      npageslabs: 0 huge, 0 nonhuge
      nactive: 0 huge, 0 nonhuge 
      ndirty: 0 huge, 0 nonhuge 
      nretained: 0 huge, 0 nonhuge 

                size ind npageslabs_huge    nactive_huge     ndirty_huge  npageslabs_nonhuge     nactive_nonhuge      ndirty_nonhuge   nretained_nonhuge
                     ---
--- End jemalloc statistics ---
[06:47:49] SELECT DISTINCT ON (column_names) statistics_name, column_names, row_count, distinct_count, null_count
FROM [SHOW STATISTICS FOR TABLE data] ORDER BY column_names, created DESC;
[06:47:50] SELECT DISTINCT ON (column_names) statistics_name, column_names, row_count, distinct_count, null_count
FROM [SHOW STATISTICS FOR TABLE data] ORDER BY column_names, created DESC;
[06:47:51] SELECT DISTINCT ON (column_names) statistics_name, column_names, row_count, distinct_count, null_count
FROM [SHOW STATISTICS FOR TABLE data] ORDER BY column_names, created DESC;
[06:47:52] SELECT DISTINCT ON (column_names) statistics_name, column_names, row_count, distinct_count, null_count
FROM [SHOW STATISTICS FOR TABLE data] ORDER BY column_names, created DESC;
[06:47:53] SELECT DISTINCT ON (column_names) statistics_name, column_names, row_count, distinct_count, null_count
FROM [SHOW STATISTICS FOR TABLE data] ORDER BY column_names, created DESC;
[06:47:54] SELECT DISTINCT ON (column_names) statistics_name, column_names, row_count, distinct_count, null_count
FROM [SHOW STATISTICS FOR TABLE data] ORDER BY column_names, created DESC;
[06:47:55] SELECT DISTINCT ON (column_names) statistics_name, column_names, row_count, distinct_count, null_count
FROM [SHOW STATISTICS FOR TABLE data] ORDER BY column_names, created DESC;
[06:47:56] 	-- FAIL
    logic.go:2829: 
         
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3913/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/fakedist-disk/fakedist-disk_test_/fakedist-disk_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/distsql_automatic_stats:25: SELECT DISTINCT ON (column_names) statistics_name, column_names, row_count, distinct_count, null_count
        FROM [SHOW STATISTICS FOR TABLE data] ORDER BY column_names, created DESC
        expected:
            statistics_name  column_names  row_count  distinct_count  null_count
            __auto__         {a}           1000       10              0
            __auto__         {a,b}         1000       100             0
            __auto__         {a,b,c}       1000       1000            0
            __auto__         {b}           1000       10              0
            __auto__         {c}           1000       10              0
            __auto__         {d}           1000       1               1000
            
        but found (query options: "colnames,retry") :
            statistics_name  column_names  row_count  distinct_count  null_count
[06:47:56] --- progress: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3913/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/fakedist-disk/fakedist-disk_test_/fakedist-disk_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/distsql_automatic_stats: 5 statements
[06:47:56] --- done: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3913/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/fakedist-disk/fakedist-disk_test_/fakedist-disk_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/distsql_automatic_stats with config fakedist-disk: 5 tests, 1 failures

    logic.go:3945: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3913/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/fakedist-disk/fakedist-disk_test_/fakedist-disk_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/distsql_automatic_stats:37: error while processing
    logic.go:3945: /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3913/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/sql/logictest/tests/fakedist-disk/fakedist-disk_test_/fakedist-disk_test.runfiles/com_github_cockroachdb_cockroach/pkg/sql/logictest/testdata/logic_test/distsql_automatic_stats:37: 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/cf735ddba09cf0809445609b7a34ef45/logTestLogic_distsql_automatic_stats2312321798
--- FAIL: TestLogic_distsql_automatic_stats (58.67s)
Help

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

This test on roachdash | Improve this report!

@mgartner
Copy link
Collaborator

mgartner commented Apr 3, 2023

Duplicate of #100384.

@mgartner mgartner closed this as completed Apr 3, 2023
@mgartner mgartner moved this to Done in SQL Queries Jul 24, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
branch-release-23.1 Used to mark GA and release blockers, technical advisories, and bugs for 23.1 C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. T-sql-queries SQL Queries Team
Projects
SQL Queries
Archived in project
Milestone
23.1
Development

No branches or pull requests
2 participants
@mgartner @cockroach-teamcity