Hyland Connect

mcasanket · ‎03-07-2013

Hi All,

I have just upgraded alfresco system from 3.2 to 3.4.11. Full indexing took around 24 hours then patches took around 3 hours to be applied.

Once the patches were applied I got message that TransactionalCache is full and it took more than 12 hours. Because of this the server was not proceeding ahead. Finally I restarted the tomcat server. But I am again getting these messages. Is there any way to overcome this problem. Below is the logs that I am getting when I start the server.

Below are the log msgs:
08:10:20,921 INFO [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/version.properties]
08:10:20,921 INFO [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
08:10:20,921 INFO [org.alfresco.config.FixedPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/domain/cache-strategies.properties]
09:27:01,189 WARN [cache.node.nodesTransactionalCache] Transactional update cache 'org.alfresco.cache.node.nodesTransactionalCache' is full (300000).
09:29:32,884 WARN [cache.node.aspectsTransactionalCache] Transactional update cache 'org.alfresco.cache.node.aspectsTransactionalCache' is full (200000).
09:29:40,684 WARN [cache.node.propertiesTransactionalCache] Transactional update cache 'org.alfresco.cache.node.propertiesTransactionalCache' is full (150000).
18:43:59,244 WARN [alfresco.cache.contentDataTransactionalCache] Transactional update cache 'org.alfresco.cache.contentDataTransactionalCache' is full (65000).
21:45:12,569 WARN [cache.node.parentAssocsTransactionalCache] Transactional update cache 'org.alfresco.cache.node.parentAssocsTransactionalCache' is full (65000).

Please help!
Thank you!

afaust · ‎03-11-2013

Hello,

it would be good to find out what kind of logic runs here that is loading all that data into caches. Can you perform some stack dumps using jstack while these messages appear? Have you tried increases logging to DEBUG level to see what kind of services are invoked around those messages? You might also want to adapt the logging format in log4j.properties to include the name of the current thread in logging output.

Without knowing what is going on it is hard to give any advice to overcome this. You could increase cache sizes, but that is only a symptomatic fix.

Regards
Axel

mcasanket · ‎05-08-2013

Hi AFaust,

<blockquote>it would be good to find out what kind of logic runs here that is loading all that data into caches. Can you perform some stack dumps using jstack while these messages appear? Have you tried increases logging to DEBUG level to see what kind of services are invoked around those messages? You might also want to adapt the logging format in log4j.properties to include the name of the current thread in logging output.</blockquote>

I have tried to connect to JConsole to take the jmx dump but was unable to connect. Also I have set log4j.logger.org.alfresco.repo.cache.EhCacheTracerJob=debug. But once the message got printed in log, no other logs come in picture.

It took more than 30 hours to finish up all these cache things. Which is much more than the time it took for full indexing. Please help

Thanks AFaust.

joe_l3 · ‎06-05-2013

Hi,

the WARNING entries show the limit value of the Transactional Cache objects. See the cache-context.xml and ehcache-default.xml files in webapps/alfresco/WEB-INF/classes/alfresco directory.

You can ignore them during the upgrade process.
Probably you have a heavy contentstore and your documents are very large to be cached during reindexing process. I have experience of Alfresco migrations who have involved 6/7 million of documents (about 500 GB of alf_data and 36 hour for Tomcat bootstrap).
During the bootstrap let Alfresco perform the patches
Then I suggest you to make a new migration from 3.4 to 4.0 and to enable the new solr search engine instead of lucene.
Solr engine is fully scalable and you can setup it into another Tomcat Application Server.