Re: Too many open files, again

The backup process requires a lot of files to be open in a short period 
of time.  Mckoi opens and closes a lot of files during normal operation 
also.  About every 512kb of data inserted into the database causes a new 
journal file to be created and later closed and deleted.

May I ask which JVM versions you are using?  You have found that the 
problem happens regardless of JVM after about a week?  Does it happen on 
both Windows and Linux machines?

Would it be possible to run a 'cat /proc/sys/fs/file-nr' every day after 
a backup and send me the output?  This should give an idea if the linux 
file descriptor limit is being exhausted.

Toby.


M. A. Sridhar wrote:
> Hi Toby,
> 
> There does seem to be a problem with too many open files under Mckoi 1.0.2. I
> have tried this on three different JVMs (IBM, BEA JRockit and Sun) on
> different Linux boxes. The problem seems to occur only during the backup
> process using the system_make_backup call -- I have not seen it show up in
> any other circumstance. I have this backup enabled every day, but it only
> seems to happen after a week or so of the application being up and running.
> 
> The stack trace is below. It's the same message I receive on all the
> occasions that it has failed. I would appreciate any ideas. Thanks.
> 
> Sridhar
> 
> % java.io.FileNotFoundException: /home/sfcrm/app/data/mckoiDb/./data/jnl11
> (Too many open files)
>         at java.io.RandomAccessFile.open(Native Method)
>         at java.io.RandomAccessFile.<init>(RandomAccessFile.java(Compiled




---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]