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

Portal instance cannot be deleted after Calendar configuration is changed

    Details

      Description

      Steps to Reproduce:

      1. Go to Control Panel > Virtual Instances
      2. Create an instance
      3. Navigate to new instance
      4. Add Calendar portlet to a page
      5. Go to Calendar portlet > Configuration
      6. Set "Week Start On" to "Monday
      7. Save
      8. Go to main instance
      9. Go to Control Panel > Virtual Instances
      10. Attempt to delete created virtual instance

      Expected Result:
      Instance can be deleted.

      Actual Result:
      Instance fails to delete with error:

      15:48:36,527 ERROR [http-nio-8080-exec-4][JDBCExceptionReporter:234] Lock wait timeout exceeded; try restarting transaction
      15:48:36,628 ERROR [http-nio-8080-exec-4][GroupLocalServiceImpl:3556] Unable to delete data for portlet null in group 35326
      
      mysql> select * from Group_ where groupId=35326;
      +-------------+--------------------------------------+---------+-----------+---------------+-------------+---------+---------------+-------------+----------+----------+------+-------------+-------+--------------+------------------+-----------------------+-------------+------+-------------------------+----------------+---------+
      | mvccVersion | uuid_                                | groupId | companyId | creatorUserId | classNameId | classPK | parentGroupId | liveGroupId | treePath | groupKey | name | description | type_ | typeSettings | manualMembership | membershipRestriction | friendlyURL | site | remoteStagingGroupCount | inheritContent | active_ |
      +-------------+--------------------------------------+---------+-----------+---------------+-------------+---------+---------------+-------------+----------+----------+------+-------------+-------+--------------+------------------+-----------------------+-------------+------+-------------------------+----------------+---------+
      |           0 | db11bf5c-7468-e34e-3934-87a5ff839530 |   35326 |     35284 |         35324 |       20084 |   35324 |             0 |           0 | /35326/  | 35324    | NULL | NULL        |     0 |              |                1 |                     0 | /test       |    0 |                       0 |              0 |       1 |
      +-------------+--------------------------------------+---------+-----------+---------------+-------------+---------+---------------+-------------+----------+----------+------+-------------+-------+--------------+------------------+-----------------------+-------------+------+-------------------------+----------------+---------+
      1 row in set (0.00 sec)
      

      Reproduced on:
      Tomcat 8.0.32 + MySQL 5.7.17. Portal master GIT ID: 4d447e93b2535b210eb32b92354e2c4f24196183.
      Tomcat 8.0.32 + MySQL 5.7.17. Portal ee-7.0.x GIT ID: e08a350d6f41d526e1437e421a8b1998540061e9.

      Not Reproducible on:
      Tomcat 8.0.32 + MySQL 5.7.17. 7.0 DXP + FP24

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                victor.ware Victor Ware
                Reporter:
                victor.ware Victor Ware
                Participants of an Issue:
                Recent user:
                Csaba Turcsan
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

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

                  Packages

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