topic java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction in Alfresco Forum

java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction

dmalla — Fri, 05 Jan 2018 10:17:28 GMT

How to Avoid Lock wait timeout exceeded exception?Hi we are using Alfresco Enterprise v5.0.1 in production. Sometimes users are not able to perform any action on node and when i checked the logs we are getting following error and they are able to perform action after couple of hours once the lock is

Re: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction

dmalla — Thu, 11 Jan 2018 10:40:48 GMT

Please respond to my query and help me.

Re: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction

afaust — Fri, 12 Jan 2018 09:45:35 GMT

Is there any long-running operation going on in the background which may have obtained locks and simply does not release them within the default time to wait? Then this error is to be expected and you may need to check that other operation for ways to reduce its impact. So far, I never had to modify the default timeout values for MySQL / InnoDB (at least when I used those - I prefer PostgreSQL nowadays).