Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-129554

Error received while upgrading from 6.2 to DXP

    Details

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

      Description

      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
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              team-upgrades Product Team Upgrades
              Reporter:
              chao.wang Chao Wang
              Participants of an Issue:
              Recent user:
              Maria Muriel
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                24 weeks, 2 days ago

                  Packages

                  Version Package