[LPS-73471] Publishing renamed page results in Duplicate Entry error - Liferay Issues

Details

Type: Bug
Status: Closed
Resolution: Fixed
Affects Version/s: 7.0.X EE, Master
Fix Version/s: 7.0.0 DXP FP26, 7.0.X EE, 7.0.4 CE GA5, 7.1.X, Master
Component/s: Staging, Wiki
Labels:

Branch Version/s:

7.0.x
Backported to Branch:

Committed
Fix Priority:
5
Sprint:
Collab 9, Collab 10
Git Pull Request:
https://github.com/brianchandotcom/liferay-portal/pull/50280

Description

Steps to reproduce:

Stage a new site
Navigate to Content > Wiki
Add a new wiki page
Add a child page
Go to child page > Actions > Move
Rename child page with a new title
Publish to live
Rename child page with a new title
Publish to live

Expected results:
Site publishes and both child pages are displayed in live.

Actual results:
Site is not published. Console errors are thrown.

22:16:27,829 ERROR [liferay/background_task-5][JDBCExceptionReporter:234] Duplicate entry '780c2f88-04d3-088a-0052-f99b5e19583c-36776' for key 'IX_899D3DFB'
22:16:27,840 WARN  [liferay/background_task-5][LayoutStagingBackgroundTaskExecutor:171] Unable to publish layout: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
22:16:27,851 ERROR [liferay/background_task-5][BackgroundTaskMessageListener:165] Unable to execute background task
com.liferay.exportimport.kernel.lar.PortletDataException: 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.exportimport.kernel.lar.BaseStagedModelDataHandler.importStagedModel(BaseStagedModelDataHandler.java:417)
        at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:369)
        at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:355)
        at com.liferay.wiki.web.exportimport.data.handler.WikiPortletDataHandler.doImportData(WikiPortletDataHandler.java:192)
        at com.liferay.exportimport.kernel.lar.BasePortletDataHandler.importData(BasePortletDataHandler.java:382)
        at com.liferay.wiki.web.exportimport.data.handler.WikiPortletDataHandler.importData(WikiPortletDataHandler.java:88)
        at com.liferay.exportimport.controller.PortletImportController.importPortletData(PortletImportController.java:296)
        at com.liferay.exportimport.controller.PortletImportController.importPortletData(PortletImportController.java:835)
        at com.liferay.exportimport.controller.LayoutImportController.doImportFile(LayoutImportController.java:827)
        at com.liferay.exportimport.controller.LayoutImportController.importFile(LayoutImportController.java:225)
        at com.liferay.portlet.exportimport.service.impl.ExportImportLocalServiceImpl.importLayouts(ExportImportLocalServiceImpl.java:185)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:163)
        at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:54)
        at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:58)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
        at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:169)
        at com.sun.proxy.$Proxy106.importLayouts(Unknown Source)
        at com.liferay.exportimport.kernel.service.ExportImportLocalServiceUtil.importLayouts(ExportImportLocalServiceUtil.java:202)
        at com.liferay.exportimport.background.task.LayoutStagingBackgroundTaskExecutor$LayoutStagingImportCallable.call(LayoutStagingBackgroundTaskExecutor.java:273)
        at com.liferay.exportimport.background.task.LayoutStagingBackgroundTaskExecutor$LayoutStagingImportCallable.call(LayoutStagingBackgroundTaskExecutor.java:246)
        at com.liferay.portal.spring.transaction.TransactionInvokerImpl$CallableMethodInvocation.proceed(TransactionInvokerImpl.java:101)
        at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:54)
        at com.liferay.portal.spring.transaction.TransactionInvokerImpl.invoke(TransactionInvokerImpl.java:47)
        at com.liferay.portal.kernel.transaction.TransactionInvokerUtil.invoke(TransactionInvokerUtil.java:28)
        at com.liferay.exportimport.background.task.LayoutStagingBackgroundTaskExecutor.execute(LayoutStagingBackgroundTaskExecutor.java:139)
        at com.liferay.portal.kernel.backgroundtask.SerialBackgroundTaskExecutor.execute(SerialBackgroundTaskExecutor.java:54)
        at com.liferay.portal.kernel.backgroundtask.DelegatingBackgroundTaskExecutor.execute(DelegatingBackgroundTaskExecutor.java:43)
        at com.liferay.portal.kernel.backgroundtask.ThreadLocalAwareBackgroundTaskExecutor.execute(ThreadLocalAwareBackgroundTaskExecutor.java:56)
        at com.liferay.portal.background.task.internal.messaging.BackgroundTaskMessageListener.doReceive(BackgroundTaskMessageListener.java:124)
        at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:26)
        at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:74)
        at com.liferay.portal.kernel.messaging.ParallelDestination$1.run(ParallelDestination.java:52)
        at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask._runTask(ThreadPoolExecutor.java:756)
        at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask.run(ThreadPoolExecutor.java:667)
        at java.lang.Thread.run(Thread.java:745)
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.kernel.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:265)
        at com.liferay.wiki.service.persistence.impl.WikiPagePersistenceImpl.findByN_T_H(WikiPagePersistenceImpl.java:11435)
        at com.liferay.wiki.service.persistence.impl.WikiPagePersistenceImpl.findByN_T_H(WikiPagePersistenceImpl.java:11294)
        at com.liferay.wiki.service.persistence.impl.WikiPagePersistenceImpl.fetchByN_T_H_First(WikiPagePersistenceImpl.java:11496)
        at com.liferay.wiki.internal.model.listener.CycleDetectorWikiPageModelListener.isCycleDetectedInWikiPagesGraph(CycleDetectorWikiPageModelListener.java:79)
        at com.liferay.wiki.internal.model.listener.CycleDetectorWikiPageModelListener.onBeforeUpdate(CycleDetectorWikiPageModelListener.java:48)
        at com.liferay.wiki.internal.model.listener.CycleDetectorWikiPageModelListener.onBeforeUpdate(CycleDetectorWikiPageModelListener.java:31)
        at com.liferay.portal.kernel.service.persistence.impl.BasePersistenceImpl.update(BasePersistenceImpl.java:344)
        at com.liferay.wiki.service.impl.WikiPageLocalServiceImpl.updateStatus(WikiPageLocalServiceImpl.java:2101)
        at sun.reflect.GeneratedMethodAccessor2377.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:163)
        at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:54)
        at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:58)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
        at com.liferay.portal.service.ServiceContextAdvice.invoke(ServiceContextAdvice.java:51)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
        at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:169)
        at com.sun.proxy.$Proxy614.updateStatus(Unknown Source)
        at com.liferay.wiki.web.internal.workflow.WikiPageWorkflowHandler.updateStatus(WikiPageWorkflowHandler.java:71)
        at com.liferay.wiki.web.internal.workflow.WikiPageWorkflowHandler.updateStatus(WikiPageWorkflowHandler.java:39)
        at com.liferay.portal.kernel.workflow.WorkflowHandlerRegistryUtil.startWorkflowInstance(WorkflowHandlerRegistryUtil.java:172)
        at com.liferay.wiki.service.impl.WikiPageLocalServiceImpl.startWorkflowInstance(WikiPageLocalServiceImpl.java:3163)
        at com.liferay.wiki.service.impl.WikiPageLocalServiceImpl.addPage(WikiPageLocalServiceImpl.java:245)
        at sun.reflect.GeneratedMethodAccessor2378.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:163)
        at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:54)
        at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:58)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
        at com.liferay.portal.service.ServiceContextAdvice.invoke(ServiceContextAdvice.java:51)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
        at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:169)
        at com.sun.proxy.$Proxy614.addPage(Unknown Source)
        at com.liferay.wiki.internal.exportimport.data.handler.WikiPageStagedModelDataHandler.doImportStagedModel(WikiPageStagedModelDataHandler.java:204)
        at com.liferay.wiki.internal.exportimport.data.handler.WikiPageStagedModelDataHandler.doImportStagedModel(WikiPageStagedModelDataHandler.java:58)
        at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.importStagedModel(BaseStagedModelDataHandler.java:369)
        ... 40 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:33)
        at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:130)
        at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:109)
        at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:83)
        at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:51)
        at com.liferay.wiki.service.persistence.impl.WikiPagePersistenceImpl.findByN_T_H(WikiPagePersistenceImpl.java:11424)
        ... 81 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 com.liferay.portal.dao.orm.hibernate.event.NestableAutoFlushEventListener.onAutoFlush(NestableAutoFlushEventListener.java:69)
        at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1185)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1261)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
        at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:118)
        ... 85 more
