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

Upgrade: changes in database indexes are not applied for non-default partitions

    Details

      Description

      Steps to reproduce it:

      1. Start 7.4 DXP EP2 bundle connected to MySQL with "database.partition.enabled=true"
      2. Create 2 virtual instances
      3. Login to both instances
      4. Shutdown DXP
      5. Execute upgrade to master
      6. When it finishes check database indexes for Calendar table in both database schemas

      Expected results:
      The indexes are exactly the same in both schemas and they are:

      create index IX_BC95A53F on Calendar (groupId, calendarResourceId, ctCollectionId);
      create index IX_8C1A91AC on Calendar (groupId, calendarResourceId, defaultCalendar, ctCollectionId);
      create index IX_2640AF6 on Calendar (uuid_[$COLUMN_LENGTH:75$], companyId, ctCollectionId);
      create index IX_E6BA3BEE on Calendar (uuid_[$COLUMN_LENGTH:75$], ctCollectionId);
      create unique index IX_31D79378 on Calendar (uuid_[$COLUMN_LENGTH:75$], groupId, ctCollectionId);
      

      Results:
      The indexes are not the same between the default database schema and the secondary schema.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              koor.gai Koor Gai
              Reporter:
              alberto.chaparro Alberto Chaparro
              Participants of an Issue:
              Recent user:
              Koor Gai
              Engineering Assignee:
              Alberto Chaparro
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

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

                  Packages

                  Version Package
                  Master