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

"Can't call rollback when autocommit=true" errors when using XA DataSource

    XMLWordPrintable

Details

    • Suggestion
    • Resolution: Resolved Locally
    • None
    • None
    • None
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

    Description

      In OC4J 9.0.4, if JIRA is configured to use "jdbc/xa/JiraXADS" instead of "jdbc/JiraDS", then it dies on startup with this error:

      ==> log/server.log <==
      05/11/22 09:40:57 9.0.4.0.0 Started
      05/11/22 09:40:57 9.0.4.0.0 Started
      2005-11-22 09:41:05,556 [core.entity.jdbc.DatabaseUtil] Entity "Action" has no table in the database
      2005-11-22 09:41:05,571 [core.entity.jdbc.DatabaseUtil] Entity "ChangeGroup" has no table in the database
      .....
      2005-11-22 09:41:06,682 [core.entity.jdbc.DatabaseUtil] Entity "VersionControl" has no table in the database
      2005-11-22 09:41:06,692 [core.entity.jdbc.DatabaseUtil] Entity "Workflow" has no table in the database
      2005-11-22 09:41:06,701 [core.entity.jdbc.DatabaseUtil] Entity "WorkflowScheme" has no table in the database
      2005-11-22 09:41:06,710 [core.entity.jdbc.DatabaseUtil] Entity "WorkflowSchemeEntity" has no table in the database
      2005-11-22 09:41:08,319 WARN [core.entity.jdbc.SQLProcessor] [SQLProcessor.rollback]: SQL Exception while rolling back insert. Error was:java.sql.SQLException: Can't call rollback when autocommit=true
      2005-11-22 09:41:08,329 WARN [NoModule] org.ofbiz.core.entity.jdbc.SQLProcessor
      java.sql.SQLException: Can't call rollback when autocommit=true
              at com.mysql.jdbc.Connection.rollback(Connection.java:4686)
              at com.evermind.sql.FilterConnection.rollback(FilterConnection.java:187)
              at com.evermind.sql.FilterConnection.rollback(FilterConnection.java:187)
              at org.ofbiz.core.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:131)
              at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:114)
              at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:153)
              at org.ofbiz.core.entity.EntityListIterator.close(EntityListIterator.java:102)
              at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:599)
              at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134)
              at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782)
              at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767)
              at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:744)
              at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.getKeys(OFBizPropertySet.java:87)
              at com.opensymphony.module.propertyset.AbstractPropertySet.getKeys(AbstractPropertySet.java:292)
              at com.op        at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:153)
              at org.ofbiz.core.entity.EntityListIterator.close(EntityListIterator.java:102)
              at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:599)
              at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134)
              at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782)
              at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767)
              at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:744)
              at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.getKeys(OFBizPropertySet.java:87)
              at com.opensymphony.module.propertyset.AbstractPropertySet.getKeys(AbstractPropertySet.java:292)
              at com.opensymphony.module.propertyset.PropertySetCloner.cloneProperties(PropertySetCloner.java:114)
              at com.opensymphony.module.propertyset.PropertySetManager.clone(PropertySetManager.java:61)
              at com.atlassian.jira.propertyset.JiraCachingPropertySet.init(JiraCachingPropertySet.java:411)
              at com.opensymphony.module.propertyset.PropertySetManager.getInstance(PropertySetManager.java:45)
              at com.opensymphony.module.propertyset.PropertySetManager.getInstance(PropertySetManager.java:22)
              at com.atlassian.jira.config.properties.PropertiesManager.loadPropertySet(PropertiesManager.java:79)
              at com.atlassian.jira.config.properties.PropertiesManager.<init>(PropertiesManager.java:25)
              at com.atlassian.jira.config.properties.PropertiesManager.getInstance(PropertiesManager.java:35)
              at com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getPropertiesManager(ApplicationPropertiesImpl.java:43)
              at com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getString(ApplicationPropertiesImpl.java:69)
              at com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getDefaultBackedString(ApplicationPropertiesImpl.java:88)
              at com.atlassian.jira.ComponentManager.registerExtensions(ComponentManager.java:315)
              at com.atlassian.jira.ComponentManager.initialise(ComponentManager.java:213)
              at com.atlassian.jira.ComponentManager.<init>(ComponentManager.java:200)
              at com.atlassian.jira.ComponentManager.<clinit>(ComponentManager.java:186)
              at com.atlassian.jira.config.webwork.JiraConfiguration.this(JiraConfiguration.java:26)
              at com.atlassian.jira.config.webwork.JiraConfiguration.<init>(JiraConfiguration.java:23)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
              at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
              at java.lang.Class.newInstance0(Class.java:350)
              at java.lang.Class.newInstance(Class.java:303)
              at webwork.config.DefaultConfiguration.<init>(DefaultConfiguration.java:113)
              at webwork.config.Configuration.getDefaultConfiguration(Configuration.java:129)
      ensymphony.module.propertyset.PropertySetCloner.cloneProperties(PropertySetCloner.java:114)
      

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: