Bug #43107 merlin 2.0.4.7138 stack overflow error
Submitted: 23 Feb 2009 12:11 Modified: 22 May 2009 8:23
Reporter: Roger David Nay Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor Severity:S3 (Non-critical)
Version:2.0.4.7138 OS:Any
Assigned to: Darren Oldag CPU Architecture:Any

[23 Feb 2009 12:11] Roger David Nay
Description:
See attached file for stack overflow errors.

How to repeat:
This appears to have been a one off incident.
[23 Feb 2009 12:13] MySQL Verification Team
Stack overflow messages

Attachment: stackoverflow.rtf (application/rtf, text), 77.95 KiB.

[26 Feb 2009 15:20] Simon Mudd
Received 8 more stack dumps today which I have to include as files as they don't fit here. I'll include 1, if you want them all let me know.

I guess this may be related to viewing more graphs over a longer time period (1 week as we don't have more data), but this may be wrong.
[26 Feb 2009 15:24] Simon Mudd
Finally included 3 dumps.

Attachment: dumps.tar.gz (application/x-gzip, text), 12.10 KiB.

[3 Mar 2009 10:28] Simon Mudd
We are still getting stack overflows. It seems mainly related to viewing graphs.

Today we had 7 at around the same time 9:53. They are too large to paste into this comment field. So the problem is not a one off. We also had to restart tomcat to resolve some responsiveness problems.

How do you want me to send these stack traces as copy/pasting from the mail messages that merlin sends is a bit tedious.
[10 Mar 2009 19:42] Darren Oldag
Reproduced in a test case where, if entities are not in hibernate L2 cache, it gets into an infinite loop/recursion trying to load the server graph object(s).
[10 Mar 2009 21:20] Darren Oldag
revision-id: oldag@mysql.com-20090310211644-waq2x0i8zzhr1ul6
parent: mark@mysql.com-20090303204420-3dca795wm19af9zt
committer: Darren L. Oldag <oldag@mysql.com>
branch nick: Trunk
timestamp: Tue 2009-03-10 16:16:44 -0500
message:
  http://bugs.mysql.com/bug.php?id=43107
  
  due to an outstanding hibernate issue,
  http://opensource.atlassian.com/projects/hibernate/browse/EJB-225,
  
  we have to force a lazy relationship inside an embedded composite
  primary key. otherwise, hibernate goes into an infinite recursion
  trying to load one of the relationships.
[10 Mar 2009 23:12] Darren Oldag
patches pushed to both 2.0 maintenance and trunk (current 2.1) trees.
[12 Mar 2009 2:22] Keith Russell
Patch installed in version 2.0.5.7152.
[12 Mar 2009 15:49] Bill Weber
verified fixed in build 2.0.5.7152
[22 May 2009 8:23] Tony Bedford
An entry has been added to the 2.0.5 changelog:

MySQL Enterprise Monitor generated a stack overflow. This was as a result of a bug in Hibernate, which caused Hibernate to enter infinite recursion while trying to load a relationship.