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

Service builder making index changes on 7.3.x

    Details

      Description

      Steps to Reproduce:

      1. Fetch 7.3.x from https://github.com/brianchandotcom/liferay-portal-ee
      2. Run ant setup-profile-dxp
      3. Run ant build-services from portal-impl/

      Expected Result:
      No changes made by Service Builder.

      Actual Result:
      Service builder making changes to re-add indexes removed in LPS-121714

           [echo] diff --git a/modules/apps/commerce/commerce-service/src/main/resources/META-INF/sql/indexes.sql b/modules/apps/commerce/commerce-service/src/main/resources/META-INF/sql/indexes.sql
           [echo] index 0ab0215ef21ee..79a0da3e1c544 100644
           [echo] --- a/modules/apps/commerce/commerce-service/src/main/resources/META-INF/sql/indexes.sql
           [echo] +++ b/modules/apps/commerce/commerce-service/src/main/resources/META-INF/sql/indexes.sql
           [echo] @@ -68,6 +68,7 @@ create index IX_DB0BB83C on CommerceShipmentItem (groupId);
           [echo]  create index IX_42E5F6EF on CommerceShippingMethod (groupId, active_);
           [echo]  create unique index IX_C4557F93 on CommerceShippingMethod (groupId, engineKey[$COLUMN_LENGTH:75$]);
           [echo]  
           [echo] +create unique index IX_BE881965 on CommerceSubscriptionEntry (CPInstanceUuid[$COLUMN_LENGTH:75$], CProductId, commerceOrderItemId);
           [echo]  create unique index IX_D7D137B1 on CommerceSubscriptionEntry (commerceOrderItemId);
           [echo]  create index IX_43E6F382 on CommerceSubscriptionEntry (companyId, userId);
           [echo]  create index IX_B99DE058 on CommerceSubscriptionEntry (groupId, companyId, userId);
           [echo] diff --git a/modules/apps/depot/depot-service/src/main/resources/META-INF/sql/indexes.sql b/modules/apps/depot/depot-service/src/main/resources/META-INF/sql/indexes.sql
           [echo] index 0303d2678c2d2..a0d3b1bf8c5ea 100644
           [echo] --- a/modules/apps/depot/depot-service/src/main/resources/META-INF/sql/indexes.sql
           [echo] +++ b/modules/apps/depot/depot-service/src/main/resources/META-INF/sql/indexes.sql
           [echo] @@ -3,6 +3,7 @@ create unique index IX_DA8D9ACC on DepotAppCustomization (depotEntryId, portletI
           [echo]  
           [echo]  create unique index IX_884D6226 on DepotEntry (groupId);
           [echo]  create index IX_FBDFFFF8 on DepotEntry (uuid_[$COLUMN_LENGTH:75$], companyId);
           [echo] +create unique index IX_8AD8247A on DepotEntry (uuid_[$COLUMN_LENGTH:75$], groupId);
           [echo]  
           [echo]  create index IX_F329B161 on DepotEntryGroupRel (ddmStructuresAvailable, toGroupId);
           [echo]  create unique index IX_65D34444 on DepotEntryGroupRel (depotEntryId, toGroupId);
           [echo] diff --git a/modules/apps/document-library-opener/document-library-opener-service/src/main/resources/META-INF/sql/indexes.sql b/modules/apps/document-library-opener/document-library-opener-service/src/main/resources/META-INF/sql/indexes.sql
           [echo] index a07a3c00e7595..0cbc618e9caa0 100644
           [echo] --- a/modules/apps/document-library-opener/document-library-opener-service/src/main/resources/META-INF/sql/indexes.sql
           [echo] +++ b/modules/apps/document-library-opener/document-library-opener-service/src/main/resources/META-INF/sql/indexes.sql
           [echo] @@ -1 +1,2 @@
           [echo] -create unique index IX_54148667 on DLOpenerFileEntryReference (fileEntryId);
           [echo] \ No newline at end of file
           [echo] +create unique index IX_54148667 on DLOpenerFileEntryReference (fileEntryId);
           [echo] +create unique index IX_6B9E4A66 on DLOpenerFileEntryReference (referenceType[$COLUMN_LENGTH:75$], fileEntryId);
           [echo] \ No newline at end of file
           [echo] diff --git a/modules/apps/document-library/document-library-service/src/main/resources/META-INF/sql/indexes.sql b/modules/apps/document-library/document-library-service/src/main/resources/META-INF/sql/indexes.sql
           [echo] index 4494b5f09e546..ef8a9569ee2a3 100644
           [echo] --- a/modules/apps/document-library/document-library-service/src/main/resources/META-INF/sql/indexes.sql
           [echo] +++ b/modules/apps/document-library/document-library-service/src/main/resources/META-INF/sql/indexes.sql
           [echo] @@ -1,3 +1,4 @@
           [echo]  create index IX_D5ED40C5 on DLFileVersionPreview (fileEntryId, ctCollectionId);
           [echo]  create unique index IX_DA3FFE on DLFileVersionPreview (fileEntryId, fileVersionId, ctCollectionId);
           [echo] +create unique index IX_ACBD78C8 on DLFileVersionPreview (fileEntryId, fileVersionId, previewStatus, ctCollectionId);
           [echo]  create index IX_3A1CF42B on DLFileVersionPreview (fileVersionId, ctCollectionId);
           [echo] \ No newline at end of file
           [echo] diff --git a/modules/apps/journal/journal-service/src/main/resources/META-INF/sql/indexes.sql b/modules/apps/journal/journal-service/src/main/resources/META-INF/sql/indexes.sql
           [echo] index c6f45fe31acfe..52d930533a2fa 100644
           [echo] --- a/modules/apps/journal/journal-service/src/main/resources/META-INF/sql/indexes.sql
           [echo] +++ b/modules/apps/journal/journal-service/src/main/resources/META-INF/sql/indexes.sql
           [echo] @@ -37,6 +37,8 @@ create unique index IX_4D5E99B9 on JournalArticle (uuid_[$COLUMN_LENGTH:75$], gr
           [echo]  
           [echo]  create index IX_E69312A1 on JournalArticleLocalization (articlePK, ctCollectionId);
           [echo]  create unique index IX_5593D868 on JournalArticleLocalization (articlePK, languageId[$COLUMN_LENGTH:75$], ctCollectionId);
           [echo] +create unique index IX_9B44D13C on JournalArticleLocalization (companyId, articlePK, languageId[$COLUMN_LENGTH:75$], ctCollectionId);
           [echo] +create unique index IX_97DC9F36 on JournalArticleLocalization (companyId, articlePK, title[$COLUMN_LENGTH:400$], languageId[$COLUMN_LENGTH:75$], ctCollectionId);
           [echo]  create index IX_429AC23C on JournalArticleLocalization (ctCollectionId);
           [echo]  
           [echo]  create index IX_B332E3F1 on JournalArticleResource (ctCollectionId);
           [echo] diff --git a/modules/apps/knowledge-base/knowledge-base-service/src/main/resources/META-INF/sql/indexes.sql b/modules/apps/knowledge-base/knowledge-base-service/src/main/resources/META-INF/sql/indexes.sql
           [echo] index 16d2a9cf5f34a..b09e381f3beda 100644
           [echo] --- a/modules/apps/knowledge-base/knowledge-base-service/src/main/resources/META-INF/sql/indexes.sql
           [echo] +++ b/modules/apps/knowledge-base/knowledge-base-service/src/main/resources/META-INF/sql/indexes.sql
           [echo] @@ -16,6 +16,7 @@ create index IX_2B6103F2 on KBArticle (parentResourcePrimKey, status);
           [echo]  create index IX_5FEF5F4F on KBArticle (resourcePrimKey, groupId, latest);
           [echo]  create index IX_8EF92E81 on KBArticle (resourcePrimKey, groupId, main);
           [echo]  create index IX_49630FA on KBArticle (resourcePrimKey, groupId, status);
           [echo] +create unique index IX_B5B6C674 on KBArticle (resourcePrimKey, groupId, version);
           [echo]  create index IX_A9E2C691 on KBArticle (resourcePrimKey, latest);
           [echo]  create index IX_69C17E43 on KBArticle (resourcePrimKey, main);
           [echo]  create index IX_4E89983C on KBArticle (resourcePrimKey, status);
           [echo] diff --git a/modules/apps/layout/layout-seo-service/src/main/resources/META-INF/sql/indexes.sql b/modules/apps/layout/layout-seo-service/src/main/resources/META-INF/sql/indexes.sql
           [echo] index f9b3a8e65c9e9..f3632037d635a 100644
           [echo] --- a/modules/apps/layout/layout-seo-service/src/main/resources/META-INF/sql/indexes.sql
           [echo] +++ b/modules/apps/layout/layout-seo-service/src/main/resources/META-INF/sql/indexes.sql
           [echo] @@ -3,4 +3,5 @@ create index IX_D9211E39 on LayoutSEOEntry (uuid_[$COLUMN_LENGTH:75$], companyId
           [echo]  create unique index IX_429DDEFB on LayoutSEOEntry (uuid_[$COLUMN_LENGTH:75$], groupId);
           [echo]  
           [echo]  create unique index IX_6E43ACCA on LayoutSEOSite (groupId);
           [echo] -create index IX_24696DD4 on LayoutSEOSite (uuid_[$COLUMN_LENGTH:75$], companyId);
           [echo] \ No newline at end of file
           [echo] +create index IX_24696DD4 on LayoutSEOSite (uuid_[$COLUMN_LENGTH:75$], companyId);
           [echo] +create unique index IX_C75B5956 on LayoutSEOSite (uuid_[$COLUMN_LENGTH:75$], groupId);
           [echo] \ No newline at end of file
           [echo] diff --git a/sql/indexes.sql b/sql/indexes.sql
           [echo] index 860da958061d6..f2bd08071007e 100644
           [echo] --- a/sql/indexes.sql
           [echo] +++ b/sql/indexes.sql
           [echo] @@ -209,11 +209,13 @@ create index IX_BD3CB13A on Group_ (classNameId, groupId, companyId, parentGroup
           [echo]  create index IX_8B5402E5 on Group_ (companyId, active_, ctCollectionId);
           [echo]  create unique index IX_504CABF5 on Group_ (companyId, classNameId, classPK, ctCollectionId);
           [echo]  create index IX_2442742A on Group_ (companyId, classNameId, ctCollectionId);
           [echo] +create unique index IX_B894AE04 on Group_ (companyId, classNameId, liveGroupId, groupKey[$COLUMN_LENGTH:150$], ctCollectionId);
           [echo]  create index IX_B7EBDBB2 on Group_ (companyId, classNameId, parentGroupId, ctCollectionId);
           [echo]  create index IX_A67A0AA5 on Group_ (companyId, classNameId, site, ctCollectionId);
           [echo]  create index IX_286EE120 on Group_ (companyId, ctCollectionId);
           [echo]  create unique index IX_9A7D6AD0 on Group_ (companyId, friendlyURL[$COLUMN_LENGTH:255$], ctCollectionId);
           [echo]  create unique index IX_BE219CF4 on Group_ (companyId, groupKey[$COLUMN_LENGTH:150$], ctCollectionId);
           [echo] +create unique index IX_94AE0C4E on Group_ (companyId, liveGroupId, groupKey[$COLUMN_LENGTH:150$], ctCollectionId);
           [echo]  create index IX_A20523FC on Group_ (companyId, parentGroupId, ctCollectionId);
           [echo]  create index IX_121A14F7 on Group_ (companyId, parentGroupId, site, ctCollectionId);
           [echo]  create index IX_162053E9 on Group_ (companyId, parentGroupId, site, inheritContent, ctCollectionId);
           [echo] @@ -403,6 +405,7 @@ create index IX_3078CBE6 on ResourcePermission (roleId, ctCollectionId);
           [echo]  create index IX_F3870DDF on ResourcePermission (scope, ctCollectionId);
           [echo]  
           [echo]  create unique index IX_C0F6BCAC on Role_ (companyId, classNameId, classPK, ctCollectionId);
           [echo] +create unique index IX_D303FC25 on Role_ (companyId, classNameId, classPK, type_, ctCollectionId);
           [echo]  create index IX_4EA65517 on Role_ (companyId, ctCollectionId);
           [echo]  create unique index IX_4CC99816 on Role_ (companyId, name[$COLUMN_LENGTH:75$], ctCollectionId);
           [echo]  create index IX_7037255A on Role_ (companyId, type_, ctCollectionId);
      

      Not seen on master or 7.2.x.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              victor.ware Victor Ware
              Reporter:
              victor.ware Victor Ware
              Participants of an Issue:
              Recent user:
              Sophia Zhang
              Engineering Assignee:
              Peter Shin
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                1 year, 6 weeks, 6 days ago

                  Packages

                  Version Package
                  7.0.0 DXP FP96
                  7.0.10.15 DXP SP15
                  7.0.X
                  7.1.10 DXP FP20
                  7.1.10.5 SP5
                  7.1.X
                  7.2.X
                  7.3.10 DXP FP1
                  7.3.10.1 DXP SP1
                  7.3.6 CE GA7
                  7.3.X
                  7.4.13 DXP GA1
                  Master