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

OutOfMemoryError when upgrading from 6.2 to 7.0

    Details

      Description

      Steps to reproduce:
      # Have a db with for example a large MBMessage table (like 2million+ entries)

      1. Install de-15 DXP tomcat bundle
      2. Perform the upgrade with 12 GB heap memory

       Issue: OutOfMemoryError occurs in the log:

      11:19:43,393 INFO [main][UpgradeProcess:99] Completed upgrade process com.liferay.portal.upgrade.UpgradeProcess_7_0_0 in 1018198ms
      Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceeded
      at com.mysql.jdbc.MysqlIO.nextRowFast(MysqlIO.java:2155)
      at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1932)
      at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:3437)
      at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:488)
      at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:3131)
      at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:2299)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2722)
      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2794)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
      at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322)
      at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
      at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
      at com.liferay.portal.kernel.dao.db.DBInspector.hasColumn(DBInspector.java:67)
      at com.liferay.portal.kernel.dao.db.BaseDBProcess.hasColumn(BaseDBProcess.java:133)
      at com.liferay.portal.kernel.upgrade.BaseUpgradeLastPublishDate.addLastPublishDateColumn(BaseUpgradeLastPublishDate.java:40)
      at com.liferay.portal.upgrade.v7_0_0.UpgradeLastPublishDate.upgradeMessageBoards(UpgradeLastPublishDate.java:123)
      at com.liferay.portal.upgrade.v7_0_0.UpgradeLastPublishDate.doUpgrade(UpgradeLastPublishDate.java:31)
      at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:90)
      at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:117)
      at com.liferay.portal.upgrade.UpgradeProcess_7_0_0.doUpgrade(UpgradeProcess_7_0_0.java:82)
      at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:90)
      at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:175)
      at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:143)
      at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:125)
      at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:164)
      at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:81)
      at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:153)
      at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:99)
      11:19:57,920 WARN [HikariPool-1 housekeeper][HikariPool:676] HikariPool-1 - Thread starvation or clock leap detected (housekeeper delta=2m43s377ms564µs171ns).
      

       Expected: The upgrade should be performed successfully.

       

       Reproduced on master too (593fb63e88cf6c7674d476f9ee8ca71e0c46521e)

        Attachments

          Activity

            People

            • Assignee:
              raven.song Raven Song
              Reporter:
              norbert.kocsis Norbert Kocsis
              Participants of an Issue:
              Recent user:
              Csaba Turcsan
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                1 year, 49 weeks, 3 days ago

                Packages

                Version Package
                7.0.0 DXP FP23
                7.0.X EE
                7.0.4 CE GA5
                7.1.0 M1
                7.1.X
                Master