0

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.

mkrieger1
  • 19,194
  • 5
  • 54
  • 65
eqxDev
  • 149
  • 1
  • 5
  • Does this answer your question? [How to debug Lock wait timeout exceeded on MySQL?](https://stackoverflow.com/questions/6000336/how-to-debug-lock-wait-timeout-exceeded-on-mysql) – Ken White Sep 09 '20 at 03:26
  • @KenWhite thanks but unfortunately not, I have already been through that thread no luck! Is it possible it is an old lock? Or a server configuration issue? – eqxDev Sep 09 '20 at 03:44

0 Answers0