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

UpgradeJournalArticleImage fails with Unique constraint violation

    Details

      Description

      UpgradeJournalArticleImage.updateJournalArticleImagesInstanceId() can fail with unique constraint violation.

      JournalArticleImage has IX_103D6207 unique index on groupId, articleId, version, elInstanceId, elName, languageId and set elInstanceId for records which miss it based on articleId and elName which is not unique, so we might end up setting the same elInstanceId for multiple records and get the constraint violation error.

      Caused by LPS-63727 which aimed to fix the same problem, but seems like it didn't fix it for every case. Error is the same.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  1 year, 5 weeks, 3 days ago

                  Packages

                  Version Package
                  7.0.0 DXP FP25
                  7.0.X EE
                  7.0.4 CE GA5
                  Master