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

New indexes for modules aren't added during the upgrade process

    Details

      Description

      Steps to reproduce it:

      1. Startup a 6.2 portal so that the database is created
      2. Shutdown it
      3. Upgrade that database to master
      4. Check indexes for JournalArticleResource table

      Results: index IX_CC7576C7 doesn't exist
      Expected results: IX_CC7576C7 exist

      New indexes for Core are created because com.liferay.portal.events.StartupHelper.updateIndexes logic takes care of it. However for modules the indexes should be added to the update.sql file.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              alberto.chaparro Alberto Chaparro
              Reporter:
              alberto.chaparro Alberto Chaparro
              Participants of an Issue:
              Recent user:
              Csaba Turcsan
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

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

                  Packages

                  Version Package
                  7.0.0 DXP FP29
                  7.0.X EE
                  7.0.4 CE GA5
                  7.0.0 DXP FP34
                  7.0.0 DXP SP7
                  7.0.5 CE GA6
                  7.1.0 M1
                  7.1.X
                  Master