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

Fail to publish the publication intermittently with message thread on DB2

    Description

    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]
    

      Attachments

        Activity

          People

          Assignee:
          support-lep@liferay.com SE Support
          Reporter:
          linda.sui Linda Sui
          Participants of an Issue:
          Recent user:
          Felipe Lins
          Votes:
          0 Vote for this issue
          Watchers:
          0 Start watching this issue

            Dates

            Created:
            Updated:
            Days since last comment:
            23 weeks, 2 days ago

              Packages

              Version Package