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.

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

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

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

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Sep 8, 2023

pkg/ccl/spanconfigccl/spanconfigsqltranslatorccl/spanconfigsqltranslatorccl_test.TestDataDriven failed with artifacts on release-23.1.10-rc @ eb3a9eb1f3b1aa1978307d864648798a389ef30d:

        ALTER PARTITION p75n OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n2]';
        ALTER PARTITION pxxx OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n3]';
        ----
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3148/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/multi_col_range_partitioning_descending:15:
         
        output didn't match expected:
        @@ -1,6 +1,6 @@
         [/Table/<table-id>, /Table/<table-id>/1)               range default
         [/Table/<table-id>/1, /Table/<table-id>/1/7)           constraints=[+n1]
         [/Table/<table-id>/1/7, /Table/<table-id>/1/7/-6)      constraints=[+n2]
         [/Table/<table-id>/1/7/-6, /Table/<table-id>/2)        constraints=[+n3]
        -[/Table/<table-id>/2, /Table/<table-id+1>)             range default
        +[/Table/<table-id>/2, /Table/<table-id>/PrefixEnd)     range default
         
            --- FAIL: TestDataDriven/3node/partition/multi_col_range_partitioning_descending (104.94s)
=== RUN   TestDataDriven/3node/repartition
        --- FAIL: TestDataDriven/3node/repartition (0.00s)
=== RUN   TestDataDriven/3node/repartition/single_col_range_partitioning_maxvalue_to_unpartitioned
=== PAUSE TestDataDriven/3node/repartition/single_col_range_partitioning_maxvalue_to_unpartitioned
=== CONT  TestDataDriven/3node/repartition/single_col_range_partitioning_maxvalue_to_unpartitioned
=== CONT  TestDataDriven/3node/repartition/single_col_range_partitioning_maxvalue_to_unpartitioned
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3148/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_maxvalue: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 p4 VALUES FROM (MINVALUE) TO (4),
          PARTITION p5 VALUES FROM (4) TO (5),
          PARTITION px VALUES FROM (5) TO (MAXVALUE)
        );
        ALTER TABLE db.tbl CONFIGURE ZONE DISCARD;
        ALTER PARTITION p4 OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n1]';
        ALTER PARTITION p5 OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n2]';
        ALTER PARTITION px OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n3]';
        ----
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3148/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_maxvalue:15:
         
        output didn't match expected:
        @@ -1,6 +1,6 @@
         [/Table/<table-id>, /Table/<table-id>/1)               range default
         [/Table/<table-id>/1, /Table/<table-id>/1/4)           constraints=[+n1]
         [/Table/<table-id>/1/4, /Table/<table-id>/1/5)         constraints=[+n2]
         [/Table/<table-id>/1/5, /Table/<table-id>/2)           constraints=[+n3]
        -[/Table/<table-id>/2, /Table/<table-id+1>)             range default
        +[/Table/<table-id>/2, /Table/<table-id>/PrefixEnd)     range default
         
            --- FAIL: TestDataDriven/3node/repartition/single_col_range_partitioning_maxvalue_to_unpartitioned (90.41s)

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

@cockroach-teamcity cockroach-teamcity added branch-release-23.1.10-rc 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 8, 2023
@cockroach-teamcity cockroach-teamcity added this to the 23.1 milestone Sep 8, 2023
@nvanbenschoten nvanbenschoten added T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) and removed T-kv KV Team labels Sep 8, 2023
@ecwall ecwall added the db-cy-23 label Sep 8, 2023
@cockroach-teamcity
Copy link
Member Author

pkg/ccl/spanconfigccl/spanconfigsqltranslatorccl/spanconfigsqltranslatorccl_test.TestDataDriven failed with artifacts on release-23.1.10-rc @ 59f454ed67c50ed552fc2a38d9732b11dc029c56:

