[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2431) QueryPlanCache grows without bound. Eventually gets OutOfMemoryException

[Nandhakumar Murugesan (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2431?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=35539#action_35539 ] 

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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira