ccl/backupccl: TestDataDriven_plpgsql_procedures failed

[cockroach-teamcity]

ccl/backupccl.TestDataDriven_plpgsql_procedures failed on release-24.1 @ f876d25ca2dce15331ddc038b3d37dda2eef454a:

=== RUN   TestDataDriven_plpgsql_procedures
    test_log_scope.go:170: test logs captured to: outputs.zip/logTestDataDriven_plpgsql_procedures1320444044
    test_log_scope.go:81: use -show-logs to present logs inline
    datadriven_test.go:446: Mock HTTP Storage "http://127.0.0.1:43703"
    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_procedures1320444044
--- FAIL: TestDataDriven_plpgsql_procedures (1.16s)

Parameters:

• attempt=1
• run=15
• 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-38440

[yuzefovich]

dup of #123194