The total number of locks exceeds the lock table size

This issue can be resolved by setting the higher values for the MySQL variable innodb_buffer_pool_size. The default value for innodb_buffer_pool_size will be 8,388,608.

To change the settings value for innodb_buffer_pool_size please see the below set.

1. Locate the file my.cnf from the server. For Linux servers this will be mostly at /etc/my.cnf
2. Add the line innodb_buffer_pool_size=64MB to this file
3. Restart the MySQL server

To restart the MySQL server, you can use anyone of the below 2 options:

1. service mysqld restart
2. /etc/init.d/mysqld restart

Reference The total number of locks exceeds the lock table size