Question
Ford
IN
Last activity: 18 Jun 2024 10:15 EDT
lock request timeout period exceeded in dbo.pr_sys_locks
lock request timeout period exceeded in dbo.pr_sys_locks.
we are facing this issue in almost all platforms,though this issue is common.
i can see this is happening frequently and causing deadlock.
this will impact application performance.
any solution for this issue?
Accepted Solution
Updated: 26 Jun 2024 10:39 EDT
Eclatprime Digital Private Limited
SG
basically you can write a custom activity to kill the long running requestors and also clear the syslock table with the un necessary entries
this you write with a standard agent and schedule it so that it will automatically run after certain period and will not block the database
Eclatprime Digital Private Limited
IN
@DevipriyaA , Hope this will help. http://https://community.pega.com/support/support-articles/delete-prsyslocks-causing-db-blockage?
Accepted Solution
Updated: 26 Jun 2024 10:39 EDT
Eclatprime Digital Private Limited
SG
basically you can write a custom activity to kill the long running requestors and also clear the syslock table with the un necessary entries
this you write with a standard agent and schedule it so that it will automatically run after certain period and will not block the database
Maantic Inc
IN
Run a job scheduler than will run multiple times a day which will query through the pr_sys_locks table and release the oldest locks.