Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

DB2 SQL Error after publishing publications with message board on DB2 11.1

Fix Priority

3

Components

Affects versions

Fix versions

Labels

Description

:info Steps to reproduce

  1. Enable Publications

  2. Add a new publication "P1"

  3. Add a new message board

  4. Add a reply for the message board

  5. Navigate to Publications Admin

  6. Review the Changes

  7. Publish the publication with JSONWS API

    curl -X POST -u 'test@liferay.com:test' -d 'ctCollectionId=1' -d 'userId=20127' http://localhost:8080/api/jsonws/ct.ctcollection/publish-ct-collection

  8. Navigate to Publications History tab with URL
    http://localhost:8080/group/control_panel/manage?p_p_id=com_liferay_change_tracking_web_portlet_PublicationsPortlet&p_p_lifecycle=0&p_p_state=maximized&p_p_mode=view&_com_liferay_change_tracking_web_portlet_PublicationsPortlet_mvcRenderCommandName=%2Fchange_tracking%2Fview_history

:cross_mark: Actual Result:
Publication fails to publishe and DB2 SQL Error throws.

2021-11-01 23:28:29.884 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.$Proxy79.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.$Proxy654.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]

Activity

Show:

Linda SuiFebruary 25, 2022 at 12:33 AM

No longer reproducible on:
Tomcat 9.0.53 + DB2 11.1. Portal master GIT ID: 461670a9b7592346ec243fda3fe52943e103f5c2.

Publication published successfully.

Linda SuiNovember 5, 2021 at 3:10 AM

After investigation, it's not a regression bug, it's found after the tests changed with the new step, I will update it as bug.

Linda SuiNovember 5, 2021 at 2:56 AM

Linda SuiNovember 5, 2021 at 1:41 AM

Linda SuiNovember 4, 2021 at 7:21 PM
Edited

Reproduced on:
Tomcat 9.0.53 + DB2 11.1. Portal master GIT ID:6231ae48877fa66223a6c766b1825cfc6d94f30f.

No Longer Reproducible
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Last Working Version

Zendesk Support

Created November 1, 2021 at 8:47 PM
Updated March 3, 2022 at 12:41 PM
Resolved February 25, 2022 at 12:34 AM

Flag notifications