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

Cannot upgrade from 7.4.3.21 CE GA21 to 7.4.3.22 CE GA22 - reopen

Details

    • Database Upgrade

    Description

      I am trying to upgrade Liferay from version 7.4.3.21 CE GA21 to 7.4.3.22 CE GA22, but during the upgrade process the following exception is thrown:

      2022-08-10 12:17:22.175 INFO [Portal Dependency Manager Component Executor--1][UpgradeProcess:106] Upgrading com.liferay.layout.page.template.internal.upgrade.v5_1_0.LayoutPageTemplateStructureUpgradeProcess
      2022-08-10 12:17:22.604 ERROR [Portal Dependency Manager Component Executor--1][BatchingBatch:134] HHH000315: Exception executing batch [java.sql.BatchUpdateException: Batch entry 0 insert into SegmentsExperience (mvccVersion, ctCollectionId, uuid_, groupId, companyId, userId, userName, createDate, modifiedDate, segmentsEntryId, segmentsExperienceKey, classNameId, classPK, name, priority, active_, typeSettings, lastPublishDate, segmentsExperienceId) values (0, 0, '78d5a711-4e9b-6034-88a3-5c5e779adb16', 41902, 20099, 20127, 'Test Test', '2022-08-10 12:17:22.574+00', '2022-08-10 12:17:22.574+00', 0, 'DEFAULT', 20005, 79, '<?xml version=''1.0'' encoding=''UTF-8''?><root available-locales="en_US" default-locale="en_US"><Name language-id="en_US">Default</Name></root>', 0, 'TRUE', NULL, NULL, 892679) was aborted: ERROR: duplicate key value violates unique constraint "ix_789cf949"
      Detail: Key (groupid, segmentsexperiencekey, ctcollectionid)=(41902, DEFAULT, 0) already exists. Call getNextException to see other errors in the batch.], SQL: insert into SegmentsExperience (mvccVersion, ctCollectionId, uuid_, groupId, companyId, userId, userName, createDate, modifiedDate, segmentsEntryId, segmentsExperienceKey, classNameId, classPK, name, priority, active_, typeSettings, lastPublishDate, segmentsExperienceId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
      2022-08-10 12:17:22.605 ERROR [Portal Dependency Manager Component Executor--1][SqlExceptionHelper:142] Batch entry 0 insert into SegmentsExperience (mvccVersion, ctCollectionId, uuid_, groupId, companyId, userId, userName, createDate, modifiedDate, segmentsEntryId, segmentsExperienceKey, classNameId, classPK, name, priority, active_, typeSettings, lastPublishDate, segmentsExperienceId) values (0, 0, '78d5a711-4e9b-6034-88a3-5c5e779adb16', 41902, 20099, 20127, 'Test Test', '2022-08-10 12:17:22.574+00', '2022-08-10 12:17:22.574+00', 0, 'DEFAULT', 20005, 79, '<?xml version=''1.0'' encoding=''UTF-8''?><root available-locales="en_US" default-locale="en_US"><Name language-id="en_US">Default</Name></root>', 0, 'TRUE', NULL, NULL, 892679) was aborted: ERROR: duplicate key value violates unique constraint "ix_789cf949"
      Detail: Key (groupid, segmentsexperiencekey, ctcollectionid)=(41902, DEFAULT, 0) already exists. Call getNextException to see other errors in the batch.
      2022-08-10 12:17:22.606 ERROR [Portal Dependency Manager Component Executor--1][SqlExceptionHelper:142] ERROR: duplicate key value violates unique constraint "ix_789cf949"
      Detail: Key (groupid, segmentsexperiencekey, ctcollectionid)=(41902, DEFAULT, 0) already exists.
      2022-08-10 12:17:22.633 INFO [Portal Dependency Manager Component Executor--1][UpgradeProcess:121] Failed upgrade process com.liferay.layout.page.template.internal.upgrade.v5_1_0.LayoutPageTemplateStructureUpgradeProcess in 458 ms
      2022-08-10 12:17:22.648 ERROR [Portal Dependency Manager Component Executor--1][UpgradeStepRegistratorTracker:221] Failed upgrade process for module com.liferay.layout.page.template.service
      com.liferay.portal.kernel.log.LogSanitizerException: com.liferay.portal.kernel.upgrade.UpgradeException: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute batch
      at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:115) ~[portal-kernel.jar:?]
      at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:133) ~[portal-kernel.jar:?]
      

      Do you have any idea why this happens?

      Attachments

        Activity

          People

            susan.chen Susan Chen
            krudz Krzysztof Rudz
            Susan Chen Susan Chen
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              22 weeks, 6 days ago

              Packages

                Version Package
                7.4.3.44 CE GA44