Hi all,
I am working in TCP mode and all the time getting Out of memory
exceptions.
My DB has only 3 tables each with max rows of 500K.
All my queries are limites by MAX_MEMORY_ROWS =1000.
I have two process with R/W access to the database concarrently
1. I am getting the following error (see stack trace bellow) , is
anyone saw similar errors?
2. I fI would like to protect my application from "out of memory"
errors what are the best setting I should use:
i.e:
Cache Settings
SET MAX_MEMORY_ROWS 1000
SET MAX_OPERATION_MEMORY 0
Any ideas?
Stack:
ex: java.lang.Exception = {org.h2.jdbc.jdbcsqlexcept...@54f}
org.h2.jdbc.JdbcSQLException
cause: java.lang.Throwable = null
message: java.lang.String = "Out of memory. [90108-111]"
java.lang.String
java.lang.Object
java.io.Serializable
java.lang.Comparable
java.lang.CharSequence
CASE_INSENSITIVE_ORDER: java.util.Comparator<java.lang.String> =
{java.lang.string$caseinsensitivecompara...@55d}
serialPersistentFields: java.io.ObjectStreamField[] =
java.io.ObjectStreamField[0]
serialVersionUID: long = -6849794470754667710
count: int = 26
hash: int = 0
offset: int = 0
value: char[] = char[26]
originalMessage: java.lang.String = "Out of memory."
java.lang.String
count: int = 14
hash: int = 37699126
offset: int = 0
value: char[] = char[14]
payload: java.lang.Object = null
sql: java.lang.String = null
stackTrace: java.lang.String = "org.h2.jdbc.JdbcSQLException: Out of
memory. [90108-111]\r\n\tat org.h2.message.Message.getSQLException
(Message.java:107)\r\n\tat org.h2.message.Message.convert(Message.java:
268)\r\n\tat org.h2.engine.Database.openDatabase(Database.java:250)\r\n
\tat org.h2.engine.Database.<init>(Database.java:218)\r\n\tat
org.h2.engine.Engine.openSession(Engine.java:57)\r\n\tat
org.h2.engine.Engine.openSession(Engine.java:139)\r\n\tat
org.h2.engine.Engine.getSession(Engine.java:119)\r\n\tat
org.h2.server.TcpServerThread.run(TcpServerThread.java:120)\r\n\tat
java.lang.Thread.run(Thread.java:619)\r\nCaused by:
java.lang.OutOfMemoryError: Java heap space\r\n\tat
org.h2.util.IntArray.checkCapacity(IntArray.java:74)\r\n\tat
org.h2.util.IntArray.add(IntArray.java:42)\r\n\tat
org.h2.store.DiskFile.setBlockCount(DiskFile.java:167)\r\n\tat
org.h2.store.DiskFile.setUnused(DiskFile.java:679)\r\n\tat
org.h2.store.DiskFile.init(DiskFile.java:416)\r\n\tat
org.h2.engine.Database.open(Database.java:555)\r\n\tat
org.h2.engine.Database.openDatabase(Database.java:223)\r\n\t... 6 more
\r\n"
java.lang.String
count: int = 1013
hash: int = 1268265298
offset: int = 0
value: char[] = char[1013]
detailMessage: java.lang.String = "Out of memory."
next: java.sql.SQLException = null
SQLState: java.lang.String = "90108"
vendorCode: int = 90108
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
