Bad performance at v6_2_0.UpgradeJournal#updateAssetEntryClassTypeId

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.X, 7.1.0 Beta 1, Master
• Fix Version/s: 7.0.0 DXP FP60, 7.0.0 DXP SP9, 7.0.X, 7.1.0 Beta 3, 7.1.X, Master
• Component/s: WCM
• Labels:
  • 7.1UPGRADE-PERFORMANCE
  • liferay-dxp-70-sp9
  • liferay-fixpack-de-60-7010
• Branch Version/s:
  7.0.x
• Backported to Branch:
  Committed
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/59139
• Bug Type: Database Upgrade

Steps to reproduce

1. Startup a 6.1.30
2. Create a Journal Structure
3. Create 1 article with 1000 versions using that structure
4. Shutdown the server
5. Perform the upgrade to master

Results:
Check for

Completed com.liferay.portal.upgrade.v6_2_0.UpgradeJournal#updateAssetEntryClassTypeId

in the logs. The process will take several minutes

Expected results:
Check for

Completed com.liferay.portal.upgrade.v6_2_0.UpgradeJournal#updateAssetEntryClassTypeId

in the logs. The process will take just a few seconds

The performance is much worse with more journalArticles and a lot of versions per article.