I had a customer with a problem using a web based email marketing software application. Importing data and deleting data seemed to stop working. The database uses InnoDB tables so I used phpMyAdmin to try to execute the delete SQL code and received the following error:
1205 lock wait timeout exceeded
For future reference: To kill the process which has locked the table visit the ‘Processes’ tab in phpMyAdmin and kill the offending process. Actions on the table should then start working again.
interspire email marketer
