Re: Too many open files?

["M. A. Sridhar" <m_a_sridhar@xxxxxxxxx>]

I do not compact tables, but I do have a backup that runs every night. And it
is true that this happened after several days of uptime.

If this is indeed a bug, can you possibly give me a fix for it? I'm using
1.0.2. I have already started deploying this app with customers, so this is a
rather serious one.

And do you suggest that I should compact tables every night?

Thanks.

--- Tobias Downer <toby@mckoi.com> wrote:

> Do you COMPACT the tables?  Another possibility is that files (and file 
> descriptors) are created when a live backup of the database is made.  If 
> you perform nightly backups then a bug may be causing the file 
> descriptor pool to become exhausted.  One solution would be to shutdown 
> and restart the database after a backup.  Does it happen after a number 
> of days of uptime?
> 
> Toby.
> 
> 
> M. A. Sridhar wrote:
> 
> > Actually, the application does not perform any create/drop/alter
> operations.
> > The schema itself is completely static  when the application is running.
> > 
> > So I am still rather puzzled.
> > 
> > Sridhar
> 
> 
> 
> 
> ---------------------------------------------------------------
> Mckoi SQL Database mailing list  http://www.mckoi.com/database/
> To unsubscribe, send a message to mckoidb-unsubscribe@mckoi.com
> 
> 


=====
M. A. Sridhar


		
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - Find what you need with new enhanced search.
http://info.mail.yahoo.com/mail_250