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

OrgGroupRole missing column on database upgraded from 6.2

    Description

    Steps to Reproduce:

    1. Import attached 6.2.10.21 database to MySQL data-archive-portal-mysql.zip
    2. Upgrade this database to Master (with DXP profile)
      • tools/portal-tools-db-upgrade-client/db_upgrade.sh
    3. Connect Master to a different, empty database schema
    4. Start master against blank database schema
    5. Compare OrgGroupRole tables between upgraded and fresh database

    Expected Result:
    Columns match between the 2 databases.

    Actual Result:
    OrgGroupRole missing column "mvccVersion" on database upgraded from 6.2

    Column in fresh master database

    `mvccVersion` bigint(20) NOT NULL DEFAULT '0'
    

    Slimmed down database dumps also attached
    fresh.sql upgraded.sql

    Not reproducible when upgrading a database from 7.x

      Attachments

      1. data-archive-portal-mysql.zip
        82 kB
      2. fresh.sql
        420 kB
      3. upgraded.sql
        438 kB
      4. 微信图片_20211228133319.png
        微信图片_20211228133319.png
        40 kB
      5. 微信图片_20211228133328.png
        微信图片_20211228133328.png
        25 kB

        Activity

          People

          Assignee:
          victor.ware Victor Ware
          Reporter:
          victor.ware Victor Ware
          Participants of an Issue:
          Recent user:
          Felipe Lins
          Engineering Assignee:
          Pei-Jung Lan
          Votes:
          0 Vote for this issue
          Watchers:
          0 Start watching this issue

            Dates

            Created:
            Updated:
            Resolved:
            Days since last comment:
            7 weeks ago

              Packages

              Version Package