Caused by: java.sql.BatchUpdateException: Duplicate entry '780c2f88-04d3-088a-0052-f99b5e19583c-36776' for key 'IX_899D3DFB'
        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2054)
        at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1467)
        at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:128)
        at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
        ... 93 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '780c2f88-04d3-088a-0052-f99b5e19583c-36776' for key 'IX_899D3DFB'
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
        at com.mysql.jdbc.Util.getInstance(Util.java:386)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2794)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2006)
        ... 98 more
22:24:34,111 ERROR [liferay/background_task-9][JDBCExceptionReporter:234] Duplicate entry 'd2fb8d3b-35c9-4aed-02a6-531746fab12a-37026' for key 'IX_899D3DFB'
22:24:34,130 WARN  [liferay/background_task-9][LayoutStagingBackgroundTaskExecutor:171] Unable to publish layout: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
22:24:34,148 ERROR [liferay/background_task-9][BackgroundTaskMessageListener:165] Unable to execute background task
com.liferay.exportimport.kernel.lar.PortletDataException: 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.exportimport.kernel.lar.BaseStagedModelDataHandler.importStagedModel(BaseStagedModelDataHandler.java:417)
        at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:369)
        at com.liferay.exportimport.kernel.lar.StagedModelDataHandlerUtil.importStagedModel(StagedModelDataHandlerUtil.java:355)
        at com.liferay.wiki.web.exportimport.data.handler.WikiPortletDataHandler.doImportData(WikiPortletDataHandler.java:192)
        at com.liferay.exportimport.kernel.lar.BasePortletDataHandler.importData(BasePortletDataHandler.java:382)
        at com.liferay.wiki.web.exportimport.data.handler.WikiPortletDataHandler.importData(WikiPortletDataHandler.java:88)
        at com.liferay.exportimport.controller.PortletImportController.importPortletData(PortletImportController.java:296)
        at com.liferay.exportimport.controller.PortletImportController.importPortletData(PortletImportController.java:835)
        at com.liferay.exportimport.controller.LayoutImportController.doImportFile(LayoutImportController.java:827)
        at com.liferay.exportimport.controller.LayoutImportController.importFile(LayoutImportController.java:225)
        at com.liferay.portlet.exportimport.service.impl.ExportImportLocalServiceImpl.importLayouts(ExportImportLocalServiceImpl.java:185)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:163)
        at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:54)
        at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:58)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
        at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:169)
        at com.sun.proxy.$Proxy106.importLayouts(Unknown Source)
        at com.liferay.exportimport.kernel.service.ExportImportLocalServiceUtil.importLayouts(ExportImportLocalServiceUtil.java:202)
        at com.liferay.exportimport.background.task.LayoutStagingBackgroundTaskExecutor$LayoutStagingImportCallable.call(LayoutStagingBackgroundTaskExecutor.java:273)
        at com.liferay.exportimport.background.task.LayoutStagingBackgroundTaskExecutor$LayoutStagingImportCallable.call(LayoutStagingBackgroundTaskExecutor.java:246)
        at com.liferay.portal.spring.transaction.TransactionInvokerImpl$CallableMethodInvocation.proceed(TransactionInvokerImpl.java:101)
        at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:54)
        at com.liferay.portal.spring.transaction.TransactionInvokerImpl.invoke(TransactionInvokerImpl.java:47)
        at com.liferay.portal.kernel.transaction.TransactionInvokerUtil.invoke(TransactionInvokerUtil.java:28)
        at com.liferay.exportimport.background.task.LayoutStagingBackgroundTaskExecutor.execute(LayoutStagingBackgroundTaskExecutor.java:139)
        at com.liferay.portal.kernel.backgroundtask.SerialBackgroundTaskExecutor.execute(SerialBackgroundTaskExecutor.java:54)
        at com.liferay.portal.kernel.backgroundtask.DelegatingBackgroundTaskExecutor.execute(DelegatingBackgroundTaskExecutor.java:43)
        at com.liferay.portal.kernel.backgroundtask.ThreadLocalAwareBackgroundTaskExecutor.execute(ThreadLocalAwareBackgroundTaskExecutor.java:56)
        at com.liferay.portal.background.task.internal.messaging.BackgroundTaskMessageListener.doReceive(BackgroundTaskMessageListener.java:124)
        at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:26)
        at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:74)
        at com.liferay.portal.kernel.messaging.ParallelDestination$1.run(ParallelDestination.java:52)
        at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask._runTask(ThreadPoolExecutor.java:756)
        at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask.run(ThreadPoolExecutor.java:667)
        at java.lang.Thread.run(Thread.java:745)
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.kernel.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:265)
        at com.liferay.wiki.service.persistence.impl.WikiPagePersistenceImpl.findByN_T_H(WikiPagePersistenceImpl.java:11435)
        at com.liferay.wiki.service.persistence.impl.WikiPagePersistenceImpl.findByN_T_H(WikiPagePersistenceImpl.java:11294)
        at com.liferay.wiki.service.persistence.impl.WikiPagePersistenceImpl.fetchByN_T_H_First(WikiPagePersistenceImpl.java:11496)
        at com.liferay.wiki.internal.model.listener.CycleDetectorWikiPageModelListener.isCycleDetectedInWikiPagesGraph(CycleDetectorWikiPageModelListener.java:79)
        at com.liferay.wiki.internal.model.listener.CycleDetectorWikiPageModelListener.onBeforeUpdate(CycleDetectorWikiPageModelListener.java:48)
        at com.liferay.wiki.internal.model.listener.CycleDetectorWikiPageModelListener.onBeforeUpdate(CycleDetectorWikiPageModelListener.java:31)
        at com.liferay.portal.kernel.service.persistence.impl.BasePersistenceImpl.update(BasePersistenceImpl.java:344)
        at com.liferay.wiki.service.impl.WikiPageLocalServiceImpl.updateStatus(WikiPageLocalServiceImpl.java:2101)
        at sun.reflect.GeneratedMethodAccessor2377.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:163)
        at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:54)
        at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:58)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
        at com.liferay.portal.service.ServiceContextAdvice.invoke(ServiceContextAdvice.java:51)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
        at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:169)
        at com.sun.proxy.$Proxy614.updateStatus(Unknown Source)
        at com.liferay.wiki.web.internal.workflow.WikiPageWorkflowHandler.updateStatus(WikiPageWorkflowHandler.java:71)
        at com.liferay.wiki.web.internal.workflow.WikiPageWorkflowHandler.updateStatus(WikiPageWorkflowHandler.java:39)
        at com.liferay.portal.kernel.workflow.WorkflowHandlerRegistryUtil.startWorkflowInstance(WorkflowHandlerRegistryUtil.java:172)
        at com.liferay.wiki.service.impl.WikiPageLocalServiceImpl.startWorkflowInstance(WikiPageLocalServiceImpl.java:3163)
        at com.liferay.wiki.service.impl.WikiPageLocalServiceImpl.addPage(WikiPageLocalServiceImpl.java:245)
        at sun.reflect.GeneratedMethodAccessor2378.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:163)
        at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:54)
        at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:58)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
        at com.liferay.portal.service.ServiceContextAdvice.invoke(ServiceContextAdvice.java:51)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:137)
        at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:169)
        at com.sun.proxy.$Proxy614.addPage(Unknown Source)
        at com.liferay.wiki.internal.exportimport.data.handler.WikiPageStagedModelDataHandler.doImportStagedModel(WikiPageStagedModelDataHandler.java:204)
        at com.liferay.wiki.internal.exportimport.data.handler.WikiPageStagedModelDataHandler.doImportStagedModel(WikiPageStagedModelDataHandler.java:58)
        at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.importStagedModel(BaseStagedModelDataHandler.java:369)
        ... 40 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:33)
        at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:130)
        at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:109)
        at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:83)
        at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:51)
        at com.liferay.wiki.service.persistence.impl.WikiPagePersistenceImpl.findByN_T_H(WikiPagePersistenceImpl.java:11424)
        ... 81 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 com.liferay.portal.dao.orm.hibernate.event.NestableAutoFlushEventListener.onAutoFlush(NestableAutoFlushEventListener.java:69)
        at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1185)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1261)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
        at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:118)
        ... 85 more
