org.postgresql.util.PSQLException: Cannot rollback when autoCommit is enabled.

Google Groups | KajMagnus | 9 months ago
  1. 0

    How do I use HikariCP for both read-only and read-write connections?

    Google Groups | 9 months ago | KajMagnus
    org.postgresql.util.PSQLException: Cannot rollback when autoCommit is enabled.
  2. 0

    Transactional evolutions with PostgreSQL are broken

    GitHub | 1 year ago | teozkr
    play.api.http.HttpErrorHandlerExceptions$$anon$1: Execution exception[[PSQLException: Cannot rollback when autoCommit is enabled.]]
  3. 0

    Steps: Enable Jpivot button in 5.0: 1. Stop Server, Go to location: C:\Program Files\pentaho\server\biserver-ee\pentaho-solutions\system\pentaho-jpivot-plugin-legacy 2. Delete the settings.xml 3. Rename settings.xml.enabled to settings.xml. Start Server 4. Login to PUC, go to opened perspective 5. Click on New dropdown 6. Click New JPivot View 7. Click OK BUG: Error: An error occurred while rendering Pivot.jsp. Please see the log for details. Log File: 2013-08-12 16:13:30,775 ERROR [org.pentaho.platform.engine.services.runtime.RuntimeContext] a81d5998-038b-11e3-91a0-d4bed936d5b7:RUNTIME:context-1205146513-1376338410708:default.xjpivot org.postgresql.util.PSQLException: Cannot rollback when autoCommit is enabled. org.pentaho.platform.api.engine.AuditException: org.postgresql.util.PSQLException: Cannot rollback when autoCommit is enabled. at org.pentaho.platform.engine.services.audit.AuditSQLEntry.auditAll(AuditSQLEntry.java:144) at org.pentaho.platform.engine.core.audit.AuditEntry.auditAll(AuditEntry.java:60) at org.pentaho.platform.engine.core.audit.AuditEntry.auditJobDuration(AuditEntry.java:49) at org.pentaho.platform.engine.core.audit.AuditHelper.audit(AuditHelper.java:91) at org.pentaho.platform.engine.core.audit.AuditHelper.audit(AuditHelper.java:42) at org.pentaho.platform.engine.services.runtime.RuntimeContext.audit(RuntimeContext.java:1683) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1294) at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1176) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1122) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1004) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:910) at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:386) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:305) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:193) at org.pentaho.jpivot.AnalysisViewService.getNewAnalysisViewRuntime(AnalysisViewService.java:553) at org.pentaho.jpivot.Pivot_jsp._jspService(Pivot_jsp.java:471) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.pentaho.platform.web.servlet.PluginDispatchServlet.service(PluginDispatchServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:156) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:83) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:265) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.WebappRootForwardingFilter.doFilter(WebappRootForwardingFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Unknown Source) Caused by: org.postgresql.util.PSQLException: Cannot rollback when autoCommit is enabled. at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:732) at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:323) at org.pentaho.platform.engine.services.audit.AuditSQLEntry.auditAll(AuditSQLEntry.java:142) ... 71 more

    Pentaho BI Platform Tracking | 3 years ago | Sarah Moursalien
    org.pentaho.platform.api.engine.AuditException: org.postgresql.util.PSQLException: Cannot rollback when autoCommit is enabled.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Steps: Enable Jpivot button in 5.0: 1. Stop Server, Go to location: C:\Program Files\pentaho\server\biserver-ee\pentaho-solutions\system\pentaho-jpivot-plugin-legacy 2. Delete the settings.xml 3. Rename settings.xml.enabled to settings.xml. Start Server 4. Login to PUC, go to opened perspective 5. Click on New dropdown 6. Click New JPivot View 7. Click OK BUG: Error: An error occurred while rendering Pivot.jsp. Please see the log for details. Log File: 2013-08-12 16:13:30,775 ERROR [org.pentaho.platform.engine.services.runtime.RuntimeContext] a81d5998-038b-11e3-91a0-d4bed936d5b7:RUNTIME:context-1205146513-1376338410708:default.xjpivot org.postgresql.util.PSQLException: Cannot rollback when autoCommit is enabled. org.pentaho.platform.api.engine.AuditException: org.postgresql.util.PSQLException: Cannot rollback when autoCommit is enabled. at org.pentaho.platform.engine.services.audit.AuditSQLEntry.auditAll(AuditSQLEntry.java:144) at org.pentaho.platform.engine.core.audit.AuditEntry.auditAll(AuditEntry.java:60) at org.pentaho.platform.engine.core.audit.AuditEntry.auditJobDuration(AuditEntry.java:49) at org.pentaho.platform.engine.core.audit.AuditHelper.audit(AuditHelper.java:91) at org.pentaho.platform.engine.core.audit.AuditHelper.audit(AuditHelper.java:42) at org.pentaho.platform.engine.services.runtime.RuntimeContext.audit(RuntimeContext.java:1683) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1294) at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1176) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1122) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:1004) at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:910) at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:386) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:305) at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:193) at org.pentaho.jpivot.AnalysisViewService.getNewAnalysisViewRuntime(AnalysisViewService.java:553) at org.pentaho.jpivot.Pivot_jsp._jspService(Pivot_jsp.java:471) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.pentaho.platform.web.servlet.PluginDispatchServlet.service(PluginDispatchServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:156) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:83) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.pentaho.platform.web.http.filters.HttpSessionPentahoSessionIntegrationFilter.doFilter(HttpSessionPentahoSessionIntegrationFilter.java:265) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.platform.web.http.filters.WebappRootForwardingFilter.doFilter(WebappRootForwardingFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Unknown Source) Caused by: org.postgresql.util.PSQLException: Cannot rollback when autoCommit is enabled. at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:732) at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:368) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:323) at org.pentaho.platform.engine.services.audit.AuditSQLEntry.auditAll(AuditSQLEntry.java:142) ... 71 more

    Pentaho BI Platform Tracking | 3 years ago | Sarah Moursalien
    org.pentaho.platform.api.engine.AuditException: org.postgresql.util.PSQLException: Cannot rollback 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.

    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 rollback when autoCommit is enabled.

      at org.postgresql.jdbc.PgConnection.rollback()
    2. org.postgresql.jdbc
      PgConnection.rollback
      1. org.postgresql.jdbc.PgConnection.rollback(PgConnection.java:796)[postgresql-9.4.1208.jar:9.4.1208]
      1 frame
    3. HikariCP-java6
      HikariDataSource.<init>
      1. com.zaxxer.hikari.pool.PoolBase.executeSql(PoolBase.java:489)[HikariCP-2.4.5.jar:na]
      2. com.zaxxer.hikari.pool.PoolBase.checkDriverSupport(PoolBase.java:379)[HikariCP-2.4.5.jar:na]
      3. com.zaxxer.hikari.pool.PoolBase.setupConnection(PoolBase.java:342)[HikariCP-2.4.5.jar:na]
      4. com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:316)[HikariCP-2.4.5.jar:na]
      5. com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:514)[HikariCP-2.4.5.jar:na]
      6. com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:118)[HikariCP-2.4.5.jar:na]
      7. com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:71)[HikariCP-2.4.5.jar:na]
      7 frames
    4. debiki
      Debiki$.createPostgresHikariDataSource
      1. debiki.Debiki$.createPostgresHikariDataSource(Debiki.scala:114)[classes/:na]
      1 frame