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

[cockroach-teamcity]

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

=== RUN   TestDataDriven
    test_log_scope.go:161: test logs captured to: /artifacts/tmp/_tmp/95402ff756937342dc1a396f8e8e6bd5/logTestDataDriven1531693588
    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/logTestDataDriven1531693588
--- FAIL: TestDataDriven (461.06s)
=== RUN   TestDataDriven/3node
    --- FAIL: TestDataDriven/3node (443.39s)
=== RUN   TestDataDriven/3node/repartition
        --- FAIL: TestDataDriven/3node/repartition (0.01s)
=== RUN   TestDataDriven/3node/repartition/single_col_list_partitioning_default_to_unpartitioned
=== PAUSE TestDataDriven/3node/repartition/single_col_list_partitioning_default_to_unpartitioned
=== CONT  TestDataDriven/3node/repartition/single_col_list_partitioning_default_to_unpartitioned
=== CONT  TestDataDriven/3node/repartition/single_col_list_partitioning_default_to_unpartitioned
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/653/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_default: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 LIST (a) (
          PARTITION p4 VALUES IN (4),
          PARTITION p5 VALUES IN (5),
          PARTITION pd VALUES IN (DEFAULT)
        );
        ALTER TABLE db.tbl CONFIGURE ZONE DISCARD;
        ALTER PARTITION p4 OF INDEX db.tbl@tbl_pkey CONFIGURE ZONE USING constraints = '[+n2]';
        ALTER PARTITION p5 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/repartition/single_col_list_partitioning_default_to_unpartitioned
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/653/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_default:15:
         
        output didn't match expected:
        @@ -1,7 +1,7 @@
         [/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>/1/6)         constraints=[+n3]
         [/Table/<table-id>/1/6, /Table/<table-id>/2)           constraints=[+n1]
        -[/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_list_partitioning_default_to_unpartitioned (73.10s)

Parameters: TAGS=bazel,gss

Help

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

Same failure on other branches

• pkg/ccl/spanconfigccl/spanconfigsqltranslatorccl/spanconfigsqltranslatorccl_test: TestDataDriven failed #110955 pkg/ccl/spanconfigccl/spanconfigsqltranslatorccl/spanconfigsqltranslatorccl_test: TestDataDriven failed [C-test-failure O-robot T-sql-foundations branch-release-23.1.11-rc.FROZEN]

/cc @cockroachdb/kv

This test on roachdash | Improve this report!

Jira issue: CRDB-31761

[rafiss]

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]

actually the branch is unfrozen now, so backport is here: #111105