search

kir-dev / vir-auth

A customized JDBC auth module for OpenAM (based on the original JDBC auth module)
MIT License
1 stars 1 forks source link

Db pool leak #3

Closed vbalazs closed 10 years ago

vbalazs commented 10 years ago

Kb naponta lehal emiatt a login, ki kell nyomozni mi ez es valami megoldast talalni ra.

vbalazs commented 10 years ago

reszlet az Authentication openam logbol

Exception : 
com.sun.identity.authentication.spi.AuthLoginException: OAuth.getUser: Problem when trying to get the Attribute Mapper
Cannot get a connection, pool error Timeout waiting for idle object
        at com.sun.identity.authentication.spi.AMLoginModule.wrapProcess(AMLoginModule.java:1008)
        at com.sun.identity.authentication.spi.AMLoginModule.login(AMLoginModule.java:1170)
        at sun.reflect.GeneratedMethodAccessor88.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at com.sun.identity.authentication.jaas.LoginContext.invoke(LoginContext.java:210)
        at com.sun.identity.authentication.jaas.LoginContext.login(LoginContext.java:123)
        at com.sun.identity.authentication.service.AMLoginContext.runLogin(AMLoginContext.java:557)
        at com.sun.identity.authentication.server.AuthContextLocal.submitRequirements(AuthContextLocal.java:699)
        at com.sun.identity.authentication.UI.LoginViewBean.processLoginDisplay(LoginViewBean.java:1400)
        at com.sun.identity.authentication.UI.LoginViewBean.processLogin(LoginViewBean.java:879)
        at com.sun.identity.authentication.UI.LoginViewBean.forwardTo(LoginViewBean.java:541)
        at com.iplanet.jato.ApplicationServletBase.dispatchRequest(ApplicationServletBase.java:981)
        at com.iplanet.jato.ApplicationServletBase.processRequest(ApplicationServletBase.java:615)
        at com.iplanet.jato.ApplicationServletBase.doPost(ApplicationServletBase.java:473)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.forgerock.openam.validation.ResponseValidationFilter.doFilter(ResponseValidationFilter.java:44)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.forgerock.openam.xui.XUIFilter.doFilter(XUIFilter.java:113)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at com.sun.identity.setup.AMSetupFilter.doFilter(AMSetupFilter.java:100)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
        at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.sun.identity.authentication.spi.AuthLoginException: OAuth.getUser: Problem when trying to get the Attribute Mapper
Cannot get a connection, pool error Timeout waiting for idle object
        at org.forgerock.openam.authentication.modules.oauth2.OAuth.getAttributesMap(OAuth.java:407)
        at org.forgerock.openam.authentication.modules.oauth2.OAuth.process(OAuth.java:224)
        at com.sun.identity.authentication.spi.AMLoginModule.wrapProcess(AMLoginModule.java:1000)
        ... 44 more
Caused by: com.sun.identity.authentication.spi.AuthLoginException: Cannot get a connection, pool error Timeout waiting for idle object
        at hu.sch.vir.oauth.exts.VirAttributeMapper.getAttributesFromDb(VirAttributeMapper.java:145)
        at hu.sch.vir.oauth.exts.VirAttributeMapper.getAttributes(VirAttributeMapper.java:35)
        at org.forgerock.openam.authentication.modules.oauth2.OAuth.getAttributesMap(OAuth.java:404)
        ... 46 more
Caused by: com.sun.identity.authentication.spi.AuthLoginException: Cannot get a connection, pool error Timeout waiting for idle object
        at hu.sch.vir.auth.common.VirDb.loadUser(VirDb.java:121)
        at hu.sch.vir.auth.common.VirDb.<init>(VirDb.java:41)
        at hu.sch.vir.oauth.exts.VirAttributeMapper.getAttributesFromDb(VirAttributeMapper.java:110)
        ... 48 more
Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object
        at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114)
        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
        at hu.sch.vir.auth.common.VirDb.getJndiConnection(VirDb.java:77)
        at hu.sch.vir.auth.common.VirDb.getConn(VirDb.java:65)
        at hu.sch.vir.auth.common.VirDb.loadUser(VirDb.java:93)
        ... 50 more
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
        at org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1171)
        at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
        ... 54 more

amAuth:08/16/2014 04:59:50:725 PM CEST: Thread[ajp-bio-58009-exec-362,5,main]
Came to before if Failed loop
amAuthConfig:08/16/2014 04:59:50:725 PM CEST: Thread[ajp-bio-58009-exec-362,5,main]
retrieving configuration: SERVICE=authsch;ORGANIZATION=o=stud,ou=services,dc=opensso,dc=java,dc=net;CLIENT=genericHTML
amAuthConfig:08/16/2014 04:59:50:725 PM CEST: Thread[ajp-bio-58009-exec-362,5,main]
cached configs {ORGANIZATION=o=stud,ou=services,dc=opensso,dc=java,dc=net;CLIENT=html=[Ljavax.security.auth.login.AppConfigurationEntry;@462c24b7, MODULE=Application;ORGANIZATION=dc=opensso,dc=java,dc=net;CLIENT=genericHTML=[Ljavax.security.auth.login.AppConfigurationEntry;@7c1e8e5e, ORGANIZATION=dc=opensso,dc=java,dc=net;CLIENT=html=[Ljavax.security.auth.login.AppConfigurationEntry;@3a14fcfb, SERVICE=authsch;ORGANIZATION=o=stud,ou=services,dc=opensso,dc=java,dc=net;CLIENT=genericHTML=[Ljavax.security.auth.login.AppConfigurationEntry;@37ece087}

a postgres logban ilyenek is latszodnak: unexpected EOF on client connection Gyanus, hogy az ilyen lezaratlan kapcsolatok okozzak a pool elfogyasat

vbalazs commented 10 years ago

ezt csak felirom ide: http://commons.apache.org/proper/commons-dbcp/configuration.html atkonfiguracioval persze nem oldjuk meg a problemat csak legfeljebb kesobb hal meg...