Thursday 23 May 2019

SAP HANA startup fails with a crashdump in hdbdaemon

Tags


Symptom

You are starting HANA. During the startup, it fails and you find a crashdump in the daemon process with name similar to daemon.crashdump.044766.trc. Upon checking the crashdump file, you observe the [CRASH_STACK] session have the following content:

[CRASH_STACK] Stacktrace of crash: (no-section-time-available)
----> Pending exceptions (possible root cause) <---- br="">exception 1: no.1000000 (MultiDB/impl/MultiDBConfiguration.cpp:392)
 hdbmdcdispatcher has wrong permissions /usr/sap//HDB00/exe/mdc/hdbmdcdispatcher 33128 != 04550; $condition$=(info.st_mode & 07557) == 04550
NO exception throw location recorded. Stack generation system error.

Unknown pending exception
Throw location of the exception unknown

Environment

    SAP HANA Platform 1.0;
    Multitenant Database Containers is used (mode = multidb);
    Database Isolation Level is set to High (database_isolation = high);

Reproducing the Issue

Start HANA: "HDB Start" or "sapcontrol -nr -function StartSystem"
Cause

Prerequisites: You have HANA 1.0 running with MDC mode and database isolation level set to high.

The error message in the CRASH_STACK indicates that there are wrong permissions in the file /usr/sap//HDB00/exe/mdc/hdbmdcdispatcher.

You can check it by running the following command:

ls - ltrah /usr/sap//HDB00/exe/mdc/hdbmdcdispatcher

The default authorization and owner are below:

-r-sr-x--- 1 root sapsys 8.7M May 14 19:38 hdbmdcdispatcher
 


Resolution

For root cause purposes, you have to check with your OS team who/what changed the ownership and authorizations of the file.

To fix this, you need to run the following commands as root:

    "chown root:sapsys /usr/sap//HDB00/exe/mdc/hdbmdcdispatcher";
    "chmod 04550 /usr/sap//HDB00/exe/mdc/hdbmdcdispatcher";


You can now start the SAP system.





















More details 2792608


EmoticonEmoticon

Note: only a member of this blog may post a comment.