[SYNCOPE-1446] Persistence exception on PostgreSQL when AUDIT is enabled on propagation tasks - ASF JIRA

XML

Word

Printable

JSON

Details

Type: Bug
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: 2.1.3
Fix Version/s: 2.1.4, 3.0.0-M0
Component/s: core
Labels:
None
Environment:

Hide
docker-compose with Syncope docker images taken from
https://github.com/apache/syncope/blob/master/docker/src/main/resources/docker-compose/docker-compose-postgresql.yml

Show
docker-compose with Syncope docker images taken from https://github.com/apache/syncope/blob/master/docker/src/main/resources/docker-compose/docker-compose-postgresql.yml

Description

Enable AUDIT on propagation tasks for a specific resource. On events like this

[PropagationTask]:[user]:[dbtable res]:[create]:[SUCCESS]
[PropagationTask]:[user]:[dbtable res]:[create]:[FAILURE]
[PropagationTask]:[user]:[dbtable res]:[update]:[SUCCESS]
...

make sure that syncope.audit.Master is set to DEBUG
Propagate an user on the selected resource (say dbtable_res).

You'll get this exception:

16:05:08.088 WARN org.apache.syncope.core.spring.security.DefaultCredentialChecker - The default jwsKey property is being used. This must be changed to avoid a security breach! 16:05:08.154 WARN org.apache.syncope.core.provisioning.api.job.SchedTaskJobDelegate - Failure pushing 'JPAUser[a714bbeb-0ce2-4cfb-94bb-eb0ce2ecfb7a]' on 'JPAExternalResource[dbtable res]' org.springframework.orm.jpa.JpaSystemException: Cannot commit when autoCommit is enabled.; nested exception is <openjpa-3.0.0-r422266:1833209 fatal general error> org.apache.openjpa.persistence.PersistenceException: Cannot commit when autoCommit is enabled. at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:407) ~[spring-orm-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:127) ~[spring-orm-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:536) ~[spring-orm-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:746) ~[spring-tx-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:714) ~[spring-tx-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:533) ~[spring-tx-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:304) ~[spring-tx-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98) ~[spring-tx-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.apache.syncope.core.persistence.jpa.spring.DomainTransactionInterceptor.invoke(DomainTransactionInterceptor.java:60) ~[syncope-core-persistence-jpa-2.1.4-SNAPSHOT.jar:2.1.4-SNAPSHOT] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at com.sun.proxy.$Proxy319.handle(Unknown Source) ~[?:?] at org.apache.syncope.core.provisioning.java.pushpull.PushJobDelegate.doHandle(PushJobDelegate.java:114) ~[syncope-core-provisioning-java-2.1.4-SNAPSHOT.jar:2.1.4-SNAPSHOT] at org.apache.syncope.core.provisioning.java.pushpull.SinglePushJobDelegate.push(SinglePushJobDelegate.java:110) ~[syncope-core-provisioning-java-2.1.4-SNAPSHOT.jar:2.1.4-SNAPSHOT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_181] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_181] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_181] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_181] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:206) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at com.sun.proxy.$Proxy201.push(Unknown Source) ~[?:?] at org.apache.syncope.core.logic.ReconciliationLogic.push(ReconciliationLogic.java:192) ~[syncope-core-logic-2.1.4-SNAPSHOT.jar:2.1.4-SNAPSHOT] at org.apache.syncope.core.logic.ReconciliationLogic$$FastClassBySpringCGLIB$$99a3c577.invoke(<generated>) ~[syncope-core-logic-2.1.4-SNAPSHOT.jar:2.1.4-SNAPSHOT] at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.apache.syncope.core.logic.LogicInvocationHandler.around(LogicInvocationHandler.java:89) ~[syncope-core-logic-2.1.4-SNAPSHOT.jar:2.1.4-SNAPSHOT] at sun.reflect.GeneratedMethodAccessor127.invoke(Unknown Source) ~[?:?] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_181] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_181] at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294) ~[spring-tx-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98) ~[spring-tx-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.apache.syncope.core.persistence.jpa.spring.DomainTransactionInterceptor.invoke(DomainTransactionInterceptor.java:60) ~[syncope-core-persistence-jpa-2.1.4-SNAPSHOT.jar:2.1.4-SNAPSHOT] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:69) ~[spring-security-core-5.1.4.RELEASE.jar:5.1.4.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:93) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.apache.syncope.core.logic.ReconciliationLogic$$EnhancerBySpringCGLIB$$b63b6270.push(<generated>) ~[syncope-core-logic-2.1.4-SNAPSHOT.jar:2.1.4-SNAPSHOT] at org.apache.syncope.core.rest.cxf.service.ReconciliationServiceImpl.push(ReconciliationServiceImpl.java:55) ~[syncope-core-rest-cxf-2.1.4-SNAPSHOT.jar:2.1.4-SNAPSHOT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_181] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_181] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_181] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_181] at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:179) ~[cxf-core-3.2.8.jar:3.2.8] at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96) ~[cxf-core-3.2.8.jar:3.2.8] at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:193) ~[cxf-rt-frontend-jaxrs-3.2.8.jar:3.2.8] at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:103) ~[cxf-rt-frontend-jaxrs-3.2.8.jar:3.2.8] at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:59) ~[cxf-core-3.2.8.jar:3.2.8] at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:96) ~[cxf-core-3.2.8.jar:3.2.8] at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:308) ~[cxf-core-3.2.8.jar:3.2.8] at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121) ~[cxf-core-3.2.8.jar:3.2.8] at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:267) ~[cxf-rt-transports-http-3.2.8.jar:3.2.8] at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:234) ~[cxf-rt-transports-http-3.2.8.jar:3.2.8] at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:208) ~[cxf-rt-transports-http-3.2.8.jar:3.2.8] at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:160) ~[cxf-rt-transports-http-3.2.8.jar:3.2.8] at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:216) ~[cxf-rt-transports-http-3.2.8.jar:3.2.8] at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:301) ~[cxf-rt-transports-http-3.2.8.jar:3.2.8] at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:220) ~[cxf-rt-transports-http-3.2.8.jar:3.2.8] at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) ~[tomcat8-servlet-api-8.5.14.jar:?] at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:276) ~[cxf-rt-transports-http-3.2.8.jar:3.2.8] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[tomcat8-catalina-8.5.14.jar:8.5.14] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat8-catalina-8.5.14.jar:8.5.14] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) ~[tomcat8-websocket-8.5.14.jar:8.5.14] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat8-catalina-8.5.14.jar:8.5.14] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat8-catalina-8.5.14.jar:8.5.14] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320) ~[spring-security-web-5.1.4.RELEASE.jar:5.1.4.RELEASE] at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) ~[spring-security-web-5.1.4.RELEASE.jar:5.1.4.RELEASE] at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) ~[spring-security-web-5.1.4.RELEASE.jar:5.1.4.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) ~[spring-security-web-5.1.4.RELEASE.jar:5.1.4.RELEASE] at org.apache.syncope.core.spring.security.MustChangePasswordFilter.doFilter(MustChangePasswordFilter.java:63) ~[syncope-core-spring-2.1.4-SNAPSHOT.jar:2.1.4-SNAPSHOT] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) ~[spring-security-web-5.1.4.RELEASE.jar:5.1.4.RELEASE] at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119) ~[spring-security-web-5.1.4.RELEASE.jar:5.1.4.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) ~[spring-security-web-5.1.4.RELEASE.jar:5.1.4.RELEASE] at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) ~[spring-security-web-5.1.4.RELEASE.jar:5.1.4.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) ~[spring-security-web-5.1.4.RELEASE.jar:5.1.4.RELEASE] at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) ~[spring-security-web-5.1.4.RELEASE.jar:5.1.4.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) ~[spring-security-web-5.1.4.RELEASE.jar:5.1.4.RELEASE] at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158) ~[spring-security-web-5.1.4.RELEASE.jar:5.1.4.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) ~[spring-security-web-5.1.4.RELEASE.jar:5.1.4.RELEASE] at org.apache.syncope.core.spring.security.JWTAuthenticationFilter.doFilterInternal(JWTAuthenticationFilter.java:110) ~[syncope-core-spring-2.1.4-SNAPSHOT.jar:2.1.4-SNAPSHOT] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) ~[spring-security-web-5.1.4.RELEASE.jar:5.1.4.RELEASE] at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) ~[spring-security-web-5.1.4.RELEASE.jar:5.1.4.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) ~[spring-security-web-5.1.4.RELEASE.jar:5.1.4.RELEASE] at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) ~[spring-security-web-5.1.4.RELEASE.jar:5.1.4.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) ~[spring-security-web-5.1.4.RELEASE.jar:5.1.4.RELEASE] at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215) ~[spring-security-web-5.1.4.RELEASE.jar:5.1.4.RELEASE] at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178) ~[spring-security-web-5.1.4.RELEASE.jar:5.1.4.RELEASE] at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat8-catalina-8.5.14.jar:8.5.14] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat8-catalina-8.5.14.jar:8.5.14] at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-5.1.5.RELEASE.jar:5.1.5.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat8-catalina-8.5.14.jar:8.5.14] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat8-catalina-8.5.14.jar:8.5.14] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) ~[tomcat8-catalina-8.5.14.jar:8.5.14] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) ~[tomcat8-catalina-8.5.14.jar:8.5.14] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470) ~[tomcat8-catalina-8.5.14.jar:8.5.14] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) ~[tomcat8-catalina-8.5.14.jar:8.5.14] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80) ~[tomcat8-catalina-8.5.14.jar:8.5.14] at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624) ~[tomcat8-catalina-8.5.14.jar:8.5.14] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) ~[tomcat8-catalina-8.5.14.jar:8.5.14] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) ~[tomcat8-catalina-8.5.14.jar:8.5.14] at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799) ~[tomcat8-coyote-8.5.14.jar:8.5.14] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) ~[tomcat8-coyote-8.5.14.jar:8.5.14] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861) ~[tomcat8-coyote-8.5.14.jar:8.5.14] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1458) ~[tomcat8-coyote-8.5.14.jar:8.5.14] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) ~[tomcat8-coyote-8.5.14.jar:8.5.14] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_181] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_181] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat8-util-8.5.14.jar:8.5.14] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_181] Caused by: org.apache.openjpa.persistence.PersistenceException: Cannot commit when autoCommit is enabled. at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5038) ~[openjpa-jdbc-3.0.0.jar:3.0.0] at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4998) ~[openjpa-jdbc-3.0.0.jar:3.0.0] at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134) ~[openjpa-jdbc-3.0.0.jar:3.0.0] at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:107) ~[openjpa-jdbc-3.0.0.jar:3.0.0] at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:59) ~[openjpa-jdbc-3.0.0.jar:3.0.0] at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.commit(JDBCStoreManager.java:203) ~[openjpa-jdbc-3.0.0.jar:3.0.0] at org.apache.openjpa.kernel.DelegatingStoreManager.commit(DelegatingStoreManager.java:95) ~[openjpa-kernel-3.0.0.jar:3.0.0] at org.apache.openjpa.datacache.DataCacheStoreManager.commit(DataCacheStoreManager.java:86) ~[openjpa-kernel-3.0.0.jar:3.0.0] at org.apache.openjpa.kernel.DelegatingStoreManager.commit(DelegatingStoreManager.java:95) ~[openjpa-kernel-3.0.0.jar:3.0.0] at org.apache.openjpa.kernel.BrokerImpl.endStoreManagerTransaction(BrokerImpl.java:1483) ~[openjpa-kernel-3.0.0.jar:3.0.0] at org.apache.openjpa.kernel.BrokerImpl.endTransaction(BrokerImpl.java:2388) ~[openjpa-kernel-3.0.0.jar:3.0.0] at org.apache.openjpa.kernel.BrokerImpl.afterCompletion(BrokerImpl.java:2041) ~[openjpa-kernel-3.0.0.jar:3.0.0] at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:94) ~[openjpa-kernel-3.0.0.jar:3.0.0] at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1526) ~[openjpa-kernel-3.0.0.jar:3.0.0] at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:932) ~[openjpa-kernel-3.0.0.jar:3.0.0] at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:590) ~[openjpa-persistence-3.0.0.jar:3.0.0] at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:532) ~[spring-orm-5.1.5.RELEASE.jar:5.1.5.RELEASE] ... 119 more Caused by: org.postgresql.util.PSQLException: Cannot commit when autoCommit is enabled. at org.postgresql.jdbc.PgConnection.commit(PgConnection.java:772) ~[postgresql-42.2.5.jar:42.2.5] at com.zaxxer.hikari.pool.ProxyConnection.commit(ProxyConnection.java:365) ~[HikariCP-3.3.1.jar:?] at com.zaxxer.hikari.pool.HikariProxyConnection.commit(HikariProxyConnection.java) ~[HikariCP-3.3.1.jar:?] at org.apache.openjpa.lib.jdbc.DelegatingConnection.commit(DelegatingConnection.java:175) ~[openjpa-lib-3.0.0.jar:3.0.0] at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.commit(LoggingConnectionDecorator.java:340) ~[openjpa-lib-3.0.0.jar:3.0.0] at org.apache.openjpa.lib.jdbc.DelegatingConnection.commit(DelegatingConnection.java:175) ~[openjpa-lib-3.0.0.jar:3.0.0] at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.commit(ConfiguringConnectionDecorator.java:123) ~[openjpa-lib-3.0.0.jar:3.0.0] at org.apache.openjpa.lib.jdbc.DelegatingConnection.commit(DelegatingConnection.java:175) ~[openjpa-lib-3.0.0.jar:3.0.0] at org.apache.openjpa.lib.jdbc.DelegatingConnection.commit(DelegatingConnection.java:175) ~[openjpa-lib-3.0.0.jar:3.0.0] at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.commit(JDBCStoreManager.java:197) ~[openjpa-jdbc-3.0.0.jar:3.0.0] at org.apache.openjpa.kernel.DelegatingStoreManager.commit(DelegatingStoreManager.java:95) ~[openjpa-kernel-3.0.0.jar:3.0.0] at org.apache.openjpa.datacache.DataCacheStoreManager.commit(DataCacheStoreManager.java:86) ~[openjpa-kernel-3.0.0.jar:3.0.0] at org.apache.openjpa.kernel.DelegatingStoreManager.commit(DelegatingStoreManager.java:95) ~[openjpa-kernel-3.0.0.jar:3.0.0] at org.apache.openjpa.kernel.BrokerImpl.endStoreManagerTransaction(BrokerImpl.java:1483) ~[openjpa-kernel-3.0.0.jar:3.0.0] at org.apache.openjpa.kernel.BrokerImpl.endTransaction(BrokerImpl.java:2388) ~[openjpa-kernel-3.0.0.jar:3.0.0] at org.apache.openjpa.kernel.BrokerImpl.afterCompletion(BrokerImpl.java:2041) ~[openjpa-kernel-3.0.0.jar:3.0.0] at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:94) ~[openjpa-kernel-3.0.0.jar:3.0.0] at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1526) ~[openjpa-kernel-3.0.0.jar:3.0.0] at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:932) ~[openjpa-kernel-3.0.0.jar:3.0.0] at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:590) ~[openjpa-persistence-3.0.0.jar:3.0.0] at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:532) ~[spring-orm-5.1.5.RELEASE.jar:5.1.5.RELEASE] ... 119 more

If syncope.audit.Master is set to INFO or other values this does not happens because audit is not persisted to database.

Attachments

Activity

People

Assignee:: Francesco Chicchiriccò

Reporter:: Andrea Patricelli

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 08/Mar/19 16:17

Updated:: 19/Apr/19 06:53

Resolved:: 12/Mar/19 11:59