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

Enable GingerCannot connect to Ginger Check your internet connection
or reload the browserDisable in this text fieldEditEdit in GingerEdit in Ginger×

Remove duplicates rows in MySQL

Remove duplicate entries in MySQL:

 ALTER IGNORE TABLE RESIM.LOD_RANDOMRECORDSIM  
 ADD UNIQUE INDEX USERIDARTISTURI (USERID, ARTISTURI);  

If it is not working with InnoDB, execute the query below first:

 SET SESSION old_alter_table=1;  

Always backup before doing such kind of tasks...