Re: Too many open files?

[Tobias Downer <toby@xxxxxxxxx>]

I've seen this error message happen on other JVMs when a Mckoi database 
has more tables than there are available file descriptors made available 
by the operating system.  I believe in Java 1.4 there was a JVM bug that 
limited the number of open files to only 400 or so.  This was a win32 
problem only.

Does your database have a lot of tables, or do you frequently ALTER, 
CREATE/DROP and COMPACT the tables?  It's possible there may be a 
problem where the open file descriptor on a dropped or compacted table 
is not properly being recycled by the JVM so it's only possible to 
perform a limited number of drops/compacts per session.

Toby.

M. A. Sridhar wrote:

> Hello,
> 
> I ran into a rather strange "Too many open files" error with Mckoi today. The
> application has been running without a hitch for a while now, and this showed
> up without warning. This error occurred on a not-very-loaded Linux box
> running the BEA JRockit JVM. Of course, restarting the application resolved
> the problem, but I'm not sure I understand why this happened.
> 
> I'd appreciate any ideas on this. Thanks in advance.
> 
> Sridhar
> 
> 
> IO Error:
> /home/sfcrm/app/data/mckoiDb/./data/456APP_data_model_for_user_type.koi : too
> many open files
> java.lang.RuntimeException: IO Error:
> /home/sfcrm/app/data/mckoiDb/./data/456APP_data_model_for_user_type.koi : too
> many open files
>         at
> com.mckoi.database.V1FileStoreSystem.openStore(Ljava.lang.String;)Lcom.mckoi.store.Store;(V1FileStoreSystem.java:155)
>         at
> com.mckoi.database.V2MasterTableDataSource.open(Ljava.lang.String;)V(V2MasterTableDataSource.java:377)
>         at
> com.mckoi.database.TableDataConglomerate.readVisibleTables()V(TableDataConglomerate.java:383)
>         at
> com.mckoi.database.TableDataConglomerate.open(Ljava.lang.String;)V(TableDataConglomerate.java:1096)
>         at com.mckoi.database.Database.init()V(Database.java:1803)
> 
> 
> =====
> 
> 
> 		
> __________________________________ 
> Do you Yahoo!? 
> Yahoo! Mail - Helps protect you from nasty viruses. 
> http://promotions.yahoo.com/new_mail
> 
> 
> ---------------------------------------------------------------
> Mckoi SQL Database mailing list  http://www.mckoi.com/database/
> To unsubscribe, send a message to mckoidb-unsubscribe@mckoi.com
> 
>