=== RUN   TestDataDriven
    test_log_scope.go:161: test logs captured to: /artifacts/tmp/_tmp/95402ff756937342dc1a396f8e8e6bd5/logTestDataDriven967468260
    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/logTestDataDriven967468260
--- FAIL: TestDataDriven (484.48s)
=== RUN   TestDataDriven/3node/partition
        --- FAIL: TestDataDriven/3node/partition (0.00s)
=== RUN   TestDataDriven/3node/partition/multi_col_range_partitioning_descending
=== PAUSE TestDataDriven/3node/partition/multi_col_range_partitioning_descending
=== CONT  TestDataDriven/3node/partition/multi_col_range_partitioning_descending
=== CONT  TestDataDriven/3node/partition/multi_col_range_partitioning_descending
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3199/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/multi_col_range_partitioning_descending:1:
        exec-sql [0 args]
        CREATE DATABASE IF NOT EXISTS db;
        CREATE TABLE IF NOT EXISTS db.tbl (a INT, b INT, c INT, PRIMARY KEY (a, b DESC, c));
        ALTER TABLE db.tbl PARTITION BY RANGE (a, b, c) (
          PARTITION p6xx VALUES FROM (MINVALUE, MINVALUE, MINVALUE) TO (6, MAXVALUE, MAXVALUE),
          PARTITION p75n VALUES FROM (7, MINVALUE, MINVALUE) TO (7, 5, MINVALUE),
          PARTITION pxxx VALUES FROM (7, 5, MINVALUE) TO (MAXVALUE, MAXVALUE, MAXVALUE)
        );
        ALTER TABLE db.tbl CONFIGURE ZONE DISCARD;
        ALTER PARTITION p6xx OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n1]';
        ALTER PARTITION p75n OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n2]';
        ALTER PARTITION pxxx OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n3]';
        ----
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3199/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/multi_col_range_partitioning_descending:15:
         
        output didn't match expected:
        @@ -1,6 +1,6 @@
         [/Table/<table-id>, /Table/<table-id>/1)               range default
         [/Table/<table-id>/1, /Table/<table-id>/1/7)           constraints=[+n1]
         [/Table/<table-id>/1/7, /Table/<table-id>/1/7/-6)      constraints=[+n2]
         [/Table/<table-id>/1/7/-6, /Table/<table-id>/2)        constraints=[+n3]
        -[/Table/<table-id>/2, /Table/<table-id+1>)             range default
        +[/Table/<table-id>/2, /Table/<table-id>/PrefixEnd)     range default
         
            --- FAIL: TestDataDriven/3node/partition/multi_col_range_partitioning_descending (82.35s)
=== RUN   TestDataDriven/3node
    --- FAIL: TestDataDriven/3node (466.69s)

Parameters: TAGS=bazel,gss

Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/spanconfigccl/spanconfigsqltranslatorccl/spanconfigsqltranslatorccl_test.TestDataDriven failed with artifacts on release-23.1.10-rc @ 59f454ed67c50ed552fc2a38d9732b11dc029c56:

=== RUN   TestDataDriven
    test_log_scope.go:161: test logs captured to: /artifacts/tmp/_tmp/95402ff756937342dc1a396f8e8e6bd5/logTestDataDriven46873347
    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/logTestDataDriven46873347
--- FAIL: TestDataDriven (480.94s)
=== RUN   TestDataDriven/3node
    --- FAIL: TestDataDriven/3node (463.25s)
=== RUN   TestDataDriven/3node/partition
        --- FAIL: TestDataDriven/3node/partition (0.01s)
