Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-9900

FogBugz importer fails: database connection closed during import run

    XMLWordPrintable

Details

    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
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            7ee5c68a815f Jeff Turner
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

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