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

    XMLWordPrintable

    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

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. LPS-55244 ResourceBlockPermission table grows with orphan rows

          • Closed

            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:
                3 years, 29 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