[Hibernate-JIRA] Created: (HHH-2431) QueryPlanCache grows without bound. Eventually gets OutOfMemoryException
6:59 p.m.
QueryPlanCache grows without bound. Eventually gets OutOfMemoryException
--------------------------------------------------------------------------
Key: HHH-2431
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2431
Project: Hibernate3
Type: Bug
Components: core
Versions: 3.2.2
Environment: all versions, all platforms
Reporter: Eric Goff
Every time you execute a query, and that query does not match any existing queries
in the QueryPlanCache, that query is *always* added to the Query Plan Cache, along with
a lot of various antlr stuff.
There seems to be no way to control it.
Minimally, there should be some sort of heap of query plans where the
least used query plan is ejected when the cache reaches it max size.
The cache size should, of course, be user configurable.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
7:03 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2431) QueryPlanCache grows without bound. Eventually gets OutOfMemoryException
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2431?page=c...
]
Eric Goff commented on HHH-2431:
--------------------------------
Of course, if one was using good database practice, one would be
using parameterized queries and not have this problem.
But an unbounded cache is also not a good POSA practice. :)
QueryPlanCache grows without bound. Eventually gets
OutOfMemoryException
--------------------------------------------------------------------------
Key: HHH-2431
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2431
Project: Hibernate3
Type: Bug
Components: core
Versions: 3.2.2
Environment: all versions, all platforms
Reporter: Eric Goff
Every time you execute a query, and that query does not match any existing queries
in the QueryPlanCache, that query is *always* added to the Query Plan Cache, along with
a lot of various antlr stuff.
There seems to be no way to control it.
Minimally, there should be some sort of heap of query plans where the
least used query plan is ejected when the cache reaches it max size.
The cache size should, of course, be user configurable.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
3:13 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2431) QueryPlanCache grows without bound. Eventually gets OutOfMemoryException
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2431?page=c...
]
Steve Ebersole commented on HHH-2431:
-------------------------------------
Have you looked at the code you are talking about?
QueryPlanCache grows without bound. Eventually gets
OutOfMemoryException
--------------------------------------------------------------------------
Key: HHH-2431
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2431
Project: Hibernate3
Type: Bug
Components: core
Versions: 3.2.2
Environment: all versions, all platforms
Reporter: Eric Goff
Every time you execute a query, and that query does not match any existing queries
in the QueryPlanCache, that query is *always* added to the Query Plan Cache, along with
a lot of various antlr stuff.
There seems to be no way to control it.
Minimally, there should be some sort of heap of query plans where the
least used query plan is ejected when the cache reaches it max size.
The cache size should, of course, be user configurable.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
7:34 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2431) QueryPlanCache grows without bound. Eventually gets OutOfMemoryException
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2431?page=c...
]
Eric Goff commented on HHH-2431:
--------------------------------
Well sorry, I did not look deep enough. Obviously, there is a limit on the cache.
The query plan cache is indeed hogging my heap space, but most likely the queries
themselves are very large.
QueryPlanCache grows without bound. Eventually gets
OutOfMemoryException
--------------------------------------------------------------------------
Key: HHH-2431
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2431
Project: Hibernate3
Type: Bug
Components: core
Versions: 3.2.2
Environment: all versions, all platforms
Reporter: Eric Goff
Every time you execute a query, and that query does not match any existing queries
in the QueryPlanCache, that query is *always* added to the Query Plan Cache, along with
a lot of various antlr stuff.
There seems to be no way to control it.
Minimally, there should be some sort of heap of query plans where the
least used query plan is ejected when the cache reaches it max size.
The cache size should, of course, be user configurable.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
7:36 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2431) QueryPlanCache grows without bound. Eventually gets OutOfMemoryException
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2431?page=c...
]
Eric Goff commented on HHH-2431:
--------------------------------
Please feel free to close this issue.
QueryPlanCache grows without bound. Eventually gets
OutOfMemoryException
--------------------------------------------------------------------------
Key: HHH-2431
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2431
Project: Hibernate3
Type: Bug
Components: core
Versions: 3.2.2
Environment: all versions, all platforms
Reporter: Eric Goff
Every time you execute a query, and that query does not match any existing queries
in the QueryPlanCache, that query is *always* added to the Query Plan Cache, along with
a lot of various antlr stuff.
There seems to be no way to control it.
Minimally, there should be some sort of heap of query plans where the
least used query plan is ejected when the cache reaches it max size.
The cache size should, of course, be user configurable.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
9:20 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2431) QueryPlanCache grows without bound. Eventually gets OutOfMemoryException
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2431?page=c...
]
Steve Ebersole commented on HHH-2431:
-------------------------------------
Well, we have discussed actually making that configurable for quite a long time. However,
noone has ever actually asked for it.
Try building from source with this modified to use a smaller limit. If that fixes your
issue, let me know and I'll look at making it configurable.
QueryPlanCache grows without bound. Eventually gets
OutOfMemoryException
--------------------------------------------------------------------------
Key: HHH-2431
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2431
Project: Hibernate3
Type: Bug
Components: core
Versions: 3.2.2
Environment: all versions, all platforms
Reporter: Eric Goff
Every time you execute a query, and that query does not match any existing queries
in the QueryPlanCache, that query is *always* added to the Query Plan Cache, along with
a lot of various antlr stuff.
There seems to be no way to control it.
Minimally, there should be some sort of heap of query plans where the
least used query plan is ejected when the cache reaches it max size.
The cache size should, of course, be user configurable.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
5:33 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2431) QueryPlanCache grows without bound. Eventually gets OutOfMemoryException
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2431?page=c...
]
Eric Goff commented on HHH-2431:
--------------------------------
I looked at the implementation of SimpleMRUCache, and although it fulfills most
requirements,
it is somewhat lacking.
For instance
case #1: if I issue 128 "get's" for the same key, I will blow out the strong
references
for other keys that are in heavy use.
case #2: If I issue 128 "put's" for unique key's, I will blow out strong
references for other keys
that are in heavy use (replacing them with queries that are used once and only once).
Perhaps a better scheme is to use a low-memory footprint accounting structure that
accounts for the # get's for a particular key. This map could have a much larger
maximum
size than 128 (perhaps 2048).
Then, when it needs to decide which element to eject from the list of strongRef's it
would be the element
that has been accessed the fewest # times.
(strongRef's would now contain only unique entries)
I would be happy to write such a beast (along with junit tests)
Thanx,
Eric
QueryPlanCache grows without bound. Eventually gets
OutOfMemoryException
--------------------------------------------------------------------------
Key: HHH-2431
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2431
Project: Hibernate3
Type: Bug
Components: core
Versions: 3.2.2
Environment: all versions, all platforms
Reporter: Eric Goff
Every time you execute a query, and that query does not match any existing queries
in the QueryPlanCache, that query is *always* added to the Query Plan Cache, along with
a lot of various antlr stuff.
There seems to be no way to control it.
Minimally, there should be some sort of heap of query plans where the
least used query plan is ejected when the cache reaches it max size.
The cache size should, of course, be user configurable.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
5:35 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2431) QueryPlanCache grows without bound. Eventually gets OutOfMemoryException
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2431?page=c...
]
Eric Goff commented on HHH-2431:
--------------------------------
Crap, I just realized I was looking at hibernate 3.1.2, not 3.2.x
ignore last entry please.
QueryPlanCache grows without bound. Eventually gets
OutOfMemoryException
--------------------------------------------------------------------------
Key: HHH-2431
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2431
Project: Hibernate3
Type: Bug
Components: core
Versions: 3.2.2
Environment: all versions, all platforms
Reporter: Eric Goff
Every time you execute a query, and that query does not match any existing queries
in the QueryPlanCache, that query is *always* added to the Query Plan Cache, along with
a lot of various antlr stuff.
There seems to be no way to control it.
Minimally, there should be some sort of heap of query plans where the
least used query plan is ejected when the cache reaches it max size.
The cache size should, of course, be user configurable.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
7:09 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2431) QueryPlanCache grows without bound. Eventually gets OutOfMemoryException
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2431?page=c...
]
Nandhakumar Murugesan commented on HHH-2431:
--------------------------------------------
When I execute a large query using hibernate, there occurs the same memory outofbounds
exceptions and it creats heap dump of 90 mb size for each hit. Can you please resolve this
as soon as possible.
QueryPlanCache grows without bound. Eventually gets
OutOfMemoryException
--------------------------------------------------------------------------
Key: HHH-2431
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2431
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.2.2
Environment: all versions, all platforms
Reporter: Eric Goff
Every time you execute a query, and that query does not match any existing queries
in the QueryPlanCache, that query is *always* added to the Query Plan Cache, along with
a lot of various antlr stuff.
There seems to be no way to control it.
Minimally, there should be some sort of heap of query plans where the
least used query plan is ejected when the cache reaches it max size.
The cache size should, of course, be user configurable.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:10 p.m.
New subject: [Hibernate-JIRA] Closed: (HHH-2431) QueryPlanCache grows without bound. Eventually gets OutOfMemoryException
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2431?page=c...
]
Steve Ebersole closed HHH-2431.
-------------------------------
Resolution: Duplicate
Addressed by HHH-5300
QueryPlanCache grows without bound. Eventually gets
OutOfMemoryException
--------------------------------------------------------------------------
Key: HHH-2431
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2431
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.2.2
Environment: all versions, all platforms
Reporter: Eric Goff
Every time you execute a query, and that query does not match any existing queries
in the QueryPlanCache, that query is *always* added to the Query Plan Cache, along with
a lot of various antlr stuff.
There seems to be no way to control it.
Minimally, there should be some sort of heap of query plans where the
least used query plan is ejected when the cache reaches it max size.
The cache size should, of course, be user configurable.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5070
days inactive
6341
days old
hibernate-issues@lists.jboss.org
9 comments
3 participants
participants (3)
-
Eric Goff (JIRA) -
Nandhakumar Murugesan (JIRA)
-
Steve Ebersole (JIRA)