UpgradeFragmentEntry failed when upgrade from 7.2.10-DXP9

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.3.10 DXP GA1, 7.3.X, Master
• Fix Version/s: 7.3.10 DXP FP1, 7.3.10.1 DXP SP1, 7.3.6 CE GA7, 7.3.X, Master
• Component/s: Fragment Administration
• Labels:
  • 7.3-blocker
  • 7.3-pre-fp1
  • QA-F
  • QA-FP
  • QA-NA
  • ee-7.2.x-only
  • ee-ts
  • liferay-dxp-73-sp1
  • liferay-fixpack-dxp-1-7310
  • pt-upgrade-review
• Branch Version/s:
  7.3.x
• Backported to Branch:
  Committed
• Fix Priority: 5
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/96922
• QA Test Name:
  • Manual_Environment_Upgrade
• QA Test Score: 5

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.