Resource cleanup activities - SAP HANA on Amazon
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Resource cleanup activities

Clean up the failed actions using following command: 

[root@prihana ~]# pcs resource cleanup SAPHana_HDB_00 --node prihana
[root@prihana ~]#pcs status
Thu Nov 12 10:45:14 2020

Cluster name: rhelhanaha
Stack: corosync
Current DC: sechana (version 1.1.19-8.el7_6.5-c3c624ea3d) - partition with quorum
Last updated: Thu Nov 12 10:45:14 2020
Last change: Thu Nov 12 10:45:06 2020 by root via crm_attribute on sechana

2 nodes configured
6 resources configured

Online: [ prihana sechana ]

Full list of resources:

 clusterfence   (stonith:fence_aws):    Started prihana
 Clone Set: SAPHanaTopology_HDB_00-clone [SAPHanaTopology_HDB_00]
     Started: [ prihana sechana ]
 Master/Slave Set: SAPHana_HDB_00-master [SAPHana_HDB_00]
     Masters: [ sechana ]
     Stopped: [ prihana ]
 hana-oip       (ocf::heartbeat:aws-vpc-move-ip):       Started sechana

Daemon Status:
  corosync: active/enabled
  pacemaker: active/enabled
  pcsd: active/enabled

Manual migration of resources from one node to another node (as shown in the preceding section) will create constraints in pcs configuration “pcs config show”. 

root@prihana ~]# pcs config show
Cluster Name: rhelhanaha
Corosync Nodes:
 prihana sechana
Pacemaker Nodes:
 prihana sechana

Resources:
 Clone: SAPHanaTopology_HDB_00-clone
  Meta Attrs: clone-max=2 clone-node-max=1 interleave=true
  Resource: SAPHanaTopology_HDB_00 (class=ocf provider=heartbeat type=SAPHanaTopology)
   Attributes: InstanceNumber=00 SID=HDB
   Operations: methods interval=0s timeout=5 (SAPHanaTopology_HDB_00-methods-interval-0s)
               monitor interval=10 timeout=600 (SAPHanaTopology_HDB_00-monitor-interval-10)
               reload interval=0s timeout=5 (SAPHanaTopology_HDB_00-reload-interval-0s)
               start interval=0s timeout=600 (SAPHanaTopology_HDB_00-start-interval-0s)
               stop interval=0s timeout=300 (SAPHanaTopology_HDB_00-stop-interval-0s)
 Master: SAPHana_HDB_00-master
  Meta Attrs: clone-max=2 clone-node-max=1 interleave=true notify=true
  Resource: SAPHana_HDB_00 (class=ocf provider=heartbeat type=SAPHana)
   Attributes: AUTOMATED_REGISTER=true DUPLICATE_PRIMARY_TIMEOUT=7200 
               InstanceNumber=00 PREFER_SITE_TAKEOVER=true SID=HDB
   Operations: demote interval=0s timeout=3600 (SAPHana_HDB_00-demote-interval-0s)
               methods interval=0s timeout=5 (SAPHana_HDB_00-methods-interval-0s)
               monitor interval=61 role=Slave timeout=700 (SAPHana_HDB_00-monitor-interval-61)
               monitor interval=59 role=Master timeout=700 (SAPHana_HDB_00-monitor-interval-59)
               promote interval=0s timeout=3600 (SAPHana_HDB_00-promote-interval-0s)
               reload interval=0s timeout=5 (SAPHana_HDB_00-reload-interval-0s)
               start interval=0s timeout=3600 (SAPHana_HDB_00-start-interval-0s)
               stop interval=0s timeout=3600 (SAPHana_HDB_00-stop-interval-0s)
 Resource: hana-oip (class=ocf provider=heartbeat type=aws-vpc-move-ip)
  Attributes: interface=eth0 ip=192.168.1.99 routing_table=rtb-0027679b7a9eff404
  Operations: monitor interval=60s timeout=30s (hana-oip-monitor-interval-60s)
              start interval=0s timeout=180s (hana-oip-start-interval-0s)
              stop interval=0s timeout=180s (hana-oip-stop-interval-0s)

Stonith Devices:
 Resource: clusterfence (class=stonith type=fence_aws)
  Attributes: pcmk_host_map=prihana:i-01b7ceb0d8799eccf;sechana:i-05b924af2f83ffe0b 
  pcmk_reboot_retries=4 pcmk_reboot_timeout=480 power_timeout=240 region=us-east-1
  Operations: monitor interval=60s (clusterfence-monitor-interval-60s)
Fencing Levels:

Location Constraints:
Ordering Constraints:
  start SAPHanaTopology_HDB_00-clone then start SAPHana_HDB_00-master 
  (kind:Mandatory) (non-symmetrical)
Colocation Constraints:
  hana-oip with SAPHana_HDB_00-master (score:2000) (rsc-role:Started) 
  (with-rsc-role:Master)
Ticket Constraints:

Alerts:
 No alerts defined

Resources Defaults:
 resource-stickiness: 1000
 migration-threshold: 5000
Operations Defaults:
 No defaults set

Cluster Properties:
 cluster-infrastructure: corosync
 cluster-name: rhelhanaha
 dc-version: 1.1.19-8.el7_6.5-c3c624ea3d
 have-watchdog: false
 last-lrm-refresh: 1605053571
Node Attributes:
 prihana: hana_hdb_op_mode=logreplay hana_hdb_remoteHost=sechana 
  hana_hdb_site=HDBPrimary hana_hdb_srmode=syncmem hana_hdb_vhost=prihana 
  lpa_hdb_lpt=1605196167
 sechana: hana_hdb_op_mode=logreplay hana_hdb_remoteHost=prihana 
  hana_hdb_site=HDBSecondary hana_hdb_srmode=syncmem hana_hdb_vhost=sechana 
  lpa_hdb_lpt=30

Quorum:
  Options:

These location constraints need to be cleaned up before you perform any further cluster actions with the following command: 

[root@prihana ~]# pcs constraint list --full
Location Constraints:
Ordering Constraints:
  start SAPHanaTopology_HDB_00-clone then start SAPHana_HDB_00-master 
(kind:Mandatory) (non-symmetrical) (id:order-SAPHanaTopology_HDB_00-
clone-SAPHana_HDB_00-master-mandatory)
Colocation Constraints:
  hana-oip with SAPHana_HDB_00-master (score:2000) (rsc-role:Started) 
(with-rsc-role:Master) (id:colocation-hana-oip-SAPHana_HDB_00-master-2000)
Ticket Constraints:
[root@prihana ~]#


root@prihana ~]# pcs constraint remove colocation-hana-oip-SAPHana_HDB_00-master-2000

[root@prihana ~]# pcs constraint list --full
Location Constraints:
Ordering Constraints:
  start SAPHanaTopology_HDB_00-clone then start SAPHana_HDB_00-master 
(kind:Mandatory) (non-symmetrical) (id:order-SAPHanaTopology_HDB_00-clone-
SAPHana_HDB_00-master-mandatory)
Colocation Constraints:
Ticket Constraints:
[root@prihana ~]#