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 #110242

Closed
cockroach-teamcity opened this issue Sep 8, 2023 · 12 comments · Fixed by #110829
Assignees
Labels
branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). db-cy-23 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-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 master @ 9d3115d1030ee7526818768913285dd0426dd9b5:

=== RUN   TestDataDriven
    test_log_scope.go:167: test logs captured to: /artifacts/tmp/_tmp/95402ff756937342dc1a396f8e8e6bd5/logTestDataDriven217792284
    test_log_scope.go:81: 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/logTestDataDriven217792284
--- FAIL: TestDataDriven (586.45s)
=== RUN   TestDataDriven/3node
    --- FAIL: TestDataDriven/3node (567.31s)
=== RUN   TestDataDriven/3node/partition
        --- FAIL: TestDataDriven/3node/partition (0.00s)
=== 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
    test_server_shim.go:84: cluster virtualization disabled due to issue: #106818 (expected label: C-test-failure)
=== CONT  TestDataDriven/3node/partition/multi_col_list_partitioning
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/2885/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]';
        ----
=== CONT  TestDataDriven/3node/partition/multi_col_list_partitioning
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/2885/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 (83.65s)

Parameters: TAGS=bazel,gss , stress=true

Help

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

Same failure on other branches

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-31341

@cockroach-teamcity cockroach-teamcity added branch-master Failures and bugs on the master branch. 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-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) labels Sep 8, 2023
@cockroach-teamcity cockroach-teamcity added this to the 23.2 milestone 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 master @ 46fedddafbff155b72e3853c4f32157cbfebcd35:

=== PAUSE TestDataDriven/3node/partition/some_indexes
=== CONT  TestDataDriven/3node/partition/some_indexes
    test_server_shim.go:84: cluster virtualization disabled due to issue: #106818 (expected label: C-test-failure)
=== NAME  TestDataDriven/3node/partition/multi_col_list_partitioning
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3332/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]';
        ----
=== NAME  TestDataDriven/3node/partition/multi_col_range_partitioning
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3332/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: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 RANGE (a, b) (
          PARTITION p34 VALUES FROM (MINVALUE, MINVALUE) TO (3, 4),
          PARTITION p56 VALUES FROM (3, 4) TO (5, 6),
          PARTITION p57 VALUES FROM (5, 6) TO (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]';
        ----
=== NAME  TestDataDriven/3node/partition/multi_col_list_partitioning
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3332/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:
        translate [2 args]
        <no input to command>
        ----
        [/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]
            --- FAIL: TestDataDriven/3node/partition/some_indexes (69.56s)
=== RUN   TestDataDriven/3node/repartition
        --- FAIL: TestDataDriven/3node/repartition (0.00s)

Parameters: TAGS=bazel,gss , stress=true

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 master @ b5836a5b4ab6c4fe58ada6002eb8c56c4e35438e:

=== RUN   TestDataDriven
    test_log_scope.go:167: test logs captured to: /artifacts/tmp/_tmp/95402ff756937342dc1a396f8e8e6bd5/logTestDataDriven934681949
    test_log_scope.go:81: use -show-logs to present logs inline
--- FAIL: TestDataDriven (447.47s)
=== RUN   TestDataDriven/3node
    --- FAIL: TestDataDriven/3node (431.80s)
=== RUN   TestDataDriven/3node/partition
        --- FAIL: TestDataDriven/3node/partition (0.00s)
=== RUN   TestDataDriven/3node/partition/list_list_partitioning
=== PAUSE TestDataDriven/3node/partition/list_list_partitioning
=== CONT  TestDataDriven/3node/partition/list_list_partitioning
    test_server_shim.go:84: cluster virtualization disabled due to issue: #106818 (expected label: C-test-failure)
=== NAME  TestDataDriven/3node/partition/multi_col_range_partitioning_maxvalue_maxvalue
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3025/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_maxvalue_maxvalue: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 RANGE (a, b) (
          PARTITION p34 VALUES FROM (MINVALUE, MINVALUE) TO (3, 4),
          PARTITION p3x VALUES FROM (3, 4) TO (3, MAXVALUE),
          PARTITION p56 VALUES FROM (3, MAXVALUE) TO (5, 6),
          PARTITION p57 VALUES FROM (5, 6) TO (5, 7),
          PARTITION pxx VALUES FROM (5, 7) TO (MAXVALUE, MAXVALUE)
        );
        ALTER TABLE db.tbl CONFIGURE ZONE DISCARD;
        ALTER PARTITION p34 OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n1]';
        ALTER PARTITION p3x 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]';
        ALTER PARTITION pxx OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n2]';
        ----
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3025/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_maxvalue_maxvalue:19:
        translate [2 args]
        <no input to command>
        ----
        [/Table/<table-id>, /Table/<table-id>/1)               range default
        [/Table/<table-id>/1, /Table/<table-id>/1/3/4)         constraints=[+n1]
        [/Table/<table-id>/1/3/4, /Table/<table-id>/1/4)       constraints=[+n2]
        [/Table/<table-id>/1/4, /Table/<table-id>/1/5/6)       constraints=[+n3]
        [/Table/<table-id>/1/5/6, /Table/<table-id>/1/5/7)     constraints=[+n1]
        [/Table/<table-id>/1/5/7, /Table/<table-id>/2)         constraints=[+n2]
        [/Table/<table-id>/2, /Table/<table-id+1>)             range default
            --- FAIL: TestDataDriven/3node/partition/list_list_partitioning (67.04s)

