We've been seeing this quite often at our web application company. The development machines run debian linux with kernel 2.4.x (they differ) and ReiserFS, and on local installations of the web app, which puts DB, web server, and CGIs on the same box, we see frequent table corruption. Sometimes it's on the order of a couple of times a week, which is absolutely ridiculous considering how little the DB install is stressed on developer boxes. Fortunately the DB server used for the public cluster, which gets its own debian linux 2.4.x machine, and I *think* doesn't use ReiserFS (the maintenance crew has changed its collective mind several times, much to the annoyance of the development and QA teams), does *not* exhibit this problem, or so the crew claims. (Don't even ask about the politics of communication within our company...)
This is clearly a BIG BIG worry for me, but the story I am handed (from some very dubious sources) is that it's an interaction between MySQL and ReiserFS and that as long as the public servers don't user ReiserFS we'll be fine. Can anybody actually lend credence to this claim? -rob On 21/5/02 at 2:49 pm, Matthias Jaekle <[EMAIL PROTECTED]> wrote: > Hello, > > approximatly twice a week I get Error 1030: error 127 (table handler) on > one table. This table is around 2.3 GB, the indexfile around 2.2 GB. > There are around 24.000.000 records in the table. > > I am running mysql 4.0.1-alpha on linux with 2.4.18 kernel. But I also > got this error with older mysql versions (3.23) and kernels. > > Sometimes restarting mysql solves the problem, sometimes I have to check > the table to get back a running system (no errors found) and sometimes I > had to repair the index or data file. But I can not find any schema. > > Checking and repairing tables take multiple hours and stops our normal > work. So it is very bad. > > Does anybody have an idea, how to solve this problem ? > Does somebody else have problems like this ? > Could there be misconfiguration responsible ? > > Many thanks > > Matthias Jaekle > > > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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
