Symptom
In a muiti-host landscape, a failover to a standby host from the failed host didn't occur.
The all hosts are belonging 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 from master nameserver trace as 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'.
Read more...
Environment
HANA 2.0
Product
Keywords
failover, standby, no hosts available to handle failing host , KBA , HAN-DB-HA , SAP HANA High Availability (System Replication, DR, etc.) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview