Hi, Of course you could increase the maximum number of open files, but that would only be a workaround.
> Did anybody faced the issue before? This usually happens if you keep a transaction open for a very long time. You can check what connections are open using: SELECT * FROM INFORMATION_SCHEMA.SESSIONS By the way, you are using a very old version of H2. What prevents you from upgrading to a newer version? Regards, Thomas On Fri, Aug 31, 2012 at 4:33 PM, Radha <[email protected]> wrote: > Hi Experts > > We are using h2 database 1.1.114 in our product. One of our customer was > facing the following issue. > > org.h2.jdbc.JdbcSQLException: IO Exception: java.io.FileNotFoundException: > xxxxxxxx_session.18683.log.db (Too many open > > files); name: xxxxxxx.18683.log.db mode: > > In the customer setup, many such log files keep opening...and finally we > are getting the above issue i.e too many open file names. > > Any idea what could be root cause of such issue? Did anybody faced the > issue before? > > The following exception we got. > > java.io.FileNotFoundException: xxxxx_session.18683.log.db (Too many open > files) > at java.io.RandomAccessFile.open(Native Method) > at java.io.RandomAccessFile.<init>(Unknown Source) > at java.io.RandomAccessFile.<init>(Unknown Source) > at org.h2.store.fs.FileObjectDisk.<init>(FileObjectDisk.java:23) > at > org.h2.store.fs.FileSystemDisk.openFileObject(FileSystemDisk.java:390) > at org.h2.store.FileStore.<init>(FileStore.java:84) > ... 20 more > > The main problem is all of sudden files are increasing and we could see > customer h2 database file size was 22 GB. Please help us finding the root > cause of the issue. > > After doing research google, i came to know that such issues will come if > the transaction is very long. Is that correct? Do we have any direct way to > reproduce the issue? > > Thanks > Radhakrishna. > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/h2-database/-/_VpehQZ_wX0J. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
