ccl/backupccl: TestDataDriven_user_defined_functions failed

[cockroach-teamcity]

ccl/backupccl.TestDataDriven_user_defined_functions failed on master @ 3060756a084cc437114d64265e79ace5720a7317:

        pq: cannot set schema on relation "tbl1" because function "f1" depends on it
        HINT: consider dropping "f1" first.
    datadriven.go:144: 
        /var/lib/engflow/worker/work/1/exec/bazel-out/k8-fastbuild/bin/pkg/ccl/backupccl/backupccl_test_/backupccl_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/backupccl/testdata/backup-restore/user-defined-functions:306:
        exec-sql [0 args]
        DROP TYPE sc1.enum1
        ----
        pq: cannot drop type "enum1" because other objects ([db1.sc1.f1]) still depend on it
    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/1/exec/bazel-out/k8-fastbuild/bin/pkg/ccl/backupccl/backupccl_test_/backupccl_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/backupccl/testdata/backup-restore/user-defined-functions:313:
        new-cluster [1 args]
        <no input to command>
        ----
    datadriven.go:144: 
        /var/lib/engflow/worker/work/1/exec/bazel-out/k8-fastbuild/bin/pkg/ccl/backupccl/backupccl_test_/backupccl_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/backupccl/testdata/backup-restore/user-defined-functions:316:
        exec-sql [1 args]
        CREATE DATABASE db1;
        CREATE SCHEMA sc1;
        CREATE TABLE sc1.t(a INT PRIMARY KEY);
        CREATE FUNCTION sc1.f() RETURNS INT LANGUAGE SQL AS $$ SELECT 1 $$;
        ----
    datadriven.go:144: 
        /var/lib/engflow/worker/work/1/exec/bazel-out/k8-fastbuild/bin/pkg/ccl/backupccl/backupccl_test_/backupccl_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/backupccl/testdata/backup-restore/user-defined-functions:324:
         WITH db_id AS (
          SELECT id FROM system.namespace WHERE name = 'defaultdb'
        ),
        schema_id AS (
          SELECT ns.id
          FROM system.namespace AS ns
          JOIN db_id ON ns."parentID" = db_id.id
          WHERE ns.name = 'sc1'
        )
        SELECT id FROM schema_id;
        expected:
        109
        
        found:
        111
    testutils.go:289: no Invalid Descriptors
    testutils.go:289: no Invalid Descriptors
    testutils.go:289: no Invalid Descriptors
    testutils.go:289: no Invalid Descriptors
    testutils.go:266: Warning: Could not check for invalid descriptors: sql: database is closed
    testutils.go:266: Warning: Could not check for invalid descriptors: sql: database is closed
    testutils.go:266: Warning: Could not check for invalid descriptors: sql: database is closed
    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_user_defined_functions3812214637
--- FAIL: TestDataDriven_user_defined_functions (13.11s)

Parameters:

• attempt=1
• run=2
• shard=24

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

[blathers-crl]

cc @cockroachdb/disaster-recovery

[msbutler]

this may have similar root cause as #120929, but I'll wait for input from sql-foundations