MySQL Bugs: #27314: Clicking Health gives multiple MsgBox "Error while fetching Server Variables."

Bug #27314	Clicking Health gives multiple MsgBox "Error while fetching Server Variables."
Submitted:	21 Mar 2007 0:58	Modified:	28 Mar 2007 14:21
Reporter:	Lynn Prentice	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.2.10	OS:	Windows (WinXP SP2)
Assigned to:		CPU Architecture:	Any
Tags:	health, message, server variables

Description:
MYSQL community server 5.1.16 accessed by MySQL Administrator 1.2.10. When I click on the Health tree item, it repeatably says via a MsgBox "Error while fetching Server Variables". I actually noticed this problem on an earlier version of the Administrator after I upgraded to the beta server version 1.2.2(?), but then it would display once, and then continue with some invalid key buffer info. However the newer version of the Administrator is unworkable in the same problem, because it repeatably pops the MsgBox
 

How to repeat:
server 5.1.16 running on win2003 server. Administrator on winXP SP2

I was unable to repeat the behavior reported when connecting from
Vista to a server running on Linux FC 6 or Windows XP and from
Windows XP connecting with server running on Windows Vista.

I have the same problem.

Error while fetching schema table status.

The following error occured: Can´t create/write to file '/var/lib/mysql/tmp/#sql_45ae_0.myi'(Errcode: 2)(1)

I was not able to repeat the behavior reported connecting against a server
running localhost and remotely (Windows 2003/XP Pro) with user root and
user with limited previleges.

I have the same problem when I upgrade mysql 5.0.37 to 5.1.17, but i forget to execute mysql_upgrade. So Mysql starts ok but if I try:
 
mysql> show variables;
ERROR 1568 (HY000): Cannot proceed because the tables used by events were found damaged at server start

This why Mysql Administrator gui gives you "Errore while fetching server variables" ...

So I execute the mysql_upgrade and then all goes ok.

[root]# ./mysql_upgrade --verbose --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock

That's all.

I got the same problem after upgrading ti mysql 6.0 (on windows xp as well as on w2k3).
mysql_upgrade produces following errors:

ERROR 1064 (42000) at line 63: You have an error in your SQL syntax; check the manual that
 corresponds to your MySQL server version for the right syntax to use near 'int DEFAULT 0'
 at line 1
ERROR 1327 (42000) at line 63: Undeclared variable: is_csv_enabled
ERROR 1064 (42000) at line 63: You have an error in your SQL syntax; check the manual that
 corresponds to your MySQL server version for the right syntax to use near 'IF (is_csv_ena
bled) THEN CREATE TABLE IF NOT EXISTS general_log (event_time TIME' at line 1
ERROR 1064 (42000) at line 63: You have an error in your SQL syntax; check the manual that
 corresponds to your MySQL server version for the right syntax to use near 'END IF' at lin
e 1
ERROR 1064 (42000) at line 63: You have an error in your SQL syntax; check the manual that
 corresponds to your MySQL server version for the right syntax to use near 'END' at line 1

ERROR 1305 (42000) at line 64: PROCEDURE mysql.create_general_log_table does not exist
ERROR 1305 (42000) at line 65: PROCEDURE mysql.create_general_log_table does not exist
ERROR 1064 (42000) at line 68: You have an error in your SQL syntax; check the manual that
 corresponds to your MySQL server version for the right syntax to use near 'int DEFAULT 0'
 at line 1
ERROR 1327 (42000) at line 68: Undeclared variable: is_csv_enabled
ERROR 1064 (42000) at line 68: You have an error in your SQL syntax; check the manual that
 corresponds to your MySQL server version for the right syntax to use near 'IF (is_csv_ena
bled) THEN CREATE TABLE IF NOT EXISTS slow_log (start_time TIMESTA' at line 1
ERROR 1064 (42000) at line 68: You have an error in your SQL syntax; check the manual that
 corresponds to your MySQL server version for the right syntax to use near 'END IF' at lin
e 1
ERROR 1064 (42000) at line 68: You have an error in your SQL syntax; check the manual that
 corresponds to your MySQL server version for the right syntax to use near 'END' at line 1

ERROR 1305 (42000) at line 69: PROCEDURE mysql.create_slow_log_table does not exist
ERROR 1305 (42000) at line 70: PROCEDURE mysql.create_slow_log_table does not exist
ERROR 1060 (42S21) at line 92: Duplicate column name 'File_priv'
ERROR 1060 (42S21) at line 98: Duplicate column name 'Grant_priv'
ERROR 1060 (42S21) at line 99: Duplicate column name 'Grant_priv'
ERROR 1060 (42S21) at line 100: Duplicate column name 'Grant_priv'
ERROR 1060 (42S21) at line 111: Duplicate column name 'ssl_type'
ERROR 1061 (42000) at line 121: Duplicate key name 'Grantor'
ERROR 1054 (42S22) at line 148: Unknown column 'Type' in 'columns_priv'
ERROR 1060 (42S21) at line 170: Duplicate column name 'type'
ERROR 1060 (42S21) at line 180: Duplicate column name 'Show_db_priv'
ERROR 1060 (42S21) at line 197: Duplicate column name 'max_questions'
ERROR 1060 (42S21) at line 207: Duplicate column name 'Create_tmp_table_priv'
ERROR 1060 (42S21) at line 210: Duplicate column name 'Create_tmp_table_priv'
ERROR 1060 (42S21) at line 304: Duplicate column name 'Create_view_priv'
ERROR 1060 (42S21) at line 307: Duplicate column name 'Create_view_priv'
ERROR 1060 (42S21) at line 310: Duplicate column name 'Create_view_priv'
ERROR 1060 (42S21) at line 316: Duplicate column name 'Show_view_priv'
ERROR 1060 (42S21) at line 319: Duplicate column name 'Show_view_priv'
ERROR 1060 (42S21) at line 322: Duplicate column name 'Show_view_priv'
ERROR 1060 (42S21) at line 339: Duplicate column name 'Create_routine_priv'
ERROR 1060 (42S21) at line 342: Duplicate column name 'Create_routine_priv'
ERROR 1060 (42S21) at line 345: Duplicate column name 'Create_routine_priv'
ERROR 1060 (42S21) at line 351: Duplicate column name 'Alter_routine_priv'
ERROR 1060 (42S21) at line 354: Duplicate column name 'Alter_routine_priv'
ERROR 1060 (42S21) at line 357: Duplicate column name 'Alter_routine_priv'
ERROR 1060 (42S21) at line 360: Duplicate column name 'Execute_priv'
ERROR 1060 (42S21) at line 363: Duplicate column name 'Execute_priv'
ERROR 1060 (42S21) at line 376: Duplicate column name 'max_user_connections'
ERROR 1060 (42S21) at line 385: Duplicate column name 'Create_user_priv'
ERROR 1060 (42S21) at line 403: Duplicate column name 'Routine_type'
ERROR 1060 (42S21) at line 511: Duplicate column name 'Event_priv'
ERROR 1060 (42S21) at line 516: Duplicate column name 'Event_priv'
ERROR 1060 (42S21) at line 524: Duplicate column name 'sql_mode'
ERROR 1060 (42S21) at line 557: Duplicate column name 'originator'
ERROR 1060 (42S21) at line 560: Duplicate column name 'time_zone'
ERROR 1060 (42S21) at line 570: Duplicate column name 'Trigger_priv'
ERROR 1060 (42S21) at line 573: Duplicate column name 'Trigger_priv'
ERROR 1060 (42S21) at line 576: Duplicate column name 'Trigger_priv'

Any idea?