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: 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
About this pageThis 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.