Bug #49085 typo in advisor Slave Error: Unknown or Incorrect Time Zone (v 1.0 *)
Submitted: 25 Nov 2009 6:12 Modified: 11 Dec 2009 15:06
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Advisors/Rules Severity:S3 (Non-critical)
Version:2.1.0.1096 OS:Linux
Assigned to: Andy Bang CPU Architecture:Any

[25 Nov 2009 6:12] Shane Bester 
Description:
the recommended action is:

Shell: mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
MySQL: stop slave;
MySQL: start slave;
MySQL: show slave statusG;

How to repeat:
mysql> show slave statusG;
ERROR 1064 (42000): 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 'statusG' at line 1

Suggested fix:
it should say:

MySQL: show slave status\G
[25 Nov 2009 9:57] Sveta Smirnova 
Thank you for the report.

Verified as described.
[3 Dec 2009 23:29] Enterprise Tools JIRA Robot 
Andy Bang writes: 
Pushed up to revision 303.
[7 Dec 2009 21:52] Enterprise Tools JIRA Robot 
Marcos Palacios writes: 
Verified fixed in advisor bundle 2.2.0.1571.
[11 Dec 2009 15:06] MC Brown 
No documentation needed.