Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

ResourceBlockPermission table grows with orphan rows

Description

ResourceBlockPermission table grows with orphan rows.

This can be tested example:
1. Empty Liferay installation
2. Insert 3 teams to default site.
3. Insert 5 Bookmarks
4. Give multiple permissions to these teams. So that you check multiple teams with same time. See: Screen Shot 2015-04-28 at 2010.50.16.png
5. You expect to see 0 from following query:

But you see larger than 0.

Attachments

1

Activity

Show:

Tibor LipuszJuly 31, 2017 at 2:16 AM

It has been reverted from ee-7.0.x due to regression in .

Linda SuiJuly 23, 2017 at 10:45 PM
Edited

PASSED Manual Testing following the steps in the description.

Fixed on:
Tomcat 8.0.32 + MySQL 5.6. Portal master GIT ID: 61cc851371ad797d2e4f71e5dcd6fe841e6418e9.
Tomcat 8.0.32 + MySQL 5.6. Portal ee-7.0.x GIT ID: e18a09ffdcc438ae7cb795a26ef3f5d977e33aef.

The count is 0.

Tibor LipuszJuly 13, 2017 at 6:47 AM

Shitian "Shelton" ZhangJuly 25, 2016 at 6:53 PM

Reproduced on:
Tomcat 7.0.62 + MySQL 5.6. Portal ee-6.2.x GIT ID: c5d4f787e572f2f8de17b43c56634bfc468ba367.
Tomcat 8.0.32 + MySQL 5.6. Portal ee-7.0.x GIT ID: b98d2dfa6e0e5c72d8f689f4af7c6c08598a9d05.
Tomcat 8.0.32 + MySQL 5.6. Portal master GIT ID: c30115ab408233f7ff666e76e703d71023a13f56.

The count is larger than 0.

Fixed

Details

Assignee

Reporter

Labels

Branch Version/s

7.0.x

Backported to Branch

Committed

Fix Priority

4

Git Pull Request

7.0 Fix Pack Version

26

Story Points

Components

Fix versions

Affects versions

Priority

Zendesk Support

Created April 27, 2015 at 3:30 PM
Updated June 25, 2023 at 11:34 PM
Resolved August 17, 2017 at 9:34 AM
Loading...