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

6.0.3 UpgradeAsset very slow when upgrading from 5.2.3

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: Fixed
    • Affects Version/s: 6.0.4 GA, 6.0.5 GA, 6.0.6 GA, 6.1.0 CE GA1, 6.2.0 CE M2
    • Component/s: None
    • Labels:
      None

      Description

      When upgrading portal from version 5.2.3, the table AssetEntry is newly created without any indexes (they are created at the end of the upgrade process), and because of that the UPDATE commands in the com.liferay.portal.upgrade.v6_0_3.UpgradeAsset execute very slowly, since they search by classNameId and classPK and no index exists on those fields at the time. I was upgrading database with about 20000 records in the assets table and the single task took long hours (while all the rest of the upgrade was relatively fast). However when I tried to add the index on (classNameId,classPK) at the same time, when the UpgradeAsset was starting, I got it to finish very quickly.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              support-lep@liferay.com SE Support
              Reporter:
              tomasz.grysztar Privalov (Inactive)
              Participants of an Issue:
              Recent user:
              Marta Elicegui
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                9 years, 18 weeks, 4 days ago

                  Packages

                  Version Package
                  6.1.10 EE GA1
                  6.1.20 EE GA2
                  6.2.0 CE M2