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:
Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
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?