MySQL Bugs: #24544: Backup report in ndb_mgm and logfile suggestion

Bug #24544	Backup report in ndb_mgm and logfile suggestion
Submitted:	23 Nov 2006 13:12	Modified:	6 Dec 2006 11:21
Reporter:	Geert Vanderkelen	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S3 (Non-critical)
Version:	5.1.12	OS:	Any (*)
Assigned to:	Jonas Oreland	CPU Architecture:	Any
Tags:	Backup, log, NDB_MGM

Description:
With MySQL 5.1.12 the backup report is not printed anymore to STDOUT (or STDERR). This is useful information for automated processes for example. It would be great that this could be enabled again. (see also bug 4590)

Also, currently the output is on 3 lines, but it would be probably better to put this one line. It makes it easier to parse for scripts.
In log files, printing 3 lines like that breaks the flow of the log a bit. Maybe it should be logged also as 1 line and with a timestamp in front of it like the other log entries.

How to repeat:
With current version 5.1.14 from bk (and 5.1.12-beta):

shell> ndb_mgm -e "START BACKUP"
Connected to Management Server at: localhost:1186
Waiting for completed, this may take several minutes
shell>

Output in cluster logs:

2006-11-23 14:05:36 [MgmSrvr] INFO     -- Node 3: Backup 1 started from node 1 completed
 StartGCP: 46 StopGCP: 49
 #Records: 2050 #LogRecords: 0
 Data: 32960 bytes Log: 0 bytes

Suggested fix:
Output the report again on STDOUT like it was before 5.1.12-beta:

shell> ndb_mgm -e "START BACKUP"
Connected to Management Server at: localhost:1186
Waiting for completed, this may take several minutes
 StartGCP: 46 StopGCP: 49
 #Records: 2050 #LogRecords: 0
 Data: 32960 bytes Log: 0 bytes
shell>

Even better, put it on one line:

shell> ndb_mgm -e "START BACKUP"
Connected to Management Server at: localhost:1186
Waiting for completed, this may take several minutes
Backup report: StartGCP: 46 StopGCP: 49 #Records: 2050 #LogRecords: 0 Data: 32960 bytes Log: 0 bytes

And in logs, something like this:
2006-11-23 14:05:36 [MgmSrvr] INFO     -- Node 3: Backup 1 started from node 1 completed, StartGCP: 46 StopGCP: 49 #Records: 2050 #LogRecords: 0 Data: 32960 bytes Log: 0 bytes

Verified using 5.1.11 (where it works) and 5.1.12 and 5.1.14 from bk on Linux.

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/15955

ChangeSet@1.2331, 2006-11-28 15:11:13+01:00, jonas@perch.ndb.mysql.com +4 -0
  ndb - bug#24544
    fix so backup message is printed even in case of "ndb_mgm -e"

comment: it still multi line printout...

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.htmlk

Documented in 5.1.14 changelog, and in Backups section of Cluster chapter in the 5.1 Manual.