Transactional update cache 'org.alfresco.personTransactionalCache' is full

[ALfreSara]

Hello,

I want to know are the locks in the database caused by "Transactional update cache 'org.alfresco.personTransactionalCache' is full (1000)." if not, what are the causes that can trigger this problem of locks and puts the database in a waiting state ?. Also I checked the logs and there is nothing special that may be causing the problem.

Thanks for your help.

[abhinavmishra14]

These posts and docs may be helpful, take a look:

https://docs.alfresco.com/5.2/tasks/cache-config.html

https://hub.alfresco.com/t5/alfresco-content-services-forum/org-alfresco-usertoauthoritytransactiona...

[Volker_Schellbe]

Hello,

I encountered  simliar Problem with the transactional cache here: 

org.alfresco.userToAuthorityTransactionalCache

In the documentation you advice to download an xml-File tx-cache-context.xml; where shall I place it  (path ?) .

rgds Volker Schellberg 

[afaust]

To be honest, I never understood why Alfresco decided to reference the tx-cache-context.xml in their documentation. That file should not be dealt with by anyone without full understanding of how caches work in Alfresco and what can (safely) be changed in that file, and how overrides of bean configurations work. 99% of the time people should stick to the cache properties in the alfresco-global.properties file. The userToAuthorityTransactionalCache can be too small if some custom code, script, or the activity feed generator has to access the details of too many users that had not yet been cached before. That kind of error in most cases is a sign of an incorrectly scoped operation. You can increase its size by setting the cache.userToAuthoritySharedCache.tx.maxItems property in alfresco-global.properties. Note that you may want to increase cache.userToAuthoritySharedCache.maxItems as well if you are dealing with more than 5000 users on a regular basis.