org.ofbiz.core.entity.GenericDataSourceException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • After a time (log entries attached) with no connections, JIRA is not accessible until I restart the Tomcat service. The first exception in the log is: 2006-01-26 21:51:19,690 INFO [jira.action.admin.DataExport] Export took 2250ms 2006-01-26 21:51:19,690 INFO [jira.action.admin.DataExport] Wrote 19006 entities to export 2006-01-27 08:32:25,670 ERROR [user.provider.ofbiz.OFBizAccessProvider] GenericEntityException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, username, PASSWORD_HASH FROM userbase WHERE username=? (Invalid state, the Connection object is closed.) org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, username, PASSWORD_HASH FROM userbase WHERE username=? (Invalid state, the Connection object is closed.) at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:330) at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1024) at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595) at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:744) at com.opensymphony.user.provider.ofbiz.OFBizAbstractProvider.findUser(OFBizAbstractProvider.java:156) at com.opensymphony.user.provider.ofbiz.OFBizAccessProvider.handles(OFBizAccessProvider.java:116) at com.opensymphony.user.UserManager.getProvider(UserManager.java:275) at com.opensymphony.user.UserManager$Accessor.getAccessProvider(UserManager.java:392) at com.opensymphony.user.Entity.getAccessProvider(Entity.java:100) at com.opensymphony.user.User.getGroups(User.java:91) at com.atlassian.jira.security.DefaultGlobalPermissionManager.hasPermission(DefaultGlobalPermissionManager.java:161) at com.atlassian.jira.security.AbstractPermissionManager.hasPermission(AbstractPermissionManager.java:85) at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.atlassian.util.profiling.object.ObjectProfiler.profiledInvoke(ObjectProfiler.java:71) at com.atlassian.jira.config.component.SwitchingInvocationHandler.invoke(SwitchingInvocationHandler.java:28) at $Proxy1.hasPermission(Unknown Source) at com.atlassian.jira.security.JiraRoleMapper.canLogin(JiraRoleMapper.java:32) at com.atlassian.seraph.auth.DefaultAuthenticator.login(DefaultAuthenticator.java:99) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:125) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.jira.web.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:25) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.jira.web.filters.gzip.GzipFilter.doFilter(GzipFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Unknown Source) java.sql.SQLException: Invalid state, the Connection object is closed. at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1494) at net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareStatement(ConnectionJDBC2.java:2215) at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:199) at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:283) at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:325) at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1024) at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595) at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:744) at com.opensymphony.user.provider.ofbiz.OFBizAbstractProvider.findUser(OFBizAbstractProvider.java:156) at com.opensymphony.user.provider.ofbiz.OFBizAccessProvider.handles(OFBizAccessProvider.java:116) at com.opensymphony.user.UserManager.getProvider(UserManager.java:275) at com.opensymphony.user.UserManager$Accessor.getAccessProvider(UserManager.java:392) at com.opensymphony.user.Entity.getAccessProvider(Entity.java:100) at com.opensymphony.user.User.getGroups(User.java:91) at com.atlassian.jira.security.DefaultGlobalPermissionManager.hasPermission(DefaultGlobalPermissionManager.java:161) at com.atlassian.jira.security.AbstractPermissionManager.hasPermission(AbstractPermissionManager.java:85) at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.atlassian.util.profiling.object.ObjectProfiler.profiledInvoke(ObjectProfiler.java:71) at com.atlassian.jira.config.component.SwitchingInvocationHandler.invoke(SwitchingInvocationHandler.java:28) at $Proxy1.hasPermission(Unknown Source) at com.atlassian.jira.security.JiraRoleMapper.canLogin(JiraRoleMapper.java:32) at com.atlassian.seraph.auth.DefaultAuthenticator.login(DefaultAuthenticator.java:99) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:125) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.jira.web.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:25) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.jira.web.filters.gzip.GzipFilter.doFilter(GzipFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Unknown Source) And then pretty much any request after that results in a "Invalid state, the Connection object is closed." error and JIRA hangs. This might be related to JRA-6796 but I'm not sure.
    via by David Demner,
  • After a time (log entries attached) with no connections, JIRA is not accessible until I restart the Tomcat service. The first exception in the log is: 2006-01-26 21:51:19,690 INFO [jira.action.admin.DataExport] Export took 2250ms 2006-01-26 21:51:19,690 INFO [jira.action.admin.DataExport] Wrote 19006 entities to export 2006-01-27 08:32:25,670 ERROR [user.provider.ofbiz.OFBizAccessProvider] GenericEntityException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, username, PASSWORD_HASH FROM userbase WHERE username=? (Invalid state, the Connection object is closed.) org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, username, PASSWORD_HASH FROM userbase WHERE username=? (Invalid state, the Connection object is closed.) at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:330) at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1024) at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595) at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:744) at com.opensymphony.user.provider.ofbiz.OFBizAbstractProvider.findUser(OFBizAbstractProvider.java:156) at com.opensymphony.user.provider.ofbiz.OFBizAccessProvider.handles(OFBizAccessProvider.java:116) at com.opensymphony.user.UserManager.getProvider(UserManager.java:275) at com.opensymphony.user.UserManager$Accessor.getAccessProvider(UserManager.java:392) at com.opensymphony.user.Entity.getAccessProvider(Entity.java:100) at com.opensymphony.user.User.getGroups(User.java:91) at com.atlassian.jira.security.DefaultGlobalPermissionManager.hasPermission(DefaultGlobalPermissionManager.java:161) at com.atlassian.jira.security.AbstractPermissionManager.hasPermission(AbstractPermissionManager.java:85) at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.atlassian.util.profiling.object.ObjectProfiler.profiledInvoke(ObjectProfiler.java:71) at com.atlassian.jira.config.component.SwitchingInvocationHandler.invoke(SwitchingInvocationHandler.java:28) at $Proxy1.hasPermission(Unknown Source) at com.atlassian.jira.security.JiraRoleMapper.canLogin(JiraRoleMapper.java:32) at com.atlassian.seraph.auth.DefaultAuthenticator.login(DefaultAuthenticator.java:99) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:125) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.jira.web.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:25) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.jira.web.filters.gzip.GzipFilter.doFilter(GzipFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Unknown Source) java.sql.SQLException: Invalid state, the Connection object is closed. at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1494) at net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareStatement(ConnectionJDBC2.java:2215) at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:199) at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:283) at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:325) at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1024) at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595) at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:744) at com.opensymphony.user.provider.ofbiz.OFBizAbstractProvider.findUser(OFBizAbstractProvider.java:156) at com.opensymphony.user.provider.ofbiz.OFBizAccessProvider.handles(OFBizAccessProvider.java:116) at com.opensymphony.user.UserManager.getProvider(UserManager.java:275) at com.opensymphony.user.UserManager$Accessor.getAccessProvider(UserManager.java:392) at com.opensymphony.user.Entity.getAccessProvider(Entity.java:100) at com.opensymphony.user.User.getGroups(User.java:91) at com.atlassian.jira.security.DefaultGlobalPermissionManager.hasPermission(DefaultGlobalPermissionManager.java:161) at com.atlassian.jira.security.AbstractPermissionManager.hasPermission(AbstractPermissionManager.java:85) at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.atlassian.util.profiling.object.ObjectProfiler.profiledInvoke(ObjectProfiler.java:71) at com.atlassian.jira.config.component.SwitchingInvocationHandler.invoke(SwitchingInvocationHandler.java:28) at $Proxy1.hasPermission(Unknown Source) at com.atlassian.jira.security.JiraRoleMapper.canLogin(JiraRoleMapper.java:32) at com.atlassian.seraph.auth.DefaultAuthenticator.login(DefaultAuthenticator.java:99) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:125) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.jira.web.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:25) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.jira.web.filters.gzip.GzipFilter.doFilter(GzipFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Unknown Source) And then pretty much any request after that results in a "Invalid state, the Connection object is closed." error and JIRA hangs. This might be related to JRA-6796 but I'm not sure.
    via by David Demner,
  • The FogBugz importer is blowing up near the end of a large import: {noformat} 2006-04-06 14:55:04,326 INFO [imports.importer.impl.ImportLogger] Rewritten comment for issue LOGI75-145 (105435.017s)^M 2006-04-06 15:02:56,451 INFO [imports.importer.impl.ImportLogger] Rewritten comment for issue IDEDEV-94 (105907.142s)^M 2006-04-06 15:19:42,591 INFO [imports.importer.impl.ImportLogger] FAILED: Unexpected failure occurred. Importer will stop immediately. Data maybe in an unstable state (106913.282s)^M 2006-04-06 15:19:42,779 INFO [imports.importer.impl.ImportLogger] com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, issueid, AUTHOR, actiontype, actionlevel, actionbody, CREATED, actionnum FROM jiraaction WHERE issueid=? AND actiontype=? (I/O Error: Connection reset)^M at com.atlassian.jira.imports.importer.impl.DefaultJiraDataImporter.rewriteOldIssueKeys(DefaultJiraDataImporter.java:652)^M at com.atlassian.jira.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:116)^M at com.atlassian.jira.imports.importer.impl.ImporterThread.run(ImporterThread.java:21)^M Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, issueid, AUTHOR, actiontype, actionlevel, actionbody, CREATED, actionnum FROM jiraaction WHERE issueid=? AND actiontype=? (I/O Error: Connection reset)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:345)^M at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1050)^M at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595)^M at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134)^M at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782)^M at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767)^M at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:744)^M at com.atlassian.jira.imports.importer.impl.DefaultJiraDataImporter.rewriteOldIssueKeys(DefaultJiraDataImporter.java:631)^M ... 2 more^M (106913.47s)^M 2006-04-06 15:19:42,966 INFO [imports.importer.impl.ImportLogger] Flushing issue cache (106913.657s)^M 2006-04-06 15:21:28,576 WARN [core.entity.jdbc.SQLProcessor] Already closed.^M 2006-04-06 15:21:28,623 WARN [core.entity.jdbc.SQLProcessor] [SQLProcessor.rollback]: SQL Exception while rolling back insert. Error was:java.sql.SQLException: Invalid state, the Connection object is closed.^M 2006-04-06 15:21:28,623 WARN [NoModule] org.ofbiz.core.entity.jdbc.SQLProcessor^M java.sql.SQLException: Invalid state, the Connection object is closed.^M at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1494)^M at net.sourceforge.jtds.jdbc.ConnectionJDBC2.rollback(ConnectionJDBC2.java:1889)^M at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:265)^M at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:288)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:131)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:114)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:153)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:702)^M at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)^M at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83)^M at java.lang.ref.Finalizer.access$100(Finalizer.java:14)^M at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160)^M 2006-04-06 15:21:28,623 WARN [NoModule] [SQLProcessor.commit]: SQL Exception occurred on commit. Error was:java.sql.SQLException: Invalid state, the Connection object is closed.^M 2006-04-06 15:21:28,638 ERROR [NoModule] Error closing the result, connection, etc in finalize EntityListIterator^M org.ofbiz.core.entity.GenericDataSourceException: SQL Exception occurred on commit (Invalid state, the Connection object is closed.)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:116)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:153)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:702)^M at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)^M at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83)^M at java.lang.ref.Finalizer.access$100(Finalizer.java:14)^M at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160)^M java.sql.SQLException: Invalid state, the Connection object is closed.^M at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1494)^M at net.sourceforge.jtds.jdbc.ConnectionJDBC2.commit(ConnectionJDBC2.java:1874)^M at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.commit(DelegatingConnection.java:238)^M at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:199)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:112)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:153)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:702)^M at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)^M at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83)^M at java.lang.ref.Finalizer.access$100(Finalizer.java:14)^M at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160)^M {noformat}
    via by Jeff Turner,
  • did a quick search for an issue that did not exist. Received this exception on the console. As a user I received a totally empty screen - clicked back button on browser, entered a correct issue in search, and went on. Exception: 2004-10-26 18:40:48,687 ERROR [atlassian.jira.servlet.QuickLinkServlet] org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, groupid, FIELDTYPE, FIE LD, OLDVALUE, OLDSTRING, NEWVALUE, NEWSTRING FROM changeitem WHERE FIELD=? AND OLDSTRING=? ORDER BY groupid desc (The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.) org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, groupid, FIELDTYPE, FIELD, OLDVALUE, OLDSTRING, NEWVALUE, NEWSTRING FROM changeitem WHERE FIELD =? AND OLDSTRING=? ORDER BY groupid desc (The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.) at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:311) at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1050) at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595) at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767) at com.atlassian.jira.servlet.QuickLinkServlet.findMovedIssue(QuickLinkServlet.java:111) at com.atlassian.jira.servlet.QuickLinkServlet.service(QuickLinkServlet.java:46) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:142) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:58) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:168) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.jira.web.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:25) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:36) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:163) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:700) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:534) java.sql.SQLException: The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator. at net.sourceforge.jtds.jdbc.SqlMessage.toSQLException(SqlMessage.java:392) at net.sourceforge.jtds.jdbc.SQLWarningChain.addOrReturn(SQLWarningChain.java:91) at net.sourceforge.jtds.jdbc.Tds.submitProcedure(Tds.java:235) at net.sourceforge.jtds.jdbc.PreparedStatement_base.submitProcedure(PreparedStatement_base.java:195)
    via by William Crighton [CCC],
  • The FogBugz importer is blowing up near the end of a large import: {noformat} 2006-04-06 14:55:04,326 INFO [imports.importer.impl.ImportLogger] Rewritten comment for issue LOGI75-145 (105435.017s)^M 2006-04-06 15:02:56,451 INFO [imports.importer.impl.ImportLogger] Rewritten comment for issue IDEDEV-94 (105907.142s)^M 2006-04-06 15:19:42,591 INFO [imports.importer.impl.ImportLogger] FAILED: Unexpected failure occurred. Importer will stop immediately. Data maybe in an unstable state (106913.282s)^M 2006-04-06 15:19:42,779 INFO [imports.importer.impl.ImportLogger] com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, issueid, AUTHOR, actiontype, actionlevel, actionbody, CREATED, actionnum FROM jiraaction WHERE issueid=? AND actiontype=? (I/O Error: Connection reset)^M at com.atlassian.jira.imports.importer.impl.DefaultJiraDataImporter.rewriteOldIssueKeys(DefaultJiraDataImporter.java:652)^M at com.atlassian.jira.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:116)^M at com.atlassian.jira.imports.importer.impl.ImporterThread.run(ImporterThread.java:21)^M Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, issueid, AUTHOR, actiontype, actionlevel, actionbody, CREATED, actionnum FROM jiraaction WHERE issueid=? AND actiontype=? (I/O Error: Connection reset)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:345)^M at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1050)^M at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595)^M at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134)^M at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782)^M at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767)^M at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:744)^M at com.atlassian.jira.imports.importer.impl.DefaultJiraDataImporter.rewriteOldIssueKeys(DefaultJiraDataImporter.java:631)^M ... 2 more^M (106913.47s)^M 2006-04-06 15:19:42,966 INFO [imports.importer.impl.ImportLogger] Flushing issue cache (106913.657s)^M 2006-04-06 15:21:28,576 WARN [core.entity.jdbc.SQLProcessor] Already closed.^M 2006-04-06 15:21:28,623 WARN [core.entity.jdbc.SQLProcessor] [SQLProcessor.rollback]: SQL Exception while rolling back insert. Error was:java.sql.SQLException: Invalid state, the Connection object is closed.^M 2006-04-06 15:21:28,623 WARN [NoModule] org.ofbiz.core.entity.jdbc.SQLProcessor^M java.sql.SQLException: Invalid state, the Connection object is closed.^M at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1494)^M at net.sourceforge.jtds.jdbc.ConnectionJDBC2.rollback(ConnectionJDBC2.java:1889)^M at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:265)^M at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:288)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:131)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:114)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:153)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:702)^M at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)^M at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83)^M at java.lang.ref.Finalizer.access$100(Finalizer.java:14)^M at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160)^M 2006-04-06 15:21:28,623 WARN [NoModule] [SQLProcessor.commit]: SQL Exception occurred on commit. Error was:java.sql.SQLException: Invalid state, the Connection object is closed.^M 2006-04-06 15:21:28,638 ERROR [NoModule] Error closing the result, connection, etc in finalize EntityListIterator^M org.ofbiz.core.entity.GenericDataSourceException: SQL Exception occurred on commit (Invalid state, the Connection object is closed.)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:116)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:153)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:702)^M at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)^M at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83)^M at java.lang.ref.Finalizer.access$100(Finalizer.java:14)^M at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160)^M java.sql.SQLException: Invalid state, the Connection object is closed.^M at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1494)^M at net.sourceforge.jtds.jdbc.ConnectionJDBC2.commit(ConnectionJDBC2.java:1874)^M at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.commit(DelegatingConnection.java:238)^M at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:199)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:112)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:153)^M at org.ofbiz.core.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:702)^M at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)^M at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83)^M at java.lang.ref.Finalizer.access$100(Finalizer.java:14)^M at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160)^M {noformat}
    via by Jeff Turner,
  • did a quick search for an issue that did not exist. Received this exception on the console. As a user I received a totally empty screen - clicked back button on browser, entered a correct issue in search, and went on. Exception: 2004-10-26 18:40:48,687 ERROR [atlassian.jira.servlet.QuickLinkServlet] org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, groupid, FIELDTYPE, FIE LD, OLDVALUE, OLDSTRING, NEWVALUE, NEWSTRING FROM changeitem WHERE FIELD=? AND OLDSTRING=? ORDER BY groupid desc (The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.) org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, groupid, FIELDTYPE, FIELD, OLDVALUE, OLDSTRING, NEWVALUE, NEWSTRING FROM changeitem WHERE FIELD =? AND OLDSTRING=? ORDER BY groupid desc (The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.) at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:311) at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1050) at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595) at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767) at com.atlassian.jira.servlet.QuickLinkServlet.findMovedIssue(QuickLinkServlet.java:111) at com.atlassian.jira.servlet.QuickLinkServlet.service(QuickLinkServlet.java:46) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:142) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:58) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:168) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.jira.web.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:25) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:36) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:163) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:700) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:534) java.sql.SQLException: The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator. at net.sourceforge.jtds.jdbc.SqlMessage.toSQLException(SqlMessage.java:392) at net.sourceforge.jtds.jdbc.SQLWarningChain.addOrReturn(SQLWarningChain.java:91) at net.sourceforge.jtds.jdbc.Tds.submitProcedure(Tds.java:235) at net.sourceforge.jtds.jdbc.PreparedStatement_base.submitProcedure(PreparedStatement_base.java:195)
    via by William Crighton [CCC],
  • "AT" is used as an alias in one of the sql statements from Jira. see: at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:619) 2008-04-29 16:18:53,893 http-8080-Processor20 ERROR [ext.charting.field.ResolutionDateDAO] org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following: select min( at.CREATED) from jiraaction at , jiraissue it where at.issueid = ? and at.issueid = it.ID and at.actiontype = 'comment' and it.REPORTER != at.AUTHOR (GDS Exception. 335544569. Dynamic SQL Error SQL error code = -104 Token unknown - line 1, column 13 at) org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:select min( at.CREATED) from jiraaction at , jiraissue it where at.issueid = ? and at.issueid = it.ID and at.actiontype = 'comment' and it.REPORTER != at.AUTHOR (GDS Exception. 335544569. Dynamic SQL Error SQL error code = -104 Token unknown - line 1, column 13 at) at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:330) at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:302) at com.atlassian.jira.ext.charting.field.AbstractSingleDateDAO.calculateDate(AbstractSingleDateDAO.java:54) at com.atlassian.jira.ext.charting.field.DateOfFirstResponseCFType.calculateFirstResponseDate(DateOfFirstResponseCFType.java:46) at com.atlassian.jira.ext.charting.field.DateOfFirstResponseCFType.getValueFromIssue(DateOfFirstResponseCFType.java:34) at com.atlassian.jira.issue.fields.CustomFieldImpl.getValue(CustomFieldImpl.java:266)
    via by Derryck Welas,
    • org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, username, PASSWORD_HASH FROM userbase WHERE username=? (Invalid state, the Connection object is closed.) at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:330) at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1024) at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595) at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767) at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:744) at com.opensymphony.user.provider.ofbiz.OFBizAbstractProvider.findUser(OFBizAbstractProvider.java:156) at com.opensymphony.user.provider.ofbiz.OFBizAccessProvider.handles(OFBizAccessProvider.java:116) at com.opensymphony.user.UserManager.getProvider(UserManager.java:275) at com.opensymphony.user.UserManager$Accessor.getAccessProvider(UserManager.java:392) at com.opensymphony.user.Entity.getAccessProvider(Entity.java:100) at com.opensymphony.user.User.getGroups(User.java:91) at com.atlassian.jira.security.DefaultGlobalPermissionManager.hasPermission(DefaultGlobalPermissionManager.java:161) at com.atlassian.jira.security.AbstractPermissionManager.hasPermission(AbstractPermissionManager.java:85) at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.atlassian.util.profiling.object.ObjectProfiler.profiledInvoke(ObjectProfiler.java:71) at com.atlassian.jira.config.component.SwitchingInvocationHandler.invoke(SwitchingInvocationHandler.java:28) at $Proxy1.hasPermission(Unknown Source) at com.atlassian.jira.security.JiraRoleMapper.canLogin(JiraRoleMapper.java:32) at com.atlassian.seraph.auth.DefaultAuthenticator.login(DefaultAuthenticator.java:99) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:125) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.jira.web.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:25) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.jira.web.filters.gzip.GzipFilter.doFilter(GzipFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Unknown Source)
    No Bugmate found.