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

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

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  2 years, 15 weeks, 2 days ago

                  Packages

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