List:Bugs« Previous MessageNext Message »
From:sasha Date:September 8 2000 6:16pm
Subject:Re: win32 3.23.23 check table fails
View as plain text  
Steve Ruby wrote:
> 
> I haven't been able to get CHECK TABLE to work in win version
> of mysql since I started trying it (3.23.18 I believe)
> 
> right now here is what happens. For a simple table with no
> data, mysql never returns from check table. The following
> commands in mysql 3.23.23 win32 never return in the
> mysql monitor (mysql.exe) the process list looks like
> 
> +----+-------+-----------+--------+---------+------+-------+-----------------------+
> | Id | User  | Host      | db     | Command | Time | State |
> Info                  |
> +----+-------+-----------+--------+---------+------+-------+-----------------------+
> |  1 | sruby | localhost | testdb | Query   | 111  | NULL  | check table
> testtable |
> |  2 | sruby | localhost | NULL   | Query   | 0    | NULL  | show
> processlist      |
> +----+-------+-----------+--------+---------+------+-------+-----------------------+
> 
> create database testdb;
> use testdb;
> create table testtable (a int);
> check table testtable;
> 
> I am testing this on a smaller table because I have
> a large table full of data when I run check table on
> it mysqld-nt instantly pops up dr watson. and the server
> crashes.  myisamchk on the same table works fine.

Looks like a there is something wrong either with your NT installation or with
NT libriaries or our NT binaries in general - on my Linux machine the above test
worked fine. Can you send us the table that CHECK TABLE breaks on?

-- 
Sasha Pachev

+------------------------------------------------------------------+
|      ____  __     _____   _____  ___     http://www.mysql.com    |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sasha Pachev            |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     sasha@stripped         |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Provo, Utah, USA        |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                         |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                        |
|             /*/             \*\ Developers Team                  |
+------------------------------------------------------------------+
Thread
win32 3.23.23 check table failsSteve Ruby8 Sep
  • Re: win32 3.23.23 check table failssasha8 Sep
  • Re: win32 3.23.23 check table failsSteve Ruby8 Sep
    • Re: win32 3.23.23 check table failsMichael Widenius9 Sep