Fail to publish the publication intermittently with message thread on DB2

• Type: Bug
• Status: Verified
• Resolution: Unresolved
• Affects Version/s: Master
• Fix Version/s: None
• Component/s: Content Publishing > Publications
• Labels:
  • 7.4-known-issues
  • QA-AUTOMATION
  • liferay-ga15-ce-743-known-issues
  • liferay-ga16-ce-743-known-issues
  • liferay-ga17-ce-743-known-issues
  • liferay-ga18-ce-743-known-issues
  • liferay-ga19-ce-743-known-issues
  • liferay-ga20-ce-743-known-issues
  • liferay-ga21-ce-743-known-issues
  • liferay-ga22-ce-743-known-issues
  • liferay-ga23-ce-743-known-issues
  • liferay-ga24-ce-743-known-issues
  • liferay-ga25-ce-743-known-issues
  • liferay-ga26-ce-743-known-issues
  • liferay-ga27-ce-743-known-issues
  • liferay-ga28-ce-743-known-issues
  • liferay-ga29-ce-743-known-issues
  • liferay-ga30-ce-743-known-issues
  • liferay-ga31-ce-743-known-issues
  • liferay-ga32-ce-743-known-issues
  • liferay-ga33-ce-743-known-issues
  • liferay-ga34-ce-743-known-issues
  • liferay-ga35-ce-743-known-issues
  • liferay-ga36-ce-743-known-issues
  • liferay-ga37-ce-743-known-issues
  • liferay-ga38-ce-743-known-issues
  • liferay-ga39-ce-743-known-issues
  • liferay-ga40-ce-743-known-issues
  • liferay-ga41-ce-743-known-issues
  • liferay-ga42-ce-743-known-issues
  • liferay-ga44-ce-743-known-issues
  • liferay-ga45-ce-743-known-issues
  • liferay-ga46-ce-743-known-issues
  • liferay-ga47-ce-743-known-issues
  • liferay-ga48-ce-743-known-issues
  • liferay-ga49-ce-743-known-issues
  • liferay-ga50-ce-743-known-issues
  • liferay-ga51-ce-743-known-issues
  • liferay-ga52-ce-743-known-issues
  • liferay-ga53-ce-743-known-issues
  • liferay-ga54-ce-743-known-issues
  • liferay-ga55-ce-743-known-issues
  • liferay-ga56-ce-743-known-issues
  • liferay-ga57-ce-743-known-issues
  • liferay-ga58-ce-743-known-issues
  • liferay-ga59-ce-743-known-issues
  • liferay-ga60-ce-743-known-issues
  • liferay-ga61-ce-743-known-issues
  • liferay-ga62-ce-743-known-issues
  • liferay-ga63-ce-743-known-issues
  • liferay-ga64-ce-743-known-issues
  • liferay-ga65-ce-743-known-issues
  • liferay-ga66-ce-743-known-issues
  • liferay-ga67-ce-743-known-issues
  • liferay-ga68-ce-743-known-issues
  • liferay-ga69-ce-743-known-issues
  • liferay-ga70-ce-743-known-issues
  • liferay-ga71-ce-743-known-issues
  • liferay-ga72-ce-743-known-issues
  • liferay-ga73-ce-743-known-issues
  • liferay-ga74-ce-743-known-issues
  • liferay-ga75-ce-743-known-issues
  • liferay-ga76-ce-743-known-issues
  • liferay-ga77-ce-743-known-issues
  • liferay-ga78-ce-743-known-issues
  • liferay-ga79-ce-743-known-issues
• Fix Priority: 3
• QA Test Name:
  • LocalFile.PublicationsMB#PublishNewMessageBoardThreadAndMessage
• QA Test Score: 4
• Quality Gate: Upstream Test Analysis

Steps to reproduce

1. Enable Publication
2. Add a new publication
3. Add a new Message Board thread
4. Add a reply for the thread
5. Go to review the changes
6. Publish the publication

Actual Result:
Fail to publish publication and the following DB2 error throws

