Hello Rafal, it looks like a problem in connection to MySql.
alex Monday, August 04, 2003, 11:25:50 AM, 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
