Total locks exceeds lock table size

The total number of locks held exceeds the InnoDB lock table size. Increase innodb_buffer_pool_size or split the transaction.