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

Upgrade to Liferay 7.4.0 fails from 7.3.5 (part 2)

    Details

      Description

      I'm trying to upgrade another project from 7.3.5 to 7.4.0 but the process upgrade fails. The problem is similar to this other issue I opened but a little different https://issues.liferay.com/browse/LPS-131391

      I followed the instructions of LPS-131391 copying the .jar to osgi/marketplace/override but this time didn't work. The exceptions are different too

      g! upgrade:checkg! upgrade:checkThere are upgrade processes available for com.liferay.asset.display.page.service from 2.3.1 to 3.0.1g! upgrade com.liferay.asset.display.page.servicegogo: CommandNotFoundException: Command not found: upgradeg! upgrade:execute com.liferay.asset.display.page.serviceINFO - Upgrading com.liferay.asset.display.page.internal.upgrade.v2_3_2.AssetDisplayPageEntryUpgradeProcessINFO - Failed upgrade process com.liferay.asset.display.page.internal.upgrade.v2_3_2.AssetDisplayPageEntryUpgradeProcess in 14 msERROR - Failed upgrade process for module com.liferay.asset.display.page.servicecom.liferay.portal.kernel.log.LogSanitizerException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: llave duplicada viola restricción de unicidad «ix_68525006»_  Detail: Ya existe la llave (groupid, classnameid, classpk, ctcollectionid)=(20182, 20424, 1184802, 0). [Sanitized] at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:109) ~[portal-kernel.jar:?] at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:127) ~[portal-kernel.jar:?] at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor$UpgradeInfosRunnable.run(UpgradeExecutor.java:199) ~[bundleFile:?] at com.liferay.portal.output.stream.container.internal.OutputStreamContainerFactoryTrackerImpl.runWithSwappedLog(OutputStreamContainerFactoryTrackerImpl.java:134) [bundleFile:?] at com.liferay.portal.upgrade.internal.executor.SwappedLogExecutor.execute(SwappedLogExecutor.java:51) [bundleFile:?] at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor.executeUpgradeInfos(UpgradeExecutor.java:154) ~[bundleFile:?] at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor.execute(UpgradeExecutor.java:117) ~[bundleFile:?] at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands.execute(ReleaseManagerOSGiCommands.java:81) [bundleFile:?] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?] at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?] at org.apache.felix.gogo.runtime.Reflective.invoke(Reflective.java:139) [bundleFile:?] at org.apache.felix.gogo.runtime.CommandProxy.execute(CommandProxy.java:91) [bundleFile:?] at org.apache.felix.gogo.runtime.Closure.executeCmd(Closure.java:599) [bundleFile:?] at org.apache.felix.gogo.runtime.Closure.executeStatement(Closure.java:526) [bundleFile:?] at org.apache.felix.gogo.runtime.Closure.execute(Closure.java:415) [bundleFile:?] at org.apache.felix.gogo.runtime.Pipe.doCall(Pipe.java:416) [bundleFile:?] at org.apache.felix.gogo.runtime.Pipe.call(Pipe.java:229) [bundleFile:?] at org.apache.felix.gogo.runtime.Pipe.call(Pipe.java:59) [bundleFile:?] at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?] at java.lang.Thread.run(Thread.java:829) [?:?]Caused by: com.liferay.portal.kernel.log.LogSanitizerException: org.postgresql.util.PSQLException: ERROR: llave duplicada viola restricción de unicidad «ix_68525006»_  Detail: Ya existe la llave (groupid, classnameid, classpk, ctcollectionid)=(20182, 20424, 1184802, 0). [Sanitized] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) ~[postgresql.jar:42.2.5] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) ~[postgresql.jar:42.2.5] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308) ~[postgresql.jar:42.2.5] at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) ~[postgresql.jar:42.2.5] at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) ~[postgresql.jar:42.2.5] at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:143) ~[postgresql.jar:42.2.5] at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:120) ~[postgresql.jar:42.2.5] at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) ~[hikaricp.jar:?] at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java) ~[hikaricp.jar:?] at com.liferay.asset.display.page.internal.upgrade.v2_3_2.AssetDisplayPageEntryUpgradeProcess._upgradeDLAssetDisplayPageTypes(AssetDisplayPageEntryUpgradeProcess.java:47) ~[?:?] at com.liferay.asset.display.page.internal.upgrade.v2_3_2.AssetDisplayPageEntryUpgradeProcess.doUpgrade(AssetDisplayPageEntryUpgradeProcess.java:31) ~[?:?] at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:104) ~[portal-kernel.jar:?] ... 23 more

       

      https://github.com/liferay/liferay-portal/blob/7.4.x/modules/apps/asset/asset-display-page-service/src/main/java/com/liferay/asset/display/page/internal/upgrade/v2_3_2/AssetDisplayPageEntryUpgradeProcess.java#L34

       

      Thanks

        Attachments

        1. sql1.sql
          1.50 MB
        2. sql2.sql
          58 kB
        3. sql3.sql
          323 kB

          Activity

            People

            Assignee:
            yang.cao Yang Cao
            Reporter:
            majulvez Miguel Angel Júlvez
            Participants of an Issue:
            Recent user:
            Clarissa Velazquez
            Engineering Assignee:
            Jürgen Kappler
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              33 weeks, 3 days ago

                Packages

                Version Package
                7.3.10.3 DXP SP3
                7.3.X
                7.4.1 CE GA2 DXP 7,4
                7.4.13 DXP GA1
                7.4.3.4 CE GA4
                Master