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

              koor.gai Koor Gai (Inactive)
              alberto.chaparro Alberto Chaparro
              Kiyoshi Lee Kiyoshi Lee
              Alberto Chaparro Alberto Chaparro
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                1 year, 14 weeks, 2 days ago

                Packages

                  Version Package
                  7.4.13 DXP GA1
                  7.4.3.4 CE GA4
                  Master