I am using MySQL 8 with InnoDB.
I have a table with about 6500 rows, when I try to delete any I get
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction error.
I have checked the processes using "show processlist". Nothing is running in the background, the same command works on another server, just not this one. I have also increased the timeout to 5000s and that still hasn't solved it.