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

Errors / Warnings during upgrade to 7.0 using postgresql

    Description

    Steps to reproduce:

    1. Start Liferay 6.2 on postgresql
    2. Shut down Liferay 6.2
    3. Use the upgrade tool to upgrade to Liferay 7.0

    Expected result:
    No errors during the upgrade.

    Actual result:
    The following warnings appear in the upgrade log. The warnings do not seem to have a functional impact.

         [java] 00:48:07,383 WARN  [main][UpgradeProcess:350] Fallback to recreating the table
         [java] org.postgresql.util.PSQLException: ERROR: cannot drop index listtype_pkey because constraint listtype_pkey on table listtype requires it
         [java]   Hint: You can drop constraint listtype_pkey on table listtype instead.
         [java]     at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
         [java]     at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
         [java]     at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
         [java]     at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
         [java]     at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:406)
         [java]     at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
         [java]     at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:291)
         [java]     at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:261)
         [java]     at com.liferay.portal.kernel.dao.db.BaseDBProcess.runSQL(BaseDBProcess.java:52)
         [java]     at com.liferay.portal.kernel.upgrade.UpgradeProcess.alter(UpgradeProcess.java:314)
         [java]     at com.liferay.portal.upgrade.v7_0_0.UpgradeListType.doUpgrade(UpgradeListType.java:27)
         [java]     at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:88)
         [java]     at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:115)
         [java]     at com.liferay.portal.upgrade.UpgradeProcess_7_0_0.doUpgrade(UpgradeProcess_7_0_0.java:83)
         [java]     at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:88)
         [java]     at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:175)
         [java]     at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:143)
         [java]     at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:125)
         [java]     at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:164)
         [java]     at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:81)
         [java]     at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:150)
         [java]     at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:96)
         [java] 00:48:18,831 WARN  [main][UpgradeProcess:350] Fallback to recreating the table
         [java] org.postgresql.util.PSQLException: ERROR: cannot drop index layoutbranch_pkey because constraint layoutbranch_pkey on table layoutbranch requires it
         [java]   Hint: You can drop constraint layoutbranch_pkey on table layoutbranch instead.
         [java]     at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
         [java]     at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
         [java]     at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
         [java]     at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
         [java]     at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:406)
         [java]     at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
         [java]     at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:291)
         [java]     at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:261)
         [java]     at com.liferay.portal.kernel.dao.db.BaseDBProcess.runSQL(BaseDBProcess.java:52)
         [java]     at com.liferay.portal.kernel.upgrade.UpgradeProcess.alter(UpgradeProcess.java:314)
         [java]     at com.liferay.portal.upgrade.v7_0_1.UpgradeLayoutBranch.doUpgrade(UpgradeLayoutBranch.java:27)
         [java]     at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:88)
         [java]     at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:115)
         [java]     at com.liferay.portal.upgrade.UpgradeProcess_7_0_1.doUpgrade(UpgradeProcess_7_0_1.java:43)
         [java]     at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:88)
         [java]     at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:175)
         [java]     at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:143)
         [java]     at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:125)
         [java]     at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:164)
         [java]     at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:81)
         [java]     at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:150)
         [java]     at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:96)

      Attachments

        Issue Links

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                4 years, 5 weeks, 4 days ago

                Packages

                Version Package
                7.0.1 CE GA2