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

Getting an IO exception from the postgres driver when upgrading JAC data from the ResolutionDate upgrade task

    XMLWordPrintable

Details

    Description

      I am seeing this exception at the end of the upgrade task

      2009-08-04 11:40:20,696 main ERROR     [atlassian.jira.upgrade.UpgradeManagerImpl] Exception thrown during upgrade: org.ofbiz.core.entity.GenericDataSourceException
      : Generic Entity Exception occurred in deleteAll (SQL Exception while executing the following:DELETE FROM public.customfieldvalue WHERE ID=? (An I/O error occured w
      hile sending to the backend.))
      com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteAll (SQL Exception wh
      ile executing the following:DELETE FROM public.customfieldvalue WHERE ID=? (An I/O error occured while sending to the backend.))
              at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.removeAll(DefaultOfBizDelegator.java:154)
              at com.atlassian.jira.issue.customfields.persistence.OfBizCustomFieldValuePersister.removeAllValues(OfBizCustomFieldValuePersister.java:200)
              at com.atlassian.jira.issue.customfields.persistence.EagerLoadingOfBizCustomFieldPersister.removeAllValues(EagerLoadingOfBizCustomFieldPersister.java:71)
              at com.atlassian.jira.issue.managers.DefaultCustomFieldManager.removeCustomFieldPossiblyLeavingOrphanedData(DefaultCustomFieldManager.java:435)
              at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build401.removeCustomFields(UpgradeTask_Build401.java:364)
              at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build401.doUpgrade(UpgradeTask_Build401.java:134)
              at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSucess(UpgradeManagerImpl.java:670)
              at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:567)
              at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:401)
              at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:351)
              at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:308)
              at com.atlassian.jira.upgrade.UpgradeLauncher.checkIfUpgradeNeeded(UpgradeLauncher.java:85)
              at com.atlassian.jira.upgrade.UpgradeLauncher.contextInitialized(UpgradeLauncher.java:45)
              at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3763)        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4211)
              at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
              at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
              at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
              at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
              at org.apache.catalina.core.StandardService.start(StandardService.java:450)
              at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
              at org.apache.catalina.startup.Catalina.start(Catalina.java:551)        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
              at java.lang.reflect.Method.invoke(Method.java:597)        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
              at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)Caused by: org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteAll (SQL Exception while executing the following:DELETE FROM
       public.customfieldvalue WHERE ID=? (An I/O error occured while sending to the backend.))        at org.ofbiz.core.entity.GenericDAO.deleteAll(GenericDAO.java:1284)
              at org.ofbiz.core.entity.GenericHelperDAO.removeAll(GenericHelperDAO.java:236)
              at org.ofbiz.core.entity.GenericDelegator.removeAll(GenericDelegator.java:1580)
              at org.ofbiz.core.entity.GenericDelegator.removeAll(GenericDelegator.java:1523)
              at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.removeAll(DefaultOfBizDelegator.java:150)
      

      It also looks like JIRA does not completely stop itself when a runtime exception is thrown from the upgrade task since the services start running.

      In the case of 4.0 the mail service tries to send out subscriptions against saved filters that have not been converted to JQL which is not going to work.

      Attachments

        Activity

          People

            andreask@atlassian.com Andreas Knecht (Inactive)
            dylan@atlassian.com Dylan Etkin [Atlassian]
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: