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

Warnings thrown during upgrade from 62 with DB2

    Details

      Description

      Steps to reproduce issue:

      1. Import the attached 621021 database into DB2 11.1.
      2. Upgrade the database.

      Expected result:
      No warnings are thrown during the upgrade.

      Actual result:
      Warnings are thrown during upgrade.

      2019-07-20 04:28:43.918 WARN  [main][BaseDB:113] DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=ROOT.IX_1E9D371D;INDEX, DRIVER=4.24.92: create unique index IX_1E9D371D on AssetEntry (classNameId, classPK);
      2019-07-20 04:28:44.028 WARN  [main][BaseDB:113] DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=ROOT.IX_D63322F9;INDEX, DRIVER=4.24.92: create unique index IX_D63322F9 on AssetTag (groupId, name);
      2019-07-20 04:28:44.068 WARN  [main][BaseDB:113] DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=ROOT.IX_C0AAD74D;INDEX, DRIVER=4.24.92: create unique index IX_C0AAD74D on AssetVocabulary (groupId, name);
      2019-07-20 04:28:44.615 WARN  [main][BaseDB:113] DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=ROOT.IX_FEFC8DA7;INDEX, DRIVER=4.24.92: create unique index IX_FEFC8DA7 on ExpandoColumn (tableId, name);
      

      Reproduced on:
      Tomcat 8.0.53 + DB2 11.1. Portal 7.0.x-private GIT ID: 88b13331c8968881e096e3e9958a23c1e218d747.

      Note:
      There is no functional impact due to these warnings.

        Attachments

          Activity

            People

            Assignee:
            support-lep@liferay.com SE Support
            Reporter:
            summer.zhang Summer Zhang
            Participants of an Issue:
            Recent user:
            Marta Elicegui
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Days since last comment:
              2 years, 13 weeks ago

                Packages

                Version Package