ccl/backupccl: TestDataDriven_system_privileges_table failed

[cockroach-teamcity]

ccl/backupccl.TestDataDriven_system_privileges_table failed on release-24.1 @ cb83fe0b9bc759e48c0739a600817ef01d95438e:

=== RUN   TestDataDriven_system_privileges_table
    test_log_scope.go:170: test logs captured to: outputs.zip/logTestDataDriven_system_privileges_table715710539
    test_log_scope.go:81: use -show-logs to present logs inline
    datadriven_test.go:446: Mock HTTP Storage "http://127.0.0.1:45777"
    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/system-privileges-table:1:
        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/system-privileges-table:4:
        exec-sql [0 args]
        CREATE USER testuser;
        CREATE USER testuser2;
        GRANT SYSTEM MODIFYCLUSTERSETTING, VIEWACTIVITY TO testuser;
        GRANT SELECT ON crdb_internal.tables TO testuser;
        CREATE EXTERNAL CONNECTION foo AS 'nodelocal://1/foo';
        GRANT USAGE ON EXTERNAL CONNECTION foo TO testuser2;
        GRANT SYSTEM VIEWACTIVITYREDACTED TO testuser2;
        GRANT SELECT ON crdb_internal.databases, crdb_internal.tables TO testuser2;
        GRANT ALL ON EXTERNAL CONNECTION foo TO testuser2;
        ----
    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/system-privileges-table:16:
         SELECT * FROM system.privileges
        output didn't match expected:
        @@ -1,8 +1,8 @@
         root /externalconn/foo {ALL} {} 1
        -testuser /global/ {MODIFYCLUSTERSETTING,VIEWACTIVITY} {} 100
        -testuser /vtable/crdb_internal/tables {SELECT} {} 100
        -testuser2 /externalconn/foo {ALL} {} 101
        -testuser2 /global/ {VIEWACTIVITYREDACTED} {} 101
        -testuser2 /vtable/crdb_internal/databases {SELECT} {} 101
        -testuser2 /vtable/crdb_internal/tables {SELECT} {} 101
        +testuser /global/ {MODIFYCLUSTERSETTING,VIEWACTIVITY} {} 102
        +testuser /vtable/crdb_internal/tables {SELECT} {} 102
        +testuser2 /externalconn/foo {ALL} {} 103
        +testuser2 /global/ {VIEWACTIVITYREDACTED} {} 103
        +testuser2 /vtable/crdb_internal/databases {SELECT} {} 103
        +testuser2 /vtable/crdb_internal/tables {SELECT} {} 103

    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_system_privileges_table715710539
--- FAIL: TestDataDriven_system_privileges_table (1.19s)

Parameters:

• attempt=1
• run=3
• shard=21
  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-40325

[navsetlur]

Duplicate of #127783