=== RUN   TestDataDriven/3node/partition/multi_col_list_partitioning_default_default
=== PAUSE TestDataDriven/3node/partition/multi_col_list_partitioning_default_default
=== CONT  TestDataDriven/3node/partition/multi_col_list_partitioning_default_default
=== CONT  TestDataDriven/3node/partition/multi_col_list_partitioning_default_default
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/2115/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/multi_col_list_partitioning_default_default:1:
        exec-sql [0 args]
        CREATE DATABASE IF NOT EXISTS db;
        CREATE TABLE IF NOT EXISTS db.tbl (a INT, b INT, PRIMARY KEY (a, b));
        ALTER TABLE db.tbl PARTITION BY LIST (a, b) (
          PARTITION p34 VALUES IN ((3, 4)),
          PARTITION p57 VALUES IN ((5, 7)),
          PARTITION p58 VALUES IN ((5, 8)),
          PARTITION p5d VALUES IN ((5, DEFAULT)),
          PARTITION pd VALUES IN ((DEFAULT, DEFAULT))
        );
        ALTER TABLE db.tbl CONFIGURE ZONE DISCARD;
        ALTER PARTITION p34 OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n1]';
        ALTER PARTITION p57 OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n2]';
        ALTER PARTITION p58 OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n3]';
        ALTER PARTITION p5d OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n1]';
        ALTER PARTITION pd OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n2]';
        ----
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/2115/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/multi_col_list_partitioning_default_default:19:
         
        output didn't match expected:
        @@ -5,7 +5,7 @@
         [/Table/<table-id>/1/5, /Table/<table-id>/1/5/7)       constraints=[+n1]
         [/Table/<table-id>/1/5/7, /Table/<table-id>/1/5/8)     constraints=[+n2]
         [/Table/<table-id>/1/5/8, /Table/<table-id>/1/5/9)     constraints=[+n3]
         [/Table/<table-id>/1/5/9, /Table/<table-id>/1/6)       constraints=[+n1]
         [/Table/<table-id>/1/6, /Table/<table-id>/2)           constraints=[+n2]
        -[/Table/<table-id>/2, /Table/<table-id+1>)             range default
        +[/Table/<table-id>/2, /Table/<table-id>/PrefixEnd)     range default
         
            --- FAIL: TestDataDriven/3node/partition/multi_col_list_partitioning_default_default (71.33s)

Parameters: TAGS=bazel,gss

Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/spanconfigccl/spanconfigsqltranslatorccl/spanconfigsqltranslatorccl_test.TestDataDriven failed with artifacts on release-23.1.10-rc @ 59f454ed67c50ed552fc2a38d9732b11dc029c56:

          PARTITION p57 VALUES IN ((5, 7)),
          PARTITION p58 VALUES IN ((5, 8)),
          PARTITION p5d VALUES IN ((5, DEFAULT))
        );
        ALTER TABLE db.tbl CONFIGURE ZONE USING constraints = '[+n1]';
        ALTER PARTITION p34 OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n2]';
        ALTER PARTITION p57 OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n3]';
        ALTER PARTITION p58 OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n1]';
        ALTER PARTITION p5d OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n2]';
        ----
=== CONT  TestDataDriven/3node/partition/multi_col_list_partitioning_default
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3086/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/multi_col_list_partitioning_default:17:
         
        output didn't match expected:
        @@ -3,7 +3,7 @@
         [/Table/<table-id>/1/3/5, /Table/<table-id>/1/5)       constraints=[+n1]
         [/Table/<table-id>/1/5, /Table/<table-id>/1/5/7)       constraints=[+n2]
         [/Table/<table-id>/1/5/7, /Table/<table-id>/1/5/8)     constraints=[+n3]
         [/Table/<table-id>/1/5/8, /Table/<table-id>/1/5/9)     constraints=[+n1]
         [/Table/<table-id>/1/5/9, /Table/<table-id>/1/6)       constraints=[+n2]
        -[/Table/<table-id>/1/6, /Table/<table-id+1>)           constraints=[+n1]
        +[/Table/<table-id>/1/6, /Table/<table-id>/PrefixEnd)   constraints=[+n1]
         
            --- FAIL: TestDataDriven/3node/partition/multi_col_list_partitioning_default (66.82s)
