ccl/backupccl: TestDataDriven_plpgsql_procedures failed

[github-actions]

ccl/backupccl.TestDataDriven_plpgsql_procedures failed on release-24.1.0-rc @ 9d77dad6162bc528e725d0c57ec01c6a07d2aea2:

=== RUN   TestDataDriven_plpgsql_procedures
    test_log_scope.go:170: test logs captured to: outputs.zip/logTestDataDriven_plpgsql_procedures859594868
    test_log_scope.go:81: use -show-logs to present logs inline
    datadriven_test.go:446: Mock HTTP Storage "http://127.0.0.1:34927"
    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/plpgsql_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/plpgsql_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 PLpgSQL AS $$
          DECLARE
            foobar sc1.enum1;
          BEGIN
            SELECT a FROM sc1.tbl1;
            SELECT 'Good'::sc1.enum1;
            SELECT nextval('sc1.sq1');
          END
        $$;
        CREATE SCHEMA sc2;
        CREATE TABLE sc2.tbl2(a INT PRIMARY KEY);
        CREATE PROCEDURE sc2.p2(i INT) LANGUAGE PLpgSQL AS $$
          BEGIN
            INSERT INTO sc2.tbl2 VALUES (i);
          END
        $$;
        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_plpgsql_procedures859594868
--- FAIL: TestDataDriven_plpgsql_procedures (1.31s)

Parameters:

• attempt=1
• run=1
• shard=39

Help

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

Same failure on other branches

• ccl/backupccl: TestDataDriven_plpgsql_procedures failed #122353 ccl/backupccl: TestDataDriven_plpgsql_procedures failed [C-test-failure O-robot P-2 T-sql-queries branch-master]

/cc @cockroachdb/test-eng

This test on roachdash | Improve this report!

Jira issue: CRDB-38728

[stevendanna]

Dup #122353