Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-25491

Checking in a document causes console error

    Details

      Description

      Checking in a document causes console error

      1. Add Documents And Media Portlet
      2. Add Basic Document
      3. Checkout Document
      4. Edit Document
        • Change file or title
        • Save and Checkin

      System displays console errors.
      Same thing happen when you save then checkin.

      20:20:42,507 ERROR [JDBCExceptionReporter:75] Duplicate entry '10180-10196-1328905149400-10010-10476-2-0' for key 'IX_8F32DEC9'
      20:20:42,510 ERROR [ParallelDestination:111] Unable to process message {destinationName=liferay/async_service, response=null, responseDestinationName=null, responseId=null, payload=com.liferay.portlet.social.service.SocialActivityLocalService.addActivity(com.liferay.portlet.social.model.SocialActivity,com.liferay.portlet.social.model.SocialActivity)@com.liferay.portlet.social.service.impl.SocialActivityLocalServiceImpl, values={principalPassword=test, principalName=10196, companyId=10154}}
      com.liferay.portal.kernel.messaging.MessageListenerException: java.lang.RuntimeException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
              at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:31)
              at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:63)
              at com.liferay.portal.kernel.messaging.ParallelDestination$1.run(ParallelDestination.java:108)
              at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask._runTask(ThreadPoolExecutor.java:669)
              at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask.run(ThreadPoolExecutor.java:580)
              at java.lang.Thread.run(Thread.java:619)
      Caused by: java.lang.RuntimeException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
              at com.liferay.portal.messaging.async.AsyncAdvice$2.run(AsyncAdvice.java:79)
              at com.liferay.portal.messaging.async.AsyncMessageListener.doReceive(AsyncMessageListener.java:30)
              at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:25)
              ... 5 more
      Caused by: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
              at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:193)
              at com.liferay.portlet.social.service.persistence.SocialActivityPersistenceImpl.updateImpl(SocialActivityPersistenceImpl.java:544)
              at com.liferay.portlet.social.service.persistence.SocialActivityPersistenceImpl.updateImpl(SocialActivityPersistenceImpl.java:1)
              at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.update(BasePersistenceImpl.java:257)
              at com.liferay.portlet.social.service.impl.SocialActivityLocalServiceImpl.addActivity(SocialActivityLocalServiceImpl.java:233)
              at sun.reflect.GeneratedMethodAccessor1102.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
              at java.lang.reflect.Method.invoke(Method.java:597)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:112)
              at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:71)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:108)
              at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:59)
              at com.liferay.portal.messaging.async.AsyncAdvice$2.run(AsyncAdvice.java:76)
              ... 7 more
      Caused by: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
              at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:30)
              at com.liferay.portal.dao.orm.hibernate.SessionImpl.flush(SessionImpl.java:122)
              at com.liferay.portal.kernel.dao.orm.ClassLoaderSession.flush(ClassLoaderSession.java:218)
              at com.liferay.portal.service.persistence.BatchSessionImpl.update(BatchSessionImpl.java:95)
              at com.liferay.portal.service.persistence.BatchSessionUtil.update(BatchSessionUtil.java:49)
              at com.liferay.portlet.social.service.persistence.SocialActivityPersistenceImpl.updateImpl(SocialActivityPersistenceImpl.java:539)
              ... 18 more
      Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
              at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)
              at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
              at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
              at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
              at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
              at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
              at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
              at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
              at com.liferay.portal.dao.orm.hibernate.SessionImpl.flush(SessionImpl.java:119)
              ... 22 more
      Caused by: java.sql.BatchUpdateException: Duplicate entry '10180-10196-1328905149400-10010-10476-2-0' for key 'IX_8F32DEC9'
              at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1257)
              at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:943)
              at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
              at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
              at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
              ... 28 more
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              albert.lee Albert Lee
              Reporter:
              benjamin.yeh Benjamin Yeh (Inactive)
              Participants of an Issue:
              Recent user:
              Esther Sanz
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                9 years, 22 weeks, 2 days ago

                  Packages

                  Version Package
                  6.1.1 CE GA2
                  6.1.20 EE GA2
                  6.2.0 CE M2