Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-6738

Exception thrown in QuickLinkServlet

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Medium
    • None
    • 3.1.1
    • None
    • Resin 3.0.12
      jTDS 1.0.3
      MSSQL 2000

    Description

      I find several execptions and I get some reports of updates that are failing but I am not sure these are related:

      2005-05-18 15:01:28,812 WARN [atlassian.jira.servlet.QuickLinkServlet] Error retrieving ChangeItems to search for moved issues. If using MSSQL, this is probably related to JRA-5067. Exception message: 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.)
      [15:01:28.812] Closing dangling connections. All connections must have a close() in a finally block.
      [15:01:28.812] java.lang.IllegalStateException: unclosed connection: UserPoolItem[jdbc/JiraDS,98611] was allocated at
      [15:01:28.812] at com.caucho.jca.UserPoolItem.<init>(UserPoolItem.java:112)
      [15:01:28.812] at com.caucho.jca.UserPoolItem.<init>(UserPoolItem.java:118)
      [15:01:28.812] at com.caucho.jca.PoolItem.toActive(PoolItem.java:253)
      [15:01:28.812] at com.caucho.jca.ConnectionPool.allocateIdle(ConnectionPool.java:735)
      [15:01:28.812] at com.caucho.jca.ConnectionPool.allocatePool(ConnectionPool.java:654)
      [15:01:28.812] at com.caucho.jca.ConnectionPool.allocate(ConnectionPool.java:619)
      [15:01:28.812] at com.caucho.jca.ConnectionPool.allocateConnection(ConnectionPool.java:516)
      [15:01:28.812] at com.caucho.sql.DataSourceImpl.getConnection(DataSourceImpl.java:69)
      [15:01:28.812] at com.caucho.sql.DBPool.getConnection(DBPool.java:582)
      [15:01:28.812] at org.ofbiz.core.entity.transaction.JNDIFactory.getJndiConnection(JNDIFactory.java:168)
      [15:01:28.812] at org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:140)
      [15:01:28.812] at org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:99)
      [15:01:28.812] at org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:53)
      [15:01:28.812] at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:211)
      [15:01:28.812] at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:283)
      [15:01:28.812] at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1024)
      [15:01:28.812] at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:595)
      [15:01:28.812] at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134)
      [15:01:28.812] at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782)
      [15:01:28.812] at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767)
      [15:01:28.812] at com.atlassian.jira.servlet.QuickLinkServlet.findMovedIssue(QuickLinkServlet.java:114)
      [15:01:28.812] at com.atlassian.jira.servlet.QuickLinkServlet.service(QuickLinkServlet.java:46)
      [15:01:28.812] at javax.servlet.http.HttpServlet.service(HttpServlet.java:90)
      [15:01:28.812] at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:99)
      [15:01:28.812] at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:142)
      [15:01:28.812] at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:58)
      [15:01:28.812] at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
      [15:01:28.812] at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:168)
      [15:01:28.812] at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
      [15:01:28.812] at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:177)
      [15:01:28.812] at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
      [15:01:28.812] at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132)
      [15:01:28.812] at com.atlassian.jira.web.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:25)
      [15:01:28.812] at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
      [15:01:28.812] at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:37)
      [15:01:28.812] at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
      [15:01:28.812] at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:36)
      [15:01:28.812] at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
      [15:01:28.812] at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:163)
      [15:01:28.812] at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:208)
      [15:01:28.812] at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:259)
      [15:01:28.812] at com.caucho.server.port.TcpConnection.run(TcpConnection.java:341)
      [15:01:28.812] at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:467)
      [15:01:28.812] at com.caucho.util.ThreadPool.run(ThreadPool.java:408)
      [15:01:28.812] at java.lang.Thread.run(Thread.java:534)
      [15:01:28.812] java.lang.IllegalStateException: Connection UserConnection[com.caucho.sql.ManagedConnectionImpl@b1221b] was not closed. Connections must have a close() in a finally block.
      [15:01:28.812] at com.caucho.jca.UserTransactionImpl.abortTransaction(UserTransactionImpl.java:454)
      [15:01:28.812] at com.caucho.jca.UserTransactionProxy.abortTransaction(UserTransactionProxy.java:174)
      [15:01:28.812] at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:183)
      [15:01:28.812] at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:208)
      [15:01:28.812] at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:259)
      [15:01:28.812] at com.caucho.server.port.TcpConnection.run(TcpConnection.java:341)
      [15:01:28.812] at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:467)
      [15:01:28.812] at com.caucho.util.ThreadPool.run(ThreadPool.java:408)
      [15:01:28.812] at java.lang.Thread.run(Thread.java:534)

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              9f222f87c041 Furore Jira Admin
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: