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 <[email protected]> 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 <[email protected]> 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 [email protected]. >>> To post to this group, send email to [email protected]. >>> 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 [email protected] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
