The total number of locks exceeds the lock table size

 SHOW VARIABLES LIKE 'innodb_buffer_pool_size';

SET GLOBAL innodb_buffer_pool_size = 2147483648;  -- 2GB

Note: The value is in bytes (2GB = 2 * 1024 * 1024 * 1024). Adjust it based on your available memory.

🔸 Limitations:

• This change is temporary and will reset when MySQL restarts.
• To make it permanent, you need to update my.cnf or my.ini