Date: 10/27/05 (MySQL Communtiy)    Keywords: no keywords

Yesterday I tried to run the command:

ALTER TABLE product ADD FULLTEXT NameDescFTIndex(name,description)

but then my connection to the Internet ran out while I was running it (this table has over 20,000 rows and is 14.6 MB if that helps).

Now it seems that the table is completely locked down for updates and no matter what I try to update, nothing works. We also have a backlog of cronjobs (Perl scripts) that update this table that cannot finish their jobs due to this lock. How can I get rid of these unnecessary locks, so we can update the table again? I've looked through all the documentation extensively and have yet to find a solution... :(

Source: http://www.livejournal.com/community/mysql/71690.html