java.sql.SQLException: Can't call rollback when autocommit=true

Atlassian JIRA | Jeff Turner | 1 decade ago
  1. 0

    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: {noformat} ==> 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) {noformat}

    Atlassian JIRA | 1 decade ago | Jeff Turner
    java.sql.SQLException: Can't call rollback when autocommit=true
  2. 0

    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: {noformat} ==> 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) {noformat}

    Atlassian JIRA | 1 decade ago | Jeff Turner
    java.sql.SQLException: Can't call rollback when autocommit=true
  3. 0

    "java.sql.SQLException: SAVEPOINT _667166fe_13ab4b3e3de__8000 does not exist" exception occur in nested transaction rollback ?

    Stack Overflow | 4 years ago | gaurav kumar
    java.sql.SQLException: SAVEPOINT _667166fe_13ab4b3e3de__8000 does not exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    [JRA-7972] Workflow migrations hang - Atlassian JIRA

    atlassian.com | 12 months ago
    java.sql.SQLException: No operations allowed after connection closed.

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Can't call rollback when autocommit=true

      at com.mysql.jdbc.Connection.rollback()
    2. MySQL jdbc
      Connection.rollback
      1. com.mysql.jdbc.Connection.rollback(Connection.java:4686)
      1 frame
    3. com.evermind.sql
      FilterConnection.rollback
      1. com.evermind.sql.FilterConnection.rollback(FilterConnection.java:187)
      2. com.evermind.sql.FilterConnection.rollback(FilterConnection.java:187)
      2 frames
    4. org.ofbiz.core
      GenericDelegator.findByAnd
      1. org.ofbiz.core.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:131)
      2. org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:114)
      3. org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:153)
      4. org.ofbiz.core.entity.EntityListIterator.close(EntityListIterator.java:102)
      5. org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:599)
      6. org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:134)
      7. org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:782)
      8. org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:767)
      9. org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:744)
      9 frames
    5. com.opensymphony.module
      AbstractPropertySet.getKeys
      1. com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.getKeys(OFBizPropertySet.java:87)
      2. com.opensymphony.module.propertyset.AbstractPropertySet.getKeys(AbstractPropertySet.java:292)
      2 frames