sbester@www:~> gcc testcase.c -g -o testcase -L/home/sbester/server/5.0/mysql-5.0.36-linux-i686/lib -I/home/sbester/server/5.0/mysql-5.0.36-linux-i686/include   -lmysqlclient_r -lz -lpthread
testcase.c: In function `worker_thread':
testcase.c:170: warning: this decimal constant is unsigned only in ISO C90
sbester@www:~> ./testcase 
running initializations..
pre-generating 16777216 bytes of random data
about to spawn 10 threads
..........
completed spawning new database worker threads
testcase is now running, so watch for error output

sbester@www:~> 




070212  3:25:13 [ERROR] mysqld-nt: Incorrect key file for table '.\test\t1.MYI'; try to repair it
070212  3:25:13 [ERROR] mysqld-nt: Incorrect key file for table '.\test\t1.MYI'; try to repair it
070212  3:25:13 [ERROR] mysqld-nt: Incorrect key file for table '.\test\t1.MYI'; try to repair it
070212  3:25:14 [ERROR] mysqld-nt: Incorrect key file for table '.\test\t1.MYI'; try to repair it
070212  3:25:14 [ERROR] mysqld-nt: Incorrect key file for table '.\test\t1.MYI'; try to repair it
070212  3:25:14 [ERROR] mysqld-nt: Incorrect key file for table '.\test\t1.MYI'; try to repair it
070212  3:25:14 [ERROR] mysqld-nt: Incorrect key file for table '.\test\t1.MYI'; try to repair it
070212  3:25:14 [ERROR] mysqld-nt: Incorrect key file for table '.\test\t1.MYI'; try to repair it
070212  3:25:14 [ERROR] mysqld-nt: Incorrect key file for table '.\test\t1.MYI'; try to repair it
070212  3:25:17 [ERROR] mysqld-nt: Incorrect key file for table '.\test\t1.MYI'; try to repair it
070212  3:25:17 [ERROR] mysqld-nt: Incorrect key file for table '.\test\t1.MYI'; try to repair it
070212  3:25:17 [ERROR] mysqld-nt: Incorrect key file for table '.\test\t1.MYI'; try to repair it
070212  3:25:17 [ERROR] mysqld-nt: Incorrect key file for table '.\test\t1.MYI'; try to repair it




mysql> check table `t1` extended;
+---------+-------+----------+----------------------------+
| Table   | Op    | Msg_type | Msg_text                   |
+---------+-------+----------+----------------------------+
| test.t1 | check | warning  | Table is marked as crashed |
| test.t1 | check | error    | Found 41752 keys of 41751  |
| test.t1 | check | error    | Corrupt                    |
+---------+-------+----------+----------------------------+
3 rows in set (0.11 sec)


sometimes

mysql> check table `t1` extended;
+---------+-------+----------+---------------------------------------+
| Table   | Op    | Msg_type | Msg_text                              |
+---------+-------+----------+---------------------------------------+
| test.t1 | check | warning  | Table is marked as crashed            |
| test.t1 | check | error    | Can't read key from filepos: 15943680 |
| test.t1 | check | error    | Corrupt                               |
+---------+-------+----------+---------------------------------------+
3 rows in set, 1 warning (0.02 sec)