Hey Guys, I apologize for not providing with sufficient details, so here they go
Stack trace as what the job is currently doing after the 2147483647 rows get inserted, java.lang.Thread.State: RUNNABLE at org.h2.util.CacheLRU.find(CacheLRU.java:281) at org.h2.util.CacheLRU.get(CacheLRU.java:287) at org.h2.store.PageStore.getPage(PageStore.java:725) - locked <0x0000000600010308> (a org.h2.store.PageStore) at org.h2.index.PageDataIndex.getPage(PageDataIndex.java:226) at org.h2.index.PageDataNode.addRowTry(PageDataNode.java:128) at org.h2.index.PageDataNode.addRowTry(PageDataNode.java:129) at org.h2.index.PageDataNode.addRowTry(PageDataNode.java:129) at org.h2.index.PageDataNode.addRowTry(PageDataNode.java:129) at org.h2.index.PageDataIndex.addTry(PageDataIndex.java:167) at org.h2.index.PageDataIndex.add(PageDataIndex.java:130) at org.h2.table.RegularTable.addRow(RegularTable.java:121) at org.h2.command.dml.Insert.addRow(Insert.java:162) at org.h2.command.dml.Select.queryFlat(Select.java:524) at org.h2.command.dml.Select.queryWithoutCache(Select.java:618) at org.h2.command.dml.Query.query(Query.java:298) at org.h2.command.dml.Insert.insertRows(Insert.java:132) at org.h2.command.dml.Insert.update(Insert.java:84) at org.h2.command.CommandContainer.update(CommandContainer.java:73) at org.h2.command.Command.executeUpdate(Command.java:226) - locked <0x000000060000ef78> (a org.h2.engine.Database) at org.h2.jdbc.JdbcStatement.executeUpdateInternal(JdbcStatement.java:125) - locked <0x000000060003d450> (a org.h2.engine.Session) at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:110) To steve's question yeah the job doesn't respond once i hit that row count, but while checking cpu activity it shows that the job is taking a 100% of the CPU, so really cant tell what h2 is trying to do apart from allocating cache_size of some sort. Thanks a lot Noel for creating and running a test, i am also going to run that job on my side with more memory. Thanks a lot guys will keep you posted on the progress. regards Harish On Wed, Apr 4, 2012 at 8:53 AM, Noel Grandin <[email protected]> wrote: > I've created a test-case for this, but I'm not very motivated to chase it > down, since it'll take 9 hours for a single run. > Sorry :-( > > > -- > 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 h2-database+unsubscribe@** > googlegroups.com <h2-database%[email protected]>. > For more options, visit this group at http://groups.google.com/** > group/h2-database?hl=en <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.