2022-03-01 00:56:55.425 ERROR [liferay/background_task-8][BackgroundTaskMessageListener:182] Unable to execute background task
com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=5;ROOT.PORTLETPREFERENCES, DRIVER=4.24.92
	at com.ibm.db2.jcc.am.b6.a(b6.java:806) ~[db2jcc4.jar:?]
	at com.ibm.db2.jcc.am.b6.a(b6.java:66) ~[db2jcc4.jar:?]
	at com.ibm.db2.jcc.am.b6.a(b6.java:140) ~[db2jcc4.jar:?]
	at com.ibm.db2.jcc.am.k3.b(k3.java:2464) ~[db2jcc4.jar:?]
	at com.ibm.db2.jcc.am.k3.c(k3.java:2445) ~[db2jcc4.jar:?]
	at com.ibm.db2.jcc.t4.ab.n(ab.java:894) ~[db2jcc4.jar:?]
	at com.ibm.db2.jcc.t4.ab.a(ab.java:119) ~[db2jcc4.jar:?]
	at com.ibm.db2.jcc.t4.p.a(p.java:50) ~[db2jcc4.jar:?]
	at com.ibm.db2.jcc.t4.aw.b(aw.java:220) ~[db2jcc4.jar:?]
	at com.ibm.db2.jcc.am.k4.bm(k4.java:3571) ~[db2jcc4.jar:?]
	at com.ibm.db2.jcc.am.k4.a(k4.java:4616) ~[db2jcc4.jar:?]
	at com.ibm.db2.jcc.am.k4.b(k4.java:4154) ~[db2jcc4.jar:?]
	at com.ibm.db2.jcc.am.k4.be(k4.java:821) ~[db2jcc4.jar:?]
	at com.ibm.db2.jcc.am.k4.executeUpdate(k4.java:795) ~[db2jcc4.jar:?]
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) ~[hikaricp.jar:?]
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java) ~[hikaricp.jar:?]
	at com.liferay.change.tracking.internal.background.task.CTServicePublisher._updateCTCollectionId(CTServicePublisher.java:324) ~[?:?]
	at com.liferay.change.tracking.internal.background.task.CTServicePublisher._publish(CTServicePublisher.java:185) ~[?:?]
	at com.liferay.portal.service.base.PortletPreferencesLocalServiceBaseImpl.updateWithUnsafeFunction(PortletPreferencesLocalServiceBaseImpl.java:526) ~[portal-impl.jar:?]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_121]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_121]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_121]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_121]
	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50) ~[portal-impl.jar:?]
	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69) ~[portal-impl.jar:?]
	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) ~[portal-impl.jar:?]
	at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49) ~[portal-impl.jar:?]
	at com.sun.proxy.$Proxy71.updateWithUnsafeFunction(Unknown Source) ~[?:?]
	at com.liferay.change.tracking.internal.background.task.CTServicePublisher.publish(CTServicePublisher.java:86) ~[?:?]
	at com.liferay.change.tracking.internal.background.task.CTPublishBackgroundTaskExecutor.execute(CTPublishBackgroundTaskExecutor.java:169) ~[?:?]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_121]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_121]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_121]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_121]
	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50) ~[portal-impl.jar:?]
	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69) ~[portal-impl.jar:?]
	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) ~[portal-impl.jar:?]
	at com.liferay.change.tracking.internal.aop.CTTransactionAdvice.invoke(CTTransactionAdvice.java:80) ~[?:?]
	at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57) ~[portal-impl.jar:?]
	at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49) ~[portal-impl.jar:?]
	at com.sun.proxy.$Proxy927.execute(Unknown Source) ~[?:?]
	at com.liferay.portal.background.task.internal.SerialBackgroundTaskExecutor.execute(SerialBackgroundTaskExecutor.java:63) ~[?:?]
	at com.liferay.portal.kernel.backgroundtask.DelegatingBackgroundTaskExecutor.execute(DelegatingBackgroundTaskExecutor.java:41) ~[portal-kernel.jar:?]
	at com.liferay.portal.background.task.internal.ThreadLocalAwareBackgroundTaskExecutor.execute(ThreadLocalAwareBackgroundTaskExecutor.java:72) ~[bundleFile:?]
	at com.liferay.portal.background.task.internal.messaging.BackgroundTaskMessageListener.doReceive(BackgroundTaskMessageListener.java:136) [bundleFile:?]
	at com.liferay.portal.kernel.messaging.BaseMessageListener.doReceive(BaseMessageListener.java:48) [portal-kernel.jar:?]
	at com.liferay.portal.kernel.messaging.BaseMessageListener.receive(BaseMessageListener.java:34) [portal-kernel.jar:?]
	at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:74) [portal-kernel.jar:?]
	at com.liferay.portal.messaging.internal.ParallelDestination$1.run(ParallelDestination.java:56) [bundleFile:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_121]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_121]
	at java.lang.Thread.run(Thread.java:745) [?:1.8.0_121]