Transfer Service failing on large volume

[kbonnet]

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

[derek]

<blockquote>i was under the impression it was designed to sync to the Alfresco Cloud (?).</blockquote>
Not really.  We actually wrote another service for that.
Currently we are working on a revamped, general purpose sync service that will eventually encompass server-server transfers at a granular level.
For now, we don't have a way of breaking the transfer into batches (I'll get that confirmed) but you can increase your DB connection timeout.  Of course, that'll just take you to the next limit.