On RDS sequelize throws error on update query: ER_LOCK_WAIT_TIMEOUT: Lock wait timeout exceeded

37 views

Skip to first unread message

Shivani A

unread,

Sep 19, 2016, 5:04:52 AM9/19/16

to Sequelize

My application was working perfectly fine on Percona mysql.

But on moving to Amazon RDS, mysql is throwing the error mentioned below for update queries (intermittently) with sequelize.

error: Unhandled server error:{"name":"SequelizeDatabaseError","message":"ER_LOCK_WAIT_TIMEOUT: Lock wait timeout exceeded; try restarting transaction",....}

I have set isolationLevel to READ COMMITTED and auto commits to false for my transaction.