Parameters: TAGS=bazel,gss , stress=true

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 master @ d7738743c955be36b1c9304a40d9e4e7b3edc4ad:

=== RUN   TestDataDriven
    test_log_scope.go:167: test logs captured to: /artifacts/tmp/_tmp/95402ff756937342dc1a396f8e8e6bd5/logTestDataDriven4293821282
    test_log_scope.go:81: use -show-logs to present logs inline
--- FAIL: TestDataDriven (439.98s)
=== RUN   TestDataDriven/3node
    --- FAIL: TestDataDriven/3node (423.11s)
=== RUN   TestDataDriven/3node/repartition
        --- FAIL: TestDataDriven/3node/repartition (0.01s)
=== 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
            --- FAIL: TestDataDriven/3node/repartition/unpartitioned_to_single_col_list_partitioning (60.69s)

Parameters: TAGS=bazel,gss , stress=true

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 master @ 0310d119569b59b9efe1b7bbc439c2c604217a4c:

=== RUN   TestDataDriven
    test_log_scope.go:167: test logs captured to: /artifacts/tmp/_tmp/95402ff756937342dc1a396f8e8e6bd5/logTestDataDriven614164525
    test_log_scope.go:81: use -show-logs to present logs inline
--- FAIL: TestDataDriven (430.74s)
=== RUN   TestDataDriven/3node/repartition/multi_col_list_partitioning_default_to_multi_col_list_partitioning
=== PAUSE TestDataDriven/3node/repartition/multi_col_list_partitioning_default_to_multi_col_list_partitioning
=== CONT  TestDataDriven/3node/repartition/multi_col_list_partitioning_default_to_multi_col_list_partitioning
            --- FAIL: TestDataDriven/3node/repartition/multi_col_list_partitioning_default_to_multi_col_list_partitioning (62.97s)
=== RUN   TestDataDriven/3node
    --- FAIL: TestDataDriven/3node (416.11s)
=== RUN   TestDataDriven/3node/repartition
        --- FAIL: TestDataDriven/3node/repartition (0.00s)

Parameters: TAGS=bazel,gss , stress=true

Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@ecwall
Copy link
Contributor

ecwall commented Sep 12, 2023

Happens deterministically when table ID is 109.

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/spanconfigccl/spanconfigsqltranslatorccl/spanconfigsqltranslatorccl_test.TestDataDriven failed with artifacts on master @ ac3c2bec120c79d595a8d335f473b8fe2487e794:

        ALTER TABLE db.tbl CONFIGURE ZONE DISCARD;
        ----
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/1942/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:
        translate [2 args]
        <no input to command>
        ----
        [/Table/<table-id>, /Table/<table-id+1>)               range default
=== NAME  TestDataDriven/3node/partition/single_col_range_partitioning_sparse
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/1942/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_sparse:13:
        translate [2 args]
        <no input to command>
        ----
        [/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]
