MySQL Bugs: #27992: Error: Could not fetch schema table status

Bug #27992	Error: Could not fetch schema table status
Submitted:	20 Apr 2007 22:58	Modified:	10 May 2007 7:45
Reporter:	Brad Kaenel	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.2.11	OS:	Windows (XP SP2)
Assigned to:		CPU Architecture:	Any
Tags:	fetch, schema, STATUS, table

Description:
After importing a database from MS SQL Server, the Administrator tool "Catalog" pan no longer functions.  The databases are listed, but clicking on any entry generates an error message dialog box stating: "Could not fetch schema table status."

No useful admin functions can be performed, since the database schema cannot be retrieved (thus, no tables/columns are available, either).

However, the database *does* exist and seems to operate correctly.  Query Browser can execute queries; client .Net programs can access the data, etc.

How to repeat:
Not certain.  May have to reinstall MySql Server and/or Administrator.

Thank you for the report.

Please provide output of statement SHOW GRANTS FOR user_you_connect_to_MA_via.

Results of SHOW GRANTS FOR devteam;

'GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE ON *.* TO 'devteam'@'%' IDENTIFIED BY PASSWORD '*35D788DF08469BE202FE5B611FF17D318FC6C287' WITH GRANT OPTION'

'GRANT ALL PRIVILEGES ON `devteam`.* TO 'devteam'@'%' WITH GRANT OPTION'

Thank you for the feedback.

Seems this bug corelated with Bug #27996. Could you please change tmpdir value in the my.cnf configuration file to some existing path located not in the Windows system directory and check if it solves this issue?

Yes, I'm sure bug 27996 is the same problem; solving one will likely solve the other.

Since I don't have access to the server box, it will take a day or so before my sysop can make the change and notify me.  I'll let you know the results...

Hello, I had the same problem and I can confirm that changing the temp folder outside the windows directory solves the issue like Sveta pointed.

Thank you, Victor, for the feedback.

I will change status of the report to "Not a Bug", as really problem is bug #27996.

Brad, if described workaround doesn't help in your case feel free to reopen the report.

NB: strictly say, tmpdir should be set to any location accessible for the user MySQL service running as. In most cases this is user SYSTEM