[automatic failover] Handle `no-healthy database available` cases

[atakavci]

Explore and cover all scenarios that could be impacted when no healthy database is available, including the initialization of StatefulRedisMultiDBConnection.
See this.