Re: Too many open files, again

Adrian Merrall <[email protected]> Fri, 20 May 2005 15:01:43 +1200
Newsgroups gmane.comp.db.mckoi
Message-ID <[email protected]>
It may also be worth running a ulimit -n to check the number of open
files allowed for a specific process.  AFAIK /proc/sys/fs/file-nr is
the system wide value for the kernel.

BTW thanks for a such a fantastic product Toby.

Regards,

Adrian
Auckland, NZ

On 5/20/05, Tobias Downer <[email protected]> wrote:
> 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]
> 
>


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