AnsweredAssumed Answered

Transfer Service failing on large volume

Question asked by kbonnet on Jan 14, 2014
Latest reply on Jan 14, 2014 by derek

Hi all,

We've implemented transfer service to publish documents to an external Alfresco instance. We're using Alfresco 4.0.e.

Now the volume of our publications is increasing, the transfers are failing. First, i hit an AJP timeout between de Apache reverse proxy and the tomcat on the destination instance. After increasing these timeout settings, i'm hitting the next timeout, in MySQL:

<blockcode>
Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
</blockcode>

I'm willing to try to increase these as well, but I fear the transfer service might not be designed to handle large volume, although i was under the impression it was designed to sync to the Alfresco Cloud (?).

If i would be able to set a batch size for the total amout, the problem would be solved. But I'm not sure these settings exist.

Anyone solved this problem?

Thanks,

Koen

Outcomes