=== NAME  TestDataDriven/3node/partition/scans
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/1942/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/scans:1:
        exec-sql [0 args]
        CREATE DATABASE IF NOT EXISTS db;
        CREATE TABLE IF NOT EXISTS db.tbl (a INT PRIMARY KEY, b INT);
        ALTER TABLE db.tbl PARTITION BY LIST (a) (
          PARTITION p3p5 VALUES IN ((3), (5)),
          PARTITION p4 VALUES IN (4),
          PARTITION pd VALUES IN (DEFAULT)
        );
        ALTER TABLE db.tbl CONFIGURE ZONE USING constraints = '[+n1]';
        ALTER PARTITION p3p5 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]';
        ALTER PARTITION pd OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n1]';
        ----
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/1942/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/scans:15:
        translate [2 args]
        <no input to command>
        ----
        [/Table/<table-id>, /Table/<table-id>/1)               constraints=[+n1]
        [/Table/<table-id>/1, /Table/<table-id>/1/3)           constraints=[+n1]
        [/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/6)         constraints=[+n2]
        [/Table/<table-id>/1/6, /Table/<table-id>/2)           constraints=[+n1]
        [/Table/<table-id>/2, /Table/<table-id+1>)             constraints=[+n1]
            --- FAIL: TestDataDriven/3node/partition/multi_col_range_partitioning_maxvalue_maxvalue (65.43s)
=== RUN   TestDataDriven/3node
    --- FAIL: TestDataDriven/3node (428.25s)

Parameters: TAGS=bazel,gss , stress=true

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 master @ 0cde11b885a5e156b970c003505acd081fb4f326:

=== RUN   TestDataDriven/3node
    --- FAIL: TestDataDriven/3node (437.76s)
=== RUN   TestDataDriven/3node/repartition
        --- FAIL: TestDataDriven/3node/repartition (0.01s)
=== RUN   TestDataDriven/3node/repartition/multi_col_range_partitioning_maxvalue_to_multi_col_range_partitioning_maxvalue_maxvalue
=== PAUSE TestDataDriven/3node/repartition/multi_col_range_partitioning_maxvalue_to_multi_col_range_partitioning_maxvalue_maxvalue
=== CONT  TestDataDriven/3node/repartition/multi_col_range_partitioning_maxvalue_to_multi_col_range_partitioning_maxvalue_maxvalue
=== NAME  TestDataDriven/3node/repartition/single_col_range_partitioning_to_unpartitioned
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3317/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/3317/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:
        translate [2 args]
        <no input to command>
        ----
        [/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]
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3317/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/3317/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:
        translate [2 args]
        <no input to command>
        ----
        [/Table/<table-id>, /Table/<table-id+1>)               range default
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3317/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/repartition/single_col_range_partitioning_to_unpartitioned:1:
        repartition [2 args]
        <no input to command>
        ----
            --- FAIL: TestDataDriven/3node/repartition/multi_col_range_partitioning_maxvalue_to_multi_col_range_partitioning_maxvalue_maxvalue (61.93s)

Parameters: TAGS=bazel,gss , stress=true

Help

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

Same failure on other branches

This test on roachdash | Improve this report!

@jeffswenson
Copy link
Collaborator

Happens deterministically when table ID is 109.

109 is a special number for keys. It is the first byte value with a PrefixEnd that is not a decodable varint. See https://cockroachlabs.slack.com/archives/C02P01CDKKP/p1693827854236639 for an example impacting tenant IDs.

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/spanconfigccl/spanconfigsqltranslatorccl/spanconfigsqltranslatorccl_test.TestDataDriven failed with artifacts on master @ 28552c8876e8d6764c2102effbb8d9842185123d:

        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3281/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_null: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 pl1 VALUES IN (NULL, 1),
          PARTITION p3  VALUES IN (3)
        );
        ALTER INDEX db.tbl@b_idx CONFIGURE ZONE USING constraints = '[+n1]';
        ALTER PARTITION pl1 OF INDEX db.tbl@b_idx CONFIGURE ZONE USING constraints = '[+n2]';
        ALTER PARTITION p3 OF INDEX db.tbl@b_idx CONFIGURE ZONE USING constraints = '[+n3]';
        ----
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3281/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_null:13:
        translate [2 args]
        <no input to command>
        ----
        [/Table/<table-id>, /Table/<table-id>/2)               range default
        [/Table/<table-id>/2, /Table/<table-id>/2/NULL)        constraints=[+n1]
        [/Table/<table-id>/2/NULL, /Table/<table-id>/2/!NULL)  constraints=[+n2]
        [/Table/<table-id>/2/!NULL, /Table/<table-id>/2/1)     constraints=[+n1]
        [/Table/<table-id>/2/1, /Table/<table-id>/2/2)         constraints=[+n2]
        [/Table/<table-id>/2/2, /Table/<table-id>/2/3)         constraints=[+n1]
        [/Table/<table-id>/2/3, /Table/<table-id>/2/4)         constraints=[+n3]
        [/Table/<table-id>/2/4, /Table/<table-id>/3)           constraints=[+n1]
        [/Table/<table-id>/3, /Table/<table-id+1>)             range default