=== RUN   TestDataDriven/3node/repartition
        --- FAIL: TestDataDriven/3node/repartition (0.00s)
=== RUN   TestDataDriven/3node/repartition/unpartitioned_to_single_col_list_partitioning
=== PAUSE TestDataDriven/3node/repartition/unpartitioned_to_single_col_list_partitioning
=== CONT  TestDataDriven/3node/repartition/unpartitioned_to_single_col_list_partitioning
=== CONT  TestDataDriven/3node/repartition/unpartitioned_to_single_col_list_partitioning
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3086/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;
        ----
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3086/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_single_col_list_partitioning (61.63s)
=== RUN   TestDataDriven/3node
    --- FAIL: TestDataDriven/3node (420.35s)

Parameters: TAGS=bazel,gss

Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@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 11, 2023
@rafiss
Copy link
Collaborator

rafiss commented Sep 11, 2023

this is a test only issue with how keys are pretty printed, so I removed the blocker label

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/spanconfigccl/spanconfigsqltranslatorccl/spanconfigsqltranslatorccl_test.TestDataDriven failed with artifacts on release-23.1.10-rc @ 91667154574c1db07021bff628c35e062d16c6df:

=== CONT  TestDataDriven
    datadriven_test.go:89: -- test log scope end --
test logs left over in: /artifacts/tmp/_tmp/95402ff756937342dc1a396f8e8e6bd5/logTestDataDriven895929956
--- FAIL: TestDataDriven (471.44s)
=== RUN   TestDataDriven/3node
    --- FAIL: TestDataDriven/3node (452.44s)
=== RUN   TestDataDriven/3node/partition
        --- FAIL: TestDataDriven/3node/partition (0.00s)
=== RUN   TestDataDriven/3node/partition/list_range_partitioning
=== PAUSE TestDataDriven/3node/partition/list_range_partitioning
=== CONT  TestDataDriven/3node/partition/list_range_partitioning
=== CONT  TestDataDriven/3node/partition/list_range_partitioning
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/2888/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/list_range_partitioning:1:
        exec-sql [0 args]
        CREATE DATABASE IF NOT EXISTS db;
        CREATE TABLE IF NOT EXISTS db.tbl (a INT, b INT, PRIMARY KEY (a, b));
        ALTER TABLE db.tbl PARTITION BY LIST (a) (
          PARTITION p3 VALUES IN (3) PARTITION BY RANGE (b) (
            PARTITION p34 VALUES FROM (MINVALUE) TO (4)
          ),
          PARTITION p5 VALUES IN (5) PARTITION BY RANGE (b) (
            PARTITION p56 VALUES FROM (MINVALUE) TO (6),
            PARTITION p5d VALUES FROM (6) TO (MAXVALUE)
          ),
          PARTITION pd VALUES IN (DEFAULT)
        );
        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 p34 OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n3]';
        ALTER PARTITION p5 OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n1]';
        ALTER PARTITION p56 OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n2]';
        ALTER PARTITION p5d OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n3]';
        ALTER PARTITION pd OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n1]';
        ----
=== CONT  TestDataDriven/3node/partition/list_range_partitioning
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/2888/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/list_range_partitioning:23:
         
        output didn't match expected:
        @@ -4,7 +4,7 @@
         [/Table/<table-id>/1/3/4, /Table/<table-id>/1/4)       constraints=[+n2]
         [/Table/<table-id>/1/4, /Table/<table-id>/1/5)         constraints=[+n1]
         [/Table/<table-id>/1/5, /Table/<table-id>/1/5/6)       constraints=[+n2]
         [/Table/<table-id>/1/5/6, /Table/<table-id>/1/6)       constraints=[+n3]
         [/Table/<table-id>/1/6, /Table/<table-id>/2)           constraints=[+n1]
        -[/Table/<table-id>/2, /Table/<table-id+1>)             constraints=[+n1]
        +[/Table/<table-id>/2, /Table/<table-id>/PrefixEnd)     constraints=[+n1]
         
            --- FAIL: TestDataDriven/3node/partition/list_range_partitioning (70.10s)

