SAP Knowledge Base Article - Preview

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 (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: 





SAP Hana Database 1.0 SP06 or lower.


SAP HANA 1.0, platform edition


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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.