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

Upgrade Error from 6.2 /7.0 / 7.1 -> master due to duplicate unique index

    Details

      Description

      Description
      Duplicate unique index attempting to be created for LayoutPageTemplateEntry (plid) service leads to a Liferay error. Happens on IBM DB2 11.1
      This also sometimes happens when using other databases to upgrade such as Sysbase. The exact cause is unknown, but the DBs cause this error when they attempt to create an index for certain services more than once.

      Steps to Reproduce
      Upgrade LayoutPageTemplate service

      Expected Result
      No DB errors

      Actual Result
      DB error

      Tested on Tomcat 9.0.10 + MySQL 5.7
      Portal master GIT ID: c158a6fa0577911b1d19ee6742d2468ade73d38a

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              kyle.miho Kyle Miho
              Reporter:
              kyle.miho Kyle Miho
              Participants of an Issue:
              Recent user:
              Mariano Álvaro
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

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

                  Packages

                  Version Package
                  Master