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/ccl/spanconfigccl/spanconfigsqltranslatorccl/spanconfigsqltranslatorccl_test: TestDataDriven failed #110955

Closed
cockroach-teamcity opened this issue Sep 20, 2023 · 4 comments
Closed

pkg/ccl/spanconfigccl/spanconfigsqltranslatorccl/spanconfigsqltranslatorccl_test: TestDataDriven failed #110955

cockroach-teamcity opened this issue Sep 20, 2023 · 4 comments
Labels
C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Milestone
23.1

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Sep 20, 2023 •
edited by cockroach-jira-scripts
Loading

pkg/ccl/spanconfigccl/spanconfigsqltranslatorccl/spanconfigsqltranslatorccl_test.TestDataDriven failed with artifacts on release-23.1.11-rc.FROZEN @ cd8ef91e69525d5e1f4020e0cd57368778939772:

=== RUN   TestDataDriven
    test_log_scope.go:161: test logs captured to: /artifacts/tmp/_tmp/95402ff756937342dc1a396f8e8e6bd5/logTestDataDriven3236917078
    test_log_scope.go:79: use -show-logs to present logs inline
=== CONT  TestDataDriven
    datadriven_test.go:89: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/95402ff756937342dc1a396f8e8e6bd5/logTestDataDriven3236917078
--- FAIL: TestDataDriven (475.70s)
=== RUN   TestDataDriven/3node
    --- FAIL: TestDataDriven/3node (457.49s)
=== RUN   TestDataDriven/3node/repartition
        --- FAIL: TestDataDriven/3node/repartition (0.00s)
=== RUN   TestDataDriven/3node/repartition/single_col_range_partitioning_to_single_col_range_partitioning_maxvalue
=== PAUSE TestDataDriven/3node/repartition/single_col_range_partitioning_to_single_col_range_partitioning_maxvalue
=== CONT  TestDataDriven/3node/repartition/single_col_range_partitioning_to_single_col_range_partitioning_maxvalue
=== CONT  TestDataDriven/3node/repartition/single_col_range_partitioning_to_single_col_range_partitioning_maxvalue
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3751/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/ccl/spanconfigccl/spanconfigsqltranslatorccl/spanconfigsqltranslatorccl_test_/spanconfigsqltranslatorccl_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/spanconfigccl/spanconfigsqltranslatorccl/testdata/3node/partition/single_col_range_partitioning:1:
        exec-sql [0 args]
        CREATE DATABASE IF NOT EXISTS db;
        CREATE TABLE IF NOT EXISTS db.tbl (a INT PRIMARY KEY);
        ALTER TABLE db.tbl PARTITION BY RANGE (a) (
          PARTITION p3 VALUES FROM (MINVALUE) TO (3),
          PARTITION p4 VALUES FROM (3) TO (4)
        );
        ALTER TABLE db.tbl CONFIGURE ZONE USING constraints = '[+n1]';
        ALTER PARTITION p3 OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n2]';
        ALTER PARTITION p4 OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n3]';
        ----
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3751/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/ccl/spanconfigccl/spanconfigsqltranslatorccl/spanconfigsqltranslatorccl_test_/spanconfigsqltranslatorccl_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/spanconfigccl/spanconfigsqltranslatorccl/testdata/3node/partition/single_col_range_partitioning:13:
         
        expected:
        [/Table/<table-id>, /Table/<table-id>/1)               constraints=[+n1]
        [/Table/<table-id>/1, /Table/<table-id>/1/3)           constraints=[+n2]
        [/Table/<table-id>/1/3, /Table/<table-id>/1/4)         constraints=[+n3]
        [/Table/<table-id>/1/4, /Table/<table-id+1>)           constraints=[+n1]
        
        found:
        [/Table/<table-id>, /Table/<table-id>/1)               constraints=[+n1]
        [/Table/<table-id>/1, /Table/<table-id>/1/3)           constraints=[+n2]
        [/Table/<table-id>/1/3, /Table/<table-id>/1/4)         constraints=[+n3]
        [/Table/<table-id>/1/4, /Table/<table-id>/PrefixEnd)   constraints=[+n1]
            --- FAIL: TestDataDriven/3node/repartition/single_col_range_partitioning_to_single_col_range_partitioning_maxvalue (79.23s)