Parameters: TAGS=bazel,gss

Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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

=== RUN   TestDataDriven
    test_log_scope.go:161: test logs captured to: /artifacts/tmp/_tmp/95402ff756937342dc1a396f8e8e6bd5/logTestDataDriven2423423991
    test_log_scope.go:79: use -show-logs to present logs inline
=== CONT  TestDataDriven
    datadriven_test.go:89: -- test log scope end --
--- FAIL: TestDataDriven (448.49s)
=== RUN   TestDataDriven/3node
    --- FAIL: TestDataDriven/3node (430.04s)
=== RUN   TestDataDriven/3node/repartition
        --- FAIL: TestDataDriven/3node/repartition (0.00s)
=== RUN   TestDataDriven/3node/repartition/secondary_index_list_partitioning_default_to_secondary_index_list_partitioning
=== PAUSE TestDataDriven/3node/repartition/secondary_index_list_partitioning_default_to_secondary_index_list_partitioning
=== CONT  TestDataDriven/3node/repartition/secondary_index_list_partitioning_default_to_secondary_index_list_partitioning
=== CONT  TestDataDriven/3node/repartition/secondary_index_list_partitioning_default_to_secondary_index_list_partitioning
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/2912/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/secondary_index_list_partitioning_default:1:
        exec-sql [0 args]
        CREATE DATABASE IF NOT EXISTS db;
        CREATE TABLE IF NOT EXISTS db.tbl (a INT PRIMARY KEY, b INT, INDEX b_idx (b));
        ALTER INDEX db.tbl@b_idx PARTITION BY LIST (b) (
          PARTITION p4 VALUES IN (4),
          PARTITION p5 VALUES IN (5),
          PARTITION pd VALUES IN (DEFAULT)
        );
        ALTER INDEX db.tbl@b_idx CONFIGURE ZONE DISCARD;
        ALTER PARTITION p4 OF INDEX db.tbl@b_idx CONFIGURE ZONE USING constraints = '[+n2]';
        ALTER PARTITION p5 OF INDEX db.tbl@b_idx CONFIGURE ZONE USING constraints = '[+n3]';
        ALTER PARTITION pd OF INDEX db.tbl@b_idx CONFIGURE ZONE USING constraints = '[+n1]';
        ----
=== CONT  TestDataDriven/3node/repartition/secondary_index_list_partitioning_default_to_secondary_index_list_partitioning
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/2912/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/secondary_index_list_partitioning_default:15:
         
        output didn't match expected:
        @@ -1,7 +1,7 @@
         [/Table/<table-id>, /Table/<table-id>/2)               range default
         [/Table/<table-id>/2, /Table/<table-id>/2/4)           constraints=[+n1]
         [/Table/<table-id>/2/4, /Table/<table-id>/2/5)         constraints=[+n2]
         [/Table/<table-id>/2/5, /Table/<table-id>/2/6)         constraints=[+n3]
         [/Table/<table-id>/2/6, /Table/<table-id>/3)           constraints=[+n1]
        -[/Table/<table-id>/3, /Table/<table-id+1>)             range default
        +[/Table/<table-id>/3, /Table/<table-id>/PrefixEnd)     range default
         
            --- FAIL: TestDataDriven/3node/repartition/secondary_index_list_partitioning_default_to_secondary_index_list_partitioning (64.53s)

Parameters: TAGS=bazel,gss

Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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

=== RUN   TestDataDriven
    test_log_scope.go:161: test logs captured to: /artifacts/tmp/_tmp/95402ff756937342dc1a396f8e8e6bd5/logTestDataDriven3798689619
    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/logTestDataDriven3798689619
