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 15 days of up time, JIRA hung on us. The login page could be accessed, but nothing else. In the stdout.log were 7 instances of the following exception. I am hypothesizing that there is an issue with the database connection pool (pool configuration is at the bottom of the description). There was little else of note in the logs. Do you have any recommendations for additional DBCP settings, e.g. setting maxWait or tweaking eviction or abandoned settings? 2005-05-24 14:44:58,089 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. 2005-05-24 14:44:58,089 WARN [NoModule] org.ofbiz.core.entity.jdbc.SQLProcessor java.sql.SQLException: Invalid state, the Connection object is closed. at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1164) at net.sourceforge.jtds.jdbc.ConnectionJDBC2.rollback(ConnectionJDBC2.java:1492) at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:265) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:333) at org.ofbiz.core.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:128) at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:112) at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:150) at org.ofbiz.core.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:668) 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-05-24 14:44:58,089 ERROR [NoModule] Error closing the result, connection, etc in finalize EntityListIterator org.ofbiz.core.entity.GenericDataSourceException: SQL Exception occurred on commit (I/O Error: Socket closed) at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:113) at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:150) at org.ofbiz.core.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:668) 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: I/O Error: Socket closed at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1004) at net.sourceforge.jtds.jdbc.TdsCore.submitSQL(TdsCore.java:848) at net.sourceforge.jtds.jdbc.ConnectionJDBC2.commit(ConnectionJDBC2.java:1486) at org.apache.commons.dbcp.DelegatingConnection.commit(DelegatingConnection.java:248) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:244) at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:110) at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:150) at org.ofbiz.core.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:668) 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) Caused by: java.net.SocketException: Socket closed at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:99) at java.net.SocketOutputStream.write(SocketOutputStream.java:136) at java.io.DataOutputStream.write(DataOutputStream.java:85) at net.sourceforge.jtds.jdbc.SharedSocket.sendNetPacket(SharedSocket.java:588) at net.sourceforge.jtds.jdbc.RequestStream.putPacket(RequestStream.java:556) at net.sourceforge.jtds.jdbc.RequestStream.flush(RequestStream.java:504) at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:991) ... 11 more DBCP configuration from server.xml: <Resource name="jdbc/JiraDS" auth="Container" type="javax.sql.DataSource"/> <ResourceParams name="jdbc/JiraDS"> <parameter> <name>driverClassName</name> <!-- NOTE: if you change the database type, you will need to change it in atlassian-jira/WEB-INF/classes/entityengine.xml --> <value>net.sourceforge.jtds.jdbc.Driver</value> </parameter> <parameter> <name>url</name> <value>jdbc:jtds:sqlserver://localhost:1433/jiradb</value> </parameter> <parameter> <name>username</name> <value>jira</value> </parameter> <parameter> <name>password</name> <value>jira</value> </parameter> <!-- NOTE: If NOT using hsqldb, comment next two parameters out --> <!-- Give unused connections 4 secs before eviction. --> <!-- <parameter> <name>minEvictableIdleTimeMillis</name> <value>4000</value> </parameter> --> <!-- Check for evictions every 5 secs. --> <!-- <parameter> <name>timeBetweenEvictionRunsMillis</name> <value>5000</value> </parameter> --> <parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter> </ResourceParams>
    via by Joshua Spiewak,
  • After 15 days of up time, JIRA hung on us. The login page could be accessed, but nothing else. In the stdout.log were 7 instances of the following exception. I am hypothesizing that there is an issue with the database connection pool (pool configuration is at the bottom of the description). There was little else of note in the logs. Do you have any recommendations for additional DBCP settings, e.g. setting maxWait or tweaking eviction or abandoned settings? 2005-05-24 14:44:58,089 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. 2005-05-24 14:44:58,089 WARN [NoModule] org.ofbiz.core.entity.jdbc.SQLProcessor java.sql.SQLException: Invalid state, the Connection object is closed. at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1164) at net.sourceforge.jtds.jdbc.ConnectionJDBC2.rollback(ConnectionJDBC2.java:1492) at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:265) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:333) at org.ofbiz.core.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:128) at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:112) at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:150) at org.ofbiz.core.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:668) 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-05-24 14:44:58,089 ERROR [NoModule] Error closing the result, connection, etc in finalize EntityListIterator org.ofbiz.core.entity.GenericDataSourceException: SQL Exception occurred on commit (I/O Error: Socket closed) at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:113) at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:150) at org.ofbiz.core.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:668) 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: I/O Error: Socket closed at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1004) at net.sourceforge.jtds.jdbc.TdsCore.submitSQL(TdsCore.java:848) at net.sourceforge.jtds.jdbc.ConnectionJDBC2.commit(ConnectionJDBC2.java:1486) at org.apache.commons.dbcp.DelegatingConnection.commit(DelegatingConnection.java:248) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:244) at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:110) at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:150) at org.ofbiz.core.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:668) 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) Caused by: java.net.SocketException: Socket closed at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:99) at java.net.SocketOutputStream.write(SocketOutputStream.java:136) at java.io.DataOutputStream.write(DataOutputStream.java:85) at net.sourceforge.jtds.jdbc.SharedSocket.sendNetPacket(SharedSocket.java:588) at net.sourceforge.jtds.jdbc.RequestStream.putPacket(RequestStream.java:556) at net.sourceforge.jtds.jdbc.RequestStream.flush(RequestStream.java:504) at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:991) ... 11 more DBCP configuration from server.xml: <Resource name="jdbc/JiraDS" auth="Container" type="javax.sql.DataSource"/> <ResourceParams name="jdbc/JiraDS"> <parameter> <name>driverClassName</name> <!-- NOTE: if you change the database type, you will need to change it in atlassian-jira/WEB-INF/classes/entityengine.xml --> <value>net.sourceforge.jtds.jdbc.Driver</value> </parameter> <parameter> <name>url</name> <value>jdbc:jtds:sqlserver://localhost:1433/jiradb</value> </parameter> <parameter> <name>username</name> <value>jira</value> </parameter> <parameter> <name>password</name> <value>jira</value> </parameter> <!-- NOTE: If NOT using hsqldb, comment next two parameters out --> <!-- Give unused connections 4 secs before eviction. --> <!-- <parameter> <name>minEvictableIdleTimeMillis</name> <value>4000</value> </parameter> --> <!-- Check for evictions every 5 secs. --> <!-- <parameter> <name>timeBetweenEvictionRunsMillis</name> <value>5000</value> </parameter> --> <parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter> </ResourceParams>
    via by Joshua Spiewak,
  • 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,
  • 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)
    via by Jeff Turner,
  • 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)
    via by Jeff Turner,
  • 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,
    • org.ofbiz.core.entity.GenericDataSourceException: SQL Exception occurred on commit (I/O Error: Socket closed) at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:113) at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:150) at org.ofbiz.core.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:668) 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)
    No Bugmate found.