Parameters: TAGS=bazel,gss

Help

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

/cc @cockroachdb/kv

This test on roachdash | Improve this report!

Jira issue: CRDB-31716
@cockroach-teamcity cockroach-teamcity added branch-release-23.1.11-rc.FROZEN C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. T-kv KV Team labels Sep 20, 2023
@cockroach-teamcity cockroach-teamcity added this to the 23.1 milestone Sep 20, 2023
@kvoli kvoli added T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) and removed T-kv KV Team labels Sep 20, 2023
@kvoli
Copy link
Collaborator

kvoli commented Sep 20, 2023

Looks like #110047 didn't make its way into the .11-rc. Re-assigning to SQL foundations.

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/spanconfigccl/spanconfigsqltranslatorccl/spanconfigsqltranslatorccl_test.TestDataDriven failed with artifacts on release-23.1.11-rc.FROZEN @ cd8ef91e69525d5e1f4020e0cd57368778939772:

=== RUN   TestDataDriven
    test_log_scope.go:161: test logs captured to: /artifacts/tmp/_tmp/95402ff756937342dc1a396f8e8e6bd5/logTestDataDriven2323947198
    test_log_scope.go:79: use -show-logs to present logs inline
=== CONT  TestDataDriven
    datadriven_test.go:89: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/95402ff756937342dc1a396f8e8e6bd5/logTestDataDriven2323947198
--- FAIL: TestDataDriven (488.21s)
=== RUN   TestDataDriven/3node
    --- FAIL: TestDataDriven/3node (467.78s)
=== RUN   TestDataDriven/3node/repartition
        --- FAIL: TestDataDriven/3node/repartition (0.00s)
=== RUN   TestDataDriven/3node/repartition/unpartitioned_to_unpartitioned
=== PAUSE TestDataDriven/3node/repartition/unpartitioned_to_unpartitioned
=== CONT  TestDataDriven/3node/repartition/unpartitioned_to_unpartitioned
=== CONT  TestDataDriven/3node/repartition/unpartitioned_to_unpartitioned
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/2730/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/ccl/spanconfigccl/spanconfigsqltranslatorccl/spanconfigsqltranslatorccl_test_/spanconfigsqltranslatorccl_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/spanconfigccl/spanconfigsqltranslatorccl/testdata/3node/partition/unpartitioned:1:
        exec-sql [0 args]
        CREATE DATABASE IF NOT EXISTS db;
        CREATE TABLE IF NOT EXISTS db.tbl (a INT PRIMARY KEY);
        ALTER TABLE db.tbl PARTITION BY NOTHING;
        ALTER TABLE db.tbl CONFIGURE ZONE DISCARD;
        ----
=== CONT  TestDataDriven/3node/repartition/unpartitioned_to_unpartitioned
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/2730/execroot/com_github_cockroachdb_cockroach/bazel-out/k8-fastbuild/bin/pkg/ccl/spanconfigccl/spanconfigsqltranslatorccl/spanconfigsqltranslatorccl_test_/spanconfigsqltranslatorccl_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/spanconfigccl/spanconfigsqltranslatorccl/testdata/3node/partition/unpartitioned:8:
         
        expected:
        [/Table/<table-id>, /Table/<table-id+1>)               range default
        
        found:
        [/Table/<table-id>, /Table/<table-id>/PrefixEnd)       range default
            --- FAIL: TestDataDriven/3node/repartition/unpartitioned_to_unpartitioned (69.66s)

Parameters: TAGS=bazel,gss

Help

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

This test on roachdash | Improve this report!

@rafiss
Copy link
Collaborator

rafiss commented Sep 21, 2023

The branch is frozen and this is a test only flake. #110829 fixes this but I don't think we'll backport to this branch.

@rafiss rafiss removed the release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. label Sep 21, 2023
@cockroach-teamcity cockroach-teamcity mentioned this issue Sep 22, 2023
Closed
@rafiss
Copy link
Collaborator

rafiss commented Sep 22, 2023

closing in favor of #111098

@rafiss rafiss closed this as completed Sep 22, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
No open projects
SQL Foundations
Archived in project
Milestone
23.1
Development

No branches or pull requests
3 participants
@rafiss @cockroach-teamcity @kvoli