--- FAIL: TestDataDriven (445.58s)
=== RUN   TestDataDriven/3node
    --- FAIL: TestDataDriven/3node (426.75s)
=== RUN   TestDataDriven/3node/partition
        --- FAIL: TestDataDriven/3node/partition (0.01s)
=== RUN   TestDataDriven/3node/partition/multi_col_list_partitioning
=== PAUSE TestDataDriven/3node/partition/multi_col_list_partitioning
=== CONT  TestDataDriven/3node/partition/multi_col_list_partitioning
=== CONT  TestDataDriven/3node/partition/multi_col_list_partitioning
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/609/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/multi_col_list_partitioning:1:
        exec-sql [0 args]
        CREATE DATABASE IF NOT EXISTS db;
        CREATE TABLE IF NOT EXISTS db.tbl (a INT, b INT, PRIMARY KEY (a, b));
        ALTER TABLE db.tbl PARTITION BY LIST (a, b) (
          PARTITION p34 VALUES IN ((3, 4)),
          PARTITION p56 VALUES IN ((5, 6)),
          PARTITION p57 VALUES IN ((5, 7))
        );
        ALTER TABLE db.tbl CONFIGURE ZONE USING constraints = '[+n1]';
        ALTER PARTITION p34 OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n2]';
        ALTER PARTITION p56 OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n3]';
        ALTER PARTITION p57 OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n1]';
        ----
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/609/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/multi_col_list_partitioning:15:
         
        output didn't match expected:
        @@ -1,7 +1,7 @@
         [/Table/<table-id>, /Table/<table-id>/1/3/4)           constraints=[+n1]
         [/Table/<table-id>/1/3/4, /Table/<table-id>/1/3/5)     constraints=[+n2]
         [/Table/<table-id>/1/3/5, /Table/<table-id>/1/5/6)     constraints=[+n1]
         [/Table/<table-id>/1/5/6, /Table/<table-id>/1/5/7)     constraints=[+n3]
         [/Table/<table-id>/1/5/7, /Table/<table-id>/1/5/8)     constraints=[+n1]
        -[/Table/<table-id>/1/5/8, /Table/<table-id+1>)         constraints=[+n1]
        +[/Table/<table-id>/1/5/8, /Table/<table-id>/PrefixEnd) constraints=[+n1]
         
            --- FAIL: TestDataDriven/3node/partition/multi_col_list_partitioning (67.82s)

Parameters: TAGS=bazel,gss

Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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

=== RUN   TestDataDriven
    test_log_scope.go:161: test logs captured to: /artifacts/tmp/_tmp/c027c4741e81bb03712e1aa65d31108a/logTestDataDriven177215837
    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/c027c4741e81bb03712e1aa65d31108a/logTestDataDriven177215837
--- FAIL: TestDataDriven (94.20s)
=== RUN   TestDataDriven/3node
    --- FAIL: TestDataDriven/3node (84.34s)
=== RUN   TestDataDriven/3node/partition
        --- FAIL: TestDataDriven/3node/partition (0.00s)
=== RUN   TestDataDriven/3node/partition/single_col_range_partitioning_sparse
=== PAUSE TestDataDriven/3node/partition/single_col_range_partitioning_sparse
=== CONT  TestDataDriven/3node/partition/single_col_range_partitioning_sparse
=== CONT  TestDataDriven/3node/partition/single_col_range_partitioning_sparse
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/8958/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-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_sparse: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 p1 VALUES FROM (1) TO (2),
          PARTITION p3 VALUES FROM (3) TO (4)
        );
        ALTER TABLE db.tbl CONFIGURE ZONE USING constraints = '[+n1]';
        ALTER PARTITION p1 OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n2]';
        ALTER PARTITION p3 OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n3]';
        ----
