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

Workflow migrations hang

    XMLWordPrintable

Details

    Description

      In JIRA 3.3 and 3.3.1, it appears that workflow migrations hang if they take more than about 10s to complete. In the logs, one sees:

      2005-09-16 16:24:28,077 WARN [core.entity.jdbc.SQLProcessor] [SQLProcessor.rollback]: SQL Exception while rolling back insert. Error was:java.sql.SQLException: No operations allowed after connection closed.
      2005-09-16 16:24:28,079 WARN [NoModule] org.ofbiz.core.entity.jdbc.SQLProcessor
      java.sql.SQLException: No operations allowed after connection closed.
      at com.mysql.jdbc.Connection.checkClosed(Connection.java:2647)
      at com.mysql.jdbc.Connection.rollback(Connection.java:1408)
      at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:265)
      at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:288)
      at org.ofbiz.core.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:131)
      at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:114)
      at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:153)
      at org.ofbiz.core.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:694)
      at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)
      at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83)
      at java.lang.ref.Finalizer.access$100(Finalizer.java:14)
      at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160)
      2005-09-16 16:24:28,098 WARN [NoModule] [SQLProcessor.commit]: SQL Exception occurred on commit. Error was:java.sql.SQLException: No operations allowed after connection closed.
      2005-09-16 16:24:28,098 ERROR [NoModule] Error closing the result, connection, etc in finalize EntityListIterator
      org.ofbiz.core.entity.GenericDataSourceException: SQL Exception occurred on commit (No operations allowed after connection closed.)
      at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:116)
      at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:153)
      at org.ofbiz.core.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:694)
      at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)
      at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83)
      at java.lang.ref.Finalizer.access$100(Finalizer.java:14)
      at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160)
      java.sql.SQLException: No operations allowed after connection closed.
      at com.mysql.jdbc.Connection.checkClosed(Connection.java:2647)
      at com.mysql.jdbc.Connection.commit(Connection.java:1039)
      at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.commit(DelegatingConnection.java:238)
      at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:199)
      at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:112)
      at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:153)
      at org.ofbiz.core.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:694)
      at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)
      at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83)
      at java.lang.ref.Finalizer.access$100(Finalizer.java:14)
      at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160)
      2005-09-16 16:24:28,101 WARN [core.entity.jdbc.SQLProcessor] [SQLProcessor.rollback]: SQL Exception while rolling back insert. Error was:java.sql.SQLException: No operations allowed after connection closed.
      2005-09-16 16:24:28,101 WARN [NoModule] org.ofbiz.core.entity.jdbc.SQLProcessor
      java.sql.SQLException: No operations allowed after connection closed.
      at com.mysql.jdbc.Connection.checkClosed(Connection.java:2647)
      at com.mysql.jdbc.Connection.rollback(Connection.java:1408)
      at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:265) at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:288)
      at org.ofbiz.core.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:131)
      at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:114) at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:153)
      at org.ofbiz.core.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:694)
      at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)
      at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83)
      at java.lang.ref.Finalizer.access$100(Finalizer.java:14)
      at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160)

      Attachments

        Activity

          People

            keith@atlassian.com Keith Brophy
            7ee5c68a815f Jeff Turner
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: