ccl/backupccl: TestDataDriven_procedures failed

[cockroach-teamcity]

ccl/backupccl.TestDataDriven_procedures failed on master @ 93ad913106b6f0f6ec98bc2cfa788ff6d8085bd4:

=== RUN   TestDataDriven_procedures
    test_log_scope.go:170: test logs captured to: outputs.zip/logTestDataDriven_procedures2886408359
    test_log_scope.go:81: use -show-logs to present logs inline
    datadriven_test.go:445: Mock HTTP Storage "http://127.0.0.1:35341"
    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/3/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/3/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_procedures2886408359
--- FAIL: TestDataDriven_procedures (1.19s)

Parameters:

• attempt=1
• run=16
• shard=42

Help

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

/cc @cockroachdb/disaster-recovery

This test on roachdash | Improve this report!

Jira issue: CRDB-38865

[DrewKimball]

Dupe of #122353.