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

com.liferay.portal.upgrade.v7_0_0.UpgradeSocial upgrade process is not setting the Counter value high enough

Details

    Description

      After the upgrade, the client experiences that SocialActivitySet.ActivitySetId exceeds the max counter value of com.liferay.counter.model.Counter, which results batch updates to fail:

      org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [insert into SocialActivitySet (groupId, companyId, userId, createDate, modifiedDate, classNameId, classPK, type_, extraData, activityCount, activitySetId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; constraint [null];
      

      Root cause: UpgradeSocial increments counter with the number of SocialActivitySets instead of incrementing to the highest id.

      Steps to Reproduce

      1. Start 6.2
      2. Make some actions that create Social Activity such as comment, rate assets etc.
      3. Start Upgrade to 7.0/DXP

      Ask norbert.kocsis if you need help for testing.

      Attachments

        Issue Links

          Activity

            People

              patricia.perez Patricia Perez
              norbert.kocsis Norbert Kocsis (Inactive)
              Kiyoshi Lee Kiyoshi Lee
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                5 years, 17 weeks, 3 days ago

                Packages

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