Magento Background Landing locked Index error Resolution: General ERROR:1205 Lock Wait Timeout

1.

Magento with the shell at the time of indexing, sometimes error:

1. General error: 1205 Lock wait timeout exceeded

This time, because of the reason for the row lock, in the table you directly use SQL to perform the update, will report this error, that is, this error is MySQL newspaper.

I need it. Table Index_process Unlock

If you want to quickly solve, then, the table import, modify, delete the database index_process table, re-import, OK, row locks will disappear.

Online also has the index of mode changed to Manual, index after the change back, as if still have a problem, reported this is the reason for the MySQL row lock,

Finally, also to empty the root directory under var/locks/all the lock file Delete (do this as if you can, I kiss)

Magento Background Landing locked Index error Resolution: General ERROR:1205 Lock Wait Timeout