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

          Issue Links

            Activity

              People

              Assignee:
              yang.cao Yang Cao
              Reporter:
              yang.cao Yang Cao
              Participants of an Issue:
              Recent user:
              Chao Wang
              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:
                44 weeks, 2 days ago

                  Packages

                  Version Package
                  7.3.10 DXP FP1
                  7.3.10.1 DXP SP1
                  7.3.6 CE GA7
                  7.3.X
                  Master