com.mysql.jdbc.exceptions.jdbc4.CommunicationsException After periods of inactivity

XMLWordPrintable

    • Type: Bug
    • Resolution: Not a bug
    • Priority: Medium
    • None
    • Affects Version/s: 2.3.4
    • Component/s: Database
    • None
    • Environment:

      production

      We get the following stack traces after periods of inactivity. Typically if I refresh the page after I get this error it goes away. Looks like a possible connection pool validation queyr (in looking at the JIRA and Confludence support systems) but I do not see any way to configure the connection pools.

      com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 12,581,371 milliseconds ago.  The last packet sent successfully to the server was 12,581,371 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
      	sun.reflect.GeneratedConstructorAccessor146.newInstance(Unknown Source)
      	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      	java.lang.reflect.Constructor.newInstance(Constructor.java:532)
      	com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
      	com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
      	com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3364)
      	com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1983)
      	com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
      	com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618)
      	com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:5000)
      	org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:371)
      	org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:328)
      	org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:63)
      	org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1327)
      	org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:558)
      	org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:374)
      	org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:263)
      	org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:101)
      	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      	$Proxy4.getUser(Unknown Source)
      	com.atlassian.crowd.openid.server.action.secure.interaction.AllowAuthentication.isOpenIDRequestValid(AllowAuthentication.java:89)
      	com.atlassian.crowd.openid.server.action.secure.interaction.AllowAuthentication.doDefault(AllowAuthentication.java:141)
      	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	java.lang.reflect.Method.invoke(Method.java:616)
      	com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:358)
      	com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:218)
      	com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:192)
      	com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
      	com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
      	com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
      	com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
      	com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
      	com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
      	com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
      	com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
      	com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116)
      	com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:273)
      	com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:202)
      	com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)
      	com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)
      	org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
      	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
      	com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:88)
      	org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738)
      	com.atlassian.crowd.integration.http.VerifyTokenFilter.doFilter(VerifyTokenFilter.java:177)
      	org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
      	org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
      	com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:41)
      	com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
      root cause
      
      java.net.SocketException: Broken pipe
      	java.net.SocketOutputStream.socketWrite0(Native Method)
      	java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109)
      	java.net.SocketOutputStream.write(SocketOutputStream.java:153)
      	java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
      	java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
      	com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3345)
      	com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1983)
      	com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
      	com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618)
      	com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:5000)
      	org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:371)
      	org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:328)
      	org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:63)
      	org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1327)
      	org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:558)
      	org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:374)
      	org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:263)
      	org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:101)
      	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      	$Proxy4.getUser(Unknown Source)
      	com.atlassian.crowd.openid.server.action.secure.interaction.AllowAuthentication.isOpenIDRequestValid(AllowAuthentication.java:89)
      	com.atlassian.crowd.openid.server.action.secure.interaction.AllowAuthentication.doDefault(AllowAuthentication.java:141)
      	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	java.lang.reflect.Method.invoke(Method.java:616)
      	com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:358)
      	com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:218)
      	com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:192)
      	com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
      	com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
      	com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
      	com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
      	com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
      	com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
      	com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
      	com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
      	com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116)
      	com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:273)
      	com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:202)
      	com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)
      	com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)
      	org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
      	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
      	com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:88)
      	org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738)
      	com.atlassian.crowd.integration.http.VerifyTokenFilter.doFilter(VerifyTokenFilter.java:177)
      	org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
      	org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
      	com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:41)
      	com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
      

            Assignee:
            Unassigned
            Reporter:
            Frank Febbraro
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: