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

Upgrade to Liferay 7.4.0 fails from 7.3.5

    Details

      Description

      I'm upgrading from liferay 7.3.5 to liferay 7.4 and the upgrade process fails in com.liferay.asset.display.page.service module (2.3.2 to 3.0.1)

       

      https://github.com/liferay/liferay-portal/blob/15a17b28ef1f3e1186e14cdb40fe1f28c949767c/modules/apps/asset/asset-display-page-service/src/main/java/com/liferay/asset/display/page/internal/upgrade/v3_0_0/UpgradeAssetDisplayPageEntry.java#L48

       

       
      2021-04-28 08:14:56.250 INFO  [main][UpgradeProcess:101] Upgrading com.liferay.asset.display.page.internal.upgrade.v3_0_0.UpgradeAssetDisplayPageEntry
      2021-04-28 08:14:56.272 INFO  [main][UpgradeProcess:115] Failed upgrade process com.liferay.asset.display.page.internal.upgrade.v3_0_0.UpgradeAssetDisplayPageEntry in 21 ms
      2021-04-28 08:14:56.277 ERROR [main][ReleaseManagerImpl:93] bundle com.liferay.portal.upgrade.impl:5.0.1 (443)[com.liferay.portal.upgrade.internal.release.ReleaseManagerImpl(1371)] : The activate method has thrown an exception
      com.liferay.portal.kernel.log.LogSanitizerException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.BatchUpdateException: Batch entry 1 insert into AssetDisplayPageEntry (uuid_, assetDisplayPageEntryId, groupId, companyId, userId, userName, createDate, modifiedDate, classNameId, classPK, layoutPageTemplateEntryId, type_, plid) values( '174f649a-e4f0-94df-a130-23e882cfcd78', 279029, 20126, 20099, 0, NULL, '2021-04-28 08:14:56.253+00', '2021-04-28 08:14:56.253+00', 33425, 85310, 0, 0, 0) was aborted: ERROR: duplicate key value violates unique constraint "ix_68525006"_  Detail: Key (groupid, classnameid, classpk, ctcollectionid)=(20126, 33425, 85310, 0) already exists.  Call getNextException to see other errors in the batch. [Sanitized]
      at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:109) ~[portal-kernel.jar:?]

       

      All the other modules were upgraded perfectly
       
      Thanks

        Attachments

        1. com.liferay.asset.display.page.api.jar
          61 kB
        2. query1.sql
          12 kB
        3. query2.sql
          54 kB
        4. query3.sql
          5 kB

          Activity

            People

            Assignee:
            team-upgrades Product Team Upgrades
            Reporter:
            majulvez Miguel Angel Júlvez
            Participants of an Issue:
            Recent user:
            Sophia Zhang
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

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

                Packages

                Version Package
                7.4.1 CE GA2 DXP 7,4
                7.4.2 CE GA3 DXP 7,4
                7.4.13 DXP GA1
                7.4.X
                Master