Uploaded image for project: 'Jahia Community'
  1. Jahia Community
  2. JAHIA-4594

duplicate entry when trying to log in (with multiple users)

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • xCM 6.0.0
    • 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)

      TestRail: Results

        Attachments

          Activity

            People

              cedmail_old Cédric Mailleux (Inactive)
              tdraier_old Thomas Draier (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                TestRail: Runs

                  TestRail: Cases

                    Packages

                      Version Package
                      xCM 6.0.0