Deleting portlets from page versions creates orphaned portlet preferences

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 6.2.10 EE GA1, 6.2.X EE, 7.0.0 M5
• Fix Version/s: 6.2.4 CE GA5, 6.2.X EE, 7.0.0 M5
• Component/s: Content Publishing > Staging
• Labels:
  • backend_test
  • liferay-fixpack-portal-49-6210
• Branch Version/s:
  6.2.x
• Backported to Branch:
  Committed
• Story Points: 17
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/25624

Steps to reproduce

1) create site and add a page
2) enable local live staging with page versioning enabled
3) add and remove a few portlets
4) look in the layoutRevision table for the "head" revision of that page and find all the portlet preferences that have a matching plid for that layoutRevisionId

expected: there should be no portletpreferences since there are no portlets on the page
actual: there are orphaned portlet preferences (since they don't belong to that page revision)