ccl/backupccl: TestDataDriven_procedures failed

[cockroach-teamcity]

ccl/backupccl.TestDataDriven_procedures failed on release-24.1 @ 3f3127b8b592b9c63df76e47cb9f0a3b47357f62:

=== RUN   TestDataDriven_procedures
    test_log_scope.go:170: test logs captured to: outputs.zip/logTestDataDriven_procedures1450669627
    test_log_scope.go:81: use -show-logs to present logs inline
    datadriven_test.go:446: Mock HTTP Storage "http://127.0.0.1:36257"
    test_server_shim.go:157: automatically injected a shared process virtual cluster under test; see comment at top of test_server_shim.go for details.
    datadriven.go:144: 
        /var/lib/engflow/worker/work/2/exec/bazel-out/k8-fastbuild/bin/pkg/ccl/backupccl/backupccl_test_/backupccl_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/backupccl/testdata/backup-restore/procedures:2:
        new-cluster [1 args]
        <no input to command>
        ----
    datadriven.go:144: 
        /var/lib/engflow/worker/work/2/exec/bazel-out/k8-fastbuild/bin/pkg/ccl/backupccl/backupccl_test_/backupccl_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/backupccl/testdata/backup-restore/procedures:5:
         CREATE DATABASE db1;
        USE db1;
        CREATE SCHEMA sc1;
        CREATE TABLE sc1.tbl1(a INT PRIMARY KEY);
        CREATE TYPE sc1.enum1 AS ENUM('Good');
        CREATE SEQUENCE sc1.sq1;
        CREATE PROCEDURE sc1.p1(a sc1.enum1) LANGUAGE SQL AS $$
          SELECT a FROM sc1.tbl1;
          SELECT 'Good'::sc1.enum1;
          SELECT nextval('sc1.sq1');
        $$;
        CREATE SCHEMA sc2;
        CREATE TABLE sc2.tbl2(a INT PRIMARY KEY);
        CREATE PROCEDURE sc2.p2(i INT) LANGUAGE SQL AS $$
          INSERT INTO sc2.tbl2 VALUES (i)
        $$;
        expected:
        
        found:
        pq: type with ID 111 does not exist
    testutils.go:289: no Invalid Descriptors
    testutils.go:266: Warning: Could not check for invalid descriptors: sql: database is closed
    panic.go:626: -- test log scope end --
test logs left over in: outputs.zip/logTestDataDriven_procedures1450669627
--- FAIL: TestDataDriven_procedures (1.19s)

Parameters:

• attempt=1
• run=18
• shard=41

Help

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

/cc @cockroachdb/test-eng

This test on roachdash | Improve this report!

Jira issue: CRDB-38240

[blathers-crl]

cc @cockroachdb/disaster-recovery

[msbutler]

also seen on master #122353

[cockroach-teamcity]

ccl/backupccl.TestDataDriven_procedures failed on release-24.1 @ 4665969fb6f4a4c1b58f10d9f99799f1939a0d62:

=== RUN   TestDataDriven_procedures
    test_log_scope.go:170: test logs captured to: outputs.zip/logTestDataDriven_procedures3097960452
    test_log_scope.go:81: use -show-logs to present logs inline
    datadriven_test.go:446: Mock HTTP Storage "http://127.0.0.1:44039"
    test_server_shim.go:157: automatically injected a shared process virtual cluster under test; see comment at top of test_server_shim.go for details.
    datadriven.go:144: 
        /var/lib/engflow/worker/work/2/exec/bazel-out/k8-fastbuild/bin/pkg/ccl/backupccl/backupccl_test_/backupccl_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/backupccl/testdata/backup-restore/procedures:2:
        new-cluster [1 args]
        <no input to command>
        ----
    datadriven.go:144: 
        /var/lib/engflow/worker/work/2/exec/bazel-out/k8-fastbuild/bin/pkg/ccl/backupccl/backupccl_test_/backupccl_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/backupccl/testdata/backup-restore/procedures:5:
         CREATE DATABASE db1;
        USE db1;
        CREATE SCHEMA sc1;
        CREATE TABLE sc1.tbl1(a INT PRIMARY KEY);
        CREATE TYPE sc1.enum1 AS ENUM('Good');
        CREATE SEQUENCE sc1.sq1;
        CREATE PROCEDURE sc1.p1(a sc1.enum1) LANGUAGE SQL AS $$
          SELECT a FROM sc1.tbl1;
          SELECT 'Good'::sc1.enum1;
          SELECT nextval('sc1.sq1');
        $$;
        CREATE SCHEMA sc2;
        CREATE TABLE sc2.tbl2(a INT PRIMARY KEY);
        CREATE PROCEDURE sc2.p2(i INT) LANGUAGE SQL AS $$
          INSERT INTO sc2.tbl2 VALUES (i)
        $$;
        expected:
        
        found:
        pq: type with ID 111 does not exist
    testutils.go:290: no Invalid Descriptors
    testutils.go:267: Warning: Could not check for invalid descriptors: sql: database is closed
    panic.go:626: -- test log scope end --
test logs left over in: outputs.zip/logTestDataDriven_procedures3097960452
--- FAIL: TestDataDriven_procedures (1.23s)

Parameters:

• attempt=1
• run=6
• shard=41

Help

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

Same failure on other branches

• ccl/backupccl: TestDataDriven_procedures failed #123832 ccl/backupccl: TestDataDriven_procedures failed [A-disaster-recovery C-test-failure O-robot T-disaster-recovery branch-master release-blocker]

This test on roachdash | Improve this report!

[msbutler]

related flake here: https://mesolite.cluster.engflow.com/invocations/default/5af94896-c553-4b3f-a1a0-06aed0049395

shall we skip these on 24.1?

[stevendanna]

Dup #122353