=== NAME  TestDataDriven/3node/partition/secondary_index_unpartitioned
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3281/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_unpartitioned: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 NOTHING;
        ALTER INDEX db.tbl@b_idx CONFIGURE ZONE DISCARD;
        ----
            --- FAIL: TestDataDriven/3node/partition/multi_col_range_partitioning_maxvalue_maxvalue (76.46s)
=== 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
            --- FAIL: TestDataDriven/3node/partition/single_col_range_partitioning_sparse (74.38s)
=== RUN   TestDataDriven/3node/repartition
        --- FAIL: TestDataDriven/3node/repartition (0.01s)
=== RUN   TestDataDriven/3node/repartition/multi_col_range_partitioning_maxvalue_to_multi_col_range_partitioning
=== PAUSE TestDataDriven/3node/repartition/multi_col_range_partitioning_maxvalue_to_multi_col_range_partitioning
=== CONT  TestDataDriven/3node/repartition/multi_col_range_partitioning_maxvalue_to_multi_col_range_partitioning
            --- FAIL: TestDataDriven/3node/repartition/multi_col_range_partitioning_maxvalue_to_multi_col_range_partitioning (87.58s)
=== RUN   TestDataDriven/3node
    --- FAIL: TestDataDriven/3node (505.78s)
=== RUN   TestDataDriven/3node/partition
        --- FAIL: TestDataDriven/3node/partition (0.01s)

Parameters: TAGS=bazel,gss , stress=true

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 master @ 985662236d7bf273b93a7b5e32def8e2d1043640:

=== RUN   TestDataDriven
    test_log_scope.go:167: test logs captured to: /artifacts/tmp/_tmp/95402ff756937342dc1a396f8e8e6bd5/logTestDataDriven2888398192
    test_log_scope.go:81: use -show-logs to present logs inline
--- FAIL: TestDataDriven (465.16s)
=== RUN   TestDataDriven/3node
    --- FAIL: TestDataDriven/3node (448.65s)
=== RUN   TestDataDriven/3node/repartition
        --- FAIL: TestDataDriven/3node/repartition (0.00s)
=== RUN   TestDataDriven/3node/repartition/single_col_range_partitioning_to_single_col_list_partitioning
=== PAUSE TestDataDriven/3node/repartition/single_col_range_partitioning_to_single_col_list_partitioning
=== CONT  TestDataDriven/3node/repartition/single_col_range_partitioning_to_single_col_list_partitioning
            --- FAIL: TestDataDriven/3node/repartition/single_col_range_partitioning_to_single_col_list_partitioning (70.84s)

Parameters: TAGS=bazel,gss , stress=true

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 master @ 6cbd07ee6fbfb92706e8cdc8c559960b1bc41663:

=== RUN   TestDataDriven
    test_log_scope.go:167: test logs captured to: /artifacts/tmp/_tmp/95402ff756937342dc1a396f8e8e6bd5/logTestDataDriven504734327
    test_log_scope.go:81: use -show-logs to present logs inline
--- FAIL: TestDataDriven (461.14s)
=== RUN   TestDataDriven/3node
    --- FAIL: TestDataDriven/3node (443.99s)
=== RUN   TestDataDriven/3node/partition
        --- FAIL: TestDataDriven/3node/partition (0.00s)
=== RUN   TestDataDriven/3node/partition/single_col_range_partitioning_maxvalue
=== PAUSE TestDataDriven/3node/partition/single_col_range_partitioning_maxvalue
=== CONT  TestDataDriven/3node/partition/single_col_range_partitioning_maxvalue
            --- FAIL: TestDataDriven/3node/partition/single_col_range_partitioning_maxvalue (69.49s)

Parameters: TAGS=bazel,gss , stress=true

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 master @ 6cbd07ee6fbfb92706e8cdc8c559960b1bc41663:

