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

Missing indexes after upgrade from 7.3 to 7.4

    Details

      Description

      Steps to Reproduce:

      1. Import attached 7.3.10 database to MySQL data-archive-portal-mysql.zip
      2. Upgrade this database to Master (with DXP profile)
        • tools/portal-tools-db-upgrade-client/db_upgrade.sh
      3. Connect Master to a different, empty database schema
      4. Start master against blank database schema
      5. Compare FragmentEntryLink and SiteFriendlyURL tables between upgraded and fresh database

      Expected Result:
      Table indexes match between the 2 databases.

      Actual Result:
      Upgraded database is missing some indexes.

      Missing indexes
      TABLE FragmentEntryLink

       KEY `IX_95663C5E` (`groupId`,`segmentsExperienceId`,`plid`,`rendererKey`,`ctCollectionId`)
      

      TABLE SiteFriendlyURL

      KEY `IX_383E2D21` (`groupId`,`companyId`)
      

      Slimmed down database dumps also attached to easily see a diff
      fresh.sql upgraded.sql

        Attachments

        1. data-archive-portal-mysql.zip
          1.17 MB
        2. fresh.sql
          421 kB
        3. upgraded.sql
          434 kB

          Activity

            People

            Assignee:
            oziel.souza Oziel Souza
            Reporter:
            victor.ware Victor Ware
            Participants of an Issue:
            Recent user:
            Oziel Souza
            Engineering Assignee:
            Ruben Pulido
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              2 weeks, 2 days ago

                Packages

                Version Package
                Master