Having Layout Branch and Versions stored in PortalPreferences can lead to Out-of-Memory (OOM) errors

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

Having many layouts and layout branches and versions can lead to Out of Memory errors. This is because each layout branches and versions information is stored for every user in the PortalPreferences table. If there are many layouts, this can lead to each record in the PortalPreferences table becoming overly large.

See the attached file to see an example record of the Preferences column from the PortalPreferences table.