MySQL - Lock wait timeout exceeded - try restarting transaction


アトラシアン コミュニティをご利用ください。


この記事はアトラシアンのサーバー プラットフォームにのみ適用されます。クラウドとサーバー製品の違いについてはこちらをご確認ください。


MySQL database is being used, and the following appears in Bamboo logs:

Caused by: java.sql.BatchUpdateException: Lock wait timeout exceeded; try restarting transaction
	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(
	at com.mysql.jdbc.PreparedStatement.executeBatch(
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(
	at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(
	at net.sf.hibernate.impl.BatcherImpl.executeBatch(
	at net.sf.hibernate.impl.SessionImpl.executeAll(
	at net.sf.hibernate.impl.SessionImpl.execute(
	at net.sf.hibernate.impl.SessionImpl.flush(
	at net.sf.hibernate.transaction.JDBCTransaction.commit(
	at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(
	... 88 more


The problem usually happens when a query is taking too long (maybe because the server is too busy).


  • Make sure the database tables are using InnoDB storage engine and READ-COMMITTED transaction isolation level.
  • If the the above configuration is correct then please try to increase the database server innodb_lock_wait_timeout variable to 500
  • Restart the Bamboo instance and the MySQL database service for the configuration to take place.
  • If the steps above don't help, please run these queries below to double-check the configuration:

    show variables like '%wait_timeout%';
    show variables like '%tx_isolation%';
    SELECT @@GLOBAL.tx_isolation, @@tx_isolation;
  • The connection pool could be increased as well. Please open the file %BAMBOO_HOME%/bamboo.cfg.xml and find the following tag:

    <property name="hibernate.c3p0.max_size">...</property>

    Please increase the value, and restart your Bamboo instance.

説明 MySQL - Lock wait timeout exceeded - try restarting transaction error appears in Bamboo logs.

最終更新日 2019 年 9 月 19 日


Powered by Confluence and Scroll Viewport.