3132131 - An expected failover didn't occur even though a standby host is configured correctly.

In a multi-host landscape, a failover to a standby host from the failed host did not occur. All hosts belong to the same failover actual group (default).

> python $DIR_INSTANCE/exe/python_support/landscapeHostConfiguration.py
----------------------------------------------------------------------------------------------
| Host        | Host   | Host     | Failover         | Failover | Failover | NameServer    | NameServer     | IndexServer    | IndexServer   | Host                 | Host                 | Worker   | Worker  | 
|             | Active | Status   | Status           | Config   | Actual   | Config        | Actual         | Config         | Actual        | Config               | Actual               | Config   | Actual  | 
|             |        |          |                  | Group    | Group    | Role          | Role           | Role           | Role          | Roles                | Roles                | Groups   | Groups  | 
| ------------| ------ | -------- | ---------------- | -------- | -------- | ------------- | -------------- | -------------- | ------------- | -------------------- | -------------------- | -------- | ------- | 
| masterhost1 |  yes   | ok       |                  |  default |  default | master 1      | master         | worker         | master        | worker xs_worker     | worker xs_worker     | default  | default | 
| failedhost1 |   no   | warning  | waiting 10 sec   |  default |  default | master 2      | slave          | worker         | slave         | worker               | worker               | default  | default | 
| standbyhost |  yes   | ignore   |                  |  default |  default | master 3      | slave          | standby        | standby       | standby              | standby              | default  | default | 

The failed failover can be found in the master nameserver trace as shown below.

[6787]{-1}[-1/-1] 2021-12-02 11:28:19.881325 i service_active_s TREXNameServer.cpp(04149) : Service active states (setInactive - failedhost1:38401, watchdog=0): 
[6787]{-1}[-1/-1] 2021-12-02 11:28:19.881342 i service_active_s TREXNameServer.cpp(04163) : - masterhost1: 16484=yes,38400=yes,38401=yes,38402=yes,38403=yes,38404=yes,38406=yes,38407=yes,38410=yes,38429=yes,38431=yes
[6787]{-1}[-1/-1] 2021-12-02 11:28:19.881351 i service_active_s TREXNameServer.cpp(04163) : - failedhost1: 38400=no,38401=no,38402=no,38403=no,38406=no,38410=no,38440=no
[6787]{-1}[-1/-1] 2021-12-02 11:28:19.881356 i service_active_s TREXNameServer.cpp(04163) : - standbyhost: 38400=yes,38401=yes,38402=yes,38406=yes,38410=yes
............
[6956]{-1}[-1/-1] 2021-12-02 11:28:48.471996 w failover TREXNameServer.cpp(05864) : no hosts available to handle failing host failedhost1, retrying later
[6950]{-1}[-1/-1] 2021-12-02 11:29:18.474162 w failover TREXNameServer.cpp(05864) : no hosts available to handle failing host failedhost1, retrying later
[6950]{-1}[-1/-1] 2021-12-02 11:29:18.474748 w failover TREXNameServer.cpp(05870) : no hosts available to handle failing host failedhost1, retrying later but without further tracing
[6950]{-1}[-1/-1] 2021-12-02 11:29:18.474875 w failover TREXNameServer.cpp(05874) : topology for all hosts=

The related failover parameter 'nameserver.ini/[failover]/cross_failover_group' has been set to 'true'.

Images/data in this KBA from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

SAP HANA, Platform Edition 2.0

failover, standby, no hosts available to handle failing host , KBA , HAN-DB-HA , SAP HANA High Availability (System Replication, DR, etc.) , Problem