Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-131435

Slow performance in UpgradeUrlSubject when upgrading to 7.3

    Details

      Description

      Steps:

      1. In 7.2 DXP, create 15k threads within Message Boards using Dummy Factory
      2. Set up and run the 7.3 upgrade

      Testing/Results:
      When upgrading, the UpgradeURLSubject step takes longer than other steps:

      2021-04-21 16:41:26.744 INFO  [main][UpgradeProcess:101] Upgrading com.liferay.message.boards.internal.upgrade.v3_0_0.UpgradeMBMessageTreePath
      2021-04-21 16:41:26.748 INFO  [main][LoggingTimer:83] Starting com.liferay.portal.kernel.upgrade.UpgradeProcess#alter
      2021-04-21 16:41:27.169 INFO  [main][LoggingTimer:44] Completed com.liferay.portal.kernel.upgrade.UpgradeProcess#alter in 421 ms
      2021-04-21 16:41:27.419 INFO  [main][UpgradeProcess:115] Completed upgrade process com.liferay.message.boards.internal.upgrade.v3_0_0.UpgradeMBMessageTreePath in 675 ms
      2021-04-21 16:41:27.422 INFO  [main][UpgradeProcess:101] Upgrading com.liferay.message.boards.internal.upgrade.v3_1_0.UpgradeUrlSubject
      2021-04-21 16:41:27.425 INFO  [main][LoggingTimer:83] Starting com.liferay.portal.kernel.upgrade.UpgradeProcess#alter
      2021-04-21 16:41:27.829 INFO  [main][LoggingTimer:44] Completed com.liferay.portal.kernel.upgrade.UpgradeProcess#alter in 404 ms
      
      
      2021-04-21 16:42:43.961 INFO  [main][UpgradeProcess:115] Completed upgrade process com.liferay.message.boards.internal.upgrade.v3_1_0.UpgradeUrlSubject in 76539 ms
      
      
      2021-04-21 16:42:43.963 INFO  [main][UpgradeProcess:101] Upgrading com.liferay.message.boards.internal.upgrade.v4_0_0.UpgradeMBCategoryLastPostDate
      2021-04-21 16:42:44.005 INFO  [main][UpgradeProcess:115] Completed upgrade process com.liferay.message.boards.internal.upgrade.v4_0_0.UpgradeMBCategoryLastPostDate in 42 ms
      2021-04-21 16:42:44.009 INFO  [main][UpgradeProcess:101] Upgrading com.liferay.message.boards.internal.upgrade.v4_0_0.UpgradeMBCategoryMessageCount
      2021-04-21 16:42:44.049 INFO  [main][UpgradeProcess:115] Completed upgrade process com.liferay.message.boards.internal.upgrade.v4_0_0.UpgradeMBCategoryMessageCount in 39 ms
      2021-04-21 16:42:44.052 INFO  [main][UpgradeProcess:101] Upgrading com.liferay.message.boards.internal.upgrade.v4_0_0.UpgradeMBCategoryThreadCount
      2021-04-21 16:42:44.090 INFO  [main][UpgradeProcess:115] Completed upgrade process com.liferay.message.boards.internal.upgrade.v4_0_0.UpgradeMBCategoryThreadCount in 38 ms
      2021-04-21 16:42:44.094 INFO  [main][UpgradeProcess:101] Upgrading com.liferay.message.boards.internal.upgrade.v5_0_0.UpgradeMBThreadMessageCount
      2021-04-21 16:42:44.368 INFO  [main][UpgradeProcess:115] Completed upgrade process com.liferay.message.boards.internal.upgrade.v5_0_0.UpgradeMBThreadMessageCount in 274 ms
      2021-04-21 16:42:44.372 INFO  [main][UpgradeProcess:101] Upgrading com.liferay.message.boards.internal.upgrade.MBServiceUpgrade$1

        Attachments

          Activity

            People

            Assignee:
            jeremy.chen Jeremy Chen
            Reporter:
            jesse.yeh Jesse Yeh
            Participants of an Issue:
            Recent user:
            Enterprise Release HU
            Engineering Assignee:
            Jesse Yeh
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              10 weeks ago

                Packages

                Version Package
                7.3.X
                7.4.1 CE GA2 DXP 7,4
                Master