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)