FogBugz importer fails: database connection closed during import run

XMLWordPrintable

    • 3.05

      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
      

              Assignee:
              Unassigned
              Reporter:
              Jeff Turner
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved:

                  Estimated:
                  Original Estimate - 4h
                  4h
                  Remaining:
                  Time Spent - 2h Remaining Estimate - 2h
                  2h
                  Logged:
                  Time Spent - 2h Remaining Estimate - 2h
                  2h