Bug #49627 Improved readability of cluster log
Submitted: 11 Dec 2009 16:13 Modified: 8 Feb 2010 14:14
Reporter: Matthew Montgomery Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S4 (Feature request)
Version:mysql-5.1-telco-7.0 OS:Any
Assigned to: Andrew Hutchings CPU Architecture:Any
Tags: 7.0.9, Contribution

[11 Dec 2009 16:13] Matthew Montgomery 
Description:
Some information contained in the cluster.log is not human readable or formatted well.

2009-12-11 14:29:34 [MgmtSrvr] INFO -- Node 1: Node 2 Connected
2009-12-11 14:29:35 [MgmtSrvr] INFO -- Mgmt server state: nodeid 2 freed, m_reserved_nodes 0000000000000000000000000000000000000000000000000000000000000002.
2009-12-11 14:29:37 [MgmtSrvr] INFO -- Node 2: Initial start, waiting for 3 to connect, nodes [ all: 2 and 3 connected: 2 no-wait: ]
2009-12-11 14:29:40 [MgmtSrvr] INFO -- Mgmt server state: nodeid 3 reserved for ip 10.0.0.10 m_reserved_nodes 000000000000000000000000000000000000000000000000000000000000000a.

How to repeat:
Read the cluster.log looking for node connections.

Suggested fix:
Messages identifying "m_reserved_nodes" in the cluster log should use the same getPrettyText functions that were introduced in Bug #44248 for "Initial start, waiting for..." messages
[23 Jan 2010 9:31] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/97963

3363 Andrew Hutchings	2010-01-23
      Bug #49627  	Improved readability of cluster log
      
      Fixed node outputs for both "Mgmt server state" messages:
      
      2010-01-23 09:23:49 [MgmtSrvr] INFO     -- Mgmt server state: nodeid 2 reserved for ip 127.0.0.1, m_reserved_nodes 1 and 2.
      ...
      2010-01-23 09:23:50 [MgmtSrvr] INFO     -- Mgmt server state: nodeid 2 freed, m_reserved_nodes 1.
[1 Feb 2010 10:04] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/98798
[2 Feb 2010 8:56] Magnus Blåudd 
Pushed to 7.0.12 and 7.1.2
[2 Feb 2010 9:08] Bugs System 
Pushed into 5.1.41-ndb-7.0.13 (revid:magnus.blaudd@sun.com-20100202090111-f2gvyfomndcjlvkr) (version source revid:magnus.blaudd@sun.com-20100201100320-xemjvo7da6x2zjml) (merge vers: 5.1.41-ndb-7.0.13) (pib:16)
[8 Feb 2010 14:14] Jon Stephens 
Documented bugfix in the NDB-7.0.12 and 7.1.2 changelogs as follows:

        Numeric codes used in management server status update messages
        in the cluster logs have been replaced with text descriptions.

Closed.