-
Type:
Bug
-
Status: Closed
-
Resolution: Won't Fix
-
Affects Version/s: 7.0.X, 7.1.X, Master
-
Fix Version/s: None
-
Labels:
-
Fix Priority:2
-
Databases:MariaDB 10.2
-
QA Test Name:
- LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive612
- LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive6130
- LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive621015
- LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive621021
- LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive625
- LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive70106
- LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive704
-
QA Test Score:35
Steps to Reproduce:
- Import the attached 7.0.4 portal database into MariaDB 10
- Upgrade to 7.0/7.1/master
Expected Result:
No sql statement issues.
Actual Result:
Upgrade throws warnings:
2018-12-13 00:25:58.607 WARN [main][UpgradeProcess:447] Attempting to upgrade table Counter by recreating the table due to: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'PRIMARY on Counter' at line 1_Query is:_drop index PRIMARY on Counter [Sanitized] 2018-12-13 00:25:58.607 INFO [main][LoggingTimer:83] Starting com.liferay.portal.kernel.upgrade.UpgradeProcess#upgradeTable#Counter 2018-12-13 00:25:58.614 INFO [main][Table:168] Starting backup of Counter to /var/folders/zv/5zswc4cd7rq93lr2t_vr1slm0000gn/T/temp-db-Counter-7856952594392737640.tmp 2018-12-13 00:25:58.616 INFO [main][Table:204] Finished backup of Counter to /var/folders/zv/5zswc4cd7rq93lr2t_vr1slm0000gn/T/temp-db-Counter-7856952594392737640.tmp in 2 ms 2018-12-13 00:25:58.648 INFO [main][LoggingTimer:43] Completed com.liferay.portal.kernel.upgrade.UpgradeProcess#upgradeTable#Counter in 41 ms 2018-12-13 00:25:58.648 WARN [main][UpgradeProcess:466] Successfully recreated and upgraded table Counter