Hi Monty! I am combining two messages into one: > Heikki> server is broken. Why does it claim that? > > This could happen if some client code set the 'thd->killed' flag. > > The main problem here is why we should get this in mysqldump, but not > in 'mysql'. > > Ken, did you get any output from mysqldump (Ie, did you get the CREATE > TABLE statement ?)
Yes, you do get a create table statement. It ends with the LOCK statement IE: -- -- Table structure for table 'terms' -- DROP TABLE IF EXISTS terms; CREATE TABLE terms ( trmID tinyint(2) unsigned NOT NULL auto_increment, trmPrct int(5) unsigned NOT NULL default '0', trmText char(30) NOT NULL default '', PRIMARY KEY (trmID), KEY trmTextidx (trmText), KEY trmPrctidx (trmPrct) ) TYPE=MyISAM; /*!40000 ALTER TABLE terms DISABLE KEYS */; -- -- Dumping data for table 'terms' -- LOCK TABLES terms WRITE; > > If this is a cache problem, then any insert or 'reset query cache' > would invalidate the cache. True, an update or insert or alter table type clears the problem, > > Note however that the query cache is not on by default; If Ken didn't > enable it, it should not have caused by this problem. > Yes, I do have query cache turned on, that is when the problem started happening. > > It would have been nice to know if restarting MySQL would have helped. > If not, then we would like to have had a copy of the InnoDB table space to > be able to replicate the problem! Yes, restarting MySQL clears the problem. The problem happens with BOTH myisam and innodb tables!!!! I can send either or both tables to the upload site. One other thought was it could be the LOCK TABLES statement that is causing this issue, I did not think to try that at the command prompt, I will check it but as I just restarted the server it will take a few hours before I see the problem again. Hope this helps, Ken > > Regards, > Monty > > -------------------------------------------------------------------- - > Before posting, please check: --------------------------------------------------------------------- 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
