Bug #44146 ndb_mgm -e " START BACKUP WAIT STARTED" not works as documented
Submitted: 8 Apr 2009 9:34 Modified: 10 Oct 2013 15:50
Reporter: Wen Xiong Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version:mysql-5.1-telco-7.0 OS:Solaris
Assigned to: Priyanka Sangam CPU Architecture:Any

[8 Apr 2009 9:34] Wen Xiong
Description:
According to the document,
With WAIT STARTED the management client waits until the backup has started before returning control to the user, as shown here:

ndb_mgm> START BACKUP WAIT STARTED
Waiting for started, this may take several minutes
Node 2: Backup 3 started from node 1
ndb_mgm>

When I run this command, 
./bin/ndb_mgm -c localhost:12500 -e "START BACKUP SNAPSHOTSTART WAIT STARTED"
backup return the result when backup completes as default.

Connected to Management Server at: localhost:12500
Waiting for started, this may take several minutes
Node 1: Backup 4 started from node 3
Node 1: Backup 4 started from node 3 completed
 StartGCP: 355 StopGCP: 358
 #Records: 42064 #LogRecords: 0
 Data: 1012588 bytes Log: 0 bytes

How to repeat:
start a cluster
ndb_mgm -e "START BACKUP SNAPSHOTSTART WAIT STARTED"
[9 Apr 2009 13:47] Jonathan Miller
Try with much larger data set
[5 May 2009 16:20] Jonathan Miller
Feedback from Wen listed below. Upgrading to P3, and assigning to Magnus to get some suggestion on workaround, or if it would be easy to fix.

/Jeb

** Wen **

The point is that when performing with this option
ndb_mgm -e "START BACKUP WAIT BACKUP",  the message should return when backup has started without waiting until it has finished as:

Waiting for started, this may take several minutes
Node 2: Backup 3 started from node 1

no matter how much data we have.

What I found:
This is result for mysql-5.1-telco-6.4 version of one month or more ago:
Connected to Management Server at: localhost:12500
Waiting for started, this may take several minutes

and this is the result for the latest version:
Connected to Management Server at: localhost:12500
Waiting for started, this may take several minutes
Node 1: Backup 2 started from node 3
Node 1: Backup 2 started from node 3 completed
StartGCP: 1058 StopGCP: 1061
#Records: 2053 #LogRecords: 0

And I need this function works, otherwise we can not know when backup has started so that we can update data after that to check if backup at start time works after restore.

BR
Wen
[10 Oct 2013 8:34] Priyanka Sangam
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.html

Fixed from MySQL Cluster 7.0.39 and upwards
[10 Oct 2013 15:51] Jon Stephens
Fixed in NDB 7.0+. Documented fix in the NDB 7.0.39, 7.1.29, and 7.2.14 changelogs, as follows:

      When START BACKUP WAIT STARTED was run from the command line using
      ndb_mgm -e, the client did not exit until the backup completed.

Closed.