On Thu, 20 Dec 2001, Almar van Pel wrote: > I believe this error is assigned to a crashed table. > > try repair table and afterwards optimize.
Eh, I forgot to mention that I've done CHECK TABLE a bit too late, when the user came and said that the problem got fixed itself, and asked me what I did. We came to the conclusion it's because of the flush tables command. Next time he has to run the check table himself and grab the table files before doing anything, and I plan to do then check table, grab files again and then flush tables and then again grab the table files. I wish there will be a difference in file sizes or timestamps or just something. In principal, there should be if he accessing somehow first row from already deleted table and claiming there's same amount of rows. But to answer your question, when I check those tables referred in errorlog, CHECK TABLE says OK. :( And no-one did any repair table on them, for sure. Currently we still don't know how to reproduce it, but at least the approach with dropping table gives an idea about cache handling. But, those errors are on the other hand haven't been logged in the errorlog, although the user received, the error through perl DBI. However, those examples from errolog are examples, when those tables aren't ever modified. They're just in the errolog file and I never found a corrupted table in such case when if I do run CHECK TABLE on them, (they're OK), as I've said above. So it looks taht at some "random" situations mysql cannot operate on some tables. It doesn't look to be related to size of the table at all, and all of them are MyISAM. So the approach drop/create isn't what happens usually here and what's logged in the errrolog. However, probably with right amount of threads operating on same database/tables would show the problem. But I've seen these 127 erros posted to list by others also, if I remeber, so maybe I'm not the only-one. It happens on Linux 2.2.19 with 3.23.44, but those errors 127 we have also on 2.4.11 if I remember right the kernel version. -- Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs MIPS / Institute for Bioinformatics <http://mips.gsf.de> GSF - National Research Center for Environment and Health Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany tel.: +49-89-3187 3616 , fax: +49-89-3187 3585 --------------------------------------------------------------------- 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
