DLFileRank query running for a long time and taking up pool usage
How To articles are not official guidelines or officially supported documentation. They are community-contributed content and may not always reflect the latest updates to Liferay DXP. We welcome your feedback to improve How To articles!
While we make every effort to ensure this Knowledge Base is accurate, it may not always reflect the most recent updates or official guidelines.We appreciate your understanding and encourage you to reach out with any feedback or concerns.
Legacy Article
You are viewing an article from our legacy "FastTrack"
publication program, made available for informational purposes. Articles
in this program were published without a requirement for independent
editing or verification and are provided"as is" without
guarantee.
Before using any information from this article, independently verify its
suitability for your situation and project.
Issue
- I am seeing a long running database query and am concerned about its impact on my environment:
insert into DLFileRank (groupId, companyId, userId, createDate,
fileEntryId, active_, fileRankId) values (:1 , :2 , :3 ,
:4 , :5 , :6 , :7 )
Resolution
- Similar to the behavior described in DLFileRank Causes Deadlock or SQL Update Batch Errors, increased activity in the Document Library can cause a spike in the update queries to the database.
- To mitigate the database pool usage, customers can disable DLFileRank entirely or reduce the time between each update using the following portal properties:
Set the interval in minutes on how often CheckFileRankMessageListener
will run to check for and remove file ranks in excess of the maximum number
of file ranks to maintain per user per file.
Defaults:
dl.file.rank.check.interval=15
Set this to true to enable file rank for document library files.
Defaults:
dl.file.rank.enabled=true
Set the maximum number of file ranks to maintain per user per file.
Defaults:
dl.file.rank.max.size=5
Did this article resolve your issue ?