Details
-
Bug
-
Resolution: Obsolete
-
Medium
-
None
-
3.5.3
-
3.05
-
Description
The FogBugz importer is blowing up near the end of a large import:
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