I have been following now the open file situation with command
lsof -c java | grep temp\.db | wc -l
that gives me the amount of open temporary lob files that the client
java process keeps open
And it seems that they both increase and decrease so I quess there is no
problem.
The problem was too low open file limits on the machine (has happened to
me before.. :(
- rami
Rami wrote:
After updating to the latest version the previous errors disappeared.
But a new one appeared.
I started getting the following error: java.io.FileNotFoundException:
/opt/apache-tomcat-6.0.24/temp/h2.temp.76099c36b7051284.134011.temp.db
(Too many open files) at java.io.RandomAccessFile.open(Native Method)
at java.io.RandomAccessFile.<init>(RandomAccessFile.java:212) at
java.io.RandomAccessFile.<init>(RandomAccessFile.java:98) at
org.h2.store.fs.FileObjectDisk.<init>(FileObjectDisk.java:25) at
org.h2.store.fs.FileSystemDisk.openFileObject(FileSystemDisk.java:444)
at org.h2.store.FileStore.<init>(FileStore.java:88) at
org.h2.store.FileStore.open(FileStore.java:141) at
org.h2.store.FileStore.open(FileStore.java:109) at
org.h2.engine.SessionRemote.openFile(SessionRemote.java:617)
at org.h2.value.ValueLobDb.initTemp(ValueLobDb.java:514) at
org.h2.value.ValueLobDb.createTempFromStream(ValueLobDb.java:476) at
org.h2.value.ValueLobDb.createTempBlob(ValueLobDb.java:441) at
org.h2.store.LobStorage.createBlob(LobStorage.java:565) at
org.h2.value.Transfer.readValue(Transfer.java:513) at
org.h2.result.ResultRemote.fetchRows(ResultRemote.java:216)
According to my understanding the client is reading a Lob and trying
to cache it on the client side. It can not open the file because OS
tells that the limit of open files has been exceeded.
So my quess is that somehow these temp files are not closed properly.
And they stay open.
- rami
Thomas Mueller wrote:
> Hi,
>
>
>> I updated h2 and there were A LOT of changes.
>>
>
> Well, there always are.
>
>
>> When I built it, it turned out that the jar was 1.3.147 instead
>> of 1.2.147 as before. So I suppose you changed the head of trunk
>> from 1.2 to 1.3?
>>
>
> This is a small change: Constants.java, change VERSION_MINOR to 2.
> Other settings depend on it, so this small change will have a big
> effect.
>
> Regards, Thomas
>
>
--
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.