=== RUN   TestDataDriven
    test_log_scope.go:167: test logs captured to: /artifacts/tmp/_tmp/95402ff756937342dc1a396f8e8e6bd5/logTestDataDriven26684496
    test_log_scope.go:81: use -show-logs to present logs inline
--- FAIL: TestDataDriven (426.56s)
=== RUN   TestDataDriven/3node/repartition/multi_col_range_partitioning_maxvalue_to_multi_col_range_partitioning
=== PAUSE TestDataDriven/3node/repartition/multi_col_range_partitioning_maxvalue_to_multi_col_range_partitioning
=== CONT  TestDataDriven/3node/repartition/multi_col_range_partitioning_maxvalue_to_multi_col_range_partitioning
            --- FAIL: TestDataDriven/3node/repartition/multi_col_range_partitioning_maxvalue_to_multi_col_range_partitioning (61.87s)
=== RUN   TestDataDriven/3node
    --- FAIL: TestDataDriven/3node (410.01s)
=== RUN   TestDataDriven/3node/partition
        --- FAIL: TestDataDriven/3node/partition (0.00s)
=== RUN   TestDataDriven/3node/partition/all_indexes_shuffled
=== PAUSE TestDataDriven/3node/partition/all_indexes_shuffled
=== CONT  TestDataDriven/3node/partition/all_indexes_shuffled
=== NAME  TestDataDriven/3node/partition/multi_col_range_partitioning_maxvalue
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/3286/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_maxvalue:17:
        translate [2 args]
        <no input to command>
        ----
        [/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/5/6)       constraints=[+n1]
        [/Table/<table-id>/1/5/6, /Table/<table-id>/1/5/7)     constraints=[+n2]
        [/Table/<table-id>/1/5/7, /Table/<table-id+1>)         constraints=[+n1]
            --- FAIL: TestDataDriven/3node/partition/all_indexes_shuffled (66.06s)
=== RUN   TestDataDriven/3node/repartition
        --- FAIL: TestDataDriven/3node/repartition (0.00s)

Parameters: TAGS=bazel,gss , stress=true

Help

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

Same failure on other branches

This test on roachdash | Improve this report!

craig bot pushed a commit that referenced this issue Sep 18, 2023
110774: pgcryptocipherccl: convert invariant errors into assertions r=rafiss a=andyyang890

This patch changes the checks for programmer error in the `pgcryptocipherccl` package to use `errors.AssertionFailedf` so that they are surfaced with greater visibility.

Epic: None

Release note: None

110803: rangefeed: actually use scheduler in scheduler benchmarks r=erikgrinaker a=erikgrinaker

Epic: none
Release note: None

110829: testing: set UseTransactionalDescIDGenerator testing knob in SQLTranslator tests r=rafiss a=ecwall

Fixes #110242
Fixes #110240

Set UseTransactionalDescIDGenerator to true to prevent transaction retries from
resulting in different descriptor IDs. Descriptor IDs appear directly in the test
output and must remain stable.

Release note: None

110830: storage: ignore {exclusive,shared} locks in ScanConflictingIntentsForDroppingLatchesEarly r=nvanbenschoten a=arulajmani

ScanConflictingIntentsForDroppingLatchesEarly is called by non-locking read requests to check for conflicts before evaluating. Non-locking reads do not conflict with Exclusive or Shared locks -- so these can be ignored when scanning the lock table. This patch does so, by making use of an appropriately configured `LockTableIterator`.

Informs #100193

Release note: None

Co-authored-by: Andy Yang <[email protected]>
Co-authored-by: Erik Grinaker <[email protected]>
Co-authored-by: Evan Wall <[email protected]>
Co-authored-by: Arul Ajmani <[email protected]>
@craig craig bot closed this as completed in b232ffe Sep 18, 2023
blathers-crl bot pushed a commit that referenced this issue Sep 18, 2023
…lator tests

Fixes #110242

Set UseTransactionalDescIDGenerator to true to prevent transaction retries from
resulting in different descriptor IDs. Descriptor IDs appear directly in the test
output and must remain stable.

Release note: None
blathers-crl bot pushed a commit that referenced this issue Sep 22, 2023
…lator tests

Fixes #110242

Set UseTransactionalDescIDGenerator to true to prevent transaction retries from
resulting in different descriptor IDs. Descriptor IDs appear directly in the test
output and must remain stable.

Release note: None
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). db-cy-23 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-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Projects
No open projects
Archived in project
3 participants