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

UpgradeFragmentEntry failed when upgrade from 7.2.10-DXP9

    Details

      Description

      Step to reproduce:

      1. Start a 7.2.10-DXP9
      2. Sign In
      3. Shutdown server
      4. Copy data folder to master
      5. Upgrade to master

      Expected Results:
      The upgrade should succeed.

      Actual Results:
      The UpgradeFragmentEntry process failed.

      2020-12-08 03:55:11.654 INFO  [main][UpgradeProcess:101] Upgrading com.liferay.fragment.internal.upgrade.v2_2_1.UpgradeFragmentEntry
      2020-12-08 03:55:11.656 INFO  [main][UpgradeProcess:115] Failed upgrade process com.liferay.fragment.internal.upgrade.v2_2_1.UpgradeFragmentEntry in 2 ms
      2020-12-08 03:55:11.675 ERROR [main][ReleaseManagerOSGiCommands:93] bundle com.liferay.portal.upgrade.impl:5.0.0 (239)[com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands(690)] : The activate method has thrown an exception
      com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLSyntaxErrorException: Can't DROP 'IX_62913C70'; check that column/key exists
              at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:109)
              at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:127)
              at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor$UpgradeInfosRunnable.run(UpgradeExecutor.java:200)
      

      Reproduced on:
      Upgrade From: 7.2.10-DXP9.
      Upgrade From: 7.2.x-private GIT ID: 129481800fc17b65cd2459b6473bb2835f7b4752.
      Tomcat 9.0.37 + MySQL 5.7. Portal master GIT ID: 11129037feb647a57bd67c88e70106cbbd1dffd6.
      Tomcat 9.0.37 + MySQL 5.7. Portal 7.3.x-private GIT ID: 02be3956520a722ac52d6a7606fb22c5c6f0abdc.
      Tomcat 9.0.37 + MySQL 5.7. Portal 7.3.10-GA1.

      Can not be reproduced on:
      Upgrade From: 7.2.10.3-SP3.
      Tomcat 9.0.37 + MySQL 5.7. Portal master GIT ID: 11129037feb647a57bd67c88e70106cbbd1dffd6.
      Tomcat 9.0.37 + MySQL 5.7. Portal 7.3.x-private GIT ID: 02be3956520a722ac52d6a7606fb22c5c6f0abdc.
      Tomcat 9.0.37 + MySQL 5.7. Portal 7.3.10-GA1.

        Attachments

          Activity

            People

            Assignee:
            yang.cao Yang Cao
            Reporter:
            yang.cao Yang Cao
            Participants of an Issue:
            Recent user:
            Jorge Diaz
            Engineering Assignee:
            Pavel Savinov (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Dates

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

                Packages

                Version Package
                7.3.X
                Master