MySQL Error Message
The total number of locks exceeds the lock table size
Reason for the Error
InnoDB reports this error when the total number
of locks exceeds the amount of memory devoted to managing locks.
To avoid this error, increase the value of
innodb_buffer_pool_size. Within
an individual application, a workaround may be to break a large
operation into smaller pieces. For example, if the error occurs
for a large INSERT, perform several
smaller INSERT operations.