ccl/backupccl: TestDataDriven_user_defined_functions_in_defaults failed

[cockroach-teamcity]

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

        query-sql [0 args]
        SELECT create_statement FROM [SHOW CREATE TABLE sc1.t1]
        ----
        CREATE TABLE sc1.t1 (
        	a INT8 NOT NULL,
        	b INT8 NULL DEFAULT sc1.f1(),
        	CONSTRAINT t1_pkey PRIMARY KEY (a ASC)
        )
    datadriven.go:144: 
        /var/lib/engflow/worker/work/0/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-in-defaults:48:
        query-sql [0 args]
        INSERT INTO sc1.t1 VALUES (1), (2);
        ----
    datadriven.go:144: 
        /var/lib/engflow/worker/work/0/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-in-defaults:52:
        query-sql [0 args]
        SELECT * FROM sc1.t1 ORDER BY a;
        ----
        1 1
        2 1
    datadriven.go:144: 
        /var/lib/engflow/worker/work/0/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-in-defaults:62:
        query-sql [0 args]
        DROP FUNCTION sc1.f1;
        ----
        pq: cannot drop function "f1" because other objects ([db1_new.sc1.t1]) 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/0/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-in-defaults:68:
        new-cluster [1 args]
        <no input to command>
        ----
    datadriven.go:144: 
        /var/lib/engflow/worker/work/0/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-in-defaults:71:
         CREATE DATABASE db1;
        USE db1;
        CREATE SCHEMA sc1;
        CREATE FUNCTION sc1.f1() RETURNS INT LANGUAGE SQL AS $$ SELECT 1 $$;
        CREATE TABLE sc1.t1(a INT PRIMARY KEY, b INT DEFAULT sc1.f1());
        expected:
        
        found:
        pq: function 110 does not exist
    testutils.go:290: no Invalid Descriptors
    testutils.go:290: no Invalid Descriptors
    testutils.go:267: Warning: Could not check for invalid descriptors: sql: database is closed
    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_user_defined_functions_in_defaults404426950
--- FAIL: TestDataDriven_user_defined_functions_in_defaults (3.40s)

Parameters:

• attempt=1
• run=11
• shard=28

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

[yuzefovich]

dup of #122353