You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cayenne.apache.org by Jin Xu <xu...@gmail.com> on 2010/05/11 05:53:59 UTC
When use MySQL, how to set "autoReconnect" of Connect/J ?
Hello, friend:
When use MySQL and the internal Connection Pool of Cayenne, how to set
"autoReconnect" of Connect/J ?
I mean how to resolve the db Connection of in the Connection Pool to
fail:
[500ErrorPage.jsp] Exception caught in 500 page [v.3.0 Apr 26 2010
09:59:17] Error performing query.
org.apache.cayenne.CayenneRuntimeException: [v.3.0 Apr 26 2010 09:59:17]
Error performing query.
at
org.apache.cayenne.access.IncrementalFaultList.fillIn(IncrementalFaultList.java:205)
at
org.apache.cayenne.access.IncrementalFaultList.<init>(IncrementalFaultList.java:139)
at
org.apache.cayenne.access.SimpleIdIncrementalFaultList.<init>(SimpleIdIncrementalFaultList.java:42)
at
org.apache.cayenne.access.DataContextQueryAction.interceptPaginatedQuery(DataContextQueryAction.java:92)
at
org.apache.cayenne.util.ObjectContextQueryAction.execute(ObjectContextQueryAction.java:95)
at org.apache.cayenne.access.DataContext.onQuery(DataContext.java:1278)
at org.apache.cayenne.access.DataContext.performQuery(DataContext.java:1267)
at
net.daimon.jira.plugins.extfunc.telephonerecord.TelephoneRecordDao.select(TelephoneRecordDao.java:122)
at
net.daimon.jira.plugins.extfunc.telephonerecord.TelephoneRecordAction.doGetTelephoneRecordList(TelephoneRecordAction.java:169)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:61)
at webwork.util.InjectionUtils.invoke(InjectionUtils.java:52)
at webwork.action.ActionSupport.invokeCommand(ActionSupport.java:417)
at webwork.action.ActionSupport.execute(ActionSupport.java:146)
at
com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:59)
at
webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:141)
at
com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:181)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.core.filters.HeaderSanitisingFilter.doFilter(HeaderSanitisingFilter.java:44)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
at
com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66)
at
org.apache.cayenne.conf.WebApplicationContextFilter.doFilter(WebApplicationContextFilter.java:91)
at
com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74)
at
com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42)
at
com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55)
at
com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.jira.web.filters.accesslog.AccessLogFilter.executeRequest(AccessLogFilter.java:154)
at
com.atlassian.jira.web.filters.accesslog.AccessLogFilter.doFilter(AccessLogFilter.java:133)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119)
at
com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55)
at
com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:40)
at
com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
at
com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55)
at
com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:206)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:131)
at
com.atlassian.jira.web.filters.JiraLoginFilter.doFilter(JiraLoginFilter.java:70)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
at
com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66)
at
com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:69)
at
com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74)
at
com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42)
at
com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55)
at
com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:99)
at
com.atlassian.jira.web.filters.JIRAProfilingFilter.doFilter(JIRAProfilingFilter.java:16)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:59)
at
com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.jira.web.filters.RequestCleanupFilter.doFilter(RequestCleanupFilter.java:53)
at
com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:81)
at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:51)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
at
com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55)
at
com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.core.filters.cache.AbstractCachingFilter.doFilter(AbstractCachingFilter.java:33)
at
com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:41)
at
com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.jira.startup.JiraStartupChecklistFilter.doFilter(JiraStartupChecklistFilter.java:72)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859)
at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555)
at java.lang.Thread.run(Unknown Source)
Caused by: org.apache.cayenne.CayenneException: [v.3.0 Apr 26 2010 09:59:17]
Error getting ResultIterator: Global Exception:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet
successfully received from the server was 65,907,954 milliseconds ago. The
last packet sent successfully to the server was 65,907,954 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.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1122)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3317)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1941)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2690)
at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:5093)
at
org.apache.cayenne.conn.PooledConnectionImpl.getConnection(PooledConnectionImpl.java:128)
at
org.apache.cayenne.conn.PoolManager.uncheckConnection(PoolManager.java:369)
at org.apache.cayenne.conn.PoolManager.getConnection(PoolManager.java:353)
at org.apache.cayenne.conn.PoolManager.getConnection(PoolManager.java:330)
at
org.apache.cayenne.access.DataNode$TransactionDataSource.getConnection(DataNode.java:364)
at org.apache.cayenne.access.DataNode.performQueries(DataNode.java:248)
at
org.apache.cayenne.access.DataDomainLegacyQueryAction.execute(DataDomainLegacyQueryAction.java:79)
at org.apache.cayenne.access.DataDomain$1.transform(DataDomain.java:720)
at
org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:840)
at org.apache.cayenne.access.DataDomain.performQueries(DataDomain.java:717)
at
org.apache.cayenne.access.DataContext.internalPerformIteratedQuery(DataContext.java:1215)
at
org.apache.cayenne.access.DataContext.performIteratedQuery(DataContext.java:1181)
at
org.apache.cayenne.access.IncrementalFaultList.fillIn(IncrementalFaultList.java:189)
at
org.apache.cayenne.access.IncrementalFaultList.<init>(IncrementalFaultList.java:139)
at
org.apache.cayenne.access.SimpleIdIncrementalFaultList.<init>(SimpleIdIncrementalFaultList.java:42)
at
org.apache.cayenne.access.DataContextQueryAction.interceptPaginatedQuery(DataContextQueryAction.java:92)
at
org.apache.cayenne.util.ObjectContextQueryAction.execute(ObjectContextQueryAction.java:95)
at org.apache.cayenne.access.DataContext.onQuery(DataContext.java:1278)
at org.apache.cayenne.access.DataContext.performQuery(DataContext.java:1267)
at
net.daimon.jira.plugins.extfunc.telephonerecord.TelephoneRecordDao.select(TelephoneRecordDao.java:122)
at
net.daimon.jira.plugins.extfunc.telephonerecord.TelephoneRecordAction.doGetTelephoneRecordList(TelephoneRecordAction.java:169)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:61)
at webwork.util.InjectionUtils.invoke(InjectionUtils.java:52)
at webwork.action.ActionSupport.invokeCommand(ActionSupport.java:417)
at webwork.action.ActionSupport.execute(ActionSupport.java:146)
at
com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:59)
at
webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:141)
at
com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:181)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.core.filters.HeaderSanitisingFilter.doFilter(HeaderSanitisingFilter.java:44)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
at
com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66)
at
org.apache.cayenne.conf.WebApplicationContextFilter.doFilter(WebApplicationContextFilter.java:91)
at
com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74)
at
com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42)
at
com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55)
at
com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.jira.web.filters.accesslog.AccessLogFilter.executeRequest(AccessLogFilter.java:154)
at
com.atlassian.jira.web.filters.accesslog.AccessLogFilter.doFilter(AccessLogFilter.java:133)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119)
at
com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55)
at
com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:40)
at
com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
at
com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55)
at
com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:206)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:131)
at
com.atlassian.jira.web.filters.JiraLoginFilter.doFilter(JiraLoginFilter.java:70)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
at
com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66)
at
com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:69)
at
com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74)
at
com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42)
at
com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55)
at
com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:99)
at
com.atlassian.jira.web.filters.JIRAProfilingFilter.doFilter(JIRAProfilingFilter.java:16)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:59)
at
com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.jira.web.filters.RequestCleanupFilter.doFilter(RequestCleanupFilter.java:53)
at
com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:81)
at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:51)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
at
com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55)
at
com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.core.filters.cache.AbstractCachingFilter.doFilter(AbstractCachingFilter.java:33)
at
com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:41)
at
com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
com.atlassian.jira.startup.JiraStartupChecklistFilter.doFilter(JiraStartupChecklistFilter.java:72)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859)
at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555)
at java.lang.Thread.run(Unknown Source)
Caused by: java.net.SocketException: Software caused connection abort:
socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(Unknown Source)
at java.net.SocketOutputStream.write(Unknown Source)
at java.io.BufferedOutputStream.flushBuffer(Unknown Source)
at java.io.BufferedOutputStream.flush(Unknown Source)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3298)
... 133 more
at
org.apache.cayenne.access.util.IteratedSelectObserver.getResultIterator(IteratedSelectObserver.java:70)
at
org.apache.cayenne.access.DataContext.internalPerformIteratedQuery(DataContext.java:1216)
at
org.apache.cayenne.access.DataContext.performIteratedQuery(DataContext.java:1181)
at
org.apache.cayenne.access.IncrementalFaultList.fillIn(IncrementalFaultList.java:189)
... 116 more
--
We are the best ! ! ! !
Re: When use MySQL, how to set "autoReconnect" of Connect/J ?
Posted by Jin Xu <xu...@gmail.com>.
Thank you ! ! ! !
Re: When use MySQL, how to set "autoReconnect" of Connect/J ?
Posted by Andrus Adamchik <an...@objectstyle.org>.
Hi Jin,
MySQL driver parameters are appended to the DB URL:
http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html
Specifically you will need "autoReconnect" parameter.
Andrus
On May 11, 2010, at 6:53 AM, Jin Xu wrote:
> Hello, friend:
> When use MySQL and the internal Connection Pool of Cayenne, how
> to set
> "autoReconnect" of Connect/J ?
>
> I mean how to resolve the db Connection of in the Connection Pool
> to
> fail:
>
> [500ErrorPage.jsp] Exception caught in 500 page [v.3.0 Apr 26 2010
> 09:59:17] Error performing query.
> org.apache.cayenne.CayenneRuntimeException: [v.3.0 Apr 26 2010
> 09:59:17]
> Error performing query.
> at
> org
> .apache
> .cayenne
> .access.IncrementalFaultList.fillIn(IncrementalFaultList.java:205)
> at
> org
> .apache
> .cayenne
> .access.IncrementalFaultList.<init>(IncrementalFaultList.java:139)
> at
> org
> .apache
> .cayenne
> .access
> .SimpleIdIncrementalFaultList
> .<init>(SimpleIdIncrementalFaultList.java:42)
> at
> org
> .apache
> .cayenne
> .access
> .DataContextQueryAction
> .interceptPaginatedQuery(DataContextQueryAction.java:92)
> at
> org
> .apache
> .cayenne
> .util.ObjectContextQueryAction.execute(ObjectContextQueryAction.java:
> 95)
> at org.apache.cayenne.access.DataContext.onQuery(DataContext.java:
> 1278)
> at
> org.apache.cayenne.access.DataContext.performQuery(DataContext.java:
> 1267)
> at
> net
> .daimon
> .jira
> .plugins
> .extfunc
> .telephonerecord.TelephoneRecordDao.select(TelephoneRecordDao.java:
> 122)
> at
> net
> .daimon
> .jira
> .plugins
> .extfunc
> .telephonerecord
> .TelephoneRecordAction
> .doGetTelephoneRecordList(TelephoneRecordAction.java:169)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at
> webwork.util.InjectionUtils
> $DefaultInjectionImpl.invoke(InjectionUtils.java:61)
> at webwork.util.InjectionUtils.invoke(InjectionUtils.java:52)
> at webwork.action.ActionSupport.invokeCommand(ActionSupport.java:417)
> at webwork.action.ActionSupport.execute(ActionSupport.java:146)
> at
> com
> .atlassian
> .jira.action.JiraActionSupport.execute(JiraActionSupport.java:59)
> at
> webwork
> .dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:
> 141)
> at
> com
> .atlassian
> .jira
> .web
> .dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:
> 181)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 290)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian
> .core
> .filters.HeaderSanitisingFilter.doFilter(HeaderSanitisingFilter.java:
> 44)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
> at
> com.atlassian.plugin.servlet.filter.DelegatingPluginFilter
> $1.doFilter(DelegatingPluginFilter.java:66)
> at
> org
> .apache
> .cayenne
> .conf
> .WebApplicationContextFilter
> .doFilter(WebApplicationContextFilter.java:91)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:
> 74)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter
> .ServletFilterModuleContainerFilter
> .doFilter(ServletFilterModuleContainerFilter.java:55)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter
> .ServletFilterModuleContainerFilter
> .doFilter(ServletFilterModuleContainerFilter.java:41)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com.atlassian.jira.web.filters.accesslog.AccessLogFilter.executeRequest
> (AccessLogFilter.java:154)
> at
> com
> .atlassian
> .jira
> .web.filters.accesslog.AccessLogFilter.doFilter(AccessLogFilter.java:
> 133)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .opensymphony
> .module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119)
> at
> com
> .opensymphony
> .module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55)
> at
> com
> .atlassian
> .jira
> .web
> .filters
> .SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:40)
> at
> com
> .atlassian
> .core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter
> .ServletFilterModuleContainerFilter
> .doFilter(ServletFilterModuleContainerFilter.java:55)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter
> .ServletFilterModuleContainerFilter
> .doFilter(ServletFilterModuleContainerFilter.java:41)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:
> 206)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian
> .security
> .auth
> .trustedapps
> .filter
> .TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian
> .seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:131)
> at
> com
> .atlassian
> .jira.web.filters.JiraLoginFilter.doFilter(JiraLoginFilter.java:70)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
> at
> com.atlassian.plugin.servlet.filter.DelegatingPluginFilter
> $1.doFilter(DelegatingPluginFilter.java:66)
> at
> com
> .atlassian
> .oauth
> .serviceprovider
> .internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:69)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:
> 74)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter
> .ServletFilterModuleContainerFilter
> .doFilter(ServletFilterModuleContainerFilter.java:55)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter
> .ServletFilterModuleContainerFilter
> .doFilter(ServletFilterModuleContainerFilter.java:41)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian
> .util
> .profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:99)
> at
> com
> .atlassian
> .jira
> .web.filters.JIRAProfilingFilter.doFilter(JIRAProfilingFilter.java:16)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian
> .jira
> .web
> .filters
> .ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:59)
> at
> com
> .atlassian
> .core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian
> .jira
> .web.filters.RequestCleanupFilter.doFilter(RequestCleanupFilter.java:
> 53)
> at
> com
> .atlassian
> .core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian
> .johnson
> .filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org
> .tuckey
> .web
> .filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:
> 350)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:
> 81)
> at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:51)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter
> .ServletFilterModuleContainerFilter
> .doFilter(ServletFilterModuleContainerFilter.java:55)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter
> .ServletFilterModuleContainerFilter
> .doFilter(ServletFilterModuleContainerFilter.java:41)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian
> .core
> .filters
> .cache.AbstractCachingFilter.doFilter(AbstractCachingFilter.java:33)
> at
> com
> .atlassian
> .core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian
> .core
> .filters
> .encoding
> .AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:41)
> at
> com
> .atlassian
> .core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian
> .jira
> .startup
> .JiraStartupChecklistFilter.doFilter(JiraStartupChecklistFilter.java:
> 72)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org
> .apache
> .catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:
> 233)
> at
> org
> .apache
> .catalina.core.StandardContextValve.invoke(StandardContextValve.java:
> 191)
> at
> org
> .apache
> .catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> at
> org
> .apache
> .catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> at
> org
> .apache
> .catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:
> 109)
> at
> org
> .apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:
> 298)
> at
> org
> .apache
> .coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859)
> at
> org.apache.coyote.http11.Http11AprProtocol
> $Http11ConnectionHandler.process(Http11AprProtocol.java:579)
> at org.apache.tomcat.util.net.AprEndpoint
> $Worker.run(AprEndpoint.java:1555)
> at java.lang.Thread.run(Unknown Source)
> Caused by: org.apache.cayenne.CayenneException: [v.3.0 Apr 26 2010
> 09:59:17]
> Error getting ResultIterator: Global Exception:
> com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last
> packet
> successfully received from the server was 65,907,954 milliseconds
> ago. The
> last packet sent successfully to the server was 65,907,954
> 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.
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown
> Source)
> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
> Source)
> at java.lang.reflect.Constructor.newInstance(Unknown Source)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
> at
> com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:
> 1122)
> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3317)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1941)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2690)
> at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:
> 5093)
> at
> org
> .apache
> .cayenne
> .conn.PooledConnectionImpl.getConnection(PooledConnectionImpl.java:
> 128)
> at
> org
> .apache.cayenne.conn.PoolManager.uncheckConnection(PoolManager.java:
> 369)
> at
> org.apache.cayenne.conn.PoolManager.getConnection(PoolManager.java:
> 353)
> at
> org.apache.cayenne.conn.PoolManager.getConnection(PoolManager.java:
> 330)
> at
> org.apache.cayenne.access.DataNode
> $TransactionDataSource.getConnection(DataNode.java:364)
> at org.apache.cayenne.access.DataNode.performQueries(DataNode.java:
> 248)
> at
> org
> .apache
> .cayenne
> .access
> .DataDomainLegacyQueryAction
> .execute(DataDomainLegacyQueryAction.java:79)
> at org.apache.cayenne.access.DataDomain$1.transform(DataDomain.java:
> 720)
> at
> org
> .apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:
> 840)
> at
> org.apache.cayenne.access.DataDomain.performQueries(DataDomain.java:
> 717)
> at
> org
> .apache
> .cayenne
> .access.DataContext.internalPerformIteratedQuery(DataContext.java:
> 1215)
> at
> org
> .apache
> .cayenne.access.DataContext.performIteratedQuery(DataContext.java:
> 1181)
> at
> org
> .apache
> .cayenne
> .access.IncrementalFaultList.fillIn(IncrementalFaultList.java:189)
> at
> org
> .apache
> .cayenne
> .access.IncrementalFaultList.<init>(IncrementalFaultList.java:139)
> at
> org
> .apache
> .cayenne
> .access
> .SimpleIdIncrementalFaultList
> .<init>(SimpleIdIncrementalFaultList.java:42)
> at
> org
> .apache
> .cayenne
> .access
> .DataContextQueryAction
> .interceptPaginatedQuery(DataContextQueryAction.java:92)
> at
> org
> .apache
> .cayenne
> .util.ObjectContextQueryAction.execute(ObjectContextQueryAction.java:
> 95)
> at org.apache.cayenne.access.DataContext.onQuery(DataContext.java:
> 1278)
> at
> org.apache.cayenne.access.DataContext.performQuery(DataContext.java:
> 1267)
> at
> net
> .daimon
> .jira
> .plugins
> .extfunc
> .telephonerecord.TelephoneRecordDao.select(TelephoneRecordDao.java:
> 122)
> at
> net
> .daimon
> .jira
> .plugins
> .extfunc
> .telephonerecord
> .TelephoneRecordAction
> .doGetTelephoneRecordList(TelephoneRecordAction.java:169)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at
> webwork.util.InjectionUtils
> $DefaultInjectionImpl.invoke(InjectionUtils.java:61)
> at webwork.util.InjectionUtils.invoke(InjectionUtils.java:52)
> at webwork.action.ActionSupport.invokeCommand(ActionSupport.java:417)
> at webwork.action.ActionSupport.execute(ActionSupport.java:146)
> at
> com
> .atlassian
> .jira.action.JiraActionSupport.execute(JiraActionSupport.java:59)
> at
> webwork
> .dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:
> 141)
> at
> com
> .atlassian
> .jira
> .web
> .dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:
> 181)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 290)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian
> .core
> .filters.HeaderSanitisingFilter.doFilter(HeaderSanitisingFilter.java:
> 44)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
> at
> com.atlassian.plugin.servlet.filter.DelegatingPluginFilter
> $1.doFilter(DelegatingPluginFilter.java:66)
> at
> org
> .apache
> .cayenne
> .conf
> .WebApplicationContextFilter
> .doFilter(WebApplicationContextFilter.java:91)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:
> 74)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter
> .ServletFilterModuleContainerFilter
> .doFilter(ServletFilterModuleContainerFilter.java:55)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter
> .ServletFilterModuleContainerFilter
> .doFilter(ServletFilterModuleContainerFilter.java:41)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com.atlassian.jira.web.filters.accesslog.AccessLogFilter.executeRequest
> (AccessLogFilter.java:154)
> at
> com
> .atlassian
> .jira
> .web.filters.accesslog.AccessLogFilter.doFilter(AccessLogFilter.java:
> 133)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .opensymphony
> .module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119)
> at
> com
> .opensymphony
> .module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55)
> at
> com
> .atlassian
> .jira
> .web
> .filters
> .SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:40)
> at
> com
> .atlassian
> .core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter
> .ServletFilterModuleContainerFilter
> .doFilter(ServletFilterModuleContainerFilter.java:55)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter
> .ServletFilterModuleContainerFilter
> .doFilter(ServletFilterModuleContainerFilter.java:41)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:
> 206)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian
> .security
> .auth
> .trustedapps
> .filter
> .TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian
> .seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:131)
> at
> com
> .atlassian
> .jira.web.filters.JiraLoginFilter.doFilter(JiraLoginFilter.java:70)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
> at
> com.atlassian.plugin.servlet.filter.DelegatingPluginFilter
> $1.doFilter(DelegatingPluginFilter.java:66)
> at
> com
> .atlassian
> .oauth
> .serviceprovider
> .internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:69)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:
> 74)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter
> .ServletFilterModuleContainerFilter
> .doFilter(ServletFilterModuleContainerFilter.java:55)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter
> .ServletFilterModuleContainerFilter
> .doFilter(ServletFilterModuleContainerFilter.java:41)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian
> .util
> .profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:99)
> at
> com
> .atlassian
> .jira
> .web.filters.JIRAProfilingFilter.doFilter(JIRAProfilingFilter.java:16)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian
> .jira
> .web
> .filters
> .ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:59)
> at
> com
> .atlassian
> .core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian
> .jira
> .web.filters.RequestCleanupFilter.doFilter(RequestCleanupFilter.java:
> 53)
> at
> com
> .atlassian
> .core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian
> .johnson
> .filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org
> .tuckey
> .web
> .filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:
> 350)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:
> 81)
> at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:51)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter
> .ServletFilterModuleContainerFilter
> .doFilter(ServletFilterModuleContainerFilter.java:55)
> at
> com
> .atlassian
> .plugin
> .servlet
> .filter
> .ServletFilterModuleContainerFilter
> .doFilter(ServletFilterModuleContainerFilter.java:41)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian
> .core
> .filters
> .cache.AbstractCachingFilter.doFilter(AbstractCachingFilter.java:33)
> at
> com
> .atlassian
> .core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian
> .core
> .filters
> .encoding
> .AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:41)
> at
> com
> .atlassian
> .core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> com
> .atlassian
> .jira
> .startup
> .JiraStartupChecklistFilter.doFilter(JiraStartupChecklistFilter.java:
> 72)
> at
> org
> .apache
> .catalina
> .core
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
> 235)
> at
> org
> .apache
> .catalina
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org
> .apache
> .catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:
> 233)
> at
> org
> .apache
> .catalina.core.StandardContextValve.invoke(StandardContextValve.java:
> 191)
> at
> org
> .apache
> .catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> at
> org
> .apache
> .catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> at
> org
> .apache
> .catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:
> 109)
> at
> org
> .apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:
> 298)
> at
> org
> .apache
> .coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859)
> at
> org.apache.coyote.http11.Http11AprProtocol
> $Http11ConnectionHandler.process(Http11AprProtocol.java:579)
> at org.apache.tomcat.util.net.AprEndpoint
> $Worker.run(AprEndpoint.java:1555)
> at java.lang.Thread.run(Unknown Source)
> Caused by: java.net.SocketException: Software caused connection abort:
> socket write error
> at java.net.SocketOutputStream.socketWrite0(Native Method)
> at java.net.SocketOutputStream.socketWrite(Unknown Source)
> at java.net.SocketOutputStream.write(Unknown Source)
> at java.io.BufferedOutputStream.flushBuffer(Unknown Source)
> at java.io.BufferedOutputStream.flush(Unknown Source)
> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3298)
> ... 133 more
>
> at
> org
> .apache
> .cayenne
> .access
> .util
> .IteratedSelectObserver
> .getResultIterator(IteratedSelectObserver.java:70)
> at
> org
> .apache
> .cayenne
> .access.DataContext.internalPerformIteratedQuery(DataContext.java:
> 1216)
> at
> org
> .apache
> .cayenne.access.DataContext.performIteratedQuery(DataContext.java:
> 1181)
> at
> org
> .apache
> .cayenne
> .access.IncrementalFaultList.fillIn(IncrementalFaultList.java:189)
> ... 116 more
>
> --
> We are the best ! ! ! !