Hello, I sorry for long code pasted.
"vickyk" wrote :
| Check the listInUseConnections() operation in the CachedConnectionManager
Mbean from the jmx-console . This will tell you what connections are not
getting closed from your application .
| All you need is to identify the application part which is leaking the
connection and fix it.
Thanks for your suggestion ;>
In my jmx (listInUseConnections() CachedConnectionManager) thera are that
tracktrace:
| [EMAIL PROTECTED]: STACKTRACE
|
| at
org.jboss.resource.connectionmanager.CachedConnectionManager.registerConnection(CachedConnectionManager.java:333)
|
| at
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:482)
|
| at
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:894)
|
| at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:73)
|
| at
org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:69)
|
| at org.hibernate.jdbc.JDBCContext.userConnection(JDBCContext.java:114)
|
| at org.hibernate.impl.SessionImpl.connection(SessionImpl.java:366)
|
| at
pl.edu.uwm.student.dao.bazowe.BazowyJdbcDAO.utworzCallableStatement(BazowyJdbcDAO.java:40)
|
| at
pl.edu.uwm.student.admi.konfiguracja.dao.NumerAlbumuDAO.pobierzKolejnyNumer(NumerAlbumuDAO.java:45)
|
| at
pl.edu.uwm.student.admi.konfiguracja.ejb.FasadaNumerAlbumuDAOBean.pobierzKolejnyNumer(FasadaNumerAlbumuDAOBean.java:35)
|
| at sun.reflect.GeneratedMethodAccessor450.invoke(Unknown Source)
|
| at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
|
| at java.lang.reflect.Method.invoke(Method.java:585)
|
| at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:109)
|
| at
org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:32)
|
| at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
|
| at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:27)
|
| at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
|
| at
org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:61)
|
| at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
|
| at
org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:39)
|
| at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
|
| at
org.jboss.aspects.security.RoleBasedAuthorizationInterceptor.invoke(RoleBasedAuthorizationInterceptor.java:151)
|
| at
org.jboss.ejb3.security.RoleBasedAuthorizationInterceptor.invoke(RoleBasedAuthorizationInterceptor.java:85)
|
| at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
|
| at
org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:63)
|
| at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
|
| at
org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:32)
|
| at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
|
| at
org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:91)
|
| at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
|
| at
org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:163)
|
| at
org.jboss.ejb3.stateless.StatelessLocalProxy.invoke(StatelessLocalProxy.java:60)
|
| at $Proxy168.pobierzKolejnyNumer(Unknown Source)
|
| at
pl.edu.uwm.student.web.kart.studenci.rejestracja.akcje.RejestracjaStudentaAction.handlerGenerujNrAlbumu(RejestracjaStudentaAction.java:292)
|
| at sun.reflect.GeneratedMethodAccessor433.invoke(Unknown Source)
|
| at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
|
| at java.lang.reflect.Method.invoke(Method.java:585)
|
| at
org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:274)
|
| at
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:194)
|
| at
pl.edu.uwm.student.web.bazowe.akcje.BazowyAction.execute(BazowyAction.java:41)
|
| at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
|
| at
pl.edu.uwm.student.web.bazowe.SystemowyRequestProcessor.processActionPerform(SystemowyRequestProcessor.java:149)
|
| at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
|
| at
pl.edu.uwm.student.web.bazowe.SystemowyRequestProcessor.process(SystemowyRequestProcessor.java:92)
|
| at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
|
| at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
|
| at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
|
| at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
|
| at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
|
| at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
|
| at
pl.edu.uwm.student.web.bazowe.SystemowyFilter.doFilter(SystemowyFilter.java:48)
|
| at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
|
| at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
|
| at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
|
| at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
|
| at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
|
| at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
|
| at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
|
| at
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
|
| at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
|
| at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
|
| at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
|
| at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
|
| at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
|
| at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
|
| at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
|
| at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
|
| at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
|
| at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
|
| at
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
|
| at java.lang.Thread.run(Thread.java:595)
|
| ,
|
Hm, I have checked Code which looks like:
=====================================
| public class NumerAlbumuDAO {
|
| // ...
|
| public NumerAlbumuDAO(EntityManager arg0) {
| super(arg0);
| }
|
| private static final String SQL_KOLEJNY = "{ ? = call
nextval('admi.sq_numer_albumu') }";
|
| /**
| * ...
| */
| public Integer pobierzKolejnyNumer() {
| CallableStatement stmt = utworzCallableStatement(SQL_KOLEJNY);
| Long numer = pobierzLong(stmt, SQL_KOLEJNY);
| return numer.intValue();
| }
|
| protected CallableStatement utworzCallableStatement(String pSql) {
| CallableStatement stmt = null;
| try {
| stmt = pobierzSesje(em).connection().prepareCall(pSql);
| if (log.isDebugEnabled()) log.debug("[NOWY CALLABLE STATEMENT]
" + pSql);
| } catch (Exception e) {
| log.fatal("B??d tworzenia statement",e);
| throw new EWyjatekInfrastruktury(e);
| }
| return stmt;
| }
|
| public Session pobierzSesje(EntityManager em) {
| if (em instanceof HibernateSession) {
| return ((HibernateSession)em).getHibernateSession();
| } else {
| return ((EntityManagerImpl)em).getSession();
| }
| }
|
| protected Long pobierzLong(CallableStatement stmt, String info) {
| try {
| stmt.registerOutParameter(1, Types.BIGINT);
| stmt.execute();
| return (Long) stmt.getLong(1);
| } catch (SQLException e) {
| throw new EWyjatekInfrastruktury(e);
| } finally {
| zamknijStatement(stmt);
| }
| }
|
| protected void zamknijStatement(PreparedStatement pStmt) {
| if (pStmt != null) {
| try {
| pStmt.close();
| } catch (Exception ee) {
| }
| }
| }
|
| }
|
Hm, I use hibernate as entitymanager and ejb3. In rare case like this I use raw
SQL statements.
Errors appears on high load on production server. As results all connections
from pool (400) are in use and this ends with exception "No ManagedConnections
available within configured blocking timeout"
Are you think this code is right ? I will very appreciate for suggestions
--
Kamil
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4079474#4079474
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4079474
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
