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

    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:
          Yunlin "Steven" Sun
          Votes:
          0 Vote for this issue
          Watchers:
          0 Start watching this issue

            Dates

            Created:
            Updated:
            Days since last comment:
            1 year, 27 weeks, 3 days ago

              Packages

              Version Package