Livecache backup failing with 'Too many open files' (24)

[Former Member]

Hi experts,

I am trying to take a complete backup of one of my livecache database from DBA planning calender. It is failing with below error.

MEDIANAME 'Pre_index_rebuild'
*** SAVE/RESTORE request accepted:
OK 

*** SAVE/RESTORE result:
ERR
-24988,ERR_SQL: SQL error
-903,Host file I/O error
3,Data backup failed
113,Open medium on /sapdb/LCA/sapdata/DISKD0006 for READ failed
1,Open file /sapdb/LCA/sapdata/DISKD0006 failed, open(READ,EXISTING) returned 'Too many open files' (24)

*** SAVE/RESTORE request:
SAVE DATA CANCEL
*** SAVE/RESTORE request accepted:
OK

*** SAVE/RESTORE result:
ERR
-24988,ERR_SQL: SQL error
-104,DBM command impossible at this time

*** DBA Action ends:
Timestamp: 20150829225656   State

I have tried by creating new media template but the result is same. I am not able to find much useful logs in livecache log files. Please suggest.

Thanks

Amar.

[govinda_9999]

I was having exactly same problem for my maxdb backup. Increased the Linux parameter ULIMIT from 1024 to 4096 as per the sap note 2975990 and restarted DB.

[Former Member]

The backups are working fine now. Those are started working fine without any action from our side.

Thanks

Amar.

[JamesZ]

Hi Amar,

Can you check the os limit for warning "Too many open files"? Maybe the open file up to limit, thus this warning occurs.

If it is already checked and without problem, please attach diagpack.tgz after executing command:

dbmcli -d <dbsid> -u control,<password> diag_pack

You will find diagpack.tgz from maxdb run directory.

Best regards,

James