1771873 - Index server crashes with traces displaying message 'Too many open files'

1. Indexserver crashes during standard db operations like backup/recovery/query and you can see entries on the indexserver alert diagnosis file like the one below: 

"[...] Cannot open file <File name>, rc=24: Too many open files [...]"

2. You face connections issue on HANA Studio. Statisticsserver traces shows entries such as the one below:

"SQLDBC error -10709: Connection failed (RTE:[89006] System call 'recv' failed, rc=104:Connection reset by peer)"

While statistics server displays a connection fail, the indexserver diagnosis files displays the real root cause of the issue, which would contain lines like the one below:

"[...]TcpListener failed to open channel: communication error: (part:-1) cannot open a new connection (Too many open files) max fd [...]"

3. The indexserver trace initialization section shows that the maximum amount of opened files is set to 1024 (MaxOpenFiles: 1024). Here's an example: 

"[...]
2012-10-02 08:34:45.164815 i Basis        TraceStream.cpp(00397) : ==== Starting hdbindexserver, version 1.00.36.366896 (NewDB100_REL)
2012-10-02 08:34:45.165153 i Basis        TraceStream.cpp(00399) : MaxOpenFiles: 1024
[...]"

4. Running the SQL below, results in VALUE = 1024: 

SELECT VALUE FROM SYS.M_HOST_INFORMATION WHERE KEY = 'os_rlimit_nofile' 

SAP Hana Database 1.0 SP06 or lower.

connection fail; HANA studio; sapstartsrv; correct limits; sapinit script; , KBA , HAN-DB , SAP HANA Database , Problem