On Sat, Oct 05, 2002 at 03:47:18PM +0300, Heikki Tuuri wrote: > Shane, > > > 021004 12:57:00 Slave: error 'Incorrect key file for table: > 'listing_text'. Try to repair it' on query 'UPDATE sell.listing_text SET > description='blah' WHERE listing_id=221112', error_code=1034 > > > > So, I issued `mysqlcheck -r sell listing_text`, and eventually "Lost > > connection to MySQL server during query". Inspection of the error log > > yields the following: > > > > mysqld: mf_iocache.c:1106: _flush_io_cache: Assertion `info->end_of_file > == my_tell(info->file,(myf) (0))' failed. > > > > Number of processes running now: 1 > > mysqld process hanging, pid 790 - killed > > did you try to run the command line repair tool on a table while the mysqld > server was up? The server must be shut down if you use the command line > tool. Otherwise the indexes of the table may be cached in the key_buffer of > the mysqld process.
Heikki, If I attempt to run mysqlcheck -r <db> <table> while the server is down, I get: mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect It is my understanding that mysqlcheck's repair mechanism relies on MySQL's built-in REPAIR statement, at least in the case of a MyISAM table. Thanks -- Shane Allen <[EMAIL PROTECTED]> interesting side-note: mutt's list-reply misses my send-hooks... :) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
