I created a new database that contains a single IMAGE table in PUBLIC
schema.
CREATE TABLE PUBLIC.IMAGE (
IMAGE_ID IDENTITY PRIMARY KEY,
BYTES BLOB
);
Example URL
jdbc:h2:tcp://localhost:10000/TEST;user=test;password=user
You can download the database from Rapidshare
http://rapidshare.com/files/433495007/TestDb.tar.gz
(The size is 274MB so hopefully you are a RapidPro user :)
It contains 3157 images and the size of them all is 286 274 562 bytes =
273MB
I ran your test case against this table (obviously the server startup and
table creation / population has to be removed)
And I get exceptions like
java.lang.NegativeArraySizeException
at
org.h2.util.Utils.newBytes(Utils.java:355)
at
org.h2.store.Data.expand(Data.java:1079)
at
org.h2.store.Data.checkCapacity(Data.java:1074)
at
org.h2.store.FileStoreInputStream.fillBuffer(FileStoreInputStream.java:100)
at
org.h2.store.FileStoreInputStream.readBlock(FileStoreInputStream.java:73)
at
org.h2.store.FileStoreInputStream.read(FileStoreInputStream.java:61)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)
Exception in thread "Thread-6" java.lang.OutOfMemoryError: Requested
memory: 987040432
at org.h2.util.Utils.newBytes(Utils.java:357)
at org.h2.store.Data.expand(Data.java:1079)
at org.h2.store.Data.checkCapacity(Data.java:1074)
at
org.h2.store.FileStoreInputStream.fillBuffer(FileStoreInputStream.java:100)
at
org.h2.store.FileStoreInputStream.readBlock(FileStoreInputStream.java:73)
at
org.h2.store.FileStoreInputStream.read(FileStoreInputStream.java:61)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)
Here one can only wonder why would H2 request 941 megs of memory.
Hope this helps.
- Rami
Thomas Mueller wrote:
Hi,
For multiple reasons, your test case is not reproducible:
- the create table statements are missing - the data is missing
(insert statements) - the test is not self-contained - I can't
reproduce the problem
My test case is:
http://h2database.com/p.html#7051c1db4cfd824bb7c45e29c4d15ac6
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.
