MySQL Bugs: #68854: START BACKUP WAIT STARTED waits forever on backup errors

Bug #68854	START BACKUP WAIT STARTED waits forever on backup errors
Submitted:	3 Apr 2013 9:54	Modified:	27 Jun 2013 21:41
Reporter:	Hartmut Holzgraefe	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S3 (Non-critical)
Version:	mysql-cluster-7.2.10, 7.2.12	OS:	Linux
Assigned to:		CPU Architecture:	Any

Description:
Doing a 

  START BACKUP 3 WAIT STARTED;

if a backup with id 3 had already been done earlier produces an error message that a backup directory with that ID already exists and can't be overwritten, but the "WAIT STARTED" part continues to wait for a backup that can't start due to the duplicate ID

How to repeat:
Do 

  START BACKUP 3 WAIT STARTED;
  START BACKUP 3 WAIT STARTED;

2nd one will hang forever after printing an error message about the duplicate backup ID

Suggested fix:
Abort WAIT STARTED wait on backup startup errors

Hello Hartmut,

Thank you for the report.
Verified as described on reported and later version.

Thanks,
Umesh

## 7.2.12

ndb_mgm> START BACKUP 1;
Waiting for completed, this may take several minutes
Node 2: Backup 1 started from node 1
Node 2: Backup 1 started from node 1 completed
 StartGCP: 522 StopGCP: 525
 #Records: 2059 #LogRecords: 0
 Data: 52164 bytes Log: 0 bytes
ndb_mgm> 
ndb_mgm> 
ndb_mgm> START BACKUP 1;
Waiting for completed, this may take several minutes
Node 2: Backup 1 started from 1 has been aborted. Error: 1350
Backup failed
*  3001: Could not start backup
*        Backup failed: file already exists (use 'START BACKUP <backup id>'): Temporary error: Temporary Resource error
ndb_mgm> 
ndb_mgm> START BACKUP 1 WAIT STARTED;
Waiting for started, this may take several minutes
Node 2: Backup 1 started from 1 has been aborted. Error: 1350

## 
[root@ushastry mysql-cluster-7.2.12]# bin/perror --ndb 1350
NDB error code 1350: Backup failed: file already exists (use 'START BACKUP <backup id>'): Temporary error: Temporary Resource error
MySQL error code 1350 (ER_VIEW_SELECT_CLAUSE): View's SELECT contains a '%s' clause

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.

Fixed in NDB 7.0+. Documented as follows in the NDB 7.0.39, 7.1.28, 7.2.14, and 7.3.3 changelogs:

        After issuing START BACKUP id WAIT STARTED, if id had already
        been used for a backup ID, an error caused by the duplicate ID
        occurred as expected, but following this, the START BACKUP
        command never completed.

Closed.