Bug #10488 show tables command makes the system hang

• Submitted: 9 May 2005 18:17
• Modified: 6 Jun 2005 16:53
• Reporter: Elim Qiu
• Status: Closed
• Category: MySQL Server: Command-line Clients
• Severity: S2 (Serious)
• Version: 5.0.2 or later
• OS: Windows (windows 2000 pro)
• CPU Architecture: Any

[9 May 2005 18:17] Elim Qiu

Description:
If a database folder has name in uppercase, when do a table list as
mysql>show tables;

the system will hang and 100% cpu usage will be taken by mysqld

How to repeat:
take any database (folder) with uppercase chars in the folder name (my case was
ESite instead of esite), put it in the data folder specified by my.ini, login with mysql client and do the following:

mysql>use ESite;
mysql>show tables;

this'll repeat the problem. notice that 'ESite' is a database name, one can replace
it by any other existing database whose name has uppercase chars.

Suggested fix:
 i don't know how to make this work as versions 5.0.1 or earlier. but uppercase chars used in database name will be a nice feature.

[10 May 2005 13:41] Hartmut Holzgraefe

Can't reproduce this with either 5.0.2 or 5.0bk on Linux, 
maybe related to case conversion on case insensitive filesystems?

[10 May 2005 17:32] Elim Qiu

Good to know linux has no problem of this type. Up to 5.01, in windows there
is also no problem. This is new from version 5.0.2 and OS=windows 2000 pro.
My guess is that windows xp and win2k will make no difference

[10 May 2005 18:17] MySQL Verification Team

Please test with the latest 5.0.4 version. 5.0.2 had problems with crashing the
server with commands like show tables.

Thanks in advance.

[24 May 2005 22:49] Elim Qiu

Getting better: the server not crash but not return the simple info either.
One can easily repeat the problem as in my earlier reports.

[24 May 2005 22:54] Elim Qiu

The bug has not been fixed. I'm still use 5.0.1

[27 May 2005 7:51] Vasily Kishkin

I tested on Win 2000 Pro Sp4, MySQL server 5.0.6 beta. I could't reproduce this bug.

[27 May 2005 13:17] Elim Qiu

cannot get 5.0.6 beta. but for 5.0.4 beta and database created by 4.* with
uppercase and lowercase chars (like ESite, MailAgent etc) still cause problems:
the command
mysql>show tables;
hangs. (but the serve not crash or eat cpu/memory as before)

[6 Jun 2005 16:42] Elim Qiu

Yes. I've tried with 5.0.6 beta and the problem has been fixed.

[6 Jun 2005 16:53] MySQL Verification Team

Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/

Additional info:

Thank you for the feedback.