ERROR: The total number of locks exceeds the lock table size Error Code: 1206

ERROR: The total number of locks exceeds the lock table size Error Code: 1206


Locate the config file of mysql in Ubuntu 18.04

/etc/mysql/mysql.conf.d/mysqld.cnf


Add the following line to the end of the file

innodb_buffer_pool_size        = 1G