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

Warning thrown when during upgrade process for PSQL

    Details

      Description

      Steps to reproduce issue:

      1. Import the attached 7.0.4 database into PostgreSQL
      2. Upgrade the database

      Expected result: Upgrade processes completes successfully with no warnings
      Actual result: Upgrade process completes, but warning is thrown:

      2018-12-12 08:10:15.202 INFO  [main][UpgradeProcess:93] Upgrading com.liferay.portal.upgrade.v7_1_x.UpgradeCounter
      2018-12-12 08:10:15.203 INFO  [main][LoggingTimer:83] Starting com.liferay.portal.kernel.upgrade.UpgradeProcess#alter
      2018-12-12 08:10:15.215 WARN  [main][UpgradeProcess:447] Attempting to upgrade table Counter by recreating the table due to: ERROR: cannot drop index counter_pkey because constraint counter_pkey on table counter requires it
        Hint: You can drop constraint counter_pkey on table counter instead.
      2018-12-12 08:10:15.215 INFO  [main][LoggingTimer:83] Starting com.liferay.portal.kernel.upgrade.UpgradeProcess#upgradeTable#Counter
      2018-12-12 08:10:15.219 INFO  [main][Table:168] Starting backup of Counter to /tmp/temp-db-Counter-4671828994220888047.tmp
      2018-12-12 08:10:15.225 INFO  [main][Table:204] Finished backup of Counter to /tmp/temp-db-Counter-4671828994220888047.tmp in 6 ms
      2018-12-12 08:10:15.244 INFO  [main][LoggingTimer:43] Completed com.liferay.portal.kernel.upgrade.UpgradeProcess#upgradeTable#Counter in 29 ms
      2018-12-12 08:10:15.244 WARN  [main][UpgradeProcess:466] Successfully recreated and upgraded table Counter
      2018-12-12 08:10:15.244 INFO  [main][LoggingTimer:43] Completed com.liferay.portal.kernel.upgrade.UpgradeProcess#alter in 41 ms
      2018-12-12 08:10:15.244 INFO  [main][UpgradeProcess:107] Completed upgrade process com.liferay.portal.upgrade.v7_1_x.UpgradeCounter in 42 ms    
      

      Reproduced on:
      Tomcat 9.0.10 + PostgreSQL 10
      Portal master GIT ID: 17920c8d2d94e155e34b593a5389e49b8ae34e57

        Attachments

          Activity

            People

            Assignee:
            support-lep@liferay.com SE Support
            Reporter:
            anthony.chu Anthony Chu
            Participants of an Issue:
            Recent user:
            Brian Wulbern
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

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

                Packages

                Version Package