Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

  1. ,
    Expert tip

    MySQL doesn't support some types of characters (such as emojis) with the utf8 encoding. You need to be on MySQL 5.5+ and force utf8mb4 (everywhere, client and server). You can do this sending the query "SET NAMES utf8mb4". Check this

  2. ,

    Make sure you are using InnoDB storage engine and READ-COMMITTED transaction isolation level and increase the database server innodb_lock_wait_timeout variable to about 500.

Solutions on the web

via Hibernate JIRA by Zbyněk Roubalík, 1 year ago
Lock wait timeout exceeded; try restarting transaction
via Hibernate JIRA by Zbyněk Roubalík, 2 years ago
Lock wait timeout exceeded; try restarting transaction
via by Unknown author, 2 years ago
Lock wait timeout exceeded; restarting transaction
via GitHub by mibby
, 2 years ago
Incorrect key file for table '/tmp/#sql_77c_10.MYI'; try to repair it
via by Unknown author, 2 years ago
via Oracle Community by 843859, 1 year ago
Lock wait timeout exceeded; try restarting transaction
java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction	at com.mysql.jdbc.SQLError.createSQLException(	at com.mysql.jdbc.MysqlIO.checkErrorPacket(	at com.mysql.jdbc.MysqlIO.nextRowFast(	at com.mysql.jdbc.MysqlIO.nextRow(	at com.mysql.jdbc.MysqlIO.readSingleRowSet(	at com.mysql.jdbc.MysqlIO.getResultSet(	at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(	at com.mysql.jdbc.MysqlIO.readAllResults(	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(	at com.mysql.jdbc.ConnectionImpl.execSQL(	at com.mysql.jdbc.PreparedStatement.executeInternal(	at com.mysql.jdbc.PreparedStatement.executeQuery(	at sun.reflect.GeneratedMethodAccessor26.invoke(Unknown Source)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(	at java.lang.reflect.Method.invoke(	at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(	at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(	at $Proxy45.executeQuery(Unknown Source)	at org.hibernate.loader.Loader.getResultSet(	at org.hibernate.loader.Loader.doQuery(	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(	at org.hibernate.loader.Loader.doList(	at org.hibernate.loader.Loader.doList(	at org.hibernate.loader.Loader.listIgnoreQueryCache(	at org.hibernate.loader.Loader.list(	at org.hibernate.loader.hql.QueryLoader.list(	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(	at org.hibernate.engine.query.spi.HQLQueryPlan.performList(	at org.hibernate.internal.SessionImpl.list(	at org.hibernate.internal.QueryImpl.list(	at org.hibernate.ejb.QueryImpl.getResultList(	at org.hibernate.ejb.test.lock.LockTest$	at org.hibernate.ejb.test.lock.LockTest$	at java.util.concurrent.FutureTask$Sync.innerRun(	at	at