Question
Auto-owners Insurance
US
Last activity: 25 Apr 2018 9:00 EDT
PR_PAGE_STORE and PR_SYS_CONTEXT Row Level Locking
We have received a passivation and and activation deadlock error during the time PR_PAGE_STORE was being cleaned up by SystemCleaner. Is there any problems or cautions with switching PR_PAGE_STORE and PR_SYS_CONTEXT to use row level locking?
Pegasystems Inc.
IN
Hi Matthew,
Please refer the below link which says there has been some issue in the past with the system cleaner:
https://collaborate.pega.com/question/prpagestore-records-are-not-deleted-after-3-days
Kindly let us know which version of pega you are using.
Regards,
Vikash
Auto-owners Insurance
US
We are using Pega 7.2.0.
We were having a problem with data purging. However, we staggered the SystemCleaner agent on our nodes (suggested in an SR) and after a few days, the errors went away.
We did, however, have a couple of times when end users deadlocked on passivation/activation. While SystemCleaner is not taking very long to run now, I would also like to switch to row level locking to help ensure this does not occur in the future.