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)

Atlassian JIRA | Dylan Etkin [Atlassian] | 8 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    I am seeing this exception at the end of the upgrade task {code} 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) {code} 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.

    Atlassian JIRA | 8 years ago | Dylan Etkin [Atlassian]
    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)
  2. 0

    I am seeing this exception at the end of the upgrade task {code} 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) {code} 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.

    Atlassian JIRA | 8 years ago | Dylan Etkin [Atlassian]
    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)

    Root Cause Analysis

    1. 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()
    2. org.ofbiz.core
      GenericDelegator.removeAll
      1. org.ofbiz.core.entity.GenericHelperDAO.removeAll(GenericHelperDAO.java:236)
      2. org.ofbiz.core.entity.GenericDelegator.removeAll(GenericDelegator.java:1580)
      3. org.ofbiz.core.entity.GenericDelegator.removeAll(GenericDelegator.java:1523)
      3 frames
    3. com.atlassian.jira
      DefaultOfBizDelegator.removeAll
      1. com.atlassian.jira.ofbiz.DefaultOfBizDelegator.removeAll(DefaultOfBizDelegator.java:150)
      1 frame