Description

    Steps to Reproduce:

    1. Import the attached 7.0.4 portal database into MariaDB 10
    2. 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
    

      Attachments

        Issue Links

          Activity

            People

            • Assignee:
              victor.ware Victor Ware
              Reporter:
              victor.ware Victor Ware
              Participants of an Issue:
              Recent user:
              Victor Ware
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                23 weeks ago