topic Alfresco Lock wait timeout exceeded exception in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/alfresco-lock-wait-timeout-exceeded-exception/m-p/5194#M2530 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>we are using an Alfresco Community 5.0&nbsp;in which the registered (nominal) users are around 2k. In some cases we get an exception from Alfresco logs that I reported below.</P><P>Here the configuration:</P><UL><LI>Server Alfresco Ubuntu 14 64 bit/12GB RAM/8 vcpu cores</LI><LI>Server MySQL Ubuntu 14 64 bit/12GB RAM/8 vcpu cores</LI></UL><P></P><P>Alfresco global&nbsp;properties about&nbsp;database is the following:</P><PRE>db.driver=com.mysql.jdbc.Driver <BR />db.username=alfresco <BR />db.password=***** <BR />db.name=alfresco <BR />db.url=jdbc:mysql://*****:3306/alfresco?useUnicode=yes&amp;characterEncoding=UTF-8 <BR />db.pool.max=275 <BR />db.pool.validate.query=SELECT 1</PRE><P>Database max_connections is about 300.</P><P></P><P>Please, do you have any suggestion about hot to solve ot make the proper tuning on Alfresco/database?</P><P></P><PRE>2017-02-07 08:50:51,325&nbsp; ERROR [post.cleanup.PostCleaner] [DefaultScheduler_Worker-5] Exception during cleanup of posts&nbsp; org.springframework.dao.CannotAcquireLockException: ### Error updating database.&nbsp; Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction <BR />### The error may involve alfresco.activities.delete_activity_posts_older_than_date-Inline ### The error occurred while setting parameters ### SQL: delete from alf_activity_post&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where post_date &lt; ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and status = ? ### Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction ; SQL []; Lock wait timeout exceeded; try restarting transaction; nested exception is java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:265)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:371)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at com.sun.proxy.$Proxy12.delete(Unknown Source)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at org.mybatis.spring.SqlSessionTemplate.delete(SqlSessionTemplate.java:268)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at org.alfresco.repo.domain.activities.ibatis.ActivityPostDAOImpl.deletePosts(ActivityPostDAOImpl.java:102)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at org.alfresco.repo.activities.post.cleanup.PostCleaner.executeWithLock(PostCleaner.java:146)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at org.alfresco.repo.activities.post.cleanup.PostCleaner.execute(PostCleaner.java:117)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR /> at org.alfresco.repo.activities.post.cleanup.PostCleanupJob.execute(PostCleanupJob.java:50)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at org.quartz.core.JobRunShell.run(JobRunShell.java:216)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563) <BR />Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1094)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4208)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4140)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2597)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2758)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2826)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1302)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:44)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:69)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:48)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:105)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:71)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:152)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at org.apache.ibatis.session.defaults.DefaultSqlSession.delete(DefaultSqlSession.java:165)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at sun.reflect.GeneratedMethodAccessor432.invoke(Unknown Source)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at java.lang.reflect.Method.invoke(Method.java:483)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:358)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ... 8 more</PRE></BODY></HTML> Tue, 07 Feb 2017 08:10:10 GMT massimo_callist 2017-02-07T08:10:10Z Alfresco Lock wait timeout exceeded exception https://connect.hyland.com/t5/alfresco-forum/alfresco-lock-wait-timeout-exceeded-exception/m-p/5194#M2530 Hi,we are using an Alfresco Community 5.0&nbsp;in which the registered (nominal) users are around 2k. In some cases we get an exception from Alfresco logs that I reported below.Here the configuration<IMG id="smileyfrustrated" class="emoticon emoticon-smileyfrustrated" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-frustrated.png" alt="Smiley Frustrated" title="Smiley Frustrated" />erver Alfresco Ubuntu 14 64 bit/12GB RAM/8 vcpu coresServer MySQL Ubuntu 14 64 bit/12GB RAM/8 vcpu cores Tue, 07 Feb 2017 08:10:10 GMT https://connect.hyland.com/t5/alfresco-forum/alfresco-lock-wait-timeout-exceeded-exception/m-p/5194#M2530 massimo_callist 2017-02-07T08:10:10Z Re: Alfresco Lock wait timeout exceeded exception https://connect.hyland.com/t5/alfresco-forum/alfresco-lock-wait-timeout-exceeded-exception/m-p/5195#M2531 <HTML><HEAD></HEAD><BODY><P>Fixed following&nbsp;these guidelines:</P><P><A class="link-titled" href="http://www.slideshare.net/LuisCabaceira/alfresco-tuning-part1" title="http://www.slideshare.net/LuisCabaceira/alfresco-tuning-part1" rel="nofollow noopener noreferrer">Alfresco tuning part1</A>&nbsp;</P></BODY></HTML> Tue, 14 Feb 2017 21:07:38 GMT https://connect.hyland.com/t5/alfresco-forum/alfresco-lock-wait-timeout-exceeded-exception/m-p/5195#M2531 massimo_callist 2017-02-14T21:07:38Z