Bug #8080 Server Lost Connection with "show fields" sql statement

• Submitted: 21 Jan 2005 21:33
• Modified: 22 Jan 2005 1:58
• Reporter: Terry Long
• Status: Duplicate
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 5.0.2-alpha
• OS: Windows (Windows 2000)
• CPU Architecture: Any

[21 Jan 2005 21:33] Terry Long

Description:
Upgraded from 4.1.7 to 5.0.2
Ran mysql_fix_privilege_tables.sql
----------
Run MysqlServer from command line using:
>mysqld-nt --console --old_password --log --verbose --skip-innodb

In other window:
>mysql -u root -p mysql
> Provide password
mysql> show fields from mysql.host;
ERROR 2013 (HY000):  Lost connection to MySQL server during Query
---------
a300sm110.log shows:
mysqld-nt, Version: 5.0.2-alpha-nt-log. started with:
TCP Port: 3306, Named Pipe: MySQL
Time                 Id Command    Argument
050121 16:30:06	      1 Connect     root@localhost on mysql
050121 16:30:11	      1 Query       show tables
050121 16:30:20	      1 Query       show fields func

How to repeat:
Repeatable on my system - follow step above.

Suggested fix:
Unkown

[22 Jan 2005 1:58] MySQL Verification Team

Thank you for the bug report. It is related to the same bug report:

http://bugs.mysql.com/bug.php?id=6950