Caused by: java.sql.BatchUpdateException: Duplicate entry 'd2fb8d3b-35c9-4aed-02a6-531746fab12a-37026' for key 'IX_899D3DFB'
        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2054)
        at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1467)
        at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:128)
        at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
        ... 93 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'd2fb8d3b-35c9-4aed-02a6-531746fab12a-37026' for key 'IX_899D3DFB'
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
        at com.mysql.jdbc.Util.getInstance(Util.java:386)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2794)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2006)
        ... 98 more

Reproduced on:
Tomcat 8.0.32 + MySQL 5.6.
Portal ee-7.0.x GIT ID: 863b0eddd85e978b66fa4388b96e398c113ee27a

Unable to reproduce on:
Tomcat 8.0.32 + MySQL 5.6.
Portal master GIT ID: 3a7f1cd0d6ef2bbb71993924f289ef1ba71d2915

Attachments

Issue Links

is related to

LPS-76284 Custom Publication doesn't work with all content as default for any kind of content (blogs, wiki, etc)

Closed

relates

LPS-104554 Publishing renamed page results in Duplicate Entry error

Closed

Publishing renamed page results in Duplicate Entry error

Details

Description

Attachments

Issue Links

Activity

People

Dates

Packages

Version	Package
7.0.0 DXP FP26
7.0.X EE
7.0.4 CE GA5
7.1.X
Master