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:
              Yunlin "Steven" Sun
              Engineering Assignee:
              Peter Shin
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                41 weeks, 1 day 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
                  Master