setupcom.atlassian.studio.host.common.DataSetupException: Error encountered updating group names in SQL statements

Atlassian JIRA | Adam Jakubowski | 1 year ago
  1. 0

    This bug only occurs when running on postgresql 9 driver. {noformat} 2015-07-30 23:03:36,446 localhost-startStop-1 ERROR anonymous [jira.studio.startup.JiraInitialData] Error doing studio specific setupcom.atlassian.studio.host.common.DataSetupException: Error encountered updating group names in SQL statements at com.atlassian.studio.jira.importer.impl.PermissionsManipulationServiceImpl.moveGroupPermissions(PermissionsManipulationServiceImpl.java:195) at com.atlassian.studio.jira.importer.impl.PermissionsManipulationServiceImpl.moveGroupWithoutMovingMemberships(PermissionsManipulationServiceImpl.java:220) at com.atlassian.studio.jira.importer.impl.LegacyStudioImportManager.migratePermissionsAndGroupsForOnDemand(LegacyStudioImportManager.java:126) at com.atlassian.studio.jira.importer.impl.LegacyStudioImportManager.postImportStudify(LegacyStudioImportManager.java:100) at com.atlassian.studio.jira.importer.impl.StudioImporterFacade.postImportStudify(StudioImporterFacade.java:92) at com.atlassian.jira.studio.startup.JiraInitialData.start(JiraInitialData.java:142) at com.atlassian.jira.studio.startup.Activator.start(Activator.java:41) at com.atlassian.jira.studio.startup.StartupHooks.afterJiraStart(StartupHooks.java:64) at com.atlassian.jira.startup.LauncherContextListener.contextInitialized(LauncherContextListener.java:73) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4992) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5490) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1575) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1565) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: org.postgresql.util.PSQLException: Cannot commit when autoCommit is enabled. at org.postgresql.jdbc2.AbstractJdbc2Connection.commit(AbstractJdbc2Connection.java:705) at org.apache.commons.dbcp.DelegatingConnection.commit(DelegatingConnection.java:334) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:211) at org.ofbiz.core.entity.jdbc.interceptors.connection.DelegatingConnection.commit(DelegatingConnection.java:66) at com.atlassian.studio.jira.importer.impl.PermissionsManipulationServiceImpl.moveGroupPermissions(PermissionsManipulationServiceImpl.java:191) {noformat}

    Atlassian JIRA | 1 year ago | Adam Jakubowski
    setupcom.atlassian.studio.host.common.DataSetupException: Error encountered updating group names in SQL statements
  2. 0

    This bug only occurs when running on postgresql 9 driver. {noformat} 2015-07-30 23:03:36,446 localhost-startStop-1 ERROR anonymous [jira.studio.startup.JiraInitialData] Error doing studio specific setupcom.atlassian.studio.host.common.DataSetupException: Error encountered updating group names in SQL statements at com.atlassian.studio.jira.importer.impl.PermissionsManipulationServiceImpl.moveGroupPermissions(PermissionsManipulationServiceImpl.java:195) at com.atlassian.studio.jira.importer.impl.PermissionsManipulationServiceImpl.moveGroupWithoutMovingMemberships(PermissionsManipulationServiceImpl.java:220) at com.atlassian.studio.jira.importer.impl.LegacyStudioImportManager.migratePermissionsAndGroupsForOnDemand(LegacyStudioImportManager.java:126) at com.atlassian.studio.jira.importer.impl.LegacyStudioImportManager.postImportStudify(LegacyStudioImportManager.java:100) at com.atlassian.studio.jira.importer.impl.StudioImporterFacade.postImportStudify(StudioImporterFacade.java:92) at com.atlassian.jira.studio.startup.JiraInitialData.start(JiraInitialData.java:142) at com.atlassian.jira.studio.startup.Activator.start(Activator.java:41) at com.atlassian.jira.studio.startup.StartupHooks.afterJiraStart(StartupHooks.java:64) at com.atlassian.jira.startup.LauncherContextListener.contextInitialized(LauncherContextListener.java:73) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4992) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5490) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1575) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1565) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: org.postgresql.util.PSQLException: Cannot commit when autoCommit is enabled. at org.postgresql.jdbc2.AbstractJdbc2Connection.commit(AbstractJdbc2Connection.java:705) at org.apache.commons.dbcp.DelegatingConnection.commit(DelegatingConnection.java:334) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:211) at org.ofbiz.core.entity.jdbc.interceptors.connection.DelegatingConnection.commit(DelegatingConnection.java:66) at com.atlassian.studio.jira.importer.impl.PermissionsManipulationServiceImpl.moveGroupPermissions(PermissionsManipulationServiceImpl.java:191) {noformat}

    Atlassian JIRA | 1 year ago | Adam Jakubowski
    setupcom.atlassian.studio.host.common.DataSetupException: Error encountered updating group names in SQL statements
  3. 0

    Getting "cannot commit when autocommit is enabled" exception while working with CachedRowSet in JDBC

    Stack Overflow | 4 years ago | user2191938
    org.postgresql.util.PSQLException: Cannot commit when autoCommit is enabled.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Cannot commit when auto commit is enabled (JDBC)

    Stack Overflow | 4 years ago | user2250795
    org.postgresql.util.PSQLException: Cannot commit when autoCommit is enabled.
  6. 0

    Postgresql and GlassFish - cannot commit when autoCommit is enabled

    Stack Overflow | 2 years ago
    javax.resource.spi.LocalTransactionException: Cannot commit when autoCommit is enabled.

    1 unregistered visitors
    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. org.postgresql.util.PSQLException

      Cannot commit when autoCommit is enabled.

      at org.postgresql.jdbc2.AbstractJdbc2Connection.commit()
    2. PostgreSQL JDBC Driver
      AbstractJdbc2Connection.commit
      1. org.postgresql.jdbc2.AbstractJdbc2Connection.commit(AbstractJdbc2Connection.java:705)
      1 frame
    3. Commons DBCP
      PoolingDataSource$PoolGuardConnectionWrapper.commit
      1. org.apache.commons.dbcp.DelegatingConnection.commit(DelegatingConnection.java:334)
      2. org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:211)
      2 frames
    4. org.ofbiz.core
      DelegatingConnection.commit
      1. org.ofbiz.core.entity.jdbc.interceptors.connection.DelegatingConnection.commit(DelegatingConnection.java:66)
      1 frame
    5. com.atlassian.studio
      PermissionsManipulationServiceImpl.moveGroupPermissions
      1. com.atlassian.studio.jira.importer.impl.PermissionsManipulationServiceImpl.moveGroupPermissions(PermissionsManipulationServiceImpl.java:191)
      1 frame