Bookmark and Share
Got error 124 from storage engine
(Publish Date: 2009-8-11 5:03pm, Total Visits: 3041, Today: 1, This Week: 1, This Month: 5)

I got the following error on a MyISAM merge table:

mysql> select * from sweepstakes_entry_09 where sweep_id = 6115;
ERROR 1030 (HY000): Got error 124 from storage engine

This error was caused by some opened base tables, using "flush tables" or "flush table table_name, table_name" to close the all tables and some specific tables and flushed the query cache.  The error was gone after "flush tables;"