Re: Too many open files?

Unfortunately it's a bug with the JVM implementation, not in Mckoi.  Are 
your installations on win32 or linux?  Have you tested with other JVMs? 
  You could test if the online backup reproduces this problem with your 
JVM/OS by repeating the backup function and see if the error occurs.

I do not suggest you COMPACT tables if it is not necessary to do so. 
COMPACT should only be used if you insert and delete data from a table 
and then you need the file space reclaimed to the file system.  We have 
installed several installations of Mckoi that have never used the 
COMPACT function.

Toby.

M. A. Sridhar wrote:
> 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 <[email protected]> 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 [email protected]