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

Upgrade from DXP 7.4 EP3 to 7.4 GA1 Fails

Details

    • 5
    • Database Upgrade

    Description

      Steps to reproduce:

      1. Install a Liferay DXP 7.4 EP3 (e.g. from Docker liferay/dxp:7.4.12-ep3)
      2. Set up DB Partition
      3. Start up Liferay
      4. Add a new virtual instance. Assert that a partition (lpartition_<companyId>) has been added to the database.
      5. Shut down Liferay 
      6. Install DXP 7.4 GA1
      7. Use the upgrade tool to migrate the original Liferay instance from EP3 to GA1

      Expected behavior:

      Upgrade process completes without errors

      Current behavior:

      An error occurs:

      Failed upgrade process com.liferay.portal.upgrade.PortalUpgradeProcess in 522 ms com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.BatchUpdateException: Unknown column 'userId' in 'field list' at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:120) at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:173) at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:136) at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:172) at com.liferay.portal.tools.DBUpgrader._upgradePortal(DBUpgrader.java:375) at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:161) at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:153) at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:129) 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:54) Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.BatchUpdateException: Unknown column 'userId' in 'field list' at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:120) at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:142) at com.liferay.portal.upgrade.PortalUpgradeProcess.doUpgrade(PortalUpgradeProcess.java:137) at com.liferay.portal.kernel.upgrade.UpgradeProcess.lambda$upgrade$0(UpgradeProcess.java:114) at com.liferay.portal.db.partition.DBPartitionUtil.forEachCompanyId(DBPartitionUtil.java:128) at com.liferay.portal.dao.db.BaseDB.process(BaseDB.java:307) at com.liferay.portal.kernel.dao.db.BaseDBProcess.process(BaseDBProcess.java:241) at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:101) ... 12 more Caused by: java.sql.BatchUpdateException: Unknown column 'userId' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.cj.util.Util.handleNewInstance(Util.java:192) at com.mysql.cj.util.Util.getInstance(Util.java:167) at com.mysql.cj.util.Util.getInstance(Util.java:174) at com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:224) at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:853) at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:435) at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:796) at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:125) at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java) at com.liferay.portal.upgrade.v7_4_x.UpgradeAccount.doUpgrade(UpgradeAccount.java:157) at com.liferay.portal.kernel.upgrade.UpgradeProcess.lambda$upgrade$0(UpgradeProcess.java:114) at com.liferay.portal.db.partition.DBPartitionUtil.forEachCompanyId(DBPartitionUtil.java:119) at com.liferay.portal.dao.db.BaseDB.process(BaseDB.java:307) at com.liferay.portal.kernel.dao.db.BaseDBProcess.process(BaseDBProcess.java:241) at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:101) ... 19 more Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'userId' in 'field list' at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1092) at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:832) ... 29 more
      

      Attachments

        Issue Links

          Activity

            People

              victor.ware Victor Ware
              eduardo.garcia Eduardo García (Inactive)
              Kiyoshi Lee Kiyoshi Lee
              Sam Ziemer Sam Ziemer
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                43 weeks, 3 days ago

                Packages

                  Version Package
                  7.4.3.5 CE GA5
                  7.4.13 DXP U1
                  Master