ccl/backupccl: TestDataDriven_procedures failed

[cockroach-teamcity]

ccl/backupccl.TestDataDriven_procedures failed with artifacts on master @ 2b3e39b5393fd61b74ee9bf21f3cf399b7ec22a7:

        pq: cannot rename relation "sc1.tbl1" because function "p1" depends on it
        HINT: consider dropping "p1" first.
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/10288/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-fastbuild/bin/pkg/ccl/backupccl/backupccl_test_/backupccl_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/backupccl/testdata/backup-restore/procedures:150:
        exec-sql [0 args]
        ALTER TABLE sc1.tbl1 SET SCHEMA sc2;
        ----
        pq: cannot set schema on relation "tbl1" because function "p1" depends on it
        HINT: consider dropping "p1" first.
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/10288/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-fastbuild/bin/pkg/ccl/backupccl/backupccl_test_/backupccl_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/backupccl/testdata/backup-restore/procedures:156:
        exec-sql [0 args]
        DROP TYPE sc1.enum1
        ----
        pq: cannot drop type "enum1" because other objects ([db1_new.sc1.p1]) 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: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/10288/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-fastbuild/bin/pkg/ccl/backupccl/backupccl_test_/backupccl_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/backupccl/testdata/backup-restore/procedures:162:
        new-cluster [1 args]
        <no input to command>
        ----
    datadriven.go:144: 
        /home/roach/.cache/bazel/_bazel_roach/c5a4e7d36696d9cd970af2045211a7df/sandbox/processwrapper-sandbox/10288/execroot/com_github_cockroachdb_cockroach/bazel-out/aarch64-fastbuild/bin/pkg/ccl/backupccl/backupccl_test_/backupccl_test.runfiles/com_github_cockroachdb_cockroach/pkg/ccl/backupccl/testdata/backup-restore/procedures:165:
         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 SQL AS $$
          SELECT a FROM sc1.tbl1;
          SELECT 'Good'::sc1.enum1;
          SELECT nextval('sc1.sq1');
        $$;
        CREATE SCHEMA sc2;
        CREATE TABLE sc2.tbl2(a INT PRIMARY KEY);
        CREATE PROCEDURE sc2.p2(i INT) LANGUAGE SQL AS $$
          INSERT INTO sc2.tbl2 VALUES (i)
        $$;
        expected:
        
        found:
        pq: type with ID 111 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: /artifacts/tmp/_tmp/869044cb92460e2d5617e7c1b27019b7/logTestDataDriven_procedures3216130560
--- FAIL: TestDataDriven_procedures (11.14s)

Help

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

Same failure on other branches

• ccl/backupccl: TestDataDriven_procedures failed #123194 ccl/backupccl: TestDataDriven_procedures failed [C-test-failure O-robot T-sql-queries branch-release-24.1]

/cc @cockroachdb/test-eng

This test on roachdash | Improve this report!

Jira issue: CRDB-38565

[blathers-crl]

cc @cockroachdb/disaster-recovery

[cockroach-teamcity]

ccl/backupccl.TestDataDriven_procedures failed on master @ 16d41751607b92234351c1ab27053c3875a4f2b7:

=== RUN   TestDataDriven_procedures
    test_log_scope.go:170: test logs captured to: outputs.zip/logTestDataDriven_procedures72352427
    test_log_scope.go:81: use -show-logs to present logs inline
    datadriven_test.go:445: Mock HTTP Storage "http://127.0.0.1:41677"
    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/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/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 SQL AS $$
          SELECT a FROM sc1.tbl1;
          SELECT 'Good'::sc1.enum1;
          SELECT nextval('sc1.sq1');
        $$;
        CREATE SCHEMA sc2;
        CREATE TABLE sc2.tbl2(a INT PRIMARY KEY);
        CREATE PROCEDURE sc2.p2(i INT) LANGUAGE SQL AS $$
          INSERT INTO sc2.tbl2 VALUES (i)
        $$;
        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_procedures72352427
--- FAIL: TestDataDriven_procedures (1.22s)

Parameters:

• attempt=1
• run=9
• shard=42

Help

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

Same failure on other branches

• ccl/backupccl: TestDataDriven_procedures failed #123194 ccl/backupccl: TestDataDriven_procedures failed [C-test-failure O-robot T-sql-queries branch-release-24.1]

This test on roachdash | Improve this report!

[yuzefovich]

dup of #122353