Thread:Project:Support desk/Database Error on Redirect/reply

The relevant line is

Error: 1205 Lock wait timeout exceeded; try restarting transaction

In your case the problematic table seems to be mw_redirect - which is kind of interesting as this table as well as your query is not very complex.

A debugging guide for this problem is available at http://stackoverflow.com/questions/6000336/how-to-debug-lock-wait-timeout-exceeded