Bug #7577 system hang
Submitted: 29 Dec 2004 15:56 Modified: 29 Dec 2004 16:12
Reporter: Elim Qiu Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.0.2-alpha (Windows (x86) without inst OS:Windows (win2k pro)
Assigned to: CPU Architecture:Any

[29 Dec 2004 15:56] Elim Qiu 
Description:
I tried 5.0.2-alpha (Windows (x86) without  installer) with
my existing 5.0.1-alpha-nt in the following way (os:win2k pro)

(1) stop mysql service
(2) renamed 5.0.1-alpha-nt installation folder (F:\MySQL -->
     F:\_MySQL)
(3) unzip the contents of 5.0.2-alpha package to F:\MySQL
(4) remove folder F:\MySQL\data since my data folder located
     at F:\DBData\MySQLData and the my.ini was modified to
     work with this setting very well for my 5.0.1-alpha-nt 
     installation
(5) start mysql service

Everything looks ok. Using mysql client, logged in and do
mysql>show databases;
The database names were displayed ok...(25 rows in set ...)

then do

mysql>use ESite;

It says(as usual);

Database changed

NOW THE PROBLEM:
mysql>show tables;

IT took 100% cpu and the system simply hang there.

I used almost the same procedure update MySQL installation
from 4.1 to 5.0.1-alpha without any problem.

Did I miss anything?

How to repeat:
described above
[29 Dec 2004 16:12] MySQL Verification Team 
Duplicate for #6950
[29 Dec 2004 16:43] Elim Qiu 
Just read #6950, different user case. don't see much similarities. But could have the same cause. Not sure to me.