4 messages in com.mysql.lists.bugsRe: 2GB kernel filesize limit and myi...
FromSent OnAttachments
Martin MOKREJŠ23 Nov 2001 08:07 
Martin MOKREJŠ23 Nov 2001 09:34 
Martin MOKREJŠ23 Nov 2001 09:59 
Michael Widenius23 Nov 2001 18:36 
Subject:Re: 2GB kernel filesize limit and myisam tables
From:Martin MOKREJŠ (mmok@natur.cuni.cz)
Date:11/23/2001 09:59:03 AM
List:com.mysql.lists.bugs

Hi, just a follow-up when I tried to repair the table I started the repair command. It was repaired OK, I run check table command and after a minute typed into the screen buffer next commands (because I thought it will give status OK. But no, because there was record pointing outside the table but the reported status was anyway OK (weird). I re-run the check table and it me *only* OK. So how did that record pointing outside got fixed? Or why did the first check table run report something untrue? Was the reason for that that I between those two CHECK TABLE commands switched the databases?

mysql> check table intergenome_data; mysql> mysql> check table intergenome_data; +------------------------------+-------+----------+---------------------------------------------------------------+ | Table | Op | Msg_type | Msg_text
| +------------------------------+-------+----------+---------------------------------------------------------------+ | Bhalodurans.intergenome_data | check | warning | Table is marked as crashed
| | Bhalodurans.intergenome_data | check | error | Size of datafile is:
2147483647 Should be: 2147486672 | | Bhalodurans.intergenome_data | check | error | Corrupt
| +------------------------------+-------+----------+---------------------------------------------------------------+ 3 rows in set (0.01 sec)

mysql> repair table intergenome_data;

use Clostridium_acetobutylicum_ATCC824;

check table intergenome_data;

+------------------------------+--------+----------+---------------------------------------------------------+ | Table | Op | Msg_type | Msg_text
| +------------------------------+--------+----------+---------------------------------------------------------+ | Bhalodurans.intergenome_data | repair | info | Found block that points
outside data file at 2147463992 | | Bhalodurans.intergenome_data | repair | status | OK
| +------------------------------+--------+----------+---------------------------------------------------------+ 2 rows in set (23 min 1.01 sec)

Soorry, this output is from REPAIR TABLE, not from CHECK TABLE yet! I'm idiot. So you can ignore this follow-up post.