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

        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:
            2 years, 6 weeks, 1 day ago

              Packages

              Version Package