The indexserver of the SAP HANA database crashes in the method PersistenceManagerImpl::writeRestartData.
In normal case, the rollback transaction table (rtt) contains only a small set of in-doubt rollbacked transactions..
Currently, long log recovery spanning many crashes/restarts of individual services or many rolled back distributed transactions can cause RTT overflow, since RTT is limited to about 500K entries. This may lead to an indexserver crash followed by a not starting indexserver. This is related to Revision 26 or previous.
To be able to restart the indexserver you will need to define the following two parameters 'default_stack_size_kb' and 'worker_stack_size_kb =4096' in the indexserver.ini file:
Those two parameters needs to be defined in the indexserver.ini file
Please copy the following 3 lines in the indexserver.ini file and restart the databse:
default_stack_size_kb = 4096
worker_stack_size_kb = 4096
After the restart of the database, please delete those two parameters by using the following statements:
ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'SYSTEM') UNSET ('threads', 'default_stack_size_kb') WITH RECONFIGURE;
ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'SYSTEM') UNSET ('threads', 'worker_stack_size_kb') WITH RECONFIGURE;
This bug will be fixed with Revision 27.
SAP Project manager openings@ Delhi/ Mumbai
Exp :10 - 26 years | City : Delhi
ABAP HANA Consultant Job | 5 - 8 yrs | Bengaluru | SAP India
Exp :3 - 5 years | City : Bangalore
Opening for Sr. SAP Basis Consultant @ Bangalore (Immediate
Exp :6 - 15 years | City : Bangalore
SAP Hana Cloud Integeration | 6 - 9 Years | Pune | Atos
Exp :6 - 9 years | City : Pune
SAP HANA (FOR BI) (SOLUTION ARCHITECT) | 11 - 13 Years | Ban
Exp :11 - 13 years | City : Bangalore