Consultor Eletrônico



Kbase P6355: Database crashes with errno=23 after adding extents
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   14/07/2010
Status: Verified

SYMPTOM(s):

Database crashes with multiple errors

Cannot find or open file <filename>. Errno=23. (43)

Cannot find or open file /wrk/dbname.b2, errno = 23. (43)

Cannot find or open file /wrk/dbname.b2, errno = 0. (43)

Unable to Open File: <filename>. Ernno=23 (98)

SYSTEM ERROR: Unable to get file descriptor for <filename> (5338)

Could not open <filename> Error=23 (5311)

Increased maxfile (softlimit) and maxfile_lim (hardlimit)

FACT(s) (Environment):

HP-UX

CHANGE:

Several new database extents added. For example, multiple single-volume databases have just been converted to multi-extend multi-volume databases

CAUSE:

System file handles are inadequate to handle the increase in extents

FIX:

Increase the number assigned to the nfile. The maxfile and maxfile_lim only increase the number of files that can be opened per process. nfile will increase the number of files for the entire system
In recent versions of HP-UX you can set nfile to 0, which then allocates number of file handles automatically.