java.sql.SQLException: No operations allowed after connection closed.

Atlassian JIRA | Jeff Turner | 1 decade ago
  1. 0

    [JRA-7972] Workflow migrations hang - Atlassian JIRA

    atlassian.com | 12 months ago
    java.sql.SQLException: No operations allowed after connection closed.
  2. 0

    [JRA-7972] Workflow migrations hang - Atlassian JIRA

    atlassian.com | 12 months ago
    java.sql.SQLException: No operations allowed after connection closed.
  3. 0

    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)

    Atlassian JIRA | 1 decade ago | Jeff Turner
    java.sql.SQLException: No operations allowed after connection closed.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    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)

    Atlassian JIRA | 1 decade ago | Jeff Turner
    java.sql.SQLException: No operations allowed after connection closed.

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      No operations allowed after connection closed.

      at com.mysql.jdbc.Connection.checkClosed()
    2. MySQL jdbc
      Connection.rollback
      1. com.mysql.jdbc.Connection.checkClosed(Connection.java:2647)
      2. com.mysql.jdbc.Connection.rollback(Connection.java:1408)
      2 frames
    3. org.apache.tomcat
      PoolingDataSource$PoolGuardConnectionWrapper.rollback
      1. org.apache.tomcat.dbcp.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:265)
      2. org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:288)
      2 frames
    4. org.ofbiz.core
      SQLProcessor.finalize
      1. org.ofbiz.core.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:131)
      2. org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:114)
      3. org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:153)
      4. org.ofbiz.core.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:694)
      4 frames
    5. Java RT
      Finalizer$FinalizerThread.run
      1. java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)
      2. java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83)
      3. java.lang.ref.Finalizer.access$100(Finalizer.java:14)
      4. java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160)
      4 frames