ccl/backupccl: TestDataDriven_plpgsql_user_defined_functions failed

[cockroach-teamcity]

ccl/backupccl.TestDataDriven_plpgsql_user_defined_functions failed on release-24.1 @ 9575819131ada5aa4e23870d854beef5caaed8b0:

    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_user_defined_functions: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_user_defined_functions: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 FUNCTION sc1.f1(a sc1.enum1) RETURNS INT LANGUAGE PLpgSQL AS $$
          DECLARE
            x INT := 0;
            foobar sc1.enum1;
          BEGIN
            SELECT a FROM sc1.tbl1;
            SELECT 'Good'::sc1.enum1;
            RETURN nextval('sc1.sq1');
          END
        $$;
        CREATE PROCEDURE p_nested(a sc1.enum1) LANGUAGE PLpgSQL AS $$
          BEGIN
            RAISE NOTICE 'a: %', a;
            SELECT nextval('sc1.sq1');
          END
        $$;
        CREATE SCHEMA sc2;
        CREATE TABLE sc2.tbl2(a INT PRIMARY KEY);
        CREATE FUNCTION sc2.f2() RETURNS INT LANGUAGE PLpgSQL AS $$
          DECLARE
            x INT;
          BEGIN
            SELECT a INTO x FROM sc2.tbl2 LIMIT 1;
            SELECT sc1.f1('Good'::sc1.enum1);
            CALL p_nested('Good'::sc1.enum1);
            RETURN x;
          END
        $$;
        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_plpgsql_user_defined_functions1020362519
--- FAIL: TestDataDriven_plpgsql_user_defined_functions (1.32s)

Parameters:

• attempt=1
• run=25
• shard=40

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-38721

[stevendanna]

Dup #122353