-
Type:
Bug
-
Status: Closed
-
Resolution: Fixed
-
Affects Version/s: 6.2.0 CE GA1, 6.2.10 EE GA1, 7.0.0 M3
-
Fix Version/s: 6.2.2 CE GA3 , 6.2.X EE, 7.0.0 M1
-
Component/s: Recycle Bin
-
Branch Version/s:6.2.x
-
Backported to Branch:Committed
-
Story Points:10
-
Fix Priority:2
-
Git Pull Request:
Automatic recycle bin cleaning is causing huge amount of DB quieries, if there are lot rows at Group table at DB.
Even trash.enabled=false disabling recycle bin from properties file dos not help nor setting trash.entry.check.interval= very high. Since it is anyways doing that on startup.
Requirement to reproduce:
Start Liferay and add huge amount of sites and users (like 50 000).
Then suddenly you find out that db is hitting huge amount of queries and your computer performance is decreasing. From database you see following kind of queries:
select trashentry0_.entryId as entryId458_, trashentry0_.groupId as groupId458_, trashentry0_.companyId as companyId458_, trashentry0_.userId as userId458_, trashentry0_.userName as userName458_, trashentry0_.createDate as createDate458_, trashentry0_.classNameId as classNam7_458_, trashentry0_.classPK as classPK458_, trashentry0_.systemEventSetKey as systemEv9_458_, trashentry0_.typeSettings as typeSet10_458_, trashentry0_.status as status458_ from TrashEntry trashentry0_ where (trashentry0_.groupId=1052961 )AND(trashentry0_.createDate<'2014-01-06 09:15:08' ) order by trashentry0_.createDate DESC
You cannot disable this from portal.properties either by setting trash.enabled=false
It seems to lead to following implementation:
- duplicates
-
LPS-43206 Trash entry check causes a performance degradation
- Closed
- is caused by
-
LPS-28154 Automatic clean up of the Recycle bin
-
- Closed
-
- is related to
-
LPE-12506 Automatic Recycle Bin cleaning causes large amount of DB queries
-
- Closed
-
-
LPS-45839 As a developer, I'd like to refactor ActionableDynamicQuery to support customized tx boundaries setup and optimize the inefficient pagination logic
-
- Closed
-
- relates
-
LPS-43206 Trash entry check causes a performance degradation
- Closed