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

Failure to upgrade from 6.0.11 to 6.1.0 due to attempt to drop index that does not exist

    Details

      Description

      The changes in LPS-26438 introduce a "drop index" statement for IX_4A1F4402 and IX_8D83D0CE.

      IX_8D83D0CE is introduced in 5.2.3 (and backported to 5.1 EE SP2) when the ResourcePermission table was introduced. Therefore, if starting from any release that does not have the ResourcePermission table, such as 5.2.2 or earlier, 5.1 EE, 5.1 EE SP1, or 5.1 EE SP2, an exception is thrown on the "drop index" statement and the rest of the update schema script is not executed.

      IX_4A1F4402 is introduced in 6.0.12. However, 6.0.11 shares the 6.0.12 upgrade path (even though it doesn't have that index), and when starting from 6.0.11, an exception is thrown on the "drop index" statement and the rest of the update schema script is not executed.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              tammy.fong Tammy Fong (Inactive)
              Reporter:
              minhchau.dang Minhchau Dang
              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, 10 weeks, 5 days ago

                  Packages

                  Version Package
                  6.1.20 EE GA2
                  --Sprint 11/12
                  6.2.0 CE M2