signal 6 Issue on Statistics Server in HANA

Scenario:
=======

We could see statisticsserver & indexserver crash dumps are generating on the system ABC.
The services are crashing with signal 6 issue for every 15-20m interval.

Symptom:
========

Before applying this note, please ensure, that you do not use the Embedded Statistics Server.
In case of problems with the Embedded Statistics Server, please look at 2006652 - SAP HANA Statistics Server - Switch to Embedded Statistics Service fails

Reason and Prerequisites
===================

In order to solve certain issues related to the Statisticsserver of the SAP HANA database it might be necessary to reinitialize the Statisticsserver.

hdbstatisticsserver service re-initialization--

Solution:
=======

Carry out the following steps to reinitialize SAP HANA Statisticsserver:
Caution: It can be a risk to make changes to the topology. Therefore, carefully check the host and the volume ID.

1. Stop all the applications that use the database. This is required because a new data backup has to be created after you reinitialize SAP HANA Statisticsserver. A log replay over the time of the service re-initialization is not supported.

2. Determine all the hosts on which SAP HANA Statisticsserver services are active:

        select host from m_services where service_name = 'statisticsserver' 

3. Determine the volume ID of the SAP HANA Statisticsserver services:

       select VOLUME_ID from m_volumes where service_name = 'statisticsserver' 

4. Stop the SAP HANA Statisticsserver services. To do this, carry out the following command for every with an SAP HANA Statisticsserver service:

ALTER SYSTEM ALTER CONFIGURATION ('daemon.ini', 'host', '') UNSET ('statisticsserver','instances') WITH RECONFIGURE 

5. Remove the SAP HANA Statisticsserver service entry from the topology. To do this, carry out the following command for every with an SAP HANA Statisticsserver service:

ALTER SYSTEM ALTER CONFIGURATION ('topology.ini', 'system') UNSET ('/host/', 'statisticsserver') WITH RECONFIGURE 

6. Remove the volumes from the topology. To do this, carry out the following command for every of an SAP HANA Statisticsserver service:

ALTER SYSTEM ALTER CONFIGURATION ('topology.ini', 'system') UNSET ('/volumes', '') WITH RECONFIGURE

7. Activate SAP HANA Statisticsserver. When you do this, specify the host on which you want SAP HANA Statisticsserver to run (determined in step 2):

ALTER SYSTEM ALTER CONFIGURATION ('daemon.ini', 'host', '') SET ('statisticsserver','instances') = '1' WITH RECONFIGURE

SAP HANA Statisticsserver is started automatically, and the volumes of the service are recreated automatically.

8. Create a new data backup.

9. Start the applications that use the database.

Note: By reinitializing the Statisticsserver you will lose all collected statistics.