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

SQL error in upgrade log: "ERROR: relation "ix_b6f21286" already exists" on PostgreSql

Description

    Steps to Reproduce:

    1. Import attached database dump of Postgesql.
    2. Upgrade to master.

    Expected Result:
    Upgrade complete without error.

    Actual Result:
    Below message in upgrade log:

     [parallel] 11:51:32,663 INFO  [main][UpgradeProcess:101] Upgrading com.liferay.document.library.internal.upgrade.v3_2_1.UpgradeDLFileEntryType
     [parallel] 11:51:32,668 INFO  [main][LoggingTimer:83] Starting com.liferay.portal.kernel.dao.db.BaseDBProcess#runSQLTemplateString
     [parallel] 11:51:32,670 WARN  [main][BaseDB:525] ERROR: relation "ix_b6f21286" already exists: create unique index IX_B6F21286 on DLFileEntryType (groupId, dataDefinitionId, ctCollectionId);
     [parallel] 
     [parallel] 11:51:32,671 INFO  [main][LoggingTimer:44] Completed com.liferay.portal.kernel.dao.db.BaseDBProcess#runSQLTemplateString in 3 ms
     [parallel] 11:51:32,671 INFO  [main][UpgradeProcess:115] Completed upgrade process com.liferay.document.library.internal.upgrade.v3_2_1.UpgradeDLFileEntryType in 8 ms
    

    Attachments

      Activity

        People

          summer.zhang Summer Zhang
          summer.zhang Summer Zhang
          Marta Elicegui Marta Elicegui
          Alejandro Tardín Alejandro Tardín
          Votes:
          0 Vote for this issue
          Watchers:
          0 Start watching this issue

          Dates

            Created:
            Updated:
            Resolved:
            1 year, 31 weeks, 2 days ago

            Packages

              Version Package
              7.4.13 DXP GA1
              Master