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.

Reply via email to