Pacemaker Fails to Start Legacy SAP HANA (Python 2-Based) After Upgrading to SAPHanaSR-0.162.2-*

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

Environment

SUSE Linux Enterprise Server for SAP Applications 15 SP5
SUSE Linux Enterprise Server for SAP Applications 15 SP4
SUSE Linux Enterprise Server for SAP Applications 15 SP3
SUSE Linux Enterprise Server for SAP Applications 15 SP2
SUSE Linux Enterprise Server for SAP Applications 15 SP1
SUSE Linux Enterprise Server for SAP Applications 12 SP5

Situation

In a legacy SAP HANA high-availability setup, using Python 2, after updating the "SAPHanaSR" package to version 0.162.2-*, the pacemaker cluster is unable to start the SAP HANA DB cluster resources. An error from the SR Hook (SAPHanaSR.py) is observed within the SAP HANA nameserver trace log file.

[5202]{-1}[-1/-1] 2024-01-28 12:15:26.462372 e ha_dr_provider PythonProxyImpl.cpp(01180) : SAPHanaSR/SAPHanaSR:srConnectionChanged() failed with python error: global name 'FileNotFoundError' is not defined
File "/usr/share/SAPHanaSR/SAPHanaSR.py", line 82, in srConnectionChanged
except FileNotFoundError:

Cluster resource agent SAPHanaSR-0.162.2-* versions:
SLES15 SPx: SAPHanaSR-0.162.2-150000.4.34.1
SLES12 SP5: SAPHanaSR-0.162.2-3.32.2

SAP HANA 2 Releases:
Revisions =< 059.06 (SPS05)
Revisions =< 065.00 (SPS06)

Resolution

Beginning with the SAPHanaSR-0.162.2 resource agent version, only SAP HANA releases that utilize Python 3 are supported for use in a Pacemaker HA cluster. SAP HANA 2.0 SPS05 revision 059 and subsequent versions provide Python 3, as well as the HA/DR provider hook method srConnectionChanged() with multi-target aware parameters.

For older SAP HANA releases (with Python 2), consider the following workarounds:

Downgrade to SAPHanaSR-0.162.1-*, which remains compatible with Python 2.
Consider upgrading to Python 3, as detailed in the following SAP Notes:

SAP Note 3093542 - Transition to Python 3 of the Python Distribution Delivered With SAP HANA 2.0

SAP Note 3070359 - Python 3 Migration Guide For SAP HANA
SAP Note 3072590 - Python 3 Support for Non-Productive SAP HANA Systems

Cause

Beginning with the "SAPHanaSR-0.162.2-*" version, the python hooks only support Python 3 and are not compatible with Python 2. The SR Hook, represented by the "/usr/share/SAPHanaSR/SAPHanaSR.py" file, introduced the 'FileNotFoundError', which is exclusive to Python 3. This change causes issues for SAP HANA instances that are still operating on Python 2.

To see which python version is configured, run below command while being logged on as OS user <sid>adm:

python --version

Status

Reported to Engineering

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.