=== CONT  TestDataDriven/3node/partition/single_col_range_partitioning_sparse
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/8958/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-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_sparse:13:
         
        output didn't match expected:
        @@ -1,6 +1,6 @@
         [/Table/<table-id>, /Table/<table-id>/1/1)             constraints=[+n1]
         [/Table/<table-id>/1/1, /Table/<table-id>/1/2)         constraints=[+n2]
         [/Table/<table-id>/1/2, /Table/<table-id>/1/3)         constraints=[+n1]
         [/Table/<table-id>/1/3, /Table/<table-id>/1/4)         constraints=[+n3]
        -[/Table/<table-id>/1/4, /Table/<table-id+1>)           constraints=[+n1]
        +[/Table/<table-id>/1/4, /Table/<table-id>/PrefixEnd)   constraints=[+n1]
         
            --- FAIL: TestDataDriven/3node/partition/single_col_range_partitioning_sparse (39.60s)
Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

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

        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/3182/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_list_partitioning:13:
         
        expected:
        [/Table/<table-id>, /Table/<table-id>/1/3)             range default
        [/Table/<table-id>/1/3, /Table/<table-id>/1/4)         constraints=[+n2]
        [/Table/<table-id>/1/4, /Table/<table-id>/1/5)         constraints=[+n3]
        [/Table/<table-id>/1/5, /Table/<table-id+1>)           range default
        
        found:
        [/Table/<table-id>, /Table/<table-id>/1/3)             range default
        [/Table/<table-id>/1/3, /Table/<table-id>/1/4)         constraints=[+n2]
        [/Table/<table-id>/1/4, /Table/<table-id>/1/5)         constraints=[+n3]
        [/Table/<table-id>/1/5, /Table/<table-id>/PrefixEnd)   range default
            --- FAIL: TestDataDriven/3node/repartition/single_col_list_partitioning_to_unpartitioned (73.73s)
=== RUN   TestDataDriven/3node/repartition/single_col_range_partitioning_maxvalue_to_unpartitioned
=== PAUSE TestDataDriven/3node/repartition/single_col_range_partitioning_maxvalue_to_unpartitioned
=== CONT  TestDataDriven/3node/repartition/single_col_range_partitioning_maxvalue_to_unpartitioned
=== CONT  TestDataDriven/3node/repartition/single_col_range_partitioning_maxvalue_to_unpartitioned
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3182/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_maxvalue: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 p4 VALUES FROM (MINVALUE) TO (4),
          PARTITION p5 VALUES FROM (4) TO (5),
          PARTITION px VALUES FROM (5) TO (MAXVALUE)
        );
        ALTER TABLE db.tbl CONFIGURE ZONE DISCARD;
        ALTER PARTITION p4 OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n1]';
        ALTER PARTITION p5 OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n2]';
        ALTER PARTITION px OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n3]';
        ----
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3182/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_maxvalue:15:
         
        output didn't match expected:
        @@ -1,6 +1,6 @@
         [/Table/<table-id>, /Table/<table-id>/1)               range default
         [/Table/<table-id>/1, /Table/<table-id>/1/4)           constraints=[+n1]
         [/Table/<table-id>/1/4, /Table/<table-id>/1/5)         constraints=[+n2]
         [/Table/<table-id>/1/5, /Table/<table-id>/2)           constraints=[+n3]
        -[/Table/<table-id>/2, /Table/<table-id+1>)             range default
        +[/Table/<table-id>/2, /Table/<table-id>/PrefixEnd)     range default
         
            --- FAIL: TestDataDriven/3node/repartition/single_col_range_partitioning_maxvalue_to_unpartitioned (67.59s)

Parameters: TAGS=bazel,gss

Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@rafiss
Copy link
Collaborator

rafiss commented Sep 18, 2023

Closing since this branch is frozen. #110829 will address this on other branches.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
C-test-failure Broken test (automatically or manually discovered). db-cy-23 O-robot Originated from a bot. T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
No open projects
Archived in project
Development

No branches or pull requests

4 participants