Details
-
Bug
-
Resolution: Done
-
Major
-
xCM 6.0.0
-
None
Description
org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:624)
org.springframework.orm.hibernate3.SpringSessionSynchronization.beforeCommit(SpringSessionSynchronization.java:143)
org.springframework.transaction.support.TransactionSynchronizationUtils.triggerBeforeCommit(TransactionSynchronizationUtils.java:72)
org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransactionManager.java:882)
org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:692)
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:678)
org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:113)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
org.springframework.aop.framework.Cglib2AopProxy$FixedChainStaticTargetInterceptor.intercept(Cglib2AopProxy.java:582)
org.jahia.hibernate.manager.JahiaUserManager$$EnhancerByCGLIB$$eac05e6a.addProperty(<generated>)
org.jahia.services.usermanager.JahiaDBUser.setProperty(JahiaDBUser.java:463)
org.jahia.params.valves.LoginEngineAuthValveImpl.invoke(LoginEngineAuthValveImpl.java:187)
org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:165)
org.jahia.params.valves.TokenAuthValveImpl.invoke(TokenAuthValveImpl.java:78)
org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:165)
org.jahia.params.valves.HttpBasicAuthValveImpl.invoke(HttpBasicAuthValveImpl.java:97)
org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:165)
org.jahia.pipelines.impl.GenericPipeline.invoke(GenericPipeline.java:152)
org.jahia.params.ProcessingContext.resolveUser(ProcessingContext.java:3430)
org.jahia.params.ParamBean.<init>(ParamBean.java:405)
org.jahia.params.ParamBean.<init>(ParamBean.java:311)
org.jahia.params.ProcessingContextFactoryImpl.getContext(ProcessingContextFactoryImpl.java:68)
org.jahia.bin.Jahia.createParamBean(Jahia.java:919)
org.jahia.bin.Jahia.service(Jahia.java:856)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.tuckey.web.filters.urlrewrite.NormalRewrittenUrl.doRewrite(NormalRewrittenUrl.java:195)
org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:159)
org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:141)
org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:90)
org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:417)
org.jahia.bin.filters.ResponseCacheControlFilter.doFilter(ResponseCacheControlFilter.java:110)
root cause
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
org.springframework.orm.hibernate3.SpringSessionSynchronization.beforeCommit(SpringSessionSynchronization.java:135)
org.springframework.transaction.support.TransactionSynchronizationUtils.triggerBeforeCommit(TransactionSynchronizationUtils.java:72)
org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransactionManager.java:882)
org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:692)
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:678)
org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:113)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
org.springframework.aop.framework.Cglib2AopProxy$FixedChainStaticTargetInterceptor.intercept(Cglib2AopProxy.java:582)
org.jahia.hibernate.manager.JahiaUserManager$$EnhancerByCGLIB$$eac05e6a.addProperty(<generated>)
org.jahia.services.usermanager.JahiaDBUser.setProperty(JahiaDBUser.java:463)
org.jahia.params.valves.LoginEngineAuthValveImpl.invoke(LoginEngineAuthValveImpl.java:187)
org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:165)
org.jahia.params.valves.TokenAuthValveImpl.invoke(TokenAuthValveImpl.java:78)
org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:165)
org.jahia.params.valves.HttpBasicAuthValveImpl.invoke(HttpBasicAuthValveImpl.java:97)
org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:165)
org.jahia.pipelines.impl.GenericPipeline.invoke(GenericPipeline.java:152)
org.jahia.params.ProcessingContext.resolveUser(ProcessingContext.java:3430)
org.jahia.params.ParamBean.<init>(ParamBean.java:405)
org.jahia.params.ParamBean.<init>(ParamBean.java:311)
org.jahia.params.ProcessingContextFactoryImpl.getContext(ProcessingContextFactoryImpl.java:68)
org.jahia.bin.Jahia.createParamBean(Jahia.java:919)
org.jahia.bin.Jahia.service(Jahia.java:856)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.tuckey.web.filters.urlrewrite.NormalRewrittenUrl.doRewrite(NormalRewrittenUrl.java:195)
org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:159)
org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:141)
org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:90)
org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:417)
org.jahia.bin.filters.ResponseCacheControlFilter.doFilter(ResponseCacheControlFilter.java:110)
root cause
java.sql.BatchUpdateException: Duplicate entry '0-lastLoginDate-jahia-root:0' for key 1
com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1666)
com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1082)
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
org.springframework.orm.hibernate3.SpringSessionSynchronization.beforeCommit(SpringSessionSynchronization.java:135)
org.springframework.transaction.support.TransactionSynchronizationUtils.triggerBeforeCommit(TransactionSynchronizationUtils.java:72)
org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransactionManager.java:882)
org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:692)
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:678)
org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:113)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
org.springframework.aop.framework.Cglib2AopProxy$FixedChainStaticTargetInterceptor.intercept(Cglib2AopProxy.java:582)
org.jahia.hibernate.manager.JahiaUserManager$$EnhancerByCGLIB$$eac05e6a.addProperty(<generated>)
org.jahia.services.usermanager.JahiaDBUser.setProperty(JahiaDBUser.java:463)
org.jahia.params.valves.LoginEngineAuthValveImpl.invoke(LoginEngineAuthValveImpl.java:187)
org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:165)
org.jahia.params.valves.TokenAuthValveImpl.invoke(TokenAuthValveImpl.java:78)
org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:165)
org.jahia.params.valves.HttpBasicAuthValveImpl.invoke(HttpBasicAuthValveImpl.java:97)
org.jahia.pipelines.impl.GenericPipeline.invokeNext(GenericPipeline.java:165)
org.jahia.pipelines.impl.GenericPipeline.invoke(GenericPipeline.java:152)
org.jahia.params.ProcessingContext.resolveUser(ProcessingContext.java:3430)
org.jahia.params.ParamBean.<init>(ParamBean.java:405)
org.jahia.params.ParamBean.<init>(ParamBean.java:311)
org.jahia.params.ProcessingContextFactoryImpl.getContext(ProcessingContextFactoryImpl.java:68)
org.jahia.bin.Jahia.createParamBean(Jahia.java:919)
org.jahia.bin.Jahia.service(Jahia.java:856)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.tuckey.web.filters.urlrewrite.NormalRewrittenUrl.doRewrite(NormalRewrittenUrl.java:195)
org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:159)
org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:141)
org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:90)
org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:417)
org.jahia.bin.filters.ResponseCacheControlFilter.doFilter(ResponseCacheControlFilter.java:110)