I found that setting cache size larger is creating the problem. Is it correct?
On Wed, Apr 27, 2011 at 7:45 PM, AI Rumman <[email protected]> wrote: > > I added the error stack. > > at > org.h2.message.DbException.getJdbcSQLException(DbException.java:327) > at org.h2.message.DbException.get(DbException.java:156) > at org.h2.message.DbException.convert(DbException.java:273) > at org.h2.command.Command.executeQuery(Command.java:185) > at org.h2.server.TcpServerThread.process(TcpServerThread.java:278) > at org.h2.server.TcpServerThread.run(TcpServerThread.java:137) > at java.lang.Thread.run(Thread.java:662) > Caused by: java.lang.OutOfMemoryError: GC overhead limit exceeded > at org.h2.value.ValueString.get(ValueString.java:123) > at org.h2.store.Data.readValue(Data.java:757) > at org.h2.index.PageDataLeaf.readRow(PageDataLeaf.java:598) > at org.h2.index.PageDataLeaf.getRowAt(PageDataLeaf.java:329) > at org.h2.index.PageDataCursor.nextRow(PageDataCursor.java:97) > at org.h2.index.PageDataCursor.next(PageDataCursor.java:49) > at org.h2.index.IndexCursor.next(IndexCursor.java:235) > at org.h2.table.TableFilter.next(TableFilter.java:352) > at org.h2.command.dml.Select.queryFlat(Select.java:512) > at org.h2.command.dml.Select.queryWithoutCache(Select.java:617) > at org.h2.command.dml.Query.query(Query.java:290) > at org.h2.command.dml.Query.query(Query.java:260) > at org.h2.command.dml.Query.query(Query.java:37) > at org.h2.command.CommandContainer.query(CommandContainer.java:78) > at org.h2.command.Command.executeQuery(Command.java:181) > ... 3 more > > > > On Wed, Apr 27, 2011 at 7:24 PM, AI Rumman <[email protected]> wrote: > >> I am using 4 GB cache size with 16 k page size and more than 10 millon of >> rows in a table. >> >> >> On Wed, Apr 27, 2011 at 7:23 PM, AI Rumman <[email protected]> wrote: >> >>> I am getting the following error: >>> Exception in thread "H2 Console Server (http://192.168.12.221:8082)" >>> java.lang.OutOfMemoryError: GC overhead limit exceeded >>> >>> >>> On Wed, Apr 27, 2011 at 4:58 PM, Thotheolh <[email protected]> wrote: >>> >>>> Do you have any data where it can be replica to discover the error ? >>>> Do you have the error logs too ? >>>> >>>> -- >>>> 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. >>>> >>>> >>> >> > -- 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.
