Re: Fwd: Question relating to bug 1812 (and Check Table results)

Paul Coldrey writes:
>   Hi Folks,
> 
> I'm trying to code a succinct test case to expose the bug reported in 
> Bug #1812. I cannot repeat the table corruption yet, with my cutdown 
> code, but I do get lots of interesting messages when running "CHECK TABLE".
> 
> Hence, my question is, should I see warnings like the following if the 
> table is OK, or are these likely to be relevant to my problems?
> 
> mysql> check table Event;
> +---------------+-------+----------+----------------------------------------------------+ 
> 
> | Table         | Op    | Msg_type | Msg_text        |
> +---------------+-------+----------+----------------------------------------------------+ 
> 
> | Daelibs.Event | check | warning  | Size of indexfile is: 145408      
> Should be: 1024  |
> | Daelibs.Event | check | warning  | Size of datafile is: 66560       
> Should be: 0      |
> | Daelibs.Event | check | warning  | Found 1280 deleted blocks       
> Should be:0       |
> | Daelibs.Event | check | warning  | Found 1280 parts                
> Should be:0 parts |
> | Daelibs.Event | check | status   | OK        |
> +---------------+-------+----------+----------------------------------------------------+ 
> 
> 5 rows in set (0.00 sec)
> 
> Cheers,
> 
>    Paul
> 
> 

The above indicate that table had problems, but was fixed with the
above command.

-- 

Sincerely,

-- 
For technical support contracts, go to https://order.mysql.com/?ref=msmi
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Sinisa Milivojevic <[email protected]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB
/_/  /_/\_, /___/\___\_\___/   Fulltime Developer and Support Coordinator
       <___/   www.mysql.com   Larnaca, Cyprus


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]