Error received while upgrading from 6.2 to DXP

• Type: Bug
• Status: Closed
• Resolution: No Longer Reproducible
• Affects Version/s: 7.2.X, 7.3.X, Master
• Fix Version/s: None
• Component/s: Database Upgrade Framework
• Labels: None
• Fix Priority: 3

Steps to reproduce:

1) Setup Liferay 6.2(6.2sp20 or ee-6.2.x) with no demo data.
2) Upload 5 files in the document library.
3) Create dynamic data list definition with one text field and one Documents & Media field.
4) Make the Documents & Media field repeatable.
5) Create a dynamic data list using the created definition.
6) Create an entry in that list with multiple documents.
7) Stop the 6.2 server
8) Setup a Liferay DXP server
9) Copy the data/document_library folder from 6.2 to DXP
10) Upgrade to DXP with the 6.2 databases with the included upgrade tool.

Expected:
Upgrade successfully without error.

Actual:
The failed upgrade process.

2021-03-23 03:11:28.680 INFO  [main][UpgradeProcess:107] Failed upgrade process com.liferay.portal.upgrade.v7_0_0.UpgradeMySQL in 11012 ms
2021-03-23 03:11:28.680 INFO  [main][UpgradeProcess:107] Failed upgrade process com.liferay.portal.upgrade.UpgradeProcess_7_0_0 in 22449 ms
com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Error on rename of '.\lportal\#sql-14f4_21' to '.\lportal\blogsstatsuser' (errno: 168 - Unknown (generic) error from engine)
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:101)
	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:173)
	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:140)
	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:122)
	at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:155)
	at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:89)
	at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:174)
	at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:103)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.liferay.portal.tools.db.upgrade.client.DBUpgraderLauncher.main(DBUpgraderLauncher.java:55)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Error on rename of '.\lportal\#sql-14f4_21' to '.\lportal\blogsstatsuser' (errno: 168 - Unknown (generic) error from engine)
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:101)
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:141)
	at com.liferay.portal.upgrade.UpgradeProcess_7_0_0.doUpgrade(UpgradeProcess_7_0_0.java:100)
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:96)
	... 12 more