Verify the buffer memory pool size.

The requesting transaction must wait for the transaction that holds the blocking lock to commit or roll back. .

ACTIVE 2 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 80109,. (This may be futile since the "timeout" was not really a. cnf file from etc/mysql/my.

.

When it happens again, run SHOW ENGINE INNODB STATUS and provide at least the section about the last deadlock.

[ERROR] ActiveRecord::StatementInvalid, Mysql2::Error: Lock wait timeout exceeded; try restarting transaction: SELECT `rpush_notifications`.

MySQL error: Lock wait timeout exceeded; try restarting transaction.

When the issue happens again, lock into the slow query logs to find out which query is causing the lock (it will exceed lock wait time).

Increase the value of innodb_lock_wait_timeout, you can do this by using one of the following two methods, Set it in my.

(This may be futile since the "timeout" was not really a.

i've problem with sequelize transactions with mysql(5.