Is the idle timeout in the datasource config set to something reasonable (such as 15 minutes)? If so, jboss should be discarding connections after 15-22 minutes of idleness, and any connection request after that should create an entirely new, fresh connection to your db.
I suggest you check the pool statistics after the expected timeout before attempting the login to make sure that all connections have been closed. If they have, it appears that mysql is not creating new working connections. If they haven't, there is something wrong with the idle connection remover. david jencks On 2003.08.04 04:25 Rafal Kedziorski wrote: > hi, > > we had following problem. We are working with JBoss 3.2.2RC2, MySQL > 4.0.14 > (only with InnoDB tables) and Sun Java 1.4.2 and IBM Java 1.4.1 on Linux. > > Out application will be used only from monday to friday. that means, that > > this application is only running 2,5 days. The first 2-4 logins failed > with > this exceptions: > > exception in server.log: > ------------------------ > 2003-08-04 10:07:47,259 ERROR > [org.jboss.security.auth.spi.DatabaseServerLoginModule] Query failed > java.sql.SQLException: Communication link failure: java.io.IOException > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java(Compiled > Code)) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java(Compiled > Code)) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java(Compiled > Code)) > at com.mysql.jdbc.Connection.execSQL(Connection.java(Compiled > Code)) > at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1538) > at > org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:289) > at > org.jboss.security.auth.spi.DatabaseServerLoginModule.getUsersPassword(DatabaseServerLoginModule.java:100) > at > org.jboss.security.auth.spi.UsernamePasswordLoginModule.login(UsernamePasswordLoginModule.java:143) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled > > Code)) > at java.lang.reflect.Method.invoke(Method.java(Compiled Code)) > at > javax.security.auth.login.LoginContext.invoke(LoginContext.java(Compiled > Code)) > at javax.security.auth.login.LoginContext.access$000(LoginContext.java:150) > at javax.security.auth.login.LoginContext$4.run(LoginContext.java:633) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.login.LoginContext.invokeModule(LoginContext.java:630) > at javax.security.auth.login.LoginContext.login(LoginContext.java:556) > at > org.jboss.security.plugins.JaasSecurityManager.defaultLogin(JaasSecurityManager.java:462) > at > org.jboss.security.plugins.JaasSecurityManager.authenticate(JaasSecurityManager.java:417) > at > org.jboss.security.plugins.JaasSecurityManager.isValid(JaasSecurityManager.java(Compiled > > Code)) > at > org.jboss.security.plugins.JaasSecurityManager.isValid(JaasSecurityManager.java(Compiled > > Code)) > at > org.jboss.ejb.plugins.SecurityInterceptor.checkSecurityAssociation(SecurityInterceptor.java(Compiled > > Code)) > at > org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:81) > at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120) > at > org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93) > at > org.jboss.ejb.StatelessSessionContainer.internalInvokeHome(StatelessSessionContainer.java:310) > at org.jboss.ejb.Container.invoke(Container.java(Compiled Code)) > at > org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:272) > at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110) > at $Proxy52.create(Unknown Source) > at de.polonium.xmlapi.request.access.LoginRequest.run(Unknown > Source) > at > de.polonium.xmlapi.analyzer.RequestQueryAnalyzer.analyzeDocument(Unknown > Source) > at de.polonium.servlets.xmlapi.MmcmsXMLApiServlet.doPost(Unknown > Source) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:360) > at > org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:294) > at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:558) > at org.mortbay.http.HttpContext.handle(HttpContext.java:1714) > at > org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:507) > at org.mortbay.http.HttpContext.handle(HttpContext.java:1664) > at org.mortbay.http.HttpServer.service(HttpServer.java:863) > at org.jboss.jetty.Jetty.service(Jetty.java:460) > at org.mortbay.http.HttpConnection.service(HttpConnection.java:775) > at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:939) > at org.mortbay.http.HttpConnection.handle(HttpConnection.java:792) > at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:201) > at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:289) > at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java(Compiled > Code)) > 2003-08-04 10:07:47,982 > WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] > ResourceException cleaning up > ManagedConnection:org.jboss.resource.JBossResourceException: Could not > cleanup: ; - nested throwable: (java.sql.SQLException: No operations > allowed after connection closed) > 2003-08-04 10:07:48,022 ERROR [org.jboss.ejb.plugins.SecurityInterceptor] > > Authentication exception, principal=mmcms > 2003-08-04 10:07:48,026 ERROR [org.jboss.ejb.plugins.LogInterceptor] > EJBException, causedBy: > java.lang.SecurityException: Authentication exception, principal=mmcms > at > org.jboss.ejb.plugins.SecurityInterceptor.checkSecurityAssociation(SecurityInterceptor.java(Compiled > > Code)) > at > org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:81) > at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120) > at > org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93) > at > org.jboss.ejb.StatelessSessionContainer.internalInvokeHome(StatelessSessionContainer.java:310) > at org.jboss.ejb.Container.invoke(Container.java(Compiled Code)) > at > org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:272) > at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110) > at $Proxy52.create(Unknown Source) > at de.polonium.xmlapi.request.access.LoginRequest.run(Unknown > Source) > at > de.polonium.xmlapi.analyzer.RequestQueryAnalyzer.analyzeDocument(Unknown > Source) > at de.polonium.servlets.xmlapi.MmcmsXMLApiServlet.doPost(Unknown > Source) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:360) > at > org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:294) > at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:558) > at org.mortbay.http.HttpContext.handle(HttpContext.java:1714) > at > org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:507) > at org.mortbay.http.HttpContext.handle(HttpContext.java:1664) > at org.mortbay.http.HttpServer.service(HttpServer.java:863) > at org.jboss.jetty.Jetty.service(Jetty.java:460) > at org.mortbay.http.HttpConnection.service(HttpConnection.java:775) > at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:939) > at org.mortbay.http.HttpConnection.handle(HttpConnection.java:792) > at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:201) > at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:289) > at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java(Compiled > Code)) > 2003-08-04 10:07:48,195 WARN [org.jboss.jbossweb] WARNING: Exception for > > /mmcmsxml > javax.ejb.EJBException: checkSecurityAssociation; CausedByException is: > Authentication exception, principal=mmcms > at > org.jboss.ejb.plugins.SecurityInterceptor.checkSecurityAssociation(SecurityInterceptor.java(Compiled > > Code)) > at > org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:81) > at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120) > at > org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93) > at > org.jboss.ejb.StatelessSessionContainer.internalInvokeHome(StatelessSessionContainer.java:310) > at org.jboss.ejb.Container.invoke(Container.java(Compiled Code)) > at > org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:272) > at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110) > at $Proxy52.create(Unknown Source) > at de.polonium.xmlapi.request.access.LoginRequest.run(Unknown > Source) > at > de.polonium.xmlapi.analyzer.RequestQueryAnalyzer.analyzeDocument(Unknown > Source) > at de.polonium.servlets.xmlapi.MmcmsXMLApiServlet.doPost(Unknown > Source) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:360) > at > org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:294) > at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:558) > at org.mortbay.http.HttpContext.handle(HttpContext.java:1714) > at > org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:507) > at org.mortbay.http.HttpContext.handle(HttpContext.java:1664) > at org.mortbay.http.HttpServer.service(HttpServer.java:863) > at org.jboss.jetty.Jetty.service(Jetty.java:460) > at org.mortbay.http.HttpConnection.service(HttpConnection.java:775) > at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:939) > at org.mortbay.http.HttpConnection.handle(HttpConnection.java:792) > at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:201) > at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:289) > at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java(Compiled > Code)) > java.lang.SecurityException: Authentication exception, principal=mmcms > at > org.jboss.ejb.plugins.SecurityInterceptor.checkSecurityAssociation(SecurityInterceptor.java(Compiled > > Code)) > at > org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:81) > at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120) > at > org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93) > at > org.jboss.ejb.StatelessSessionContainer.internalInvokeHome(StatelessSessionContainer.java:310) > at org.jboss.ejb.Container.invoke(Container.java(Compiled Code)) > at > org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:272) > at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110) > at $Proxy52.create(Unknown Source) > at de.polonium.xmlapi.request.access.LoginRequest.run(Unknown > Source) > at > de.polonium.xmlapi.analyzer.RequestQueryAnalyzer.analyzeDocument(Unknown > Source) > at de.polonium.servlets.xmlapi.MmcmsXMLApiServlet.doPost(Unknown > Source) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:360) > at > org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:294) > at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:558) > at org.mortbay.http.HttpContext.handle(HttpContext.java:1714) > at > org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:507) > at org.mortbay.http.HttpContext.handle(HttpContext.java:1664) > at org.mortbay.http.HttpServer.service(HttpServer.java:863) > at org.jboss.jetty.Jetty.service(Jetty.java:460) > at org.mortbay.http.HttpConnection.service(HttpConnection.java:775) > at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:939) > at org.mortbay.http.HttpConnection.handle(HttpConnection.java:792) > at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:201) > at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:289) > at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java(Compiled > Code)) > > > exception in our log file: > -------------------------- > > 2003-08-04 10:07:48,226 FATAL [de.polonium.servlets.ErrorServlet] doGet() > error request from 10.0.60.21 (10.0.60.21) > status_code: 500 > uri: /mmcmsxml > exception: > javax.ejb.EJBException: checkSecurityAssociation; CausedByException is: > Authentication exception, principal=mmcms > at > org.jboss.ejb.plugins.SecurityInterceptor.checkSecurityAssociation(SecurityInterceptor.java(Compiled > > Code)) > at > org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:81) > at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120) > at > org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93) > at > org.jboss.ejb.StatelessSessionContainer.internalInvokeHome(StatelessSessionContainer.java:310) > at org.jboss.ejb.Container.invoke(Container.java(Compiled Code)) > at > org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:272) > at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110) > at $Proxy52.create(Unknown Source) > at de.polonium.xmlapi.request.access.LoginRequest.run(Unknown > Source) > at > de.polonium.xmlapi.analyzer.RequestQueryAnalyzer.analyzeDocument(Unknown > Source) > at de.polonium.servlets.xmlapi.MmcmsXMLApiServlet.doPost(Unknown > Source) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:360) > at > org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:294) > at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:558) > at org.mortbay.http.HttpContext.handle(HttpContext.java:1714) > at > org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:507) > at org.mortbay.http.HttpContext.handle(HttpContext.java:1664) > at org.mortbay.http.HttpServer.service(HttpServer.java:863) > at org.jboss.jetty.Jetty.service(Jetty.java:460) > at org.mortbay.http.HttpConnection.service(HttpConnection.java:775) > at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:939) > at org.mortbay.http.HttpConnection.handle(HttpConnection.java:792) > at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:201) > at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:289) > at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java(Compiled > Code)) > java.lang.SecurityException: Authentication exception, principal=mmcms > at > org.jboss.ejb.plugins.SecurityInterceptor.checkSecurityAssociation(SecurityInterceptor.java(Compiled > > Code)) > at > org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:81) > at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120) > at > org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93) > at > org.jboss.ejb.StatelessSessionContainer.internalInvokeHome(StatelessSessionContainer.java:310) > at org.jboss.ejb.Container.invoke(Container.java(Compiled Code)) > at > org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:272) > at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110) > at $Proxy52.create(Unknown Source) > at de.polonium.xmlapi.request.access.LoginRequest.run(Unknown > Source) > at > de.polonium.xmlapi.analyzer.RequestQueryAnalyzer.analyzeDocument(Unknown > Source) > at de.polonium.servlets.xmlapi.MmcmsXMLApiServlet.doPost(Unknown > Source) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:360) > at > org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:294) > at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:558) > at org.mortbay.http.HttpContext.handle(HttpContext.java:1714) > at > org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:507) > at org.mortbay.http.HttpContext.handle(HttpContext.java:1664) > at org.mortbay.http.HttpServer.service(HttpServer.java:863) > at org.jboss.jetty.Jetty.service(Jetty.java:460) > at org.mortbay.http.HttpConnection.service(HttpConnection.java:775) > at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:939) > at org.mortbay.http.HttpConnection.handle(HttpConnection.java:792) > at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:201) > at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:289) > at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java(Compiled > Code)) > > Is this a JBoss or MySQL problem? > > > Best Regards, > Rafal > > > > ------------------------------------------------------- > This SF.Net email sponsored by: Free pre-built ASP.NET sites including > Data Reports, E-commerce, Portals, and Forums are available now. > Download today and enter to win an XBOX or Visual Studio .NET. > http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01 > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > > ------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
