Bug #49158 Start phase transitions should be logged in the nodes output log
Submitted: 27 Nov 2009 10:20 Modified: 5 Feb 2010 16:26
Reporter: Hartmut Holzgraefe 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: ANY, Contribution, mysql-ndb-7.0.9

[27 Nov 2009 10:20] Hartmut Holzgraefe
Description:
Currently start phase transitions only seem to be logged to the management nodes cluster log. It would be nice to have them in the data nodes out log, too, for two reasons:

- easier to extract as they are not mixed with messages from other nodes
- when looking at the ndb_#_out.log it would be clear right away what start phase a node was in when writing a message to the out log at any given time
- sometimes we only have the data nodes logs but not the cluster log

How to repeat:
.

Suggested fix:
When sending a start phase transition message to the management node(s) also write a log line to the local ndb_#_out.log
[22 Jan 2010 23:39] 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/97951

3363 Andrew Hutchings	2010-01-22
      Bug #49158  	Start phase transitions should be logged in the nodes output log
      
      Added new info level message into data node's log, for example:
      
      2010-01-22 23:30:05 [ndbd] INFO     -- Start phase 0 completed
      saving 0x7fa164b38000 at 0xd10db8 (0)
      2010-01-22 23:30:05 [ndbd] INFO     -- Start phase 1 completed
      2010-01-22 23:30:05 [ndbd] INFO     -- Start phase 2 completed
      ...
      2010-01-22 23:30:08 [ndbd] INFO     -- Start phase 101 completed
      2010-01-22 23:30:08 [ndbd] INFO     -- Node started
[2 Feb 2010 9:38] 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/98910
[2 Feb 2010 9:42] Bugs System
Pushed into 5.1.41-ndb-7.0.13 (revid:magnus.blaudd@sun.com-20100202093752-g013gr3nvk1qa1ik) (version source revid:magnus.blaudd@sun.com-20100202093752-g013gr3nvk1qa1ik) (merge vers: 5.1.41-ndb-7.0.13) (pib:16)
[2 Feb 2010 11:17] Magnus BlÄudd
Pushed to 7.0.13 and 7.1.2
[5 Feb 2010 16:26] Jon Stephens
Documented in the NDB-7.0.13 and 7.1.2 changelogs as follows:

      Start phases are now written to the data node logs. 

Closed.