Application is hosted on JBoss server and uses Hibernate caching.
i got very strange error and could not launch the application after that, I had
to restart the server finally. It was related to prepared statement cache. The
error log was
[22-01-2008 13:08:04.150] [67934313] [STDOUT] [INFO ] [TP-Processor9]
22-Jan-2008 13:08.04 ERROR {NDC=} java.lang.IllegalStateException:
Attempt to put a new cache entry on a full cache
java.lang.IllegalStateException: Attempt to put a new cache entry on a full
cache
at
org.jboss.util.LRUCachePolicy$LRUList.promote(LRUCachePolicy.java:304)
at org.jboss.util.LRUCachePolicy.get(LRUCachePolicy.java:128)
at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:295)
at
org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:172)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:442)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:368)
at
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
at org.hibernate.loader.Loader.doQuery(Loader.java:661)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1533)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
at
org.springframework.orm.hibernate3.HibernateTemplate$35.doInHibernate(HibernateTemplate.java:979)
at
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:367)
at
org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:969)
at
org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:962)
prepared statement cahce size is configured to be 25 in datasource
configurations, is increasing the size solution of this, but as per LRU even
if the cache is full new entry should replace the least recently used entry of
the cache. Please suggest....
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4123387#4123387
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4123387
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
