Checking in a document causes console error

Description

Add Documents And Media Portlet
Add Basic Document
Checkout Document
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

Environment

Tomcat 7.0.25 + MySQL 5.1. 6.1.x Revision: 100241

Linked issues

is caused by

LPSA-19313

Documents and Media Library - webdav publishing - version

relates

LPE-6083

Checking in a document will cause an exception

Activity

Show:

Cynthia Wilburn March 12, 2012 at 2:00 PM

Reopening to add 6.1.1 CE GA2. Close as Fixed.

Albert Lee February 14, 2012 at 5:38 PM

PASSED Manual Testing following steps in description.

Fixed on:
Tomcat 7.0.25 + MySQL 5. 6.1.x GIT ID: 4166a5e8894ce3c6024bfc549545e5fc74c1320c.
Tomcat 7.0.25 + MySQL 5. 6.2.x GIT ID: 6535813184f8681e14487b205c17df1caee259d0.

Paul Piao February 13, 2012 at 9:45 PM

PASSED Manual Testing following steps in description.

Reproduced on:
Tomcat 7.0 + MySQL 5. 6.2.x GIT ID: e354860adddefee192d20eba73219035255c2dfd.
I can see the description error message.

Fixed on:
Tomcat 7.0 + MySQL 5. 6.1.x GIT ID: 18ab4ed74b14c153d0a7a936f70d8093dcac331f.
Tomcat 7.0 + MySQL 5. 6.2.x GIT ID: 00cb08388ab375e2b5714809057c07fa7e1f67a6.
Can not see the error message.

Michael Saechang February 13, 2012 at 2:42 PM

Committed on:
6.1.x GIT ID: 061a167cc708527daf744aa21200d1786cad2889.
6.2.x GIT ID: dd026dcaf15011d606f001962bfb0982ab80baf4.

Fixed

Pinned fields

Click on the next to a field label to start pinning.

Details
Assignee
Albert Lee(Deactivated)
Reporter
Benjamin Yeh(Deactivated)
Labels
QA-R
Branch Version/s
6.1.x
Backported to Branch
Committed
Fix Priority
4
Caused by
Other bug fix
Git Pull Request
https://github.com/brianchandotcom/liferay-portal/pull/4185
Bug Type
Regression Bug
Components
Documents & Media
Fix versions
6.1.1 CE GA2
6.1.20 EE GA2
6.2.0 CE M2
Affects versions
6.1.0 CE GA1
6.2.0 CE M2
Priority
Medium

Zendesk Support

Created February 10, 2012 at 12:43 PM

Updated June 24, 2023 at 4:00 PM

Resolved October 3, 2012 at 5:40 PM

Checking in a document causes console error

Description

Environment

Linked issues

is caused by

relates

Activity

Cynthia Wilburn March 12, 2012 at 2:00 PM

Albert Lee February 14, 2012 at 5:38 PM

Paul Piao February 13, 2012 at 9:45 PM

Michael Saechang February 13, 2012 at 2:42 PM

Details

Assignee

Reporter

Labels

Branch Version/s

Backported to Branch

Fix Priority

Caused by

Git Pull Request

Bug Type

Components

Fix versions

Affects versions

Priority

Zendesk SupportLinked Tickets

Zendesk Support

Zendesk Support