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

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




--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

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
/ /|_/ / // /\ \/ /_/ / /__ 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/bugs?unsub=gcdmb-bugs@m.gmane.org