Bug #18593 Backup started from 1 has been aborted. Error: 723
Submitted: 28 Mar 2006 23:15 Modified: 23 May 2006 22:11
Reporter: Jonathan Miller Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version:5.1.9 OS:Linux (Linux 32 Bit OS)
Assigned to: Jonathan Miller CPU Architecture:Any

[28 Mar 2006 23:15] Jonathan Miller
Description:
In trying to recover my Cluster Slave, I had copied over the latest backup (#50) to the slave and tried to restore. When atempting the restore I recieved:

[ndbdev@ndb10 BACKUP-50]$ ndb_restore -c $ndbc -n 2 -b 50 -m -e -r ./
Nodeid = 2
Backup Id = 50
backup path = ./
Ndb version in backup files: Version 5.1.9
Unsupported table type!! 0
Restore: Failed to load content

NDBT_ProgramExit: 1 - Failed

Yet, trying an older backup (#48) it started to restore then cored. I will open a different bug for the core.

 BACKUP-48]$ ndb_restore -c $ndbc -n 2 -b 48 -m -e -r ./
Nodeid = 2
Backup Id = 48
backup path = ./
Ndb version in backup files: Version 5.1.9
Connected to ndb!!
Creating logfile group: lg1...done
Creating tablespace: TESTER2_TS...done
Creating tablespace: TPCB_TS...done
Creating tablespace: BANK_TS...done
Creating datafile "./BANK_DF/datafile02.dat"...done
Creating datafile "./tpcb_ts/datafile.dat"...done
Creating datafile "./BANK_DF/datafile.dat"...done
Creating undofile "./lg1/undofile.dat"...done
Creating undofile "./lg1/undofile2.dat"...done
Creating datafile "./tester2_ts/datafile.dat"...done
Creating undofile "./lg1/undofile3.dat"...done
Successfully restored table BANK2/def/SYSTEM_VALUES
Successfully restored table event REPL$BANK2/SYSTEM_VALUES
Successfully restored table BANK2/def/ACCOUNT
Successfully restored table event REPL$BANK2/ACCOUNT
Successfully restored table hlr/def/matable
Successfully restored table event REPL$hlr/matable
Successfully restored table BANK/def/GL
Successfully restored table event REPL$BANK/GL
Successfully restored table TPCB/def/teller
Successfully restored table event REPL$TPCB/teller
Successfully restored table TPCB/def/branch
Successfully restored table event REPL$TPCB/branch
Successfully restored table TPCB/def/history
Successfully restored table event REPL$TPCB/history
Successfully restored table BANK/def/SYSTEM_VALUES
Successfully restored table event REPL$BANK/SYSTEM_VALUES
Successfully restored table TPCB/def/trans
Successfully restored table event REPL$TPCB/trans
Successfully restored table BANK/def/TRANSACTION
Successfully restored table event REPL$BANK/TRANSACTION
Successfully restored table BANK2/def/ACCOUNT_TYPES
Successfully restored table event REPL$BANK2/ACCOUNT_TYPES
Successfully restored table TPCB/def/account
Successfully restored table event REPL$TPCB/account
Successfully restored table BANK2/def/GL
Successfully restored table event REPL$BANK2/GL
Successfully restored table TESTER2/def/t1
Successfully restored table event REPL$TESTER2/t1
Successfully restored table BANK/def/ACCOUNT
Successfully restored table event REPL$BANK/ACCOUNT
Successfully restored table BANK/def/ACCOUNT_TYPES
Successfully restored table event REPL$BANK/ACCOUNT_TYPES
Successfully restored table BANK2/def/TRANSACTION
Successfully restored table event REPL$BANK2/TRANSACTION
Successfully created index PRIMARY on trans
Successfully created index PRIMARY on branch
Successfully created index PRIMARY on history
Successfully created index PRIMARY on account
Successfully created index PRIMARY on teller
_____________________________________________________
Processing data in table: BANK2/def/SYSTEM_VALUES(24) fragment 0
_____________________________________________________
Processing data in table: BANK2/def/ACCOUNT(22) fragment 0
_____________________________________________________
Processing data in table: cluster/def/NDB$BLOB_2_3(3) fragment 0
_____________________________________________________
Processing data in table: hlr/def/matable(34) fragment 0
_____________________________________________________
Processing data in table: BANK/def/GL(29) fragment 0
_____________________________________________________
Processing data in table: TPCB/def/teller(15) fragment 0
_____________________________________________________
Processing data in table: TPCB/def/branch(13) fragment 0
_____________________________________________________
Processing data in table: TPCB/def/history(17) fragment 0
_____________________________________________________
Processing data in table: sys/def/NDB$EVENTS_0(1) fragment 0
_____________________________________________________
Processing data in table: BANK/def/SYSTEM_VALUES(32) fragment 0
_____________________________________________________
Processing data in table: TPCB/def/trans(19) fragment 0
_____________________________________________________
Processing data in table: BANK/def/TRANSACTION(31) fragment 0
_____________________________________________________
Processing data in table: BANK2/def/ACCOUNT_TYPES(25) fragment 0
_____________________________________________________
Processing data in table: TPCB/def/account(11) fragment 0
_____________________________________________________
Processing data in table: cluster/def/schema(2) fragment 0
_____________________________________________________
Processing data in table: BANK2/def/GL(21) fragment 0
_____________________________________________________
Processing data in table: cluster/def/apply_status(4) fragment 0
_____________________________________________________
Processing data in table: TESTER2/def/t1(37) fragment 0
_____________________________________________________
Processing data in table: BANK/def/ACCOUNT(30) fragment 0
_____________________________________________________
Processing data in table: BANK/def/ACCOUNT_TYPES(33) fragment 0
_____________________________________________________
Processing data in table: sys/def/SYSTAB_0(0) fragment 0
_____________________________________________________
Processing data in table: BANK2/def/TRANSACTION(23) fragment 0
Aborted (core dumped)

How to repeat:
Setup a 2 data node cluster with 2 replicas and try to restore the backup for #50
[28 Mar 2006 23:22] Jonathan Miller
2006-03-29 01:01:48 [MgmSrvr] ALERT    -- Node 2: Backup 51 started from 1 has been aborted. Error: 723
2006-03-29 01:01:49 [MgmSrvr] ALERT    -- Node 4: Backup 51 started from 1 has been aborted. Error: 723
2006-03-29 01:01:49 [MgmSrvr] ALERT    -- Node 5: Backup 51 started from 1 has been aborted. Error: 723
2006-03-29 01:01:49 [MgmSrvr] ALERT    -- Node 3: Backup 51 started from 1 has been aborted. Error: 723
2006-03-29 01:02:12 [MgmSrvr] INFO     -- Node 2: Local checkpoint 439 started. Keep GCI = 9135 oldest restorable GCI = 9140
2006-03-29 01:02:17 [MgmSrvr] INFO     -- Mgmt server state: nodeid 6 reserved for ip 10.100.1.92
[28 Mar 2006 23:23] Jonathan Miller
2006-03-29 01:05:09 [MgmSrvr] INFO     -- Mgmt server state: nodeid 6 freed, m_reserved_nodes 0000000000000002.
2006-03-29 01:05:11 [MgmSrvr] ALERT    -- Node 2: Backup 52 started from 1 has been aborted. Error: 723
2006-03-29 01:05:11 [MgmSrvr] ALERT    -- Node 4: Backup 52 started from 1 has been aborted. Error: 723
2006-03-29 01:05:11 [MgmSrvr] ALERT    -- Node 5: Backup 52 started from 1 has been aborted. Error: 723
2006-03-29 01:05:11 [MgmSrvr] ALERT    -- Node 3: Backup 52 started from 1 has been aborted. Error: 723
[23 Apr 2006 6:37] Jonas Oreland
Wo/ more info we will never fix this.
(or reproducable testcase)
I have never seen this before.
It could be some DDL in parallell with backup...but that we test...
[19 May 2006 21:23] Jonathan Miller
If I hit this again I will reopen.