ccl/backupccl: TestBackupRestoreSystemUsers failed

[cockroach-teamcity]

ccl/backupccl.TestBackupRestoreSystemUsers failed on release-24.1 @ 7c483c276934758d4bf736b40594d4541377d526:

=== RUN   TestBackupRestoreSystemUsers
    test_log_scope.go:170: test logs captured to: outputs.zip/logTestBackupRestoreSystemUsers2190553932
    test_log_scope.go:81: use -show-logs to present logs inline
    test_server_shim.go:157: automatically injected an external process virtual cluster under test; see comment at top of test_server_shim.go for details.
    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.
    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.
    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.
    testutils.go:290: no Invalid Descriptors
    testutils.go:290: no Invalid Descriptors
    testutils.go:290: no Invalid Descriptors
    testutils.go:290: no Invalid Descriptors
    backup_test.go:10077: -- test log scope end --
test logs left over in: outputs.zip/logTestBackupRestoreSystemUsers2190553932
--- FAIL: TestBackupRestoreSystemUsers (144.95s)
=== RUN   TestBackupRestoreSystemUsers/restore-from-backup-with-existing-user
    backup_test.go:10058: query 'SELECT * FROM system.users': expected:
        admin, , true, 2
        app, NULL, false, 101
        app_role, NULL, true, 102
        root, , false, 1
        test, NULL, false, 103
        test_role, NULL, true, 104
        testuser, NULL, false, 100
        
        got:
        admin, , true, 2
        app, NULL, false, 103
        app_role, NULL, true, 104
        root, , false, 1
        test, NULL, false, 105
        test_role, NULL, true, 106
        testuser, NULL, false, 102
        
    --- FAIL: TestBackupRestoreSystemUsers/restore-from-backup-with-existing-user (30.25s)

Parameters:

• attempt=1
• race=true
• run=1
• shard=23

Help

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

Same failure on other branches

• ccl/backupccl: TestBackupRestoreSystemUsers failed #123870 ccl/backupccl: TestBackupRestoreSystemUsers failed [C-test-failure O-robot T-disaster-recovery branch-master release-blocker]

/cc @cockroachdb/disaster-recovery

This test on roachdash | Improve this report!

Jira issue: CRDB-38608

[msbutler]

well this certainly assumed some hard corded id's. removing release blocker.

[msbutler]

fixed by #124063