StaleStateException happens when reselect manual asset on configuration modal of Asset Publisher

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.4.13 DXP U64, Master
• Fix Version/s: 7.4.13 DXP U66, 7.4.3.66 CE GA66, Master
• Component/s: Content Display Widgets > Asset Publisher widget
• Labels:
  • 7.4-known-issues
  • 7.4.13-u66
  • QA-AUTOMATION
  • liferay-ga64-ce-743-known-issues
• Fix Priority: 3
• Git Pull Request: https://github.com/liferay-echo/liferay-portal/pull/11173
• Bug Type: Default
• QA Test Name:
  • LocalFile.AssetPublisherUseCase#RemoveMultipleManualSelectionAssetEntries
• QA Test Score: 5

Step to reproduce:

1. Add two web contents
2. Add an Asset Publisher to a widget page
3. Navigate to the configuration modal of Asset Publisher
4. Change the Asset Selection to Manual
5. Expand the Asset Entries section
6. Select both web contents
7. Remove one
8. Reselect that web content

Expected Results:
The configuration modal should be rendered well.

Actual Results:
The configuration modal becomes empty. The following error is thrown on server console:

2023-02-14 02:35:34.001 ERROR [http-nio-8080-exec-10][BatchingBatch:139] HHH000315: Exception executing batch [org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; statement executed: update PortletPreferenceValue set mvccVersion=?, smallValue=? where portletPreferenceValueId=? and mvccVersion=?], SQL: update PortletPreferenceValue set mvccVersion=?, smallValue=? where portletPreferenceValueId=? and mvccVersion=?
2023-02-14 02:35:34.008 ERROR [http-nio-8080-exec-10][PortletServlet:118] Unable to process portlet com_liferay_portlet_configuration_web_portlet_PortletConfigurationPortlet: org.springframework.orm.hibernate5.HibernateOptimisticLockingFailureException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; statement executed: update PortletPreferenceValue set mvccVersion=?, smallValue=? where portletPreferenceValueId=? and mvccVersion=?; nested exception is org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; statement executed: update PortletPreferenceValue set mvccVersion=?, smallValue=? where portletPreferenceValueId=? and mvccVersion=?
javax.portlet.PortletException:

Reproduced on:
Tomcat 9.0.71 + MySQL 5.7. Portal master GIT ID: a5c96d94cf09ad045c4ab352ae0730a8f5af5712.
Tomcat 9.0.71 + MySQL 5.7. Portal 7.4.13-DXP-U64 build #6356.