topic Re: Transactional update cache 'org.alfresco.personTransactionalCache' is full in Alfresco Forum

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

ALfreSara — Thu, 05 Nov 2020 18:25:33 GMT

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.

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

abhinavmishra14 — Fri, 06 Nov 2020 00:28:14 GMT

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-usertoauthoritytransactionalcache-is-full-100/td-p/154471

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

Volker_Schellbe — Mon, 18 Nov 2024 12:33:05 GMT

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

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

afaust — Tue, 19 Nov 2024 21:08:15 GMT

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.