`TestDatabases/redshift_cluster/auto_user_keep` flakiness

[nklaassen]

Failure

Link(s) to logs

• https://github.com/gravitational/teleport/actions/runs/10705690243/job/29681682584?pr=45876

Relevant snippet

=== CONT  TestDatabases/redshift_cluster/auto_user_keep
    redshift_test.go:176: 
            Error Trace:    /__w/teleport/teleport/e2e/aws/redshift_test.go:289
                                        /opt/go/src/runtime/asm_amd64.s:1695
            Error:          Should be false
            Messages:       user "auto_keep_6bce1c" should not be able to login after deactivating
    redshift_test.go:176: 
            Error Trace:    /__w/teleport/teleport/e2e/aws/redshift_test.go:266
                                        /__w/teleport/teleport/e2e/aws/redshift_test.go:176
                                        /__w/teleport/teleport/e2e/aws/redshift_test.go:210
            Error:          Condition never satisfied
            Test:           TestDatabases/redshift_cluster/auto_user_keep
            Messages:       waiting for auto user "auto_keep_6bce1c" to be deactivated

[rosstimothy]

Seeing similar failures for the auto_user_drop test as well: https://github.com/gravitational/teleport/issues/46348

[eriktate]

https://github.com/gravitational/teleport/actions/runs/11168062348/job/31045648259?pr=46829