Indepth HANA Cluster Debug Data Collection (PACEMAKER, SAP)

This document (7022702) is provided subject to the disclaimer at the end of this document.

Environment

SUSE Linux Enterprise Server for SAP Applications

Situation

This document is aimed at interested Customers and SUSE Support. This is a living document, please do check for changes before applying or referring to it.

Assuming there are issues in the behavior of the pacemaker cluster in connection with HANA that are not obvious from an Error Message or covered in another TID the common question is "what Data to provide to enable SUSE Support to find a solution for my HANA Cluster Setup"
 

Resolution

1) hb_report

Please provide an hb_report from the time of the incident with a time frame covering at least one hour before and one hour after.

Assuming the issue happened on

    November 25th. 2017 at 11:00
   
that would be then

    hb_report -u root -f "2017/11/25 10:00" -t "2017/11/25 12:00" /tmp/hana.case
   
the resulting file

    /tmp/hana.case.bz2
   
contains the necessary data from a cluster perspective. It the logfile configuration in corosync.conf was changed add the necessary  path to the logfile in the hb_report command as argument, otherwise the hb_report will be useless.

If ssh is available on the Servers there is no need to run hb_report on every node, as it will ssh to the other nodes and collect the data.

2) supportconfig

On all cluster nodes run
 
    supportconfig
 
or if logs have been rotated since the incident use the '-l' flag to collect all logs.
 
    supportconfig -l
   
and provide the resulting file which will be in /var/log/

3) HANA Data
Note:  A supportconfig plugin has been released in the updates channels  which will automatically gather SAP information when running the supportconfig's in the above step if the plugin is already installed. ( To install the plugin run: zypper in supportutils-plugin-ha-sap ) 

change to the SAP User

    su - <SID>adm
   
find the instance number of the SAP Instance and run on every node

    sapcontrol -nr <NR> -function GetProcessList >> /tmp/hana.$HOSTNAME

               (where NR is the Instance Number of the SAP Instance in question)
 
    hdbnsutil -sr_state >> /tmp/hana.$HOSTNAME
   
    HDBSettings.sh landscapeHostConfiguration.py --sapcontrol=1 >> /tmp/hana.$HOSTNAME; echo $? >> /tmp/hana.$HOSTNAME
   
    HDBSettings.sh systemReplicationStatus.py >> /tmp/hana.$HOSTNAME; echo $? >> /tmp/hana.$HOSTNAME

    HDB info >> /tmp/hana.$HOSTNAME

    HDBSettings.sh systemOverview.py >> /tmp/hana.$HOSTNAME   

   
provide the files

    /tmp/hana.$HOSTNAME
   
that will be created by this.

Expected Result, assuming it is a 2 Node Cluster, replace 2 with Number of Nodes in case the cluster has more nodes.

    1    hb_report from cluster   
    2    supportconfigs from each node
    2    hana.$HOSTNAME files from each node   

provide these files to the SUSE Support.
 

Additional Information

There are plans to implement this maybe into supportconfig at some stage for automatic collection.
Update:  supportutils-plugin-ha-sap RPM was released May 6, 2020 in updates channels. 

If one wanted to check also the SAP Hana Logs then

change to the SAP User

    su - <SID>adm
   
and then issue

         cdtrace

which takes one directly to the local HANA Logs.
 

Disclaimer

This Support Knowledgebase provides a valuable tool for SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.

  • Document ID:7022702
  • Creation Date: 02-Mar-2018
  • Modified Date:03-Nov-2020
    • SUSE Linux Enterprise High Availability Extension
    • SUSE Linux Enterprise Server for SAP Applications

< Back to Support Search

For questions or concerns with the SUSE Knowledgebase please contact: tidfeedback@suse.com

SUSE Support Forums

Get your questions answered by experienced Sys Ops or interact with other SUSE community experts.

Join Our Community

Support Resources

Learn how to get the most from the technical support you receive with your SUSE Subscription, Premium Support, Academic Program, or Partner Program.


SUSE Customer Support Quick Reference Guide SUSE Technical Support Handbook Update Advisories
Support FAQ

Open an Incident

Open an incident with SUSE Technical Support, manage your subscriptions, download patches, or manage user access.

Go to Customer Center