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.
