Hi, I don't see anything strange. It could still be a Javascript performance problem.
Would it be possible for you to change the H2 source code a little bit, compile it yourself, and run a test? The change I have in mind is change the limits in the class DbSchema. Change MAX_TABLES_LIST_INDEXES to 10, MAX_TABLES_LIST_COLUMNS and MAX_PROCEDURES_LIST_COLUMNS to 50. This would reduce the amount of Javascript that is generated and executed. Regards, Thomas On Tuesday, October 7, 2014, Tony Nelson <hhub...@gmail.com> wrote: > Sorry I didn't reply sooner. Rather than dump all that text here, I put > them in pastebin. > > stack: http://pastebin.com/pQEjanPL > histo: http://pastebin.com/4RQpx0L5 > > Thanks for any insight you can offer. > > Tony > > On Saturday, October 4, 2014 5:06:47 AM UTC-4, Thomas Mueller wrote: >> >> Hi, >> >> Could you get a few full thread dumps while the problem occurs? To get >> them, use "jps -l" (to get the process id), and then "jstack -l <pid>". >> Also, could you get a heap histogram ("jmap -histo <pid>")? >> >> Regards, >> Thomas >> >> On Sat, Oct 4, 2014 at 10:58 AM, Noel Grandin <noelg...@gmail.com> wrote: >> >>> Can you measure the time (in seconds)? It sounds like some kind of >>> timeout. >>> Knowing the rough time gap might give us a clue as to what kind of >>> timeout that is. >>> >>> Otherwise the only thing I can think of is to fire the console up from >>> inside an IDE with a debugger (eg Eclipse) and trace the sequence of >>> operations. >>> The Console class would be the starting point, obviously. >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "H2 Database" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to h2-database...@googlegroups.com. >>> To post to this group, send email to h2-da...@googlegroups.com. >>> Visit this group at http://groups.google.com/group/h2-database. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to h2-database+unsubscr...@googlegroups.com > <javascript:_e(%7B%7D,'cvml','h2-database%2bunsubscr...@googlegroups.com');> > . > To post to this group, send email to h2-database@googlegroups.com > <javascript:_e(%7B%7D,'cvml','h2-database@googlegroups.com');>. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
