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

Liferay 7 database upgrade extremely slow

    Details

    • Fix Priority:
      4
    • JDK:
      Oracle Sun JDK 8
    • Application Servers:
      Apache Tomcat 8.0.x
    • Databases:
      SQL Server 2008 R2

      Description

      I've was stuck at this for 5 hours:

      16:11:37,732 INFO [main][LoggingTimer:38] Completed com.liferay.portal.upgrade.v6_2_0.UpgradeJournal#updateTemplates in 8529 ms
      16:11:37,732 INFO [main][LoggingTimer:70] Starting com.liferay.portal.upgrade.v6_2_0.UpgradeJournal#updateAssetEntryClassTypeId
      16:55:39,881 INFO [main][LoggingTimer:38] Completed com.liferay.portal.upgrade.v6_2_0.UpgradeJournal#updateAssetEntryClassTypeId in 2642149 ms
      16:55:39,884 INFO [main][LoggingTimer:70] Starting com.liferay.portal.kernel.upgrade.BaseUpgradePortletPreferences#updatePortletPreferences
      22:03:52,705 INFO [main][LoggingTimer:38] Completed com.liferay.portal.kernel.upgrade.BaseUpgradePortletPreferences#updatePortletPreferences in 18492820 ms

      I've been sitting at this for over 20 hours now:

      14:18:10,594 INFO [main][UpgradeProcess:82] Upgrading com.liferay.portal.upgrade.v7_0_0.UpgradeLookAndFeel
      14:18:10,595 INFO [main][LoggingTimer:70] Starting com.liferay.portal.kernel.upgrade.BaseUpgradePortletPreferences#updatePortletPreferences

      I'm attaching SQL Server traces (logs of the transactions) for you to view.

        Attachments

        1. 62stacks.txt
          378 kB
        2. 7stacks.txt
          259 kB
        3. Traces.zip
          198 kB

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

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

                Packages

                Version Package