Bug #42811 Replication tab does not account for the new Last_IO|SQL_Error columns in 5.1
Submitted: 12 Feb 2009 22:41 Modified: 22 May 2009 9:07
Reporter: Mark Leith Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Web Severity:S2 (Serious)
Version:2.0.4.7141 OS:Any
Assigned to: Darren Oldag CPU Architecture:Any
Tags: mem, replication tab

[12 Feb 2009 22:41] Mark Leith
Description:
There were 4 new columns added to SHOW SLAVE STATUS within 5.1:

                Last_IO_Errno: 0
                Last_IO_Error: 
               Last_SQL_Errno: 0
               Last_SQL_Error: 

These are not shown, nor accounted for, within the replication tab - they should probably be shown in the near future as more people move to 5.1 GA.

How to repeat:
Run MEM against a 5.1 slave. Check for the existence of anything relating to "Last_IO_Error" or "Last_SQL_Error" within the tab or popups. 

Suggested fix:
Add in details for the SQL and IO thread Errors and Errnos.
[19 Feb 2009 17:30] Mark Matthews
For 2.0, we still work, at least according to http://dev.mysql.com/doc/refman/5.1/en/show-slave-status.html (the new columns get mapped to the old one, not broken out). Since it would require a UI change, we should include support of these columns with other replication tab "polish" in 2.1.
[24 Feb 2009 1:41] Bill Weber
Verified that as stated in http://dev.mysql.com/doc/refman/5.1/en/show-slave-status.html - the old Last_Errno and Last_Error are aliases for the new 5.1 Last_SQL_Errno and Last_SQL_Error so you will still get those as before. The new 5.1 Last_IO_Errno and Last_IO_Error are not aliased and will therefore need to be added.
[15 Apr 2009 23:06] Darren Oldag
per request from the reporter, we'll add those fields when they are present.
[16 Apr 2009 20:14] Darren Oldag
patch pushed to trunk for 2.1 build

revision-id: oldag@mysql.com-20090416200850-7q8nh2x5y7bcqwh0
parent: jsled@asynchronous.org-20090416194704-338lwwpbzx2y1tc7
committer: Darren L. Oldag <oldag@mysql.com>
branch nick: Trunk
timestamp: Thu 2009-04-16 15:08:50 -0500
message:
  add last_{sql|io}_err{no|or} support to the replication tab
  and the replication server popups.
  
  "last error" was renamed in all views to "last sql error" because
  in pre 5.1 mysql's, it really was always the sql error, and i/o
  errors were simply never shown.
  
  in the case where the mysql server does not support both sql and io
  servers, the io column is left blank in the tab, and in the popup
  the rows are not even there.
[16 Apr 2009 20:36] Keith Russell
Patch installed in versions => 2.1.0.1026.
[16 Apr 2009 20:42] Keith Russell
Status changed by mistake. Will be in the next 2.1 build.
[23 Apr 2009 16:28] Keith Russell
Patch installed in versions => 2.1.0.1030.
[25 Apr 2009 0:59] Bill Weber
verified the Last IO Error column is added and displays the Last IO error correctly in build 2.1.0.1031
[22 May 2009 9:07] Tony Bedford
An entry has been added to the 2.1.0 changelog:

There were four columns added to the SHOW SLAVE STATUS query in MySQL Server 5.1: Last_IO_Errno, Last_IO_Error, Last_SQL_Errno, and Last_SQL_Error.

However, these were not displayed within the Replication tab.