Bug #8721 Error getting tables from db directory causes app to hang

• Submitted: 23 Feb 2005 5:37
• Modified: 16 Sep 2005 18:22
• Reporter: John David Duncan
• Status: Not a Bug
• Category: MySQL Administrator
• Severity: S3 (Non-critical)
• Version: 1.0.3-alpha
• OS: Mac OS X (Mac OS X)
• Assigned to: Alfredo Kojima
• CPU Architecture: Any

[23 Feb 2005 5:37] John David Duncan

Description:
I have a database directory which (due to bad permissions) my server can't read:

mysql> use sforce_mysql_sales-engineeringDatabase changed
mysql> show tables;ERROR 12 (HY000): Can't read dir of './sforce_mysql_sales-engineering/' (Errcode: 13)

When I go to "Catalogs" in Administrator, and then select this database from the "Schemata" list, Administrator hangs and has to be killed with "Force Quit."  

How to repeat:
sh#  cd /var/lib/mysql
sh# chown some-other-user db1

Choose "Catalogs" in Administrator, and then select this db1 from the "Schemata" list.

[24 Feb 2005 5:19] Alfredo Kojima

Hi Josh

What version of the server are you using? I've tried that with 4.1.8 and it didn't hang.
But perhaps it got fixed from other unrelated changes, please follow up after testing it on 1.0.4.

[25 Feb 2005 4:04] Ognjen Honovic

It happens to me too with server 5.0.2 and Administrator 1.0.19, and with browser 1.1.5.
When I click on a database to fetch the list of tables, the server crashes.

[25 Feb 2005 21:21] Alfredo Kojima

The server crash is a server bug and has already been reported to the server team. 
I'll make sure that Adminstrator doesn't hang in the event that the server crashes, but in the meantime you should downgrade to server version 5.0.1