MySQL Bugs: #11675: Invalid backup log when running with #nodes != 2^x

Bug #11675	Invalid backup log when running with #nodes != 2^x
Submitted:	30 Jun 2005 18:43	Modified:	1 Aug 2005 15:40
Reporter:	Jonathan Miller	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S1 (Critical)
Version:	5.0, 5.1.0-wl2325-wl1354-new	OS:	Linux (Linux)
Assigned to:	Jonas Oreland	CPU Architecture:	Any

Description:
I have verified this one at least three times now. I will save of all files under ndb08:/space/bug#### where #### = this bug report.

The testing basically consisted of what the bank test does, except I was using 4 computers. 2 for the master and 2 for the slave. After letting the slave catchup, I would dump and compare both. The compare always came out the some with the dump files not matching.

How to repeat:
I will list out three attemps. 

Attempt #1
Master 
NDB08:
ndbdev@ndb08:~/jmiller/builds/run> ndb_mgmd -f config.ini 
Cluster configuration warning:
  arbitrator with id 1 and db node with id 2 on same host ndb08
  Running arbitrator on the same host as a database node may
  cause complete cluster shutdown in case of host failure.
ndbdev@ndb08:~/jmiller/builds/run> ndbd -c $ndbc --initial
ndbdev@ndb08:~/jmiller/builds/run> ndbd -c $ndbc --initial
NDB09:
[ndbdev@ndb09 run]$ ndbd -c $ndbc --initial
[ndbdev@ndb09 run]$ ndbd -c $ndbc --initial

NDB08
ndbdev@ndb08:~/jmiller/builds/run> mysql_server start
Starting MySQL.                                            [  OK  ]
ndbdev@ndb08:~/jmiller/builds/run> mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 449 to server version: 5.1.0-a_drop5p3-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> source /home/ndbdev/jmiller/setupFiles/BANK.SQL
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.12 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Database changed
Query OK, 0 rows affected (1.50 sec)

Query OK, 0 rows affected (0.30 sec)

Query OK, 0 rows affected (0.29 sec)

Query OK, 0 rows affected (2.54 sec)

Query OK, 0 rows affected (0.29 sec)
mysql> source /home/ndbdev/jmiller/setupFiles/grant.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> exit
ndbdev@ndb08:~/jmiller/builds/run> NDB_CONNECTSTRING=ndb08:14000
../bin/bankCreator -d BANK > BC.out
ndbdev@ndb08:~/jmiller/builds/run>  NDB_CONNECTSTRING=ndb08:14000
../bin/bankTimer -w 5  > BTimer.out &
[1] 14244
ndbdev@ndb08:~/jmiller/builds/run>  NDB_CONNECTSTRING=ndb08:14000
../bin/bankMakeGL  > BGL.out &
[2] 14252
ndbdev@ndb08:~/jmiller/builds/run> NDB_CONNECTSTRING=ndb08:14000
../bin/bankTransactionMaker  > Btrans.out &
[3] 14260

NDB10:
[ndbdev@ndb10 run]$ ndb_mgmd -f config.ini Cluster configuration warning:
  arbitrator with id 1 and db node with id 2 on same host ndb10
  Running arbitrator on the same host as a database node may
  cause complete cluster shutdown in case of host failure.
[ndbdev@ndb10 run]$ ndbd -c $ndbc --initial [ndbdev@ndb10 run]$ ndbd -c $ndbc
--initial

NDB11:
[ndbdev@ndb11 run]$ ndbd -c $ndbc --initial
[ndbdev@ndb11 run]$ ndbd -c $ndbc --initial

NDB08:
ndbdev@ndb08:~/jmiller/builds/run> ndb_mgm $ndbc -e "start backup"
Connected to Management Server at: ndb08:14000
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: 385 StopGCP: 388
 #Records: 5382 #LogRecords: 5100
 Data: 119096 bytes Log: 256240 bytes
ndbdev@ndb08:~/jmiller/builds/run> scp -r BACKUP/
ndb10:/home/ndbdev/jmiller/builds/run/
BACKUP-1.2.ctl       100% |*****************************|  8360       00:00
BACKUP-1.2.log       100% |*****************************|   129 KB    00:00
BACKUP-1-0.2.Data    100% |*****************************| 30560       00:00
BACKUP-1.4.ctl       100% |*****************************|  8360       00:00
BACKUP-1-0.4.Data    100% |*****************************| 31440       00:00
BACKUP-1.4.log       100% |*****************************|    44       00:00

NDB09:
[ndbdev@ndb09 run]$ scp -r BACKUP/ ndb10:/home/ndbdev/jmiller/builds/run/
BACKUP-1.5.log       100% |*****************************|   120 KB    00:00
BACKUP-1.5.ctl       100% |*****************************|  8360       00:00
BACKUP-1.3.ctl       100% |*****************************|  8360       00:00
BACKUP-1.3.log       100% |*****************************|    44       00:00
BACKUP-1-0.3.Data    100% |*****************************| 28572       00:00
BACKUP-1-0.5.Data    100% |*****************************| 29692       00:00

NDB10:
[ndbdev@ndb10 run]$ ndb_restore -c $ndbc -n 2 -e -m -b 1 -r ./BACKUP/BACKUP-1/
Ndb version in backup files: Version 5.1.0
Connected to ndb!!
Successfully restored table BANK/def/ACCOUNT_TYPE
Successfully restored table BANK/def/ACCOUNT_TYPES
Successfully restored table BANK/def/SYSTEM_VALUES
Successfully restored table BANK/def/TRANSACTION
Successfully restored table BANK/def/ACCOUNT
Successfully restored table BANK/def/GL
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPE(8) fragment 0
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPES(7) fragment 0
_____________________________________________________
Restoring data in table: BANK/def/SYSTEM_VALUES(6) fragment 0
_____________________________________________________
Restoring data in table: BANK/def/TRANSACTION(5) fragment 0
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT(4) fragment 0
_____________________________________________________
Restoring data in table: BANK/def/GL(3) fragment 0
_____________________________________________________
Restoring data in table: cluster_replication/def/apply_status(2) fragment 0
_____________________________________________________
Restoring data in table: sys/def/NDB$EVENTS_0(1) fragment 0
_____________________________________________________
Restoring data in table: sys/def/SYSTAB_0(0) fragment 0
Restored 310 tuples and 2392 log entries
[ndbdev@ndb10 run]$ ndb_restore -c $ndbc -n 3 -e  -b 1 -r ./BACKUP/BACKUP-1/
Ndb version in backup files: Version 5.1.0
Connected to ndb!!
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPE(8) fragment 2
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPES(7) fragment 2
_____________________________________________________
Restoring data in table: BANK/def/SYSTEM_VALUES(6) fragment 2
_____________________________________________________
Restoring data in table: BANK/def/TRANSACTION(5) fragment 2
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT(4) fragment 2
_____________________________________________________
Restoring data in table: BANK/def/GL(3) fragment 2
_____________________________________________________
Restoring data in table: cluster_replication/def/apply_status(2) fragment 2
_____________________________________________________
Restoring data in table: sys/def/NDB$EVENTS_0(1) fragment 2
_____________________________________________________
Restoring data in table: sys/def/SYSTAB_0(0) fragment 2
Restored 284 tuples and 0 log entries
[ndbdev@ndb10 run]$ ndb_restore -c $ndbc -n 4 -e  -b 1 -r ./BACKUP/BACKUP-1/
Ndb version in backup files: Version 5.1.0
Connected to ndb!!
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPE(8) fragment 1
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPES(7) fragment 1
_____________________________________________________
Restoring data in table: BANK/def/SYSTEM_VALUES(6) fragment 1
_____________________________________________________
Restoring data in table: BANK/def/TRANSACTION(5) fragment 1
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT(4) fragment 1
_____________________________________________________
Restoring data in table: BANK/def/GL(3) fragment 1
_____________________________________________________
Restoring data in table: cluster_replication/def/apply_status(2) fragment 1
_____________________________________________________
Restoring data in table: sys/def/NDB$EVENTS_0(1) fragment 1
_____________________________________________________
Restoring data in table: sys/def/SYSTAB_0(0) fragment 1
Restored 340 tuples and 0 log entries
[ndbdev@ndb10 run]$ ndb_restore -c $ndbc -n 5 -e  -b 1 -r ./BACKUP/BACKUP-1/
Ndb version in backup files: Version 5.1.0
Connected to ndb!!
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPE(8) fragment 3
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPES(7) fragment 3
_____________________________________________________
Restoring data in table: BANK/def/SYSTEM_VALUES(6) fragment 3
_____________________________________________________
Restoring data in table: BANK/def/TRANSACTION(5) fragment 3
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT(4) fragment 3
_____________________________________________________
Restoring data in table: BANK/def/GL(3) fragment 3
_____________________________________________________
Restoring data in table: cluster_replication/def/apply_status(2) fragment 3
_____________________________________________________
Restoring data in table: sys/def/NDB$EVENTS_0(1) fragment 3
_____________________________________________________
Restoring data in table: sys/def/SYSTAB_0(0) fragment 3
Restored 344 tuples and 2088 log entries

[ndbdev@ndb10 run]$ mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.1.0-a_drop5p3

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database BANK;
Query OK, 1 row affected (0.00 sec)

mysql> use BANK
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables
    -> ;
+----------------+
| Tables_in_BANK |
+----------------+
| ACCOUNT        |
| ACCOUNT_TYPES  |
| GL             |
| SYSTEM_VALUES  |
| TRANSACTION    |
+----------------+
5 rows in set (0.02 sec)

mysql> exit
[ndbdev@ndb10 run]$ perl ../../resetslave.pl ndb08 3307 root BLANK NDB10 3306
root BLANK
        Slave Epoch =  387
        Master bin log =  master1.000003
        Master Bin Log position =  7906594
        Slave has been updated. You may now start slave.

Wait 5 minutes.

NDB08:
ndbdev@ndb08:~/jmiller/builds/run> kill -9 14260
[3]+  Killed                  NDB_CONNECTSTRING=ndb08:14000
../bin/bankTransactionMaker >Btrans.out
ndbdev@ndb08:~/jmiller/builds/run> kill -9 14252
[2]+  Killed                  NDB_CONNECTSTRING=ndb08:14000 ../bin/bankMakeGL
>BGL.out
ndbdev@ndb08:~/jmiller/builds/run> kill -9 14244
[1]+  Killed                  NDB_CONNECTSTRING=ndb08:14000 ../bin/bankTimer -w
5 >BTimer.out

NDB10:
[ndbdev@ndb10 run]$ mysql -u root Welcome to the MySQL monitor.  Commands end
with ; or \g.
Your MySQL connection id is 3 to server version: 5.1.0-a_drop5p3

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> start slave;
Query OK, 0 rows affected (0.00 sec)
mysql> show slave status\G;
*************************** 1. row ***************************
             Slave_IO_State: Waiting for master to send event
                Master_Host: ndb08
                Master_User: rep
                Master_Port: 3307
              Connect_Retry: 1
            Master_Log_File: master1.000003
        Read_Master_Log_Pos: 22052219
             Relay_Log_File: ndb10-relay-bin.000002
              Relay_Log_Pos: 5545035
      Relay_Master_Log_File: master1.000003
           Slave_IO_Running: Yes
          Slave_SQL_Running: Yes
            Replicate_Do_DB:
        Replicate_Ignore_DB:
         Replicate_Do_Table:
     Replicate_Ignore_Table:
    Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
                 Last_Errno: 0
                 Last_Error:
               Skip_Counter: 0
        Exec_Master_Log_Pos: 13451388
            Relay_Log_Space: 14145866
            Until_Condition: None
             Until_Log_File:
              Until_Log_Pos: 0
         Master_SSL_Allowed: No
         Master_SSL_CA_File:
         Master_SSL_CA_Path:
            Master_SSL_Cert:
          Master_SSL_Cipher:
             Master_SSL_Key:
      Seconds_Behind_Master: 408
1 row in set (0.00 sec)

ERROR:
No query specified
.............................
.......................
................
..........
......
mysql> show slave status\G;
*************************** 1. row ***************************
             Slave_IO_State: Waiting for master to send event
                Master_Host: ndb08
                Master_User: rep
                Master_Port: 3307
              Connect_Retry: 1
            Master_Log_File: master1.000003
        Read_Master_Log_Pos: 22052219
             Relay_Log_File: ndb10-relay-bin.000002
              Relay_Log_Pos: 14145866
      Relay_Master_Log_File: master1.000003
           Slave_IO_Running: Yes
          Slave_SQL_Running: Yes
            Replicate_Do_DB:
        Replicate_Ignore_DB:
         Replicate_Do_Table:
     Replicate_Ignore_Table:
    Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
                 Last_Errno: 0
                 Last_Error:
               Skip_Counter: 0
        Exec_Master_Log_Pos: 22052219
            Relay_Log_Space: 14145866
            Until_Condition: None
             Until_Log_File:
              Until_Log_Pos: 0
         Master_SSL_Allowed: No
         Master_SSL_CA_File:
         Master_SSL_CA_Path:
            Master_SSL_Cert:
          Master_SSL_Cipher:
             Master_SSL_Key:
      Seconds_Behind_Master: 0
1 row in set (0.00 sec)

ERROR:
No query specified

mysql> exit
[ndbdev@ndb10 run]$  mysqldump --compact --order-by-primary
--skip-extended-insert --no-create-info -u root BANK > slave_BANK.sql
[ndbdev@ndb10 run]$  scp slave_BANK.sql ndb08:/home/ndbdev/jmiller/builds/run/
slave_BANK.sql       100% |*****************************|   158 KB    00:00

NDB08:
ndbdev@ndb08:~/jmiller/builds/run> mysqldump --compact --order-by-primary
--skip-extended-insert --no-create-info -u root BANK > master_BANK.sql
ndbdev@ndb08:~/jmiller/builds/run> diff master_BANK.sql slave_BANK.sql
706c706
< INSERT INTO `GL` VALUES (139,0,9283056,14,59731,11,53488,1);
---
> INSERT INTO `GL` VALUES (139,0,9283056,14,59731,11,53488,0);
710,711c710,711
< INSERT INTO `GL` VALUES (139,4,133959,29,142022,21,85487,1);
< INSERT INTO `GL` VALUES (140,0,9283056,0,0,0,0,1);
---
> INSERT INTO `GL` VALUES (139,4,133959,29,142022,21,85487,0);
> INSERT INTO `GL` VALUES (140,0,9283056,0,0,0,0,0);
713,715c713,715
< INSERT INTO `GL` VALUES (140,2,161882,1,4695,0,0,1);
< INSERT INTO `GL` VALUES (140,3,400172,0,0,1,4695,1);
< INSERT INTO `GL` VALUES (140,4,133959,0,0,0,0,1);
---
> INSERT INTO `GL` VALUES (140,2,161882,1,4695,0,0,0);
> INSERT INTO `GL` VALUES (140,3,400172,0,0,1,4695,0);
> INSERT INTO `GL` VALUES (140,4,133959,0,0,0,0,0);
717,721c717,720
< INSERT INTO `GL` VALUES (141,1,130752,35,161771,32,141950,1);
< INSERT INTO `GL` VALUES (141,2,152400,28,114077,32,123559,1);
< INSERT INTO `GL` VALUES (141,3,449996,30,156617,23,106793,1);
< INSERT INTO `GL` VALUES (141,4,69716,15,65898,22,130141,1);
< INSERT INTO `GL` VALUES (142,0,9267737,6,36393,10,55792,1);
---
> INSERT INTO `GL` VALUES (141,1,130752,35,161771,32,141950,0);
> INSERT INTO `GL` VALUES (141,2,152400,28,114077,32,123559,0);
> INSERT INTO `GL` VALUES (141,3,449996,30,156617,23,106793,0);
> INSERT INTO `GL` VALUES (141,4,69716,15,65898,22,130141,0);
724d722
< INSERT INTO `GL` VALUES (142,3,462656,15,80279,16,67619,1);
727d724
< INSERT INTO `GL` VALUES (143,1,123808,40,164538,40,179128,1);
729,731d725
< INSERT INTO `GL` VALUES (143,3,457043,31,134773,24,140386,1);
< INSERT INTO `GL` VALUES (143,4,147443,27,136577,19,76351,1);
< INSERT INTO `GL` VALUES (144,0,9185365,21,94744,26,132100,1);
733,735d726
< INSERT INTO `GL` VALUES (144,2,127206,54,237926,55,249705,1);
< INSERT INTO `GL` VALUES (144,3,462332,60,324697,61,319408,1);
< INSERT INTO `GL` VALUES (144,4,140451,51,235034,56,242026,1);
1967a1959,2285
> INSERT INTO `TRANSACTION` VALUES (17746,4,4,0,3000,139,3012);
> INSERT INTO `TRANSACTION` VALUES (17749,3,3,2,3000,139,9603);
> INSERT INTO `TRANSACTION` VALUES (17752,9,4,5,3000,139,2154);
> INSERT INTO `TRANSACTION` VALUES (17753,9,4,6,2000,139,8571);
> INSERT INTO `TRANSACTION` VALUES (17756,9,4,1,2000,139,4888);
> INSERT INTO `TRANSACTION` VALUES (17757,0,0,1,2000,139,3568);
> INSERT INTO `TRANSACTION` VALUES (17759,3,3,8,2000,139,7696);
> INSERT INTO `TRANSACTION` VALUES (17760,4,4,1,2000,139,1811);
> INSERT INTO `TRANSACTION` VALUES (17761,4,4,6,3000,139,6780);
> INSERT INTO `TRANSACTION` VALUES (17762,3,3,6,2000,139,4898);
> INSERT INTO `TRANSACTION` VALUES (17768,3,3,7,2000,139,6203);
> INSERT INTO `TRANSACTION` VALUES (17769,0,0,3,2000,139,7954);
> INSERT INTO `TRANSACTION` VALUES (17770,3,3,6,2000,139,8413);
> INSERT INTO `TRANSACTION` VALUES (17771,3,3,8,2000,139,4506);
> INSERT INTO `TRANSACTION` VALUES (17772,0,0,1,3000,139,3245);
> INSERT INTO `TRANSACTION` VALUES (17773,3,3,1,2000,139,1985);
> INSERT INTO `TRANSACTION` VALUES (17774,8,3,9,2000,139,9724);
> INSERT INTO `TRANSACTION` VALUES (17775,7,2,8,2000,139,4878);
> INSERT INTO `TRANSACTION` VALUES (17775,8,3,7,3000,139,4878);
> INSERT INTO `TRANSACTION` VALUES (17776,4,4,3,3000,139,6150);
> INSERT INTO `TRANSACTION` VALUES (17779,7,2,6,2000,139,7940);
> INSERT INTO `TRANSACTION` VALUES (17782,2,2,5,3000,139,8795);
> INSERT INTO `TRANSACTION` VALUES (17783,7,2,6,3000,139,3175);
> INSERT INTO `TRANSACTION` VALUES (17784,8,3,7,3000,139,8824);
> INSERT INTO `TRANSACTION` VALUES (17785,2,2,0,3000,139,8526);
> INSERT INTO `TRANSACTION` VALUES (17786,0,0,7,2000,139,975);
> INSERT INTO `TRANSACTION` VALUES (17786,7,2,0,3000,139,975);
> INSERT INTO `TRANSACTION` VALUES (17788,7,2,0,2000,139,9094);
> INSERT INTO `TRANSACTION` VALUES (17791,9,4,6,3000,139,2349);
> INSERT INTO `TRANSACTION` VALUES (17792,3,3,5,2000,139,3717);
> INSERT INTO `TRANSACTION` VALUES (17794,0,0,5,3000,139,1837);
> INSERT INTO `TRANSACTION` VALUES (17796,3,3,9,2000,139,344);
> INSERT INTO `TRANSACTION` VALUES (17796,9,4,3,3000,139,344);
> INSERT INTO `TRANSACTION` VALUES (17797,2,2,1,3000,139,6333);
> INSERT INTO `TRANSACTION` VALUES (17799,3,3,4,2000,139,4883);
> INSERT INTO `TRANSACTION` VALUES (17799,4,4,3,3000,139,4883);
> INSERT INTO `TRANSACTION` VALUES (17800,4,4,1,2000,139,7313);
> INSERT INTO `TRANSACTION` VALUES (17801,7,2,5,2000,139,7631);
> INSERT INTO `TRANSACTION` VALUES (17803,8,3,0,2000,139,3587);
> INSERT INTO `TRANSACTION` VALUES (17804,9,4,8,3000,139,8994);
> INSERT INTO `TRANSACTION` VALUES (17805,0,0,5,2000,139,5147);
> INSERT INTO `TRANSACTION` VALUES (17806,8,3,9,2000,139,6649);
> INSERT INTO `TRANSACTION` VALUES (17806,9,4,8,3000,139,6649);
> INSERT INTO `TRANSACTION` VALUES (17807,8,3,6,2000,139,5646);
> INSERT INTO `TRANSACTION` VALUES (17808,9,4,5,2000,139,2879);
> INSERT INTO `TRANSACTION` VALUES (17809,7,2,1,2000,139,5276);
> INSERT INTO `TRANSACTION` VALUES (17811,9,4,6,3000,139,5999);
> INSERT INTO `TRANSACTION` VALUES (17812,3,3,9,2000,139,1562);
> INSERT INTO `TRANSACTION` VALUES (17815,9,4,5,3000,139,305);
> INSERT INTO `TRANSACTION` VALUES (17817,2,2,1,2000,139,1158);
> INSERT INTO `TRANSACTION` VALUES (17818,9,4,8,3000,139,7393);
> INSERT INTO `TRANSACTION` VALUES (17819,3,3,5,3000,139,4846);
> INSERT INTO `TRANSACTION` VALUES (17820,0,0,5,3000,139,6594);
> INSERT INTO `TRANSACTION` VALUES (17821,7,2,2,2000,139,9925);
> INSERT INTO `TRANSACTION` VALUES (17822,9,4,1,3000,139,7227);
> INSERT INTO `TRANSACTION` VALUES (17823,4,4,2,2000,139,2865);
> INSERT INTO `TRANSACTION` VALUES (17825,0,0,4,3000,139,2610);
> INSERT INTO `TRANSACTION` VALUES (17825,4,4,0,2000,139,2610);
> INSERT INTO `TRANSACTION` VALUES (17826,2,2,1,2000,139,3319);
> INSERT INTO `TRANSACTION` VALUES (17828,4,4,5,2000,139,2304);
> INSERT INTO `TRANSACTION` VALUES (17829,2,2,8,3000,139,4089);
> INSERT INTO `TRANSACTION` VALUES (17830,4,4,3,2000,139,4888);
> INSERT INTO `TRANSACTION` VALUES (17831,0,0,9,3000,139,4272);
> INSERT INTO `TRANSACTION` VALUES (17833,9,4,6,2000,139,7987);
> INSERT INTO `TRANSACTION` VALUES (17835,2,2,3,2000,139,2211);
> INSERT INTO `TRANSACTION` VALUES (17835,3,3,2,3000,139,2211);
> INSERT INTO `TRANSACTION` VALUES (17837,0,0,1,3000,139,8956);
> INSERT INTO `TRANSACTION` VALUES (17839,9,4,0,2000,139,149);
> INSERT INTO `TRANSACTION` VALUES (17841,2,2,8,3000,139,9838);
> INSERT INTO `TRANSACTION` VALUES (17841,8,3,2,2000,139,9838);
> INSERT INTO `TRANSACTION` VALUES (17842,9,4,8,3000,139,2739);
> INSERT INTO `TRANSACTION` VALUES (17843,9,4,5,2000,139,3985);
> INSERT INTO `TRANSACTION` VALUES (17846,8,3,1,3000,139,4529);
> INSERT INTO `TRANSACTION` VALUES (17847,8,3,1,2000,139,4049);
> INSERT INTO `TRANSACTION` VALUES (17849,8,3,9,2000,139,9813);
> INSERT INTO `TRANSACTION` VALUES (17849,9,4,8,3000,139,9813);
> INSERT INTO `TRANSACTION` VALUES (17850,3,3,7,3000,139,8129);
> INSERT INTO `TRANSACTION` VALUES (17851,8,3,2,2000,139,2513);
> INSERT INTO `TRANSACTION` VALUES (17852,7,2,8,2000,139,5741);
> INSERT INTO `TRANSACTION` VALUES (17852,8,3,7,3000,139,5741);
> INSERT INTO `TRANSACTION` VALUES (17853,3,3,8,3000,139,6737);
> INSERT INTO `TRANSACTION` VALUES (17853,8,3,3,2000,139,6737);
> INSERT INTO `TRANSACTION` VALUES (17854,3,3,4,2000,139,805);
> INSERT INTO `TRANSACTION` VALUES (17855,4,4,2,2000,139,6330);
> INSERT INTO `TRANSACTION` VALUES (17857,3,3,8,2000,139,2943);
> INSERT INTO `TRANSACTION` VALUES (17857,8,3,3,3000,139,2943);
> INSERT INTO `TRANSACTION` VALUES (17859,7,2,6,3000,139,8088);
> INSERT INTO `TRANSACTION` VALUES (17861,7,2,9,3000,139,6970);
> INSERT INTO `TRANSACTION` VALUES (17862,2,2,5,3000,139,9826);
> INSERT INTO `TRANSACTION` VALUES (17864,3,3,5,2000,139,7447);
> INSERT INTO `TRANSACTION` VALUES (17865,3,3,7,2000,139,1885);
> INSERT INTO `TRANSACTION` VALUES (17866,2,2,1,3000,139,4513);
> INSERT INTO `TRANSACTION` VALUES (17870,3,3,0,3000,139,6365);
> INSERT INTO `TRANSACTION` VALUES (17873,2,2,5,2000,139,3942);
> INSERT INTO `TRANSACTION` VALUES (17874,4,4,1,2000,139,4091);
> INSERT INTO `TRANSACTION` VALUES (17875,8,3,7,3000,139,9801);
> INSERT INTO `TRANSACTION` VALUES (17876,3,3,5,3000,139,5319);
> INSERT INTO `TRANSACTION` VALUES (17879,0,0,9,2000,139,1720);
> INSERT INTO `TRANSACTION` VALUES (17879,9,4,0,3000,139,1720);
> INSERT INTO `TRANSACTION` VALUES (17880,0,0,7,3000,139,457);
> INSERT INTO `TRANSACTION` VALUES (17882,0,0,3,3000,139,7504);
> INSERT INTO `TRANSACTION` VALUES (17883,3,3,7,2000,139,8827);
> INSERT INTO `TRANSACTION` VALUES (17884,3,3,7,2000,140,4695);
> INSERT INTO `TRANSACTION` VALUES (17884,7,2,3,3000,140,4695);
> INSERT INTO `TRANSACTION` VALUES (17886,6,1,7,3000,141,1102);
> INSERT INTO `TRANSACTION` VALUES (17886,7,2,6,2000,141,1102);
> INSERT INTO `TRANSACTION` VALUES (17887,5,1,8,2000,141,139);
> INSERT INTO `TRANSACTION` VALUES (17888,8,3,1,2000,141,5969);
> INSERT INTO `TRANSACTION` VALUES (17890,2,2,4,2000,141,3574);
> INSERT INTO `TRANSACTION` VALUES (17891,3,3,8,2000,141,8083);
> INSERT INTO `TRANSACTION` VALUES (17892,8,3,0,3000,141,7947);
> INSERT INTO `TRANSACTION` VALUES (17893,1,1,5,3000,141,2578);
> INSERT INTO `TRANSACTION` VALUES (17893,5,1,1,2000,141,2578);
> INSERT INTO `TRANSACTION` VALUES (17894,7,2,8,2000,141,779);
> INSERT INTO `TRANSACTION` VALUES (17896,0,0,5,2000,141,6088);
> INSERT INTO `TRANSACTION` VALUES (17896,5,1,0,3000,141,6088);
> INSERT INTO `TRANSACTION` VALUES (17897,7,2,1,3000,141,4814);
> INSERT INTO `TRANSACTION` VALUES (17898,5,1,8,2000,141,8959);
> INSERT INTO `TRANSACTION` VALUES (17899,6,1,1,3000,141,630);
> INSERT INTO `TRANSACTION` VALUES (17900,2,2,7,3000,141,889);
> INSERT INTO `TRANSACTION` VALUES (17900,7,2,2,2000,141,889);
> INSERT INTO `TRANSACTION` VALUES (17901,1,1,7,2000,141,2081);
> INSERT INTO `TRANSACTION` VALUES (17902,6,1,7,3000,141,6502);
> INSERT INTO `TRANSACTION` VALUES (17902,7,2,6,2000,141,6502);
> INSERT INTO `TRANSACTION` VALUES (17903,1,1,8,3000,141,2325);
> INSERT INTO `TRANSACTION` VALUES (17903,8,3,1,2000,141,2325);
> INSERT INTO `TRANSACTION` VALUES (17904,8,3,9,2000,141,3137);
> INSERT INTO `TRANSACTION` VALUES (17906,9,4,3,2000,141,9168);
> INSERT INTO `TRANSACTION` VALUES (17907,9,4,1,2000,141,4119);
> INSERT INTO `TRANSACTION` VALUES (17909,0,0,5,3000,141,7395);
> INSERT INTO `TRANSACTION` VALUES (17910,3,3,7,3000,141,3442);
> INSERT INTO `TRANSACTION` VALUES (17911,3,3,7,2000,141,85);
> INSERT INTO `TRANSACTION` VALUES (17911,7,2,3,3000,141,85);
> INSERT INTO `TRANSACTION` VALUES (17912,7,2,6,2000,141,4161);
> INSERT INTO `TRANSACTION` VALUES (17913,8,3,9,2000,141,2759);
> INSERT INTO `TRANSACTION` VALUES (17913,9,4,8,3000,141,2759);
> INSERT INTO `TRANSACTION` VALUES (17914,1,1,7,3000,141,1086);
> INSERT INTO `TRANSACTION` VALUES (17914,7,2,1,2000,141,1086);
> INSERT INTO `TRANSACTION` VALUES (17915,6,1,7,2000,141,4395);
> INSERT INTO `TRANSACTION` VALUES (17917,8,3,9,3000,141,2444);
> INSERT INTO `TRANSACTION` VALUES (17917,9,4,8,2000,141,2444);
> INSERT INTO `TRANSACTION` VALUES (17918,4,4,1,2000,141,8933);
> INSERT INTO `TRANSACTION` VALUES (17919,8,3,1,2000,141,3602);
> INSERT INTO `TRANSACTION` VALUES (17920,3,3,5,2000,141,5597);
> INSERT INTO `TRANSACTION` VALUES (17920,5,1,3,3000,141,5597);
> INSERT INTO `TRANSACTION` VALUES (17922,4,4,8,2000,141,7771);
> INSERT INTO `TRANSACTION` VALUES (17922,8,3,4,3000,141,7771);
> INSERT INTO `TRANSACTION` VALUES (17923,9,4,8,3000,141,1829);
> INSERT INTO `TRANSACTION` VALUES (17924,7,2,1,3000,141,431);
> INSERT INTO `TRANSACTION` VALUES (17926,9,4,6,2000,141,9794);
> INSERT INTO `TRANSACTION` VALUES (17927,7,2,5,3000,141,8046);
> INSERT INTO `TRANSACTION` VALUES (17928,7,2,2,2000,141,2871);
> INSERT INTO `TRANSACTION` VALUES (17929,3,3,9,3000,141,2982);
> INSERT INTO `TRANSACTION` VALUES (17930,7,2,8,3000,141,5724);
> INSERT INTO `TRANSACTION` VALUES (17930,8,3,7,2000,141,5724);
> INSERT INTO `TRANSACTION` VALUES (17931,1,1,2,2000,141,5049);
> INSERT INTO `TRANSACTION` VALUES (17931,2,2,1,3000,141,5049);
> INSERT INTO `TRANSACTION` VALUES (17932,8,3,9,2000,141,7976);
> INSERT INTO `TRANSACTION` VALUES (17934,3,3,9,3000,141,3036);
> INSERT INTO `TRANSACTION` VALUES (17934,9,4,3,2000,141,3036);
> INSERT INTO `TRANSACTION` VALUES (17936,7,2,6,3000,141,7956);
> INSERT INTO `TRANSACTION` VALUES (17937,8,3,0,2000,141,2105);
> INSERT INTO `TRANSACTION` VALUES (17938,2,2,4,2000,141,773);
> INSERT INTO `TRANSACTION` VALUES (17939,2,2,6,3000,141,2940);
> INSERT INTO `TRANSACTION` VALUES (17940,0,0,4,3000,141,9822);
> INSERT INTO `TRANSACTION` VALUES (17940,4,4,0,2000,141,9822);
> INSERT INTO `TRANSACTION` VALUES (17942,3,3,9,3000,141,6104);
> INSERT INTO `TRANSACTION` VALUES (17942,9,4,3,2000,141,6104);
> INSERT INTO `TRANSACTION` VALUES (17943,6,1,8,3000,141,4281);
> INSERT INTO `TRANSACTION` VALUES (17943,8,3,6,2000,141,4281);
> INSERT INTO `TRANSACTION` VALUES (17944,3,3,6,3000,141,1032);
> INSERT INTO `TRANSACTION` VALUES (17944,6,1,3,2000,141,1032);
> INSERT INTO `TRANSACTION` VALUES (17945,4,4,8,2000,141,9130);
> INSERT INTO `TRANSACTION` VALUES (17945,8,3,4,3000,141,9130);
> INSERT INTO `TRANSACTION` VALUES (17947,9,4,6,2000,141,9441);
> INSERT INTO `TRANSACTION` VALUES (17948,4,4,6,2000,141,1381);
> INSERT INTO `TRANSACTION` VALUES (17949,3,3,7,3000,141,3356);
> INSERT INTO `TRANSACTION` VALUES (17949,7,2,3,2000,141,3356);
> INSERT INTO `TRANSACTION` VALUES (17950,1,1,3,3000,141,7787);
> INSERT INTO `TRANSACTION` VALUES (17951,0,0,4,3000,141,8623);
> INSERT INTO `TRANSACTION` VALUES (17952,0,0,2,2000,141,6327);
> INSERT INTO `TRANSACTION` VALUES (17952,2,2,0,3000,141,6327);
> INSERT INTO `TRANSACTION` VALUES (17953,2,2,8,2000,141,8508);
> INSERT INTO `TRANSACTION` VALUES (17953,8,3,2,3000,141,8508);
> INSERT INTO `TRANSACTION` VALUES (17956,5,1,7,2000,141,1697);
> INSERT INTO `TRANSACTION` VALUES (17956,7,2,5,3000,141,1697);
> INSERT INTO `TRANSACTION` VALUES (17957,6,1,5,3000,141,3846);
> INSERT INTO `TRANSACTION` VALUES (17959,6,1,8,3000,141,3365);
> INSERT INTO `TRANSACTION` VALUES (17960,3,3,7,3000,141,1253);
> INSERT INTO `TRANSACTION` VALUES (17960,7,2,3,2000,141,1253);
> INSERT INTO `TRANSACTION` VALUES (17961,4,4,6,2000,141,7508);
> INSERT INTO `TRANSACTION` VALUES (17961,6,1,4,3000,141,7508);
> INSERT INTO `TRANSACTION` VALUES (17963,8,3,0,3000,141,4195);
> INSERT INTO `TRANSACTION` VALUES (17964,5,1,2,2000,141,4677);
> INSERT INTO `TRANSACTION` VALUES (17965,2,2,6,3000,141,784);
> INSERT INTO `TRANSACTION` VALUES (17965,6,1,2,2000,141,784);
> INSERT INTO `TRANSACTION` VALUES (17966,7,2,0,3000,141,9009);
> INSERT INTO `TRANSACTION` VALUES (17968,9,4,7,2000,141,2421);
> INSERT INTO `TRANSACTION` VALUES (17969,1,1,3,3000,141,661);
> INSERT INTO `TRANSACTION` VALUES (17970,4,4,3,2000,141,936);
> INSERT INTO `TRANSACTION` VALUES (17971,1,1,7,2000,141,23);
> INSERT INTO `TRANSACTION` VALUES (17972,4,4,2,3000,141,1767);
> INSERT INTO `TRANSACTION` VALUES (17973,5,1,1,3000,141,4445);
> INSERT INTO `TRANSACTION` VALUES (17974,1,1,8,3000,141,2109);
> INSERT INTO `TRANSACTION` VALUES (17974,8,3,1,2000,141,2109);
> INSERT INTO `TRANSACTION` VALUES (17975,6,1,7,2000,141,6595);
> INSERT INTO `TRANSACTION` VALUES (17975,7,2,6,3000,141,6595);
> INSERT INTO `TRANSACTION` VALUES (17976,4,4,7,3000,141,365);
> INSERT INTO `TRANSACTION` VALUES (17976,7,2,4,2000,141,365);
> INSERT INTO `TRANSACTION` VALUES (17977,0,0,3,2000,141,9731);
> INSERT INTO `TRANSACTION` VALUES (17977,3,3,0,3000,141,9731);
> INSERT INTO `TRANSACTION` VALUES (17978,6,1,5,3000,141,3412);
> INSERT INTO `TRANSACTION` VALUES (17979,3,3,4,2000,141,5294);
> INSERT INTO `TRANSACTION` VALUES (17979,4,4,3,3000,141,5294);
> INSERT INTO `TRANSACTION` VALUES (17980,3,3,8,2000,141,4234);
> INSERT INTO `TRANSACTION` VALUES (17980,8,3,3,3000,141,4234);
> INSERT INTO `TRANSACTION` VALUES (17982,8,3,7,3000,141,7263);
> INSERT INTO `TRANSACTION` VALUES (17983,4,4,1,2000,141,7667);
> INSERT INTO `TRANSACTION` VALUES (17984,2,2,7,2000,141,6672);
> INSERT INTO `TRANSACTION` VALUES (17984,7,2,2,3000,141,6672);
> INSERT INTO `TRANSACTION` VALUES (17985,7,2,9,3000,141,3859);
> INSERT INTO `TRANSACTION` VALUES (17985,9,4,7,2000,141,3859);
> INSERT INTO `TRANSACTION` VALUES (17986,4,4,8,3000,141,9633);
> INSERT INTO `TRANSACTION` VALUES (17988,7,2,5,2000,141,2305);
> INSERT INTO `TRANSACTION` VALUES (17989,5,1,7,3000,141,9138);
> INSERT INTO `TRANSACTION` VALUES (17989,7,2,5,2000,141,9138);
> INSERT INTO `TRANSACTION` VALUES (17990,5,1,4,2000,141,7387);
> INSERT INTO `TRANSACTION` VALUES (17991,2,2,0,2000,141,2019);
> INSERT INTO `TRANSACTION` VALUES (17992,9,4,8,3000,141,8881);
> INSERT INTO `TRANSACTION` VALUES (17993,8,3,2,3000,141,7928);
> INSERT INTO `TRANSACTION` VALUES (17994,1,1,2,3000,141,8529);
> INSERT INTO `TRANSACTION` VALUES (17995,3,3,2,2000,141,6819);
> INSERT INTO `TRANSACTION` VALUES (17996,2,2,7,3000,141,4050);
> INSERT INTO `TRANSACTION` VALUES (17996,7,2,2,2000,141,4050);
> INSERT INTO `TRANSACTION` VALUES (17998,2,2,7,3000,141,293);
> INSERT INTO `TRANSACTION` VALUES (17998,7,2,2,2000,141,293);
> INSERT INTO `TRANSACTION` VALUES (17999,7,2,8,2000,141,8887);
> INSERT INTO `TRANSACTION` VALUES (17999,8,3,7,3000,141,8887);
> INSERT INTO `TRANSACTION` VALUES (18000,6,1,4,2000,141,6853);
> INSERT INTO `TRANSACTION` VALUES (18001,2,2,8,2000,142,39);
> INSERT INTO `TRANSACTION` VALUES (18001,8,3,2,3000,142,39);
> INSERT INTO `TRANSACTION` VALUES (18002,4,4,8,3000,142,713);
> INSERT INTO `TRANSACTION` VALUES (18003,5,1,3,3000,142,5801);
> INSERT INTO `TRANSACTION` VALUES (18004,0,0,9,2000,142,3807);
> INSERT INTO `TRANSACTION` VALUES (18004,9,4,0,3000,142,3807);
> INSERT INTO `TRANSACTION` VALUES (18005,5,1,7,2000,142,4196);
> INSERT INTO `TRANSACTION` VALUES (18005,7,2,5,3000,142,4196);
> INSERT INTO `TRANSACTION` VALUES (18008,3,3,4,2000,142,4193);
> INSERT INTO `TRANSACTION` VALUES (18008,4,4,3,3000,142,4193);
> INSERT INTO `TRANSACTION` VALUES (18009,0,0,8,3000,142,5571);
> INSERT INTO `TRANSACTION` VALUES (18009,8,3,0,2000,142,5571);
> INSERT INTO `TRANSACTION` VALUES (18010,4,4,0,2000,142,4701);
> INSERT INTO `TRANSACTION` VALUES (18011,0,0,1,3000,142,9650);
> INSERT INTO `TRANSACTION` VALUES (18014,0,0,9,3000,142,4626);
> INSERT INTO `TRANSACTION` VALUES (18014,9,4,0,2000,142,4626);
> INSERT INTO `TRANSACTION` VALUES (18015,9,4,5,2000,142,3485);
> INSERT INTO `TRANSACTION` VALUES (18016,5,1,7,2000,142,2087);
> INSERT INTO `TRANSACTION` VALUES (18016,7,2,5,3000,142,2087);
> INSERT INTO `TRANSACTION` VALUES (18017,5,1,7,3000,142,9408);
> INSERT INTO `TRANSACTION` VALUES (18017,7,2,5,2000,142,9408);
> INSERT INTO `TRANSACTION` VALUES (18018,2,2,6,3000,142,945);
> INSERT INTO `TRANSACTION` VALUES (18018,6,1,2,2000,142,945);
> INSERT INTO `TRANSACTION` VALUES (18019,1,1,8,3000,142,4401);
> INSERT INTO `TRANSACTION` VALUES (18019,8,3,1,2000,142,4401);
> INSERT INTO `TRANSACTION` VALUES (18020,1,1,0,3000,142,4176);
> INSERT INTO `TRANSACTION` VALUES (18021,2,2,3,2000,142,7764);
> INSERT INTO `TRANSACTION` VALUES (18022,6,1,7,2000,142,2973);
> INSERT INTO `TRANSACTION` VALUES (18023,2,2,8,3000,142,5879);
> INSERT INTO `TRANSACTION` VALUES (18024,6,1,5,3000,142,1852);
> INSERT INTO `TRANSACTION` VALUES (18025,9,4,6,3000,142,7331);
> INSERT INTO `TRANSACTION` VALUES (18026,3,3,5,3000,142,7385);
> INSERT INTO `TRANSACTION` VALUES (18027,2,2,8,3000,142,2026);
> INSERT INTO `TRANSACTION` VALUES (18027,8,3,2,2000,142,2026);
> INSERT INTO `TRANSACTION` VALUES (18028,3,3,7,2000,142,7484);
> INSERT INTO `TRANSACTION` VALUES (18028,7,2,3,3000,142,7484);
> INSERT INTO `TRANSACTION` VALUES (18029,6,1,0,3000,142,5321);
> INSERT INTO `TRANSACTION` VALUES (18030,3,3,2,3000,142,6199);
> INSERT INTO `TRANSACTION` VALUES (18031,3,3,4,2000,142,5957);
> INSERT INTO `TRANSACTION` VALUES (18032,2,2,8,2000,142,5172);
> INSERT INTO `TRANSACTION` VALUES (18032,8,3,2,3000,142,5172);
> INSERT INTO `TRANSACTION` VALUES (18033,2,2,6,2000,142,4879);
> INSERT INTO `TRANSACTION` VALUES (18033,6,1,2,3000,142,4879);
> INSERT INTO `TRANSACTION` VALUES (18034,6,1,5,3000,142,3625);
> INSERT INTO `TRANSACTION` VALUES (18035,2,2,7,3000,142,4402);
> INSERT INTO `TRANSACTION` VALUES (18035,7,2,2,2000,142,4402);
> INSERT INTO `TRANSACTION` VALUES (18036,0,0,7,3000,142,8565);
> INSERT INTO `TRANSACTION` VALUES (18038,4,4,9,2000,142,3714);
> INSERT INTO `TRANSACTION` VALUES (18038,9,4,4,3000,142,3714);
> INSERT INTO `TRANSACTION` VALUES (18039,2,2,8,3000,142,2203);
> INSERT INTO `TRANSACTION` VALUES (18039,8,3,2,2000,142,2203);
> INSERT INTO `TRANSACTION` VALUES (18040,7,2,8,2000,142,3299);
> INSERT INTO `TRANSACTION` VALUES (18040,8,3,7,3000,142,3299);
> INSERT INTO `TRANSACTION` VALUES (18042,0,0,2,2000,142,277);
> INSERT INTO `TRANSACTION` VALUES (18043,0,0,2,2000,142,5484);
> INSERT INTO `TRANSACTION` VALUES (18043,2,2,0,3000,142,5484);
> INSERT INTO `TRANSACTION` VALUES (18044,6,1,7,3000,142,1455);
> INSERT INTO `TRANSACTION` VALUES (18044,7,2,6,2000,142,1455);
> INSERT INTO `TRANSACTION` VALUES (18045,6,1,8,3000,142,3809);
> INSERT INTO `TRANSACTION` VALUES (18045,8,3,6,2000,142,3809);
> INSERT INTO `TRANSACTION` VALUES (18046,6,1,7,2000,142,5539);
> INSERT INTO `TRANSACTION` VALUES (18046,7,2,6,3000,142,5539);
> INSERT INTO `TRANSACTION` VALUES (18047,0,0,2,2000,142,8974);
> INSERT INTO `TRANSACTION` VALUES (18047,2,2,0,3000,142,8974);
> INSERT INTO `TRANSACTION` VALUES (18048,0,0,5,2000,142,3820);
> INSERT INTO `TRANSACTION` VALUES (18048,5,1,0,3000,142,3820);
> INSERT INTO `TRANSACTION` VALUES (18049,5,1,8,3000,142,2820);
> INSERT INTO `TRANSACTION` VALUES (18049,8,3,5,2000,142,2820);
> INSERT INTO `TRANSACTION` VALUES (18050,6,1,3,2000,142,8816);
> INSERT INTO `TRANSACTION` VALUES (18051,9,4,2,2000,142,813);
> INSERT INTO `TRANSACTION` VALUES (18052,8,3,3,2000,142,5790);
> INSERT INTO `TRANSACTION` VALUES (18053,2,2,9,2000,142,380);
> INSERT INTO `TRANSACTION` VALUES (18053,9,4,2,3000,142,380);
> INSERT INTO `TRANSACTION` VALUES (18054,6,1,7,3000,142,1982);
> INSERT INTO `TRANSACTION` VALUES (18055,1,1,2,2000,142,1185);
> INSERT INTO `TRANSACTION` VALUES (18055,2,2,1,3000,142,1185);
> INSERT INTO `TRANSACTION` VALUES (18057,4,4,6,2000,142,5860);
> INSERT INTO `TRANSACTION` VALUES (18058,7,2,8,2000,142,9184);
> INSERT INTO `TRANSACTION` VALUES (18058,8,3,7,3000,142,9184);
> INSERT INTO `TRANSACTION` VALUES (18060,5,1,4,3000,142,853);
> INSERT INTO `TRANSACTION` VALUES (18061,6,1,8,3000,142,1719);
> INSERT INTO `TRANSACTION` VALUES (18063,1,1,7,3000,142,1641);
> INSERT INTO `TRANSACTION` VALUES (18064,8,3,9,2000,142,2929);
> INSERT INTO `TRANSACTION` VALUES (18064,9,4,8,3000,142,2929);
> INSERT INTO `TRANSACTION` VALUES (18065,4,4,1,3000,142,4718);
> INSERT INTO `TRANSACTION` VALUES (18066,5,1,3,2000,142,2615);
> INSERT INTO `TRANSACTION` VALUES (18067,2,2,1,2000,142,5265);
> INSERT INTO `TRANSACTION` VALUES (18068,9,4,7,3000,142,9178);

Attempt #2
NDB10: 
[ndbdev@ndb10 run]$ mysql -u root Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 14 to server version: 5.1.0-a_drop5p3

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> drop database BANK;
Query OK, 0 rows affected (1.31 sec)

mysql> create database BANK;
Query OK, 1 row affected (0.00 sec)

mysql> use BANK;
Database changed

mysql> show tables;
Empty set (0.01 sec)

mysql> exit
Bye
[ndbdev@ndb10 run]$ ndb_restore -c $ndbc -n 2 -e -m -b 1 -r ./BACKUP/BACKUP-1/ Ndb version in backup files: Version 5.1.0
Connected to ndb!!
Successfully restored table BANK/def/ACCOUNT_TYPE
Successfully restored table BANK/def/ACCOUNT_TYPES
Successfully restored table BANK/def/SYSTEM_VALUES
Successfully restored table BANK/def/TRANSACTION
Successfully restored table BANK/def/ACCOUNT
Successfully restored table BANK/def/GL
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPE(8) fragment 0
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPES(7) fragment 0
_____________________________________________________
Restoring data in table: BANK/def/SYSTEM_VALUES(6) fragment 0
_____________________________________________________
Restoring data in table: BANK/def/TRANSACTION(5) fragment 0
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT(4) fragment 0
_____________________________________________________
Restoring data in table: BANK/def/GL(3) fragment 0
_____________________________________________________
Restoring data in table: cluster_replication/def/apply_status(2) fragment 0
_____________________________________________________
Restoring data in table: sys/def/NDB$EVENTS_0(1) fragment 0
_____________________________________________________
Restoring data in table: sys/def/SYSTAB_0(0) fragment 0
Restored 310 tuples and 2392 log entries
[ndbdev@ndb10 run]$ ndb_restore -c $ndbc -n 3 -e  -b 1 -r ./BACKUP/BACKUP-1/
Ndb version in backup files: Version 5.1.0
Connected to ndb!!
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPE(8) fragment 2
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPES(7) fragment 2
_____________________________________________________
Restoring data in table: BANK/def/SYSTEM_VALUES(6) fragment 2
_____________________________________________________
Restoring data in table: BANK/def/TRANSACTION(5) fragment 2
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT(4) fragment 2
_____________________________________________________
Restoring data in table: BANK/def/GL(3) fragment 2
_____________________________________________________
Restoring data in table: cluster_replication/def/apply_status(2) fragment 2
_____________________________________________________
Restoring data in table: sys/def/NDB$EVENTS_0(1) fragment 2
_____________________________________________________
Restoring data in table: sys/def/SYSTAB_0(0) fragment 2
Restored 284 tuples and 0 log entries
[ndbdev@ndb10 run]$ ndb_restore -c $ndbc -n 4 -e  -b 1 -r ./BACKUP/BACKUP-1/
Ndb version in backup files: Version 5.1.0
Connected to ndb!!
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPE(8) fragment 1
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPES(7) fragment 1
_____________________________________________________
Restoring data in table: BANK/def/SYSTEM_VALUES(6) fragment 1
_____________________________________________________
Restoring data in table: BANK/def/TRANSACTION(5) fragment 1
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT(4) fragment 1
_____________________________________________________
Restoring data in table: BANK/def/GL(3) fragment 1
_____________________________________________________
Restoring data in table: cluster_replication/def/apply_status(2) fragment 1
_____________________________________________________
Restoring data in table: sys/def/NDB$EVENTS_0(1) fragment 1
_____________________________________________________
Restoring data in table: sys/def/SYSTAB_0(0) fragment 1
Restored 340 tuples and 0 log entries
[ndbdev@ndb10 run]$ ndb_restore -c $ndbc -n 5 -e  -b 1 -r ./BACKUP/BACKUP-1/
Ndb version in backup files: Version 5.1.0
Connected to ndb!!
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPE(8) fragment 3
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPES(7) fragment 3
_____________________________________________________
Restoring data in table: BANK/def/SYSTEM_VALUES(6) fragment 3
_____________________________________________________
Restoring data in table: BANK/def/TRANSACTION(5) fragment 3
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT(4) fragment 3
_____________________________________________________
Restoring data in table: BANK/def/GL(3) fragment 3
_____________________________________________________
Restoring data in table: cluster_replication/def/apply_status(2) fragment 3
_____________________________________________________
Restoring data in table: sys/def/NDB$EVENTS_0(1) fragment 3
_____________________________________________________
Restoring data in table: sys/def/SYSTAB_0(0) fragment 3
Restored 344 tuples and 2088 log entries
[ndbdev@ndb10 run]$ perl ../../resetslave.pl ndb08 3307 root BLANK NDB10 3306 root BLANK
        Slave Epoch =  457
Use of uninitialized value in concatenation (.) or string at ../../resetslave.pl line 124.
        Master bin log =
Use of uninitialized value in concatenation (.) or string at ../../resetslave.pl line 125.
        Master Bin Log position =
Use of uninitialized value in concatenation (.) or string at ../../resetslave.pl line 130.
Use of uninitialized value in concatenation (.) or string at ../../resetslave.pl line 130.
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at ../../resetslave.pl line 133.
CHNAGE MASTER on slave error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at ../../resetslave.pl line 133.
[ndbdev@ndb10 run]$ mysql -u root Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 16 to server version: 5.1.0-a_drop5p3

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select * from cluster_replication.apply_status
    -> ;
+-----------+-------+
| server_id | epoch |
+-----------+-------+
|         0 |   387 |
|         1 |   457 |
+-----------+-------+
2 rows in set (0.08 sec)

mysql> delete from cluster_replication.apply_status where server_id = 1;
Query OK, 1 row affected (0.05 sec)

mysql> select * from cluster_replication.apply_status
    -> ;
+-----------+-------+
| server_id | epoch |
+-----------+-------+
|         0 |   387 |
+-----------+-------+
1 rows in set (0.03 sec)

mysql> exit
Bye
[ndbdev@ndb10 run]$ perl ../../resetslave.pl ndb08 3307 root BLANK NDB10 3306 root BLANK
        Slave Epoch =  387
        Master bin log =  master1.000003
        Master Bin Log position =  7906594
        Slave has been updated. You may now start slave.
[ndbdev@ndb10 run]$ mysql -u root Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 19 to server version: 5.1.0-a_drop5p3

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> start slave;
Query OK, 0 rows affected (0.00 sec)

mysql> show slave status\G;
*************************** 1. row ***************************
             Slave_IO_State: Waiting for master to send event
                Master_Host: ndb08
                Master_User: rep
                Master_Port: 3307
              Connect_Retry: 1
            Master_Log_File: master1.000003
        Read_Master_Log_Pos: 22052219
             Relay_Log_File: ndb10-relay-bin.000002
              Relay_Log_Pos: 526046
      Relay_Master_Log_File: master1.000003
           Slave_IO_Running: Yes
          Slave_SQL_Running: Yes
            Replicate_Do_DB:
        Replicate_Ignore_DB:
         Replicate_Do_Table:
     Replicate_Ignore_Table:
    Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
                 Last_Errno: 0
                 Last_Error:
               Skip_Counter: 0
        Exec_Master_Log_Pos: 8432399
            Relay_Log_Space: 14145866
            Until_Condition: None
             Until_Log_File:
              Until_Log_Pos: 0
         Master_SSL_Allowed: No
         Master_SSL_CA_File:
         Master_SSL_CA_Path:
            Master_SSL_Cert:
          Master_SSL_Cipher:
             Master_SSL_Key:
      Seconds_Behind_Master: 5384
1 row in set (0.00 sec)

ERROR:
No query specified

mysql> show slave status\G;
*************************** 1. row ***************************
             Slave_IO_State: Waiting for master to send event
                Master_Host: ndb08
                Master_User: rep
                Master_Port: 3307
              Connect_Retry: 1
            Master_Log_File: master1.000003
        Read_Master_Log_Pos: 22052219
             Relay_Log_File: ndb10-relay-bin.000002
              Relay_Log_Pos: 14145866
      Relay_Master_Log_File: master1.000003
           Slave_IO_Running: Yes
          Slave_SQL_Running: Yes
            Replicate_Do_DB:
        Replicate_Ignore_DB:
         Replicate_Do_Table:
     Replicate_Ignore_Table:
    Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
                 Last_Errno: 0
                 Last_Error:
               Skip_Counter: 0
        Exec_Master_Log_Pos: 22052219
            Relay_Log_Space: 14145866
            Until_Condition: None
             Until_Log_File:
              Until_Log_Pos: 0
         Master_SSL_Allowed: No
         Master_SSL_CA_File:
         Master_SSL_CA_Path:
            Master_SSL_Cert:
          Master_SSL_Cipher:
             Master_SSL_Key:
      Seconds_Behind_Master: 0
1 row in set (0.00 sec)

ERROR:
No query specified

mysql> exit

[ndbdev@ndb10 run]$  mysqldump --compact --order-by-primary --skip-extended-insert --no-create-info -u root BANK > slave_BANK.sql

[ndbdev@ndb10 run]$  scp slave_BANK.sql ndb08:/home/ndbdev/jmiller/builds/run/ slave_BANK.sql       100% |*****************************|   158 KB    00:00

NDB08:
ndbdev@ndb08:~/jmiller/builds/run> mysqldump --compact --order-by-primary --skip-extended-insert --no-create-info -u root BANK > master_BANK.sql
ndbdev@ndb08:~/jmiller/builds/run> diff master_BANK.sql slave_BANK.sql 706c706
< INSERT INTO `GL` VALUES (139,0,9283056,14,59731,11,53488,1);
---
> INSERT INTO `GL` VALUES (139,0,9283056,14,59731,11,53488,0);
710,711c710,711
< INSERT INTO `GL` VALUES (139,4,133959,29,142022,21,85487,1);
< INSERT INTO `GL` VALUES (140,0,9283056,0,0,0,0,1);
---
> INSERT INTO `GL` VALUES (139,4,133959,29,142022,21,85487,0);
> INSERT INTO `GL` VALUES (140,0,9283056,0,0,0,0,0);
713,715c713,715
< INSERT INTO `GL` VALUES (140,2,161882,1,4695,0,0,1);
< INSERT INTO `GL` VALUES (140,3,400172,0,0,1,4695,1);
< INSERT INTO `GL` VALUES (140,4,133959,0,0,0,0,1);
---
> INSERT INTO `GL` VALUES (140,2,161882,1,4695,0,0,0);
> INSERT INTO `GL` VALUES (140,3,400172,0,0,1,4695,0);
> INSERT INTO `GL` VALUES (140,4,133959,0,0,0,0,0);
717,721c717,720
< INSERT INTO `GL` VALUES (141,1,130752,35,161771,32,141950,1);
< INSERT INTO `GL` VALUES (141,2,152400,28,114077,32,123559,1);
< INSERT INTO `GL` VALUES (141,3,449996,30,156617,23,106793,1);
< INSERT INTO `GL` VALUES (141,4,69716,15,65898,22,130141,1);
< INSERT INTO `GL` VALUES (142,0,9267737,6,36393,10,55792,1);
---
> INSERT INTO `GL` VALUES (141,1,130752,35,161771,32,141950,0);
> INSERT INTO `GL` VALUES (141,2,152400,28,114077,32,123559,0);
> INSERT INTO `GL` VALUES (141,3,449996,30,156617,23,106793,0);
> INSERT INTO `GL` VALUES (141,4,69716,15,65898,22,130141,0);
724d722
< INSERT INTO `GL` VALUES (142,3,462656,15,80279,16,67619,1);
727d724
< INSERT INTO `GL` VALUES (143,1,123808,40,164538,40,179128,1);
729,731d725
< INSERT INTO `GL` VALUES (143,3,457043,31,134773,24,140386,1);
< INSERT INTO `GL` VALUES (143,4,147443,27,136577,19,76351,1);
< INSERT INTO `GL` VALUES (144,0,9185365,21,94744,26,132100,1);
733,735d726
< INSERT INTO `GL` VALUES (144,2,127206,54,237926,55,249705,1);
< INSERT INTO `GL` VALUES (144,3,462332,60,324697,61,319408,1);
< INSERT INTO `GL` VALUES (144,4,140451,51,235034,56,242026,1);
1967a1959,2285
> INSERT INTO `TRANSACTION` VALUES (17746,4,4,0,3000,139,3012);
> INSERT INTO `TRANSACTION` VALUES (17749,3,3,2,3000,139,9603);
> INSERT INTO `TRANSACTION` VALUES (17752,9,4,5,3000,139,2154);
> INSERT INTO `TRANSACTION` VALUES (17753,9,4,6,2000,139,8571);
> INSERT INTO `TRANSACTION` VALUES (17756,9,4,1,2000,139,4888);
> INSERT INTO `TRANSACTION` VALUES (17757,0,0,1,2000,139,3568);
> INSERT INTO `TRANSACTION` VALUES (17759,3,3,8,2000,139,7696);
> INSERT INTO `TRANSACTION` VALUES (17760,4,4,1,2000,139,1811);
> INSERT INTO `TRANSACTION` VALUES (17761,4,4,6,3000,139,6780);
> INSERT INTO `TRANSACTION` VALUES (17762,3,3,6,2000,139,4898);
> INSERT INTO `TRANSACTION` VALUES (17768,3,3,7,2000,139,6203);
> INSERT INTO `TRANSACTION` VALUES (17769,0,0,3,2000,139,7954);
> INSERT INTO `TRANSACTION` VALUES (17770,3,3,6,2000,139,8413);
> INSERT INTO `TRANSACTION` VALUES (17771,3,3,8,2000,139,4506);
> INSERT INTO `TRANSACTION` VALUES (17772,0,0,1,3000,139,3245);
> INSERT INTO `TRANSACTION` VALUES (17773,3,3,1,2000,139,1985);
> INSERT INTO `TRANSACTION` VALUES (17774,8,3,9,2000,139,9724);
> INSERT INTO `TRANSACTION` VALUES (17775,7,2,8,2000,139,4878);
> INSERT INTO `TRANSACTION` VALUES (17775,8,3,7,3000,139,4878);
> INSERT INTO `TRANSACTION` VALUES (17776,4,4,3,3000,139,6150);
> INSERT INTO `TRANSACTION` VALUES (17779,7,2,6,2000,139,7940);
> INSERT INTO `TRANSACTION` VALUES (17782,2,2,5,3000,139,8795);
> INSERT INTO `TRANSACTION` VALUES (17783,7,2,6,3000,139,3175);
> INSERT INTO `TRANSACTION` VALUES (17784,8,3,7,3000,139,8824);
> INSERT INTO `TRANSACTION` VALUES (17785,2,2,0,3000,139,8526);
> INSERT INTO `TRANSACTION` VALUES (17786,0,0,7,2000,139,975);
> INSERT INTO `TRANSACTION` VALUES (17786,7,2,0,3000,139,975);
> INSERT INTO `TRANSACTION` VALUES (17788,7,2,0,2000,139,9094);
> INSERT INTO `TRANSACTION` VALUES (17791,9,4,6,3000,139,2349);
> INSERT INTO `TRANSACTION` VALUES (17792,3,3,5,2000,139,3717);
> INSERT INTO `TRANSACTION` VALUES (17794,0,0,5,3000,139,1837);
> INSERT INTO `TRANSACTION` VALUES (17796,3,3,9,2000,139,344);
> INSERT INTO `TRANSACTION` VALUES (17796,9,4,3,3000,139,344);
> INSERT INTO `TRANSACTION` VALUES (17797,2,2,1,3000,139,6333);
> INSERT INTO `TRANSACTION` VALUES (17799,3,3,4,2000,139,4883);
> INSERT INTO `TRANSACTION` VALUES (17799,4,4,3,3000,139,4883);
> INSERT INTO `TRANSACTION` VALUES (17800,4,4,1,2000,139,7313);
> INSERT INTO `TRANSACTION` VALUES (17801,7,2,5,2000,139,7631);
> INSERT INTO `TRANSACTION` VALUES (17803,8,3,0,2000,139,3587);
> INSERT INTO `TRANSACTION` VALUES (17804,9,4,8,3000,139,8994);
> INSERT INTO `TRANSACTION` VALUES (17805,0,0,5,2000,139,5147);
> INSERT INTO `TRANSACTION` VALUES (17806,8,3,9,2000,139,6649);
> INSERT INTO `TRANSACTION` VALUES (17806,9,4,8,3000,139,6649);
> INSERT INTO `TRANSACTION` VALUES (17807,8,3,6,2000,139,5646);
> INSERT INTO `TRANSACTION` VALUES (17808,9,4,5,2000,139,2879);
> INSERT INTO `TRANSACTION` VALUES (17809,7,2,1,2000,139,5276);
> INSERT INTO `TRANSACTION` VALUES (17811,9,4,6,3000,139,5999);
> INSERT INTO `TRANSACTION` VALUES (17812,3,3,9,2000,139,1562);
> INSERT INTO `TRANSACTION` VALUES (17815,9,4,5,3000,139,305);
> INSERT INTO `TRANSACTION` VALUES (17817,2,2,1,2000,139,1158);
> INSERT INTO `TRANSACTION` VALUES (17818,9,4,8,3000,139,7393);
> INSERT INTO `TRANSACTION` VALUES (17819,3,3,5,3000,139,4846);
> INSERT INTO `TRANSACTION` VALUES (17820,0,0,5,3000,139,6594);
> INSERT INTO `TRANSACTION` VALUES (17821,7,2,2,2000,139,9925);
> INSERT INTO `TRANSACTION` VALUES (17822,9,4,1,3000,139,7227);
> INSERT INTO `TRANSACTION` VALUES (17823,4,4,2,2000,139,2865);
> INSERT INTO `TRANSACTION` VALUES (17825,0,0,4,3000,139,2610);
> INSERT INTO `TRANSACTION` VALUES (17825,4,4,0,2000,139,2610);
> INSERT INTO `TRANSACTION` VALUES (17826,2,2,1,2000,139,3319);
> INSERT INTO `TRANSACTION` VALUES (17828,4,4,5,2000,139,2304);
> INSERT INTO `TRANSACTION` VALUES (17829,2,2,8,3000,139,4089);
> INSERT INTO `TRANSACTION` VALUES (17830,4,4,3,2000,139,4888);
> INSERT INTO `TRANSACTION` VALUES (17831,0,0,9,3000,139,4272);
> INSERT INTO `TRANSACTION` VALUES (17833,9,4,6,2000,139,7987);
> INSERT INTO `TRANSACTION` VALUES (17835,2,2,3,2000,139,2211);
> INSERT INTO `TRANSACTION` VALUES (17835,3,3,2,3000,139,2211);
> INSERT INTO `TRANSACTION` VALUES (17837,0,0,1,3000,139,8956);
> INSERT INTO `TRANSACTION` VALUES (17839,9,4,0,2000,139,149);
> INSERT INTO `TRANSACTION` VALUES (17841,2,2,8,3000,139,9838);
> INSERT INTO `TRANSACTION` VALUES (17841,8,3,2,2000,139,9838);
> INSERT INTO `TRANSACTION` VALUES (17842,9,4,8,3000,139,2739);
> INSERT INTO `TRANSACTION` VALUES (17843,9,4,5,2000,139,3985);
> INSERT INTO `TRANSACTION` VALUES (17846,8,3,1,3000,139,4529);
> INSERT INTO `TRANSACTION` VALUES (17847,8,3,1,2000,139,4049);
> INSERT INTO `TRANSACTION` VALUES (17849,8,3,9,2000,139,9813);
> INSERT INTO `TRANSACTION` VALUES (17849,9,4,8,3000,139,9813);
> INSERT INTO `TRANSACTION` VALUES (17850,3,3,7,3000,139,8129);
> INSERT INTO `TRANSACTION` VALUES (17851,8,3,2,2000,139,2513);
> INSERT INTO `TRANSACTION` VALUES (17852,7,2,8,2000,139,5741);
> INSERT INTO `TRANSACTION` VALUES (17852,8,3,7,3000,139,5741);
> INSERT INTO `TRANSACTION` VALUES (17853,3,3,8,3000,139,6737);
> INSERT INTO `TRANSACTION` VALUES (17853,8,3,3,2000,139,6737);
> INSERT INTO `TRANSACTION` VALUES (17854,3,3,4,2000,139,805);
> INSERT INTO `TRANSACTION` VALUES (17855,4,4,2,2000,139,6330);
> INSERT INTO `TRANSACTION` VALUES (17857,3,3,8,2000,139,2943);
> INSERT INTO `TRANSACTION` VALUES (17857,8,3,3,3000,139,2943);
> INSERT INTO `TRANSACTION` VALUES (17859,7,2,6,3000,139,8088);
> INSERT INTO `TRANSACTION` VALUES (17861,7,2,9,3000,139,6970);
> INSERT INTO `TRANSACTION` VALUES (17862,2,2,5,3000,139,9826);
> INSERT INTO `TRANSACTION` VALUES (17864,3,3,5,2000,139,7447);
> INSERT INTO `TRANSACTION` VALUES (17865,3,3,7,2000,139,1885);
> INSERT INTO `TRANSACTION` VALUES (17866,2,2,1,3000,139,4513);
> INSERT INTO `TRANSACTION` VALUES (17870,3,3,0,3000,139,6365);
> INSERT INTO `TRANSACTION` VALUES (17873,2,2,5,2000,139,3942);
> INSERT INTO `TRANSACTION` VALUES (17874,4,4,1,2000,139,4091);
> INSERT INTO `TRANSACTION` VALUES (17875,8,3,7,3000,139,9801);
> INSERT INTO `TRANSACTION` VALUES (17876,3,3,5,3000,139,5319);
> INSERT INTO `TRANSACTION` VALUES (17879,0,0,9,2000,139,1720);
> INSERT INTO `TRANSACTION` VALUES (17879,9,4,0,3000,139,1720);
> INSERT INTO `TRANSACTION` VALUES (17880,0,0,7,3000,139,457);
> INSERT INTO `TRANSACTION` VALUES (17882,0,0,3,3000,139,7504);
> INSERT INTO `TRANSACTION` VALUES (17883,3,3,7,2000,139,8827);
> INSERT INTO `TRANSACTION` VALUES (17884,3,3,7,2000,140,4695);
> INSERT INTO `TRANSACTION` VALUES (17884,7,2,3,3000,140,4695);
> INSERT INTO `TRANSACTION` VALUES (17886,6,1,7,3000,141,1102);
> INSERT INTO `TRANSACTION` VALUES (17886,7,2,6,2000,141,1102);
> INSERT INTO `TRANSACTION` VALUES (17887,5,1,8,2000,141,139);
> INSERT INTO `TRANSACTION` VALUES (17888,8,3,1,2000,141,5969);
> INSERT INTO `TRANSACTION` VALUES (17890,2,2,4,2000,141,3574);
> INSERT INTO `TRANSACTION` VALUES (17891,3,3,8,2000,141,8083);
> INSERT INTO `TRANSACTION` VALUES (17892,8,3,0,3000,141,7947);
> INSERT INTO `TRANSACTION` VALUES (17893,1,1,5,3000,141,2578);
> INSERT INTO `TRANSACTION` VALUES (17893,5,1,1,2000,141,2578);
> INSERT INTO `TRANSACTION` VALUES (17894,7,2,8,2000,141,779);
> INSERT INTO `TRANSACTION` VALUES (17896,0,0,5,2000,141,6088);
> INSERT INTO `TRANSACTION` VALUES (17896,5,1,0,3000,141,6088);
> INSERT INTO `TRANSACTION` VALUES (17897,7,2,1,3000,141,4814);
> INSERT INTO `TRANSACTION` VALUES (17898,5,1,8,2000,141,8959);
> INSERT INTO `TRANSACTION` VALUES (17899,6,1,1,3000,141,630);
> INSERT INTO `TRANSACTION` VALUES (17900,2,2,7,3000,141,889);
> INSERT INTO `TRANSACTION` VALUES (17900,7,2,2,2000,141,889);
> INSERT INTO `TRANSACTION` VALUES (17901,1,1,7,2000,141,2081);
> INSERT INTO `TRANSACTION` VALUES (17902,6,1,7,3000,141,6502);
> INSERT INTO `TRANSACTION` VALUES (17902,7,2,6,2000,141,6502);
> INSERT INTO `TRANSACTION` VALUES (17903,1,1,8,3000,141,2325);
> INSERT INTO `TRANSACTION` VALUES (17903,8,3,1,2000,141,2325);
> INSERT INTO `TRANSACTION` VALUES (17904,8,3,9,2000,141,3137);
> INSERT INTO `TRANSACTION` VALUES (17906,9,4,3,2000,141,9168);
> INSERT INTO `TRANSACTION` VALUES (17907,9,4,1,2000,141,4119);
> INSERT INTO `TRANSACTION` VALUES (17909,0,0,5,3000,141,7395);
> INSERT INTO `TRANSACTION` VALUES (17910,3,3,7,3000,141,3442);
> INSERT INTO `TRANSACTION` VALUES (17911,3,3,7,2000,141,85);
> INSERT INTO `TRANSACTION` VALUES (17911,7,2,3,3000,141,85);
> INSERT INTO `TRANSACTION` VALUES (17912,7,2,6,2000,141,4161);
> INSERT INTO `TRANSACTION` VALUES (17913,8,3,9,2000,141,2759);
> INSERT INTO `TRANSACTION` VALUES (17913,9,4,8,3000,141,2759);
> INSERT INTO `TRANSACTION` VALUES (17914,1,1,7,3000,141,1086);
> INSERT INTO `TRANSACTION` VALUES (17914,7,2,1,2000,141,1086);
> INSERT INTO `TRANSACTION` VALUES (17915,6,1,7,2000,141,4395);
> INSERT INTO `TRANSACTION` VALUES (17917,8,3,9,3000,141,2444);
> INSERT INTO `TRANSACTION` VALUES (17917,9,4,8,2000,141,2444);
> INSERT INTO `TRANSACTION` VALUES (17918,4,4,1,2000,141,8933);
> INSERT INTO `TRANSACTION` VALUES (17919,8,3,1,2000,141,3602);
> INSERT INTO `TRANSACTION` VALUES (17920,3,3,5,2000,141,5597);
> INSERT INTO `TRANSACTION` VALUES (17920,5,1,3,3000,141,5597);
> INSERT INTO `TRANSACTION` VALUES (17922,4,4,8,2000,141,7771);
> INSERT INTO `TRANSACTION` VALUES (17922,8,3,4,3000,141,7771);
> INSERT INTO `TRANSACTION` VALUES (17923,9,4,8,3000,141,1829);
> INSERT INTO `TRANSACTION` VALUES (17924,7,2,1,3000,141,431);
> INSERT INTO `TRANSACTION` VALUES (17926,9,4,6,2000,141,9794);
> INSERT INTO `TRANSACTION` VALUES (17927,7,2,5,3000,141,8046);
> INSERT INTO `TRANSACTION` VALUES (17928,7,2,2,2000,141,2871);
> INSERT INTO `TRANSACTION` VALUES (17929,3,3,9,3000,141,2982);
> INSERT INTO `TRANSACTION` VALUES (17930,7,2,8,3000,141,5724);
> INSERT INTO `TRANSACTION` VALUES (17930,8,3,7,2000,141,5724);
> INSERT INTO `TRANSACTION` VALUES (17931,1,1,2,2000,141,5049);
> INSERT INTO `TRANSACTION` VALUES (17931,2,2,1,3000,141,5049);
> INSERT INTO `TRANSACTION` VALUES (17932,8,3,9,2000,141,7976);
> INSERT INTO `TRANSACTION` VALUES (17934,3,3,9,3000,141,3036);
> INSERT INTO `TRANSACTION` VALUES (17934,9,4,3,2000,141,3036);
> INSERT INTO `TRANSACTION` VALUES (17936,7,2,6,3000,141,7956);
> INSERT INTO `TRANSACTION` VALUES (17937,8,3,0,2000,141,2105);
> INSERT INTO `TRANSACTION` VALUES (17938,2,2,4,2000,141,773);
> INSERT INTO `TRANSACTION` VALUES (17939,2,2,6,3000,141,2940);
> INSERT INTO `TRANSACTION` VALUES (17940,0,0,4,3000,141,9822);
> INSERT INTO `TRANSACTION` VALUES (17940,4,4,0,2000,141,9822);
> INSERT INTO `TRANSACTION` VALUES (17942,3,3,9,3000,141,6104);
> INSERT INTO `TRANSACTION` VALUES (17942,9,4,3,2000,141,6104);
> INSERT INTO `TRANSACTION` VALUES (17943,6,1,8,3000,141,4281);
> INSERT INTO `TRANSACTION` VALUES (17943,8,3,6,2000,141,4281);
> INSERT INTO `TRANSACTION` VALUES (17944,3,3,6,3000,141,1032);
> INSERT INTO `TRANSACTION` VALUES (17944,6,1,3,2000,141,1032);
> INSERT INTO `TRANSACTION` VALUES (17945,4,4,8,2000,141,9130);
> INSERT INTO `TRANSACTION` VALUES (17945,8,3,4,3000,141,9130);
> INSERT INTO `TRANSACTION` VALUES (17947,9,4,6,2000,141,9441);
> INSERT INTO `TRANSACTION` VALUES (17948,4,4,6,2000,141,1381);
> INSERT INTO `TRANSACTION` VALUES (17949,3,3,7,3000,141,3356);
> INSERT INTO `TRANSACTION` VALUES (17949,7,2,3,2000,141,3356);
> INSERT INTO `TRANSACTION` VALUES (17950,1,1,3,3000,141,7787);
> INSERT INTO `TRANSACTION` VALUES (17951,0,0,4,3000,141,8623);
> INSERT INTO `TRANSACTION` VALUES (17952,0,0,2,2000,141,6327);
> INSERT INTO `TRANSACTION` VALUES (17952,2,2,0,3000,141,6327);
> INSERT INTO `TRANSACTION` VALUES (17953,2,2,8,2000,141,8508);
> INSERT INTO `TRANSACTION` VALUES (17953,8,3,2,3000,141,8508);
> INSERT INTO `TRANSACTION` VALUES (17956,5,1,7,2000,141,1697);
> INSERT INTO `TRANSACTION` VALUES (17956,7,2,5,3000,141,1697);
> INSERT INTO `TRANSACTION` VALUES (17957,6,1,5,3000,141,3846);
> INSERT INTO `TRANSACTION` VALUES (17959,6,1,8,3000,141,3365);
> INSERT INTO `TRANSACTION` VALUES (17960,3,3,7,3000,141,1253);
> INSERT INTO `TRANSACTION` VALUES (17960,7,2,3,2000,141,1253);
> INSERT INTO `TRANSACTION` VALUES (17961,4,4,6,2000,141,7508);
> INSERT INTO `TRANSACTION` VALUES (17961,6,1,4,3000,141,7508);
> INSERT INTO `TRANSACTION` VALUES (17963,8,3,0,3000,141,4195);
> INSERT INTO `TRANSACTION` VALUES (17964,5,1,2,2000,141,4677);
> INSERT INTO `TRANSACTION` VALUES (17965,2,2,6,3000,141,784);
> INSERT INTO `TRANSACTION` VALUES (17965,6,1,2,2000,141,784);
> INSERT INTO `TRANSACTION` VALUES (17966,7,2,0,3000,141,9009);
> INSERT INTO `TRANSACTION` VALUES (17968,9,4,7,2000,141,2421);
> INSERT INTO `TRANSACTION` VALUES (17969,1,1,3,3000,141,661);
> INSERT INTO `TRANSACTION` VALUES (17970,4,4,3,2000,141,936);
> INSERT INTO `TRANSACTION` VALUES (17971,1,1,7,2000,141,23);
> INSERT INTO `TRANSACTION` VALUES (17972,4,4,2,3000,141,1767);
> INSERT INTO `TRANSACTION` VALUES (17973,5,1,1,3000,141,4445);
> INSERT INTO `TRANSACTION` VALUES (17974,1,1,8,3000,141,2109);
> INSERT INTO `TRANSACTION` VALUES (17974,8,3,1,2000,141,2109);
> INSERT INTO `TRANSACTION` VALUES (17975,6,1,7,2000,141,6595);
> INSERT INTO `TRANSACTION` VALUES (17975,7,2,6,3000,141,6595);
> INSERT INTO `TRANSACTION` VALUES (17976,4,4,7,3000,141,365);
> INSERT INTO `TRANSACTION` VALUES (17976,7,2,4,2000,141,365);
> INSERT INTO `TRANSACTION` VALUES (17977,0,0,3,2000,141,9731);
> INSERT INTO `TRANSACTION` VALUES (17977,3,3,0,3000,141,9731);
> INSERT INTO `TRANSACTION` VALUES (17978,6,1,5,3000,141,3412);
> INSERT INTO `TRANSACTION` VALUES (17979,3,3,4,2000,141,5294);
> INSERT INTO `TRANSACTION` VALUES (17979,4,4,3,3000,141,5294);
> INSERT INTO `TRANSACTION` VALUES (17980,3,3,8,2000,141,4234);
> INSERT INTO `TRANSACTION` VALUES (17980,8,3,3,3000,141,4234);
> INSERT INTO `TRANSACTION` VALUES (17982,8,3,7,3000,141,7263);
> INSERT INTO `TRANSACTION` VALUES (17983,4,4,1,2000,141,7667);
> INSERT INTO `TRANSACTION` VALUES (17984,2,2,7,2000,141,6672);
> INSERT INTO `TRANSACTION` VALUES (17984,7,2,2,3000,141,6672);
> INSERT INTO `TRANSACTION` VALUES (17985,7,2,9,3000,141,3859);
> INSERT INTO `TRANSACTION` VALUES (17985,9,4,7,2000,141,3859);
> INSERT INTO `TRANSACTION` VALUES (17986,4,4,8,3000,141,9633);
> INSERT INTO `TRANSACTION` VALUES (17988,7,2,5,2000,141,2305);
> INSERT INTO `TRANSACTION` VALUES (17989,5,1,7,3000,141,9138);
> INSERT INTO `TRANSACTION` VALUES (17989,7,2,5,2000,141,9138);
> INSERT INTO `TRANSACTION` VALUES (17990,5,1,4,2000,141,7387);
> INSERT INTO `TRANSACTION` VALUES (17991,2,2,0,2000,141,2019);
> INSERT INTO `TRANSACTION` VALUES (17992,9,4,8,3000,141,8881);
> INSERT INTO `TRANSACTION` VALUES (17993,8,3,2,3000,141,7928);
> INSERT INTO `TRANSACTION` VALUES (17994,1,1,2,3000,141,8529);
> INSERT INTO `TRANSACTION` VALUES (17995,3,3,2,2000,141,6819);
> INSERT INTO `TRANSACTION` VALUES (17996,2,2,7,3000,141,4050);
> INSERT INTO `TRANSACTION` VALUES (17996,7,2,2,2000,141,4050);
> INSERT INTO `TRANSACTION` VALUES (17998,2,2,7,3000,141,293);
> INSERT INTO `TRANSACTION` VALUES (17998,7,2,2,2000,141,293);
> INSERT INTO `TRANSACTION` VALUES (17999,7,2,8,2000,141,8887);
> INSERT INTO `TRANSACTION` VALUES (17999,8,3,7,3000,141,8887);
> INSERT INTO `TRANSACTION` VALUES (18000,6,1,4,2000,141,6853);
> INSERT INTO `TRANSACTION` VALUES (18001,2,2,8,2000,142,39);
> INSERT INTO `TRANSACTION` VALUES (18001,8,3,2,3000,142,39);
> INSERT INTO `TRANSACTION` VALUES (18002,4,4,8,3000,142,713);
> INSERT INTO `TRANSACTION` VALUES (18003,5,1,3,3000,142,5801);
> INSERT INTO `TRANSACTION` VALUES (18004,0,0,9,2000,142,3807);
> INSERT INTO `TRANSACTION` VALUES (18004,9,4,0,3000,142,3807);
> INSERT INTO `TRANSACTION` VALUES (18005,5,1,7,2000,142,4196);
> INSERT INTO `TRANSACTION` VALUES (18005,7,2,5,3000,142,4196);
> INSERT INTO `TRANSACTION` VALUES (18008,3,3,4,2000,142,4193);
> INSERT INTO `TRANSACTION` VALUES (18008,4,4,3,3000,142,4193);
> INSERT INTO `TRANSACTION` VALUES (18009,0,0,8,3000,142,5571);
> INSERT INTO `TRANSACTION` VALUES (18009,8,3,0,2000,142,5571);
> INSERT INTO `TRANSACTION` VALUES (18010,4,4,0,2000,142,4701);
> INSERT INTO `TRANSACTION` VALUES (18011,0,0,1,3000,142,9650);
> INSERT INTO `TRANSACTION` VALUES (18014,0,0,9,3000,142,4626);
> INSERT INTO `TRANSACTION` VALUES (18014,9,4,0,2000,142,4626);
> INSERT INTO `TRANSACTION` VALUES (18015,9,4,5,2000,142,3485);
> INSERT INTO `TRANSACTION` VALUES (18016,5,1,7,2000,142,2087);
> INSERT INTO `TRANSACTION` VALUES (18016,7,2,5,3000,142,2087);
> INSERT INTO `TRANSACTION` VALUES (18017,5,1,7,3000,142,9408);
> INSERT INTO `TRANSACTION` VALUES (18017,7,2,5,2000,142,9408);
> INSERT INTO `TRANSACTION` VALUES (18018,2,2,6,3000,142,945);
> INSERT INTO `TRANSACTION` VALUES (18018,6,1,2,2000,142,945);
> INSERT INTO `TRANSACTION` VALUES (18019,1,1,8,3000,142,4401);
> INSERT INTO `TRANSACTION` VALUES (18019,8,3,1,2000,142,4401);
> INSERT INTO `TRANSACTION` VALUES (18020,1,1,0,3000,142,4176);
> INSERT INTO `TRANSACTION` VALUES (18021,2,2,3,2000,142,7764);
> INSERT INTO `TRANSACTION` VALUES (18022,6,1,7,2000,142,2973);
> INSERT INTO `TRANSACTION` VALUES (18023,2,2,8,3000,142,5879);
> INSERT INTO `TRANSACTION` VALUES (18024,6,1,5,3000,142,1852);
> INSERT INTO `TRANSACTION` VALUES (18025,9,4,6,3000,142,7331);
> INSERT INTO `TRANSACTION` VALUES (18026,3,3,5,3000,142,7385);
> INSERT INTO `TRANSACTION` VALUES (18027,2,2,8,3000,142,2026);
> INSERT INTO `TRANSACTION` VALUES (18027,8,3,2,2000,142,2026);
> INSERT INTO `TRANSACTION` VALUES (18028,3,3,7,2000,142,7484);
> INSERT INTO `TRANSACTION` VALUES (18028,7,2,3,3000,142,7484);
> INSERT INTO `TRANSACTION` VALUES (18029,6,1,0,3000,142,5321);
> INSERT INTO `TRANSACTION` VALUES (18030,3,3,2,3000,142,6199);
> INSERT INTO `TRANSACTION` VALUES (18031,3,3,4,2000,142,5957);
> INSERT INTO `TRANSACTION` VALUES (18032,2,2,8,2000,142,5172);
> INSERT INTO `TRANSACTION` VALUES (18032,8,3,2,3000,142,5172);
> INSERT INTO `TRANSACTION` VALUES (18033,2,2,6,2000,142,4879);
> INSERT INTO `TRANSACTION` VALUES (18033,6,1,2,3000,142,4879);
> INSERT INTO `TRANSACTION` VALUES (18034,6,1,5,3000,142,3625);
> INSERT INTO `TRANSACTION` VALUES (18035,2,2,7,3000,142,4402);
> INSERT INTO `TRANSACTION` VALUES (18035,7,2,2,2000,142,4402);
> INSERT INTO `TRANSACTION` VALUES (18036,0,0,7,3000,142,8565);
> INSERT INTO `TRANSACTION` VALUES (18038,4,4,9,2000,142,3714);
> INSERT INTO `TRANSACTION` VALUES (18038,9,4,4,3000,142,3714);
> INSERT INTO `TRANSACTION` VALUES (18039,2,2,8,3000,142,2203);
> INSERT INTO `TRANSACTION` VALUES (18039,8,3,2,2000,142,2203);
> INSERT INTO `TRANSACTION` VALUES (18040,7,2,8,2000,142,3299);
> INSERT INTO `TRANSACTION` VALUES (18040,8,3,7,3000,142,3299);
> INSERT INTO `TRANSACTION` VALUES (18042,0,0,2,2000,142,277);
> INSERT INTO `TRANSACTION` VALUES (18043,0,0,2,2000,142,5484);
> INSERT INTO `TRANSACTION` VALUES (18043,2,2,0,3000,142,5484);
> INSERT INTO `TRANSACTION` VALUES (18044,6,1,7,3000,142,1455);
> INSERT INTO `TRANSACTION` VALUES (18044,7,2,6,2000,142,1455);
> INSERT INTO `TRANSACTION` VALUES (18045,6,1,8,3000,142,3809);
> INSERT INTO `TRANSACTION` VALUES (18045,8,3,6,2000,142,3809);
> INSERT INTO `TRANSACTION` VALUES (18046,6,1,7,2000,142,5539);
> INSERT INTO `TRANSACTION` VALUES (18046,7,2,6,3000,142,5539);
> INSERT INTO `TRANSACTION` VALUES (18047,0,0,2,2000,142,8974);
> INSERT INTO `TRANSACTION` VALUES (18047,2,2,0,3000,142,8974);
> INSERT INTO `TRANSACTION` VALUES (18048,0,0,5,2000,142,3820);
> INSERT INTO `TRANSACTION` VALUES (18048,5,1,0,3000,142,3820);
> INSERT INTO `TRANSACTION` VALUES (18049,5,1,8,3000,142,2820);
> INSERT INTO `TRANSACTION` VALUES (18049,8,3,5,2000,142,2820);
> INSERT INTO `TRANSACTION` VALUES (18050,6,1,3,2000,142,8816);
> INSERT INTO `TRANSACTION` VALUES (18051,9,4,2,2000,142,813);
> INSERT INTO `TRANSACTION` VALUES (18052,8,3,3,2000,142,5790);
> INSERT INTO `TRANSACTION` VALUES (18053,2,2,9,2000,142,380);
> INSERT INTO `TRANSACTION` VALUES (18053,9,4,2,3000,142,380);
> INSERT INTO `TRANSACTION` VALUES (18054,6,1,7,3000,142,1982);
> INSERT INTO `TRANSACTION` VALUES (18055,1,1,2,2000,142,1185);
> INSERT INTO `TRANSACTION` VALUES (18055,2,2,1,3000,142,1185);
> INSERT INTO `TRANSACTION` VALUES (18057,4,4,6,2000,142,5860);
> INSERT INTO `TRANSACTION` VALUES (18058,7,2,8,2000,142,9184);
> INSERT INTO `TRANSACTION` VALUES (18058,8,3,7,3000,142,9184);
> INSERT INTO `TRANSACTION` VALUES (18060,5,1,4,3000,142,853);
> INSERT INTO `TRANSACTION` VALUES (18061,6,1,8,3000,142,1719);
> INSERT INTO `TRANSACTION` VALUES (18063,1,1,7,3000,142,1641);
> INSERT INTO `TRANSACTION` VALUES (18064,8,3,9,2000,142,2929);
> INSERT INTO `TRANSACTION` VALUES (18064,9,4,8,3000,142,2929);
> INSERT INTO `TRANSACTION` VALUES (18065,4,4,1,3000,142,4718);
> INSERT INTO `TRANSACTION` VALUES (18066,5,1,3,2000,142,2615);
> INSERT INTO `TRANSACTION` VALUES (18067,2,2,1,2000,142,5265);
> INSERT INTO `TRANSACTION` VALUES (18068,9,4,7,3000,142,9178);

Attempt #3
NDB10:
[ndbdev@ndb10 run]$ ndb_mgm $ndbc -e shutdown
Connected to Management Server at: ndb10:14000
4 NDB Cluster storage node(s) have shutdown.
NDB Cluster management server shutdown.
[ndbdev@ndb10 run]$ mysql_server stop
Shutting down MySQL                                        [  OK  ]
[ndbdev@ndb10 run]$ ls
[ndbdev@ndb10 run]$ ls
BACKUP             ndb_1_out.log  ndb_2_out.log  ndb_4_out.log
config.ini         ndb_1.pid      ndb_2.pid      ndb_4.pid
ndb_1_cluster.log  ndb_2_fs       ndb_4_fs       slave_BANK.sql
[ndbdev@ndb10 run]$ rm -rf ndb*
[ndbdev@ndb10 run]$ ls
BACKUP  config.ini  slave_BANK.sql
[ndbdev@ndb10 run]$ rm slave_BANK.sql
[ndbdev@ndb10 run]$ cd ../var/
[ndbdev@ndb10 var]$ rm -rf *
[ndbdev@ndb10 var]$ ls
[ndbdev@ndb10 var]$ installdb
Installing all prepared tables
Fill help tables

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/home/ndbdev/jmiller/builds/bin/mysqladmin -u root password 'new-password'
/home/ndbdev/jmiller/builds/bin/mysqladmin -u root -h ndb10.mysql.com password 'new-password'
See the manual for more instructions.

You can start the MySQL daemon with:
cd /home/ndbdev/jmiller/builds ; /home/ndbdev/jmiller/builds/bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the /home/ndbdev/jmiller/builds/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com
[ndbdev@ndb10 var]$ ls
cluster_replication  ndb10.mysql.com.err     ndb10-relay-bin.index
master.info          ndb10-relay-bin.000001  relay-log.info
mysql                ndb10-relay-bin.000002  test

[ndbdev@ndb10 run]$ ndb_mgmd -f config.ini
Cluster configuration warning:
  arbitrator with id 1 and db node with id 2 on same host ndb10
  Running arbitrator on the same host as a database node may
  cause complete cluster shutdown in case of host failure.
[ndbdev@ndb10 run]$ ndbd -c $ndbc --initial 
[ndbdev@ndb10 run]$ ndbd -c $ndbc --initial

NDB11:
[ndbdev@ndb11 run]$
[ndbdev@ndb11 run]$ ls
ndb_3_fs  ndb_3_out.log  ndb_3.pid  ndb_5_fs  ndb_5_out.log  ndb_5.pid  zup.txt
[ndbdev@ndb11 run]$ rm -rf *
[ndbdev@ndb11 run]$ ndbd -c $ndbc --initial
[ndbdev@ndb11 run]$ ndbd -c $ndbc --initial

NDB10:
Starting MySQL                                             [  OK  ]
[ndbdev@ndb10 run]$ ndb_mgm $ndbc
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: ndb10:14000
Cluster Configuration
---------------------
[ndbd(NDB)]     4 node(s)
id=2    @10.100.1.95  (Version: 5.1.0, Nodegroup: 0, Master)
id=3    @10.100.1.96  (Version: 5.1.0, Nodegroup: 0)
id=4    @10.100.1.95  (Version: 5.1.0, Nodegroup: 1)
id=5    @10.100.1.96  (Version: 5.1.0, Nodegroup: 1)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @10.100.1.95  (Version: 5.1.0)

[mysqld(API)]   4 node(s)
id=6    @10.100.1.95  (Version: 5.1.0)
id=7 (not connected, accepting connect from ndb10)
id=8 (not connected, accepting connect from ndb11)
id=9 (not connected, accepting connect from ndb11)

ndb_mgm> exit
[ndbdev@ndb10 run]$ ndb_restore -c $ndbc -n 2 -e -m -b 1 -r ./BACKUP/BACKUP-1/ Ndb version in backup files: Version 5.1.0
Connected to ndb!!
Successfully restored table BANK/def/ACCOUNT_TYPE
Successfully restored table BANK/def/ACCOUNT_TYPES
Successfully restored table BANK/def/SYSTEM_VALUES
Successfully restored table BANK/def/TRANSACTION
Successfully restored table BANK/def/ACCOUNT
Successfully restored table BANK/def/GL
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPE(8) fragment 0
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPES(7) fragment 0
_____________________________________________________
Restoring data in table: BANK/def/SYSTEM_VALUES(6) fragment 0
_____________________________________________________
Restoring data in table: BANK/def/TRANSACTION(5) fragment 0
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT(4) fragment 0
_____________________________________________________
Restoring data in table: BANK/def/GL(3) fragment 0
_____________________________________________________
Restoring data in table: cluster_replication/def/apply_status(2) fragment 0
_____________________________________________________
Restoring data in table: sys/def/NDB$EVENTS_0(1) fragment 0
_____________________________________________________
Restoring data in table: sys/def/SYSTAB_0(0) fragment 0
Restored 310 tuples and 2392 log entries
[ndbdev@ndb10 run]$ ndb_restore -c $ndbc -n 3 -e  -b 1 -r ./BACKUP/BACKUP-1/
Ndb version in backup files: Version 5.1.0
Connected to ndb!!
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPE(8) fragment 2
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPES(7) fragment 2
_____________________________________________________
Restoring data in table: BANK/def/SYSTEM_VALUES(6) fragment 2
_____________________________________________________
Restoring data in table: BANK/def/TRANSACTION(5) fragment 2
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT(4) fragment 2
_____________________________________________________
Restoring data in table: BANK/def/GL(3) fragment 2
_____________________________________________________
Restoring data in table: cluster_replication/def/apply_status(2) fragment 2
_____________________________________________________
Restoring data in table: sys/def/NDB$EVENTS_0(1) fragment 2
_____________________________________________________
Restoring data in table: sys/def/SYSTAB_0(0) fragment 2
Restored 284 tuples and 0 log entries
[ndbdev@ndb10 run]$ ndb_restore -c $ndbc -n 4 -e  -b 1 -r ./BACKUP/BACKUP-1/
Ndb version in backup files: Version 5.1.0
Connected to ndb!!
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPE(8) fragment 1
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPES(7) fragment 1
_____________________________________________________
Restoring data in table: BANK/def/SYSTEM_VALUES(6) fragment 1
_____________________________________________________
Restoring data in table: BANK/def/TRANSACTION(5) fragment 1
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT(4) fragment 1
_____________________________________________________
Restoring data in table: BANK/def/GL(3) fragment 1
_____________________________________________________
Restoring data in table: cluster_replication/def/apply_status(2) fragment 1
_____________________________________________________
Restoring data in table: sys/def/NDB$EVENTS_0(1) fragment 1
_____________________________________________________
Restoring data in table: sys/def/SYSTAB_0(0) fragment 1
Restored 340 tuples and 0 log entries
[ndbdev@ndb10 run]$ ndb_restore -c $ndbc -n 5 -e  -b 1 -r ./BACKUP/BACKUP-1/
Ndb version in backup files: Version 5.1.0
Connected to ndb!!
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPE(8) fragment 3
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPES(7) fragment 3
_____________________________________________________
Restoring data in table: BANK/def/SYSTEM_VALUES(6) fragment 3
_____________________________________________________
Restoring data in table: BANK/def/TRANSACTION(5) fragment 3
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT(4) fragment 3
_____________________________________________________
Restoring data in table: BANK/def/GL(3) fragment 3
_____________________________________________________
Restoring data in table: cluster_replication/def/apply_status(2) fragment 3
_____________________________________________________
Restoring data in table: sys/def/NDB$EVENTS_0(1) fragment 3
_____________________________________________________
Restoring data in table: sys/def/SYSTAB_0(0) fragment 3
Restored 344 tuples and 2088 log entries
[ndbdev@ndb10 run]$ perl ../../resetslave.pl ndb08 3307 root BLANK NDB10 3306 root BLANK
        Slave Epoch =  387
        Master bin log =  master1.000003
        Master Bin Log position =  7906594
        Slave has been updated. You may now start slave.
[ndbdev@ndb10 run]$ mysql -u root 

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.1.0-a_drop5p3
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database BANK;
Query OK, 1 row affected (0.00 sec)

mysql> start slave;
Query OK, 0 rows affected (0.00 sec)
mysql> show slave status\G;
*************************** 1. row ***************************
             Slave_IO_State: Waiting for master to send event
                Master_Host: ndb08
                Master_User: rep
                Master_Port: 3307
              Connect_Retry: 1
            Master_Log_File: master1.000003
        Read_Master_Log_Pos: 22052219
             Relay_Log_File: ndb10-relay-bin.000002
              Relay_Log_Pos: 526046
      Relay_Master_Log_File: master1.000003
           Slave_IO_Running: Yes
          Slave_SQL_Running: Yes
            Replicate_Do_DB:
        Replicate_Ignore_DB:
         Replicate_Do_Table:
     Replicate_Ignore_Table:
    Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
                 Last_Errno: 0
                 Last_Error:
               Skip_Counter: 0
        Exec_Master_Log_Pos: 8432399
            Relay_Log_Space: 14145866
            Until_Condition: None
             Until_Log_File:
              Until_Log_Pos: 0
         Master_SSL_Allowed: No
         Master_SSL_CA_File:
         Master_SSL_CA_Path:
            Master_SSL_Cert:
          Master_SSL_Cipher:
             Master_SSL_Key:
      Seconds_Behind_Master: 6743
1 row in set (0.00 sec)
mysql> show slave status\G;
*************************** 1. row ***************************
             Slave_IO_State: Waiting for master to send event
                Master_Host: ndb08
                Master_User: rep
                Master_Port: 3307
              Connect_Retry: 1
            Master_Log_File: master1.000003
        Read_Master_Log_Pos: 22052219
             Relay_Log_File: ndb10-relay-bin.000002
              Relay_Log_Pos: 14145866
      Relay_Master_Log_File: master1.000003
           Slave_IO_Running: Yes
          Slave_SQL_Running: Yes
            Replicate_Do_DB:
        Replicate_Ignore_DB:
         Replicate_Do_Table:
     Replicate_Ignore_Table:
    Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
                 Last_Errno: 0
                 Last_Error:
               Skip_Counter: 0
        Exec_Master_Log_Pos: 22052219
            Relay_Log_Space: 14145866
            Until_Condition: None
             Until_Log_File:
              Until_Log_Pos: 0
         Master_SSL_Allowed: No
         Master_SSL_CA_File:
         Master_SSL_CA_Path:
            Master_SSL_Cert:
          Master_SSL_Cipher:
             Master_SSL_Key:
      Seconds_Behind_Master: 0
1 row in set (0.00 sec)

ERROR:
No query specified

mysql> exit
Bye
[ndbdev@ndb10 run]$  mysqldump --compact --order-by-primary --skip-extended-insert --no-create-info -u root BANK > slave_BANK.sql
[ndbdev@ndb10 run]$  scp slave_BANK.sql ndb08:/home/ndbdev/jmiller/builds/run/ slave_BANK.sql       100% |*****************************|   158 KB    00:00

NDB08:

ndbdev@ndb08:~/jmiller/builds/run> mysqldump --compact --order-by-primary --skip-extended-insert --no-create-info -u root BANK > master_BANK.sql
ndbdev@ndb08:~/jmiller/builds/run> diff master_BANK.sql slave_BANK.sql 706c706
< INSERT INTO `GL` VALUES (139,0,9283056,14,59731,11,53488,1);
---
> INSERT INTO `GL` VALUES (139,0,9283056,14,59731,11,53488,0);
710,711c710,711
< INSERT INTO `GL` VALUES (139,4,133959,29,142022,21,85487,1);
< INSERT INTO `GL` VALUES (140,0,9283056,0,0,0,0,1);
---
> INSERT INTO `GL` VALUES (139,4,133959,29,142022,21,85487,0);
> INSERT INTO `GL` VALUES (140,0,9283056,0,0,0,0,0);
713,715c713,715
< INSERT INTO `GL` VALUES (140,2,161882,1,4695,0,0,1);
< INSERT INTO `GL` VALUES (140,3,400172,0,0,1,4695,1);
< INSERT INTO `GL` VALUES (140,4,133959,0,0,0,0,1);
---
> INSERT INTO `GL` VALUES (140,2,161882,1,4695,0,0,0);
> INSERT INTO `GL` VALUES (140,3,400172,0,0,1,4695,0);
> INSERT INTO `GL` VALUES (140,4,133959,0,0,0,0,0);
717,721c717,720
< INSERT INTO `GL` VALUES (141,1,130752,35,161771,32,141950,1);
< INSERT INTO `GL` VALUES (141,2,152400,28,114077,32,123559,1);
< INSERT INTO `GL` VALUES (141,3,449996,30,156617,23,106793,1);
< INSERT INTO `GL` VALUES (141,4,69716,15,65898,22,130141,1);
< INSERT INTO `GL` VALUES (142,0,9267737,6,36393,10,55792,1);
---
> INSERT INTO `GL` VALUES (141,1,130752,35,161771,32,141950,0);
> INSERT INTO `GL` VALUES (141,2,152400,28,114077,32,123559,0);
> INSERT INTO `GL` VALUES (141,3,449996,30,156617,23,106793,0);
> INSERT INTO `GL` VALUES (141,4,69716,15,65898,22,130141,0);
724d722
< INSERT INTO `GL` VALUES (142,3,462656,15,80279,16,67619,1);
727d724
< INSERT INTO `GL` VALUES (143,1,123808,40,164538,40,179128,1);
729,731d725
< INSERT INTO `GL` VALUES (143,3,457043,31,134773,24,140386,1);
< INSERT INTO `GL` VALUES (143,4,147443,27,136577,19,76351,1);
< INSERT INTO `GL` VALUES (144,0,9185365,21,94744,26,132100,1);
733,735d726
< INSERT INTO `GL` VALUES (144,2,127206,54,237926,55,249705,1);
< INSERT INTO `GL` VALUES (144,3,462332,60,324697,61,319408,1);
< INSERT INTO `GL` VALUES (144,4,140451,51,235034,56,242026,1);
1967a1959,2285
> INSERT INTO `TRANSACTION` VALUES (17746,4,4,0,3000,139,3012);
> INSERT INTO `TRANSACTION` VALUES (17749,3,3,2,3000,139,9603);
> INSERT INTO `TRANSACTION` VALUES (17752,9,4,5,3000,139,2154);
> INSERT INTO `TRANSACTION` VALUES (17753,9,4,6,2000,139,8571);
> INSERT INTO `TRANSACTION` VALUES (17756,9,4,1,2000,139,4888);
> INSERT INTO `TRANSACTION` VALUES (17757,0,0,1,2000,139,3568);
> INSERT INTO `TRANSACTION` VALUES (17759,3,3,8,2000,139,7696);
> INSERT INTO `TRANSACTION` VALUES (17760,4,4,1,2000,139,1811);
> INSERT INTO `TRANSACTION` VALUES (17761,4,4,6,3000,139,6780);
> INSERT INTO `TRANSACTION` VALUES (17762,3,3,6,2000,139,4898);
> INSERT INTO `TRANSACTION` VALUES (17768,3,3,7,2000,139,6203);
> INSERT INTO `TRANSACTION` VALUES (17769,0,0,3,2000,139,7954);
> INSERT INTO `TRANSACTION` VALUES (17770,3,3,6,2000,139,8413);
> INSERT INTO `TRANSACTION` VALUES (17771,3,3,8,2000,139,4506);
> INSERT INTO `TRANSACTION` VALUES (17772,0,0,1,3000,139,3245);
> INSERT INTO `TRANSACTION` VALUES (17773,3,3,1,2000,139,1985);
> INSERT INTO `TRANSACTION` VALUES (17774,8,3,9,2000,139,9724);
> INSERT INTO `TRANSACTION` VALUES (17775,7,2,8,2000,139,4878);
> INSERT INTO `TRANSACTION` VALUES (17775,8,3,7,3000,139,4878);
> INSERT INTO `TRANSACTION` VALUES (17776,4,4,3,3000,139,6150);
> INSERT INTO `TRANSACTION` VALUES (17779,7,2,6,2000,139,7940);
> INSERT INTO `TRANSACTION` VALUES (17782,2,2,5,3000,139,8795);
> INSERT INTO `TRANSACTION` VALUES (17783,7,2,6,3000,139,3175);
> INSERT INTO `TRANSACTION` VALUES (17784,8,3,7,3000,139,8824);
> INSERT INTO `TRANSACTION` VALUES (17785,2,2,0,3000,139,8526);
> INSERT INTO `TRANSACTION` VALUES (17786,0,0,7,2000,139,975);
> INSERT INTO `TRANSACTION` VALUES (17786,7,2,0,3000,139,975);
> INSERT INTO `TRANSACTION` VALUES (17788,7,2,0,2000,139,9094);
> INSERT INTO `TRANSACTION` VALUES (17791,9,4,6,3000,139,2349);
> INSERT INTO `TRANSACTION` VALUES (17792,3,3,5,2000,139,3717);
> INSERT INTO `TRANSACTION` VALUES (17794,0,0,5,3000,139,1837);
> INSERT INTO `TRANSACTION` VALUES (17796,3,3,9,2000,139,344);
> INSERT INTO `TRANSACTION` VALUES (17796,9,4,3,3000,139,344);
> INSERT INTO `TRANSACTION` VALUES (17797,2,2,1,3000,139,6333);
> INSERT INTO `TRANSACTION` VALUES (17799,3,3,4,2000,139,4883);
> INSERT INTO `TRANSACTION` VALUES (17799,4,4,3,3000,139,4883);
> INSERT INTO `TRANSACTION` VALUES (17800,4,4,1,2000,139,7313);
> INSERT INTO `TRANSACTION` VALUES (17801,7,2,5,2000,139,7631);
> INSERT INTO `TRANSACTION` VALUES (17803,8,3,0,2000,139,3587);
> INSERT INTO `TRANSACTION` VALUES (17804,9,4,8,3000,139,8994);
> INSERT INTO `TRANSACTION` VALUES (17805,0,0,5,2000,139,5147);
> INSERT INTO `TRANSACTION` VALUES (17806,8,3,9,2000,139,6649);
> INSERT INTO `TRANSACTION` VALUES (17806,9,4,8,3000,139,6649);
> INSERT INTO `TRANSACTION` VALUES (17807,8,3,6,2000,139,5646);
> INSERT INTO `TRANSACTION` VALUES (17808,9,4,5,2000,139,2879);
> INSERT INTO `TRANSACTION` VALUES (17809,7,2,1,2000,139,5276);
> INSERT INTO `TRANSACTION` VALUES (17811,9,4,6,3000,139,5999);
> INSERT INTO `TRANSACTION` VALUES (17812,3,3,9,2000,139,1562);
> INSERT INTO `TRANSACTION` VALUES (17815,9,4,5,3000,139,305);
> INSERT INTO `TRANSACTION` VALUES (17817,2,2,1,2000,139,1158);
> INSERT INTO `TRANSACTION` VALUES (17818,9,4,8,3000,139,7393);
> INSERT INTO `TRANSACTION` VALUES (17819,3,3,5,3000,139,4846);
> INSERT INTO `TRANSACTION` VALUES (17820,0,0,5,3000,139,6594);
> INSERT INTO `TRANSACTION` VALUES (17821,7,2,2,2000,139,9925);
> INSERT INTO `TRANSACTION` VALUES (17822,9,4,1,3000,139,7227);
> INSERT INTO `TRANSACTION` VALUES (17823,4,4,2,2000,139,2865);
> INSERT INTO `TRANSACTION` VALUES (17825,0,0,4,3000,139,2610);
> INSERT INTO `TRANSACTION` VALUES (17825,4,4,0,2000,139,2610);
> INSERT INTO `TRANSACTION` VALUES (17826,2,2,1,2000,139,3319);
> INSERT INTO `TRANSACTION` VALUES (17828,4,4,5,2000,139,2304);
> INSERT INTO `TRANSACTION` VALUES (17829,2,2,8,3000,139,4089);
> INSERT INTO `TRANSACTION` VALUES (17830,4,4,3,2000,139,4888);
> INSERT INTO `TRANSACTION` VALUES (17831,0,0,9,3000,139,4272);
> INSERT INTO `TRANSACTION` VALUES (17833,9,4,6,2000,139,7987);
> INSERT INTO `TRANSACTION` VALUES (17835,2,2,3,2000,139,2211);
> INSERT INTO `TRANSACTION` VALUES (17835,3,3,2,3000,139,2211);
> INSERT INTO `TRANSACTION` VALUES (17837,0,0,1,3000,139,8956);
> INSERT INTO `TRANSACTION` VALUES (17839,9,4,0,2000,139,149);
> INSERT INTO `TRANSACTION` VALUES (17841,2,2,8,3000,139,9838);
> INSERT INTO `TRANSACTION` VALUES (17841,8,3,2,2000,139,9838);
> INSERT INTO `TRANSACTION` VALUES (17842,9,4,8,3000,139,2739);
> INSERT INTO `TRANSACTION` VALUES (17843,9,4,5,2000,139,3985);
> INSERT INTO `TRANSACTION` VALUES (17846,8,3,1,3000,139,4529);
> INSERT INTO `TRANSACTION` VALUES (17847,8,3,1,2000,139,4049);
> INSERT INTO `TRANSACTION` VALUES (17849,8,3,9,2000,139,9813);
> INSERT INTO `TRANSACTION` VALUES (17849,9,4,8,3000,139,9813);
> INSERT INTO `TRANSACTION` VALUES (17850,3,3,7,3000,139,8129);
> INSERT INTO `TRANSACTION` VALUES (17851,8,3,2,2000,139,2513);
> INSERT INTO `TRANSACTION` VALUES (17852,7,2,8,2000,139,5741);
> INSERT INTO `TRANSACTION` VALUES (17852,8,3,7,3000,139,5741);
> INSERT INTO `TRANSACTION` VALUES (17853,3,3,8,3000,139,6737);
> INSERT INTO `TRANSACTION` VALUES (17853,8,3,3,2000,139,6737);
> INSERT INTO `TRANSACTION` VALUES (17854,3,3,4,2000,139,805);
> INSERT INTO `TRANSACTION` VALUES (17855,4,4,2,2000,139,6330);
> INSERT INTO `TRANSACTION` VALUES (17857,3,3,8,2000,139,2943);
> INSERT INTO `TRANSACTION` VALUES (17857,8,3,3,3000,139,2943);
> INSERT INTO `TRANSACTION` VALUES (17859,7,2,6,3000,139,8088);
> INSERT INTO `TRANSACTION` VALUES (17861,7,2,9,3000,139,6970);
> INSERT INTO `TRANSACTION` VALUES (17862,2,2,5,3000,139,9826);
> INSERT INTO `TRANSACTION` VALUES (17864,3,3,5,2000,139,7447);
> INSERT INTO `TRANSACTION` VALUES (17865,3,3,7,2000,139,1885);
> INSERT INTO `TRANSACTION` VALUES (17866,2,2,1,3000,139,4513);
> INSERT INTO `TRANSACTION` VALUES (17870,3,3,0,3000,139,6365);
> INSERT INTO `TRANSACTION` VALUES (17873,2,2,5,2000,139,3942);
> INSERT INTO `TRANSACTION` VALUES (17874,4,4,1,2000,139,4091);
> INSERT INTO `TRANSACTION` VALUES (17875,8,3,7,3000,139,9801);
> INSERT INTO `TRANSACTION` VALUES (17876,3,3,5,3000,139,5319);
> INSERT INTO `TRANSACTION` VALUES (17879,0,0,9,2000,139,1720);
> INSERT INTO `TRANSACTION` VALUES (17879,9,4,0,3000,139,1720);
> INSERT INTO `TRANSACTION` VALUES (17880,0,0,7,3000,139,457);
> INSERT INTO `TRANSACTION` VALUES (17882,0,0,3,3000,139,7504);
> INSERT INTO `TRANSACTION` VALUES (17883,3,3,7,2000,139,8827);
> INSERT INTO `TRANSACTION` VALUES (17884,3,3,7,2000,140,4695);
> INSERT INTO `TRANSACTION` VALUES (17884,7,2,3,3000,140,4695);
> INSERT INTO `TRANSACTION` VALUES (17886,6,1,7,3000,141,1102);
> INSERT INTO `TRANSACTION` VALUES (17886,7,2,6,2000,141,1102);
> INSERT INTO `TRANSACTION` VALUES (17887,5,1,8,2000,141,139);
> INSERT INTO `TRANSACTION` VALUES (17888,8,3,1,2000,141,5969);
> INSERT INTO `TRANSACTION` VALUES (17890,2,2,4,2000,141,3574);
> INSERT INTO `TRANSACTION` VALUES (17891,3,3,8,2000,141,8083);
> INSERT INTO `TRANSACTION` VALUES (17892,8,3,0,3000,141,7947);
> INSERT INTO `TRANSACTION` VALUES (17893,1,1,5,3000,141,2578);
> INSERT INTO `TRANSACTION` VALUES (17893,5,1,1,2000,141,2578);
> INSERT INTO `TRANSACTION` VALUES (17894,7,2,8,2000,141,779);
> INSERT INTO `TRANSACTION` VALUES (17896,0,0,5,2000,141,6088);
> INSERT INTO `TRANSACTION` VALUES (17896,5,1,0,3000,141,6088);
> INSERT INTO `TRANSACTION` VALUES (17897,7,2,1,3000,141,4814);
> INSERT INTO `TRANSACTION` VALUES (17898,5,1,8,2000,141,8959);
> INSERT INTO `TRANSACTION` VALUES (17899,6,1,1,3000,141,630);
> INSERT INTO `TRANSACTION` VALUES (17900,2,2,7,3000,141,889);
> INSERT INTO `TRANSACTION` VALUES (17900,7,2,2,2000,141,889);
> INSERT INTO `TRANSACTION` VALUES (17901,1,1,7,2000,141,2081);
> INSERT INTO `TRANSACTION` VALUES (17902,6,1,7,3000,141,6502);
> INSERT INTO `TRANSACTION` VALUES (17902,7,2,6,2000,141,6502);
> INSERT INTO `TRANSACTION` VALUES (17903,1,1,8,3000,141,2325);
> INSERT INTO `TRANSACTION` VALUES (17903,8,3,1,2000,141,2325);
> INSERT INTO `TRANSACTION` VALUES (17904,8,3,9,2000,141,3137);
> INSERT INTO `TRANSACTION` VALUES (17906,9,4,3,2000,141,9168);
> INSERT INTO `TRANSACTION` VALUES (17907,9,4,1,2000,141,4119);
> INSERT INTO `TRANSACTION` VALUES (17909,0,0,5,3000,141,7395);
> INSERT INTO `TRANSACTION` VALUES (17910,3,3,7,3000,141,3442);
> INSERT INTO `TRANSACTION` VALUES (17911,3,3,7,2000,141,85);
> INSERT INTO `TRANSACTION` VALUES (17911,7,2,3,3000,141,85);
> INSERT INTO `TRANSACTION` VALUES (17912,7,2,6,2000,141,4161);
> INSERT INTO `TRANSACTION` VALUES (17913,8,3,9,2000,141,2759);
> INSERT INTO `TRANSACTION` VALUES (17913,9,4,8,3000,141,2759);
> INSERT INTO `TRANSACTION` VALUES (17914,1,1,7,3000,141,1086);
> INSERT INTO `TRANSACTION` VALUES (17914,7,2,1,2000,141,1086);
> INSERT INTO `TRANSACTION` VALUES (17915,6,1,7,2000,141,4395);
> INSERT INTO `TRANSACTION` VALUES (17917,8,3,9,3000,141,2444);
> INSERT INTO `TRANSACTION` VALUES (17917,9,4,8,2000,141,2444);
> INSERT INTO `TRANSACTION` VALUES (17918,4,4,1,2000,141,8933);
> INSERT INTO `TRANSACTION` VALUES (17919,8,3,1,2000,141,3602);
> INSERT INTO `TRANSACTION` VALUES (17920,3,3,5,2000,141,5597);
> INSERT INTO `TRANSACTION` VALUES (17920,5,1,3,3000,141,5597);
> INSERT INTO `TRANSACTION` VALUES (17922,4,4,8,2000,141,7771);
> INSERT INTO `TRANSACTION` VALUES (17922,8,3,4,3000,141,7771);
> INSERT INTO `TRANSACTION` VALUES (17923,9,4,8,3000,141,1829);
> INSERT INTO `TRANSACTION` VALUES (17924,7,2,1,3000,141,431);
> INSERT INTO `TRANSACTION` VALUES (17926,9,4,6,2000,141,9794);
> INSERT INTO `TRANSACTION` VALUES (17927,7,2,5,3000,141,8046);
> INSERT INTO `TRANSACTION` VALUES (17928,7,2,2,2000,141,2871);
> INSERT INTO `TRANSACTION` VALUES (17929,3,3,9,3000,141,2982);
> INSERT INTO `TRANSACTION` VALUES (17930,7,2,8,3000,141,5724);
> INSERT INTO `TRANSACTION` VALUES (17930,8,3,7,2000,141,5724);
> INSERT INTO `TRANSACTION` VALUES (17931,1,1,2,2000,141,5049);
> INSERT INTO `TRANSACTION` VALUES (17931,2,2,1,3000,141,5049);
> INSERT INTO `TRANSACTION` VALUES (17932,8,3,9,2000,141,7976);
> INSERT INTO `TRANSACTION` VALUES (17934,3,3,9,3000,141,3036);
> INSERT INTO `TRANSACTION` VALUES (17934,9,4,3,2000,141,3036);
> INSERT INTO `TRANSACTION` VALUES (17936,7,2,6,3000,141,7956);
> INSERT INTO `TRANSACTION` VALUES (17937,8,3,0,2000,141,2105);
> INSERT INTO `TRANSACTION` VALUES (17938,2,2,4,2000,141,773);
> INSERT INTO `TRANSACTION` VALUES (17939,2,2,6,3000,141,2940);
> INSERT INTO `TRANSACTION` VALUES (17940,0,0,4,3000,141,9822);
> INSERT INTO `TRANSACTION` VALUES (17940,4,4,0,2000,141,9822);
> INSERT INTO `TRANSACTION` VALUES (17942,3,3,9,3000,141,6104);
> INSERT INTO `TRANSACTION` VALUES (17942,9,4,3,2000,141,6104);
> INSERT INTO `TRANSACTION` VALUES (17943,6,1,8,3000,141,4281);
> INSERT INTO `TRANSACTION` VALUES (17943,8,3,6,2000,141,4281);
> INSERT INTO `TRANSACTION` VALUES (17944,3,3,6,3000,141,1032);
> INSERT INTO `TRANSACTION` VALUES (17944,6,1,3,2000,141,1032);
> INSERT INTO `TRANSACTION` VALUES (17945,4,4,8,2000,141,9130);
> INSERT INTO `TRANSACTION` VALUES (17945,8,3,4,3000,141,9130);
> INSERT INTO `TRANSACTION` VALUES (17947,9,4,6,2000,141,9441);
> INSERT INTO `TRANSACTION` VALUES (17948,4,4,6,2000,141,1381);
> INSERT INTO `TRANSACTION` VALUES (17949,3,3,7,3000,141,3356);
> INSERT INTO `TRANSACTION` VALUES (17949,7,2,3,2000,141,3356);
> INSERT INTO `TRANSACTION` VALUES (17950,1,1,3,3000,141,7787);
> INSERT INTO `TRANSACTION` VALUES (17951,0,0,4,3000,141,8623);
> INSERT INTO `TRANSACTION` VALUES (17952,0,0,2,2000,141,6327);
> INSERT INTO `TRANSACTION` VALUES (17952,2,2,0,3000,141,6327);
> INSERT INTO `TRANSACTION` VALUES (17953,2,2,8,2000,141,8508);
> INSERT INTO `TRANSACTION` VALUES (17953,8,3,2,3000,141,8508);
> INSERT INTO `TRANSACTION` VALUES (17956,5,1,7,2000,141,1697);
> INSERT INTO `TRANSACTION` VALUES (17956,7,2,5,3000,141,1697);
> INSERT INTO `TRANSACTION` VALUES (17957,6,1,5,3000,141,3846);
> INSERT INTO `TRANSACTION` VALUES (17959,6,1,8,3000,141,3365);
> INSERT INTO `TRANSACTION` VALUES (17960,3,3,7,3000,141,1253);
> INSERT INTO `TRANSACTION` VALUES (17960,7,2,3,2000,141,1253);
> INSERT INTO `TRANSACTION` VALUES (17961,4,4,6,2000,141,7508);
> INSERT INTO `TRANSACTION` VALUES (17961,6,1,4,3000,141,7508);
> INSERT INTO `TRANSACTION` VALUES (17963,8,3,0,3000,141,4195);
> INSERT INTO `TRANSACTION` VALUES (17964,5,1,2,2000,141,4677);
> INSERT INTO `TRANSACTION` VALUES (17965,2,2,6,3000,141,784);
> INSERT INTO `TRANSACTION` VALUES (17965,6,1,2,2000,141,784);
> INSERT INTO `TRANSACTION` VALUES (17966,7,2,0,3000,141,9009);
> INSERT INTO `TRANSACTION` VALUES (17968,9,4,7,2000,141,2421);
> INSERT INTO `TRANSACTION` VALUES (17969,1,1,3,3000,141,661);
> INSERT INTO `TRANSACTION` VALUES (17970,4,4,3,2000,141,936);
> INSERT INTO `TRANSACTION` VALUES (17971,1,1,7,2000,141,23);
> INSERT INTO `TRANSACTION` VALUES (17972,4,4,2,3000,141,1767);
> INSERT INTO `TRANSACTION` VALUES (17973,5,1,1,3000,141,4445);
> INSERT INTO `TRANSACTION` VALUES (17974,1,1,8,3000,141,2109);
> INSERT INTO `TRANSACTION` VALUES (17974,8,3,1,2000,141,2109);
> INSERT INTO `TRANSACTION` VALUES (17975,6,1,7,2000,141,6595);
> INSERT INTO `TRANSACTION` VALUES (17975,7,2,6,3000,141,6595);
> INSERT INTO `TRANSACTION` VALUES (17976,4,4,7,3000,141,365);
> INSERT INTO `TRANSACTION` VALUES (17976,7,2,4,2000,141,365);
> INSERT INTO `TRANSACTION` VALUES (17977,0,0,3,2000,141,9731);
> INSERT INTO `TRANSACTION` VALUES (17977,3,3,0,3000,141,9731);
> INSERT INTO `TRANSACTION` VALUES (17978,6,1,5,3000,141,3412);
> INSERT INTO `TRANSACTION` VALUES (17979,3,3,4,2000,141,5294);
> INSERT INTO `TRANSACTION` VALUES (17979,4,4,3,3000,141,5294);
> INSERT INTO `TRANSACTION` VALUES (17980,3,3,8,2000,141,4234);
> INSERT INTO `TRANSACTION` VALUES (17980,8,3,3,3000,141,4234);
> INSERT INTO `TRANSACTION` VALUES (17982,8,3,7,3000,141,7263);
> INSERT INTO `TRANSACTION` VALUES (17983,4,4,1,2000,141,7667);
> INSERT INTO `TRANSACTION` VALUES (17984,2,2,7,2000,141,6672);
> INSERT INTO `TRANSACTION` VALUES (17984,7,2,2,3000,141,6672);
> INSERT INTO `TRANSACTION` VALUES (17985,7,2,9,3000,141,3859);
> INSERT INTO `TRANSACTION` VALUES (17985,9,4,7,2000,141,3859);
> INSERT INTO `TRANSACTION` VALUES (17986,4,4,8,3000,141,9633);
> INSERT INTO `TRANSACTION` VALUES (17988,7,2,5,2000,141,2305);
> INSERT INTO `TRANSACTION` VALUES (17989,5,1,7,3000,141,9138);
> INSERT INTO `TRANSACTION` VALUES (17989,7,2,5,2000,141,9138);
> INSERT INTO `TRANSACTION` VALUES (17990,5,1,4,2000,141,7387);
> INSERT INTO `TRANSACTION` VALUES (17991,2,2,0,2000,141,2019);
> INSERT INTO `TRANSACTION` VALUES (17992,9,4,8,3000,141,8881);
> INSERT INTO `TRANSACTION` VALUES (17993,8,3,2,3000,141,7928);
> INSERT INTO `TRANSACTION` VALUES (17994,1,1,2,3000,141,8529);
> INSERT INTO `TRANSACTION` VALUES (17995,3,3,2,2000,141,6819);
> INSERT INTO `TRANSACTION` VALUES (17996,2,2,7,3000,141,4050);
> INSERT INTO `TRANSACTION` VALUES (17996,7,2,2,2000,141,4050);
> INSERT INTO `TRANSACTION` VALUES (17998,2,2,7,3000,141,293);
> INSERT INTO `TRANSACTION` VALUES (17998,7,2,2,2000,141,293);
> INSERT INTO `TRANSACTION` VALUES (17999,7,2,8,2000,141,8887);
> INSERT INTO `TRANSACTION` VALUES (17999,8,3,7,3000,141,8887);
> INSERT INTO `TRANSACTION` VALUES (18000,6,1,4,2000,141,6853);
> INSERT INTO `TRANSACTION` VALUES (18001,2,2,8,2000,142,39);
> INSERT INTO `TRANSACTION` VALUES (18001,8,3,2,3000,142,39);
> INSERT INTO `TRANSACTION` VALUES (18002,4,4,8,3000,142,713);
> INSERT INTO `TRANSACTION` VALUES (18003,5,1,3,3000,142,5801);
> INSERT INTO `TRANSACTION` VALUES (18004,0,0,9,2000,142,3807);
> INSERT INTO `TRANSACTION` VALUES (18004,9,4,0,3000,142,3807);
> INSERT INTO `TRANSACTION` VALUES (18005,5,1,7,2000,142,4196);
> INSERT INTO `TRANSACTION` VALUES (18005,7,2,5,3000,142,4196);
> INSERT INTO `TRANSACTION` VALUES (18008,3,3,4,2000,142,4193);
> INSERT INTO `TRANSACTION` VALUES (18008,4,4,3,3000,142,4193);
> INSERT INTO `TRANSACTION` VALUES (18009,0,0,8,3000,142,5571);
> INSERT INTO `TRANSACTION` VALUES (18009,8,3,0,2000,142,5571);
> INSERT INTO `TRANSACTION` VALUES (18010,4,4,0,2000,142,4701);
> INSERT INTO `TRANSACTION` VALUES (18011,0,0,1,3000,142,9650);
> INSERT INTO `TRANSACTION` VALUES (18014,0,0,9,3000,142,4626);
> INSERT INTO `TRANSACTION` VALUES (18014,9,4,0,2000,142,4626);
> INSERT INTO `TRANSACTION` VALUES (18015,9,4,5,2000,142,3485);
> INSERT INTO `TRANSACTION` VALUES (18016,5,1,7,2000,142,2087);
> INSERT INTO `TRANSACTION` VALUES (18016,7,2,5,3000,142,2087);
> INSERT INTO `TRANSACTION` VALUES (18017,5,1,7,3000,142,9408);
> INSERT INTO `TRANSACTION` VALUES (18017,7,2,5,2000,142,9408);
> INSERT INTO `TRANSACTION` VALUES (18018,2,2,6,3000,142,945);
> INSERT INTO `TRANSACTION` VALUES (18018,6,1,2,2000,142,945);
> INSERT INTO `TRANSACTION` VALUES (18019,1,1,8,3000,142,4401);
> INSERT INTO `TRANSACTION` VALUES (18019,8,3,1,2000,142,4401);
> INSERT INTO `TRANSACTION` VALUES (18020,1,1,0,3000,142,4176);
> INSERT INTO `TRANSACTION` VALUES (18021,2,2,3,2000,142,7764);
> INSERT INTO `TRANSACTION` VALUES (18022,6,1,7,2000,142,2973);
> INSERT INTO `TRANSACTION` VALUES (18023,2,2,8,3000,142,5879);
> INSERT INTO `TRANSACTION` VALUES (18024,6,1,5,3000,142,1852);
> INSERT INTO `TRANSACTION` VALUES (18025,9,4,6,3000,142,7331);
> INSERT INTO `TRANSACTION` VALUES (18026,3,3,5,3000,142,7385);
> INSERT INTO `TRANSACTION` VALUES (18027,2,2,8,3000,142,2026);
> INSERT INTO `TRANSACTION` VALUES (18027,8,3,2,2000,142,2026);
> INSERT INTO `TRANSACTION` VALUES (18028,3,3,7,2000,142,7484);
> INSERT INTO `TRANSACTION` VALUES (18028,7,2,3,3000,142,7484);
> INSERT INTO `TRANSACTION` VALUES (18029,6,1,0,3000,142,5321);
> INSERT INTO `TRANSACTION` VALUES (18030,3,3,2,3000,142,6199);
> INSERT INTO `TRANSACTION` VALUES (18031,3,3,4,2000,142,5957);
> INSERT INTO `TRANSACTION` VALUES (18032,2,2,8,2000,142,5172);
> INSERT INTO `TRANSACTION` VALUES (18032,8,3,2,3000,142,5172);
> INSERT INTO `TRANSACTION` VALUES (18033,2,2,6,2000,142,4879);
> INSERT INTO `TRANSACTION` VALUES (18033,6,1,2,3000,142,4879);
> INSERT INTO `TRANSACTION` VALUES (18034,6,1,5,3000,142,3625);
> INSERT INTO `TRANSACTION` VALUES (18035,2,2,7,3000,142,4402);
> INSERT INTO `TRANSACTION` VALUES (18035,7,2,2,2000,142,4402);
> INSERT INTO `TRANSACTION` VALUES (18036,0,0,7,3000,142,8565);
> INSERT INTO `TRANSACTION` VALUES (18038,4,4,9,2000,142,3714);
> INSERT INTO `TRANSACTION` VALUES (18038,9,4,4,3000,142,3714);
> INSERT INTO `TRANSACTION` VALUES (18039,2,2,8,3000,142,2203);
> INSERT INTO `TRANSACTION` VALUES (18039,8,3,2,2000,142,2203);
> INSERT INTO `TRANSACTION` VALUES (18040,7,2,8,2000,142,3299);
> INSERT INTO `TRANSACTION` VALUES (18040,8,3,7,3000,142,3299);
> INSERT INTO `TRANSACTION` VALUES (18042,0,0,2,2000,142,277);
> INSERT INTO `TRANSACTION` VALUES (18043,0,0,2,2000,142,5484);
> INSERT INTO `TRANSACTION` VALUES (18043,2,2,0,3000,142,5484);
> INSERT INTO `TRANSACTION` VALUES (18044,6,1,7,3000,142,1455);
> INSERT INTO `TRANSACTION` VALUES (18044,7,2,6,2000,142,1455);
> INSERT INTO `TRANSACTION` VALUES (18045,6,1,8,3000,142,3809);
> INSERT INTO `TRANSACTION` VALUES (18045,8,3,6,2000,142,3809);
> INSERT INTO `TRANSACTION` VALUES (18046,6,1,7,2000,142,5539);
> INSERT INTO `TRANSACTION` VALUES (18046,7,2,6,3000,142,5539);
> INSERT INTO `TRANSACTION` VALUES (18047,0,0,2,2000,142,8974);
> INSERT INTO `TRANSACTION` VALUES (18047,2,2,0,3000,142,8974);
> INSERT INTO `TRANSACTION` VALUES (18048,0,0,5,2000,142,3820);
> INSERT INTO `TRANSACTION` VALUES (18048,5,1,0,3000,142,3820);
> INSERT INTO `TRANSACTION` VALUES (18049,5,1,8,3000,142,2820);
> INSERT INTO `TRANSACTION` VALUES (18049,8,3,5,2000,142,2820);
> INSERT INTO `TRANSACTION` VALUES (18050,6,1,3,2000,142,8816);
> INSERT INTO `TRANSACTION` VALUES (18051,9,4,2,2000,142,813);
> INSERT INTO `TRANSACTION` VALUES (18052,8,3,3,2000,142,5790);
> INSERT INTO `TRANSACTION` VALUES (18053,2,2,9,2000,142,380);
> INSERT INTO `TRANSACTION` VALUES (18053,9,4,2,3000,142,380);
> INSERT INTO `TRANSACTION` VALUES (18054,6,1,7,3000,142,1982);
> INSERT INTO `TRANSACTION` VALUES (18055,1,1,2,2000,142,1185);
> INSERT INTO `TRANSACTION` VALUES (18055,2,2,1,3000,142,1185);
> INSERT INTO `TRANSACTION` VALUES (18057,4,4,6,2000,142,5860);
> INSERT INTO `TRANSACTION` VALUES (18058,7,2,8,2000,142,9184);
> INSERT INTO `TRANSACTION` VALUES (18058,8,3,7,3000,142,9184);
> INSERT INTO `TRANSACTION` VALUES (18060,5,1,4,3000,142,853);
> INSERT INTO `TRANSACTION` VALUES (18061,6,1,8,3000,142,1719);
> INSERT INTO `TRANSACTION` VALUES (18063,1,1,7,3000,142,1641);
> INSERT INTO `TRANSACTION` VALUES (18064,8,3,9,2000,142,2929);
> INSERT INTO `TRANSACTION` VALUES (18064,9,4,8,3000,142,2929);
> INSERT INTO `TRANSACTION` VALUES (18065,4,4,1,3000,142,4718);
> INSERT INTO `TRANSACTION` VALUES (18066,5,1,3,2000,142,2615);
> INSERT INTO `TRANSACTION` VALUES (18067,2,2,1,2000,142,5265);
> INSERT INTO `TRANSACTION` VALUES (18068,9,4,7,3000,142,9178);

Suggested fix:
Ensure that no data is lost or added starting slave from master cluster backup.

Currently unable to recreate with current clone. If I find this again in later testing, I will reopen this bug report.

Have reproduced with the follwing configuration:
Master: NDB08 (with NDB07 & NDB09)
3 computers 2 data nodes each for total == 6 data nodes.
Each systems has a ndb_mgmd for a total == 3 ndb_mgmd processes
Each systems has a MySQLD for a total == 3 MySQLD processes

Slave: NDB10 (with NDB11 & NDB12)
3 computers 2 data nodes each for total == 6 data nodes.
Each systems has a ndb_mgmd for a total == 3 ndb_mgmd processes
Each systems has a MySQLD for a total == 3 MySQLD processes

The BANK test is started and allowed to run for a while. On another system ndbtest (sabre) table create and data load is started. Once the ndbtest finished loading the data a cluster backup is started with the BANK test still running.

What is found is that the backup does no contain all data for the logs and data. That the number of logs and data stated as dumped by the backup is not what is restored.

Notice file size and rows restored for node 5 & 7 log.

2005-07-21 17:48:09 [MgmSrvr] INFO     -- Node 4: Backup 1 started from node 1
completed
 StartGCP: 1874 StopGCP: 1890
 #Records: 5006057 #LogRecords: 4223
 Data: 580146832 bytes Log: 197588 bytes

total 567444
-rw-r-----    1 ndbdev   ndbdev   72472068 Jul 21 20:35 BACKUP-1-0.4.Data
-rw-r-----    1 ndbdev   ndbdev   145089144 Jul 21 20:36 BACKUP-1-0.5.Data
-rw-r-----    1 ndbdev   ndbdev   72494380 Jul 21 20:36 BACKUP-1-0.6.Data
-rw-r-----    1 ndbdev   ndbdev   72573616 Jul 21 20:35 BACKUP-1-0.7.Data
-rw-r-----    1 ndbdev   ndbdev   145047164 Jul 21 20:36 BACKUP-1-0.8.Data
-rw-r-----    1 ndbdev   ndbdev   72472380 Jul 21 20:35 BACKUP-1-0.9.Data
-rw-r-----    1 ndbdev   ndbdev      11864 Jul 21 20:35 BACKUP-1.4.ctl
-rw-r-----    1 ndbdev   ndbdev      79444 Jul 21 20:35 BACKUP-1.4.log
-rw-r-----    1 ndbdev   ndbdev      11864 Jul 21 20:36 BACKUP-1.5.ctl
-rw-r-----    1 ndbdev   ndbdev         44 Jul 21 20:36 BACKUP-1.5.log
-rw-r-----    1 ndbdev   ndbdev      11864 Jul 21 20:35 BACKUP-1.6.ctl
-rw-r-----    1 ndbdev   ndbdev      60408 Jul 21 20:35 BACKUP-1.6.log
-rw-r-----    1 ndbdev   ndbdev      11864 Jul 21 20:35 BACKUP-1.7.ctl
-rw-r-----    1 ndbdev   ndbdev         44 Jul 21 20:35 BACKUP-1.7.log
-rw-r-----    1 ndbdev   ndbdev      11864 Jul 21 20:35 BACKUP-1.8.ctl
-rw-r-----    1 ndbdev   ndbdev      20432 Jul 21 20:36 BACKUP-1.8.log
-rw-r-----    1 ndbdev   ndbdev      11864 Jul 21 20:35 BACKUP-1.9.ctl
-rw-r-----    1 ndbdev   ndbdev      37480 Jul 21 20:36 BACKUP-1.9.log

[ndb10 run]$ ndb_restore -c $ndbc -n 4 -m -e -b 1 -r ./BACKUP/BACKUP-1/ Ndb version in backup files: Version 5.1.0
Connected to ndb!!
Successfully restored table atae/def/dcacache
Successfully restored table event REPL$atae/dcacache
Successfully restored table BANK/def/ACCOUNT_TYPE
Successfully restored table BANK/def/ACCOUNT_TYPES
Successfully restored table event REPL$BANK/ACCOUNT_TYPES
Successfully restored table BANK/def/SYSTEM_VALUES
Successfully restored table event REPL$BANK/SYSTEM_VALUES
Successfully restored table BANK/def/TRANSACTION
Successfully restored table event REPL$BANK/TRANSACTION
Successfully restored table BANK/def/ACCOUNT
Successfully restored table event REPL$BANK/ACCOUNT
Successfully restored table BANK/def/GL
Successfully restored table event REPL$BANK/GL
Successfully created index PRIMARY on dcacache
_____________________________________________________
Restoring data in table: atae/def/dcacache(9) fragment 0
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPE(8) fragment 0
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPES(7) fragment 0
_____________________________________________________
Restoring data in table: BANK/def/SYSTEM_VALUES(6) fragment 0
_____________________________________________________
Restoring data in table: BANK/def/TRANSACTION(5) fragment 0
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT(4) fragment 0
_____________________________________________________
Restoring data in table: BANK/def/GL(3) fragment 0
_____________________________________________________
Restoring data in table: cluster_replication/def/apply_status(2) fragment 0
_____________________________________________________
Restoring data in table: sys/def/NDB$EVENTS_0(1) fragment 0
_____________________________________________________
Restoring data in table: sys/def/SYSTAB_0(0) fragment 0
Restored 624840 tuples and 1611 log entries
[ndb10 run]$ ndb_restore -c $ndbc -n 5 -e -b 1 -r ./BACKUP/BACKUP-1/
Ndb version in backup files: Version 5.1.0
Connected to ndb!!
_____________________________________________________
Restoring data in table: atae/def/dcacache(9) fragment 3
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPE(8) fragment 3
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPES(7) fragment 3
_____________________________________________________
Restoring data in table: BANK/def/SYSTEM_VALUES(6) fragment 3
_____________________________________________________
Restoring data in table: BANK/def/TRANSACTION(5) fragment 3
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT(4) fragment 3
_____________________________________________________
Restoring data in table: BANK/def/GL(3) fragment 3
_____________________________________________________
Restoring data in table: cluster_replication/def/apply_status(2) fragment 3
_____________________________________________________
Restoring data in table: sys/def/NDB$EVENTS_0(1) fragment 3
_____________________________________________________
Restoring data in table: sys/def/SYSTAB_0(0) fragment 3
Restored 1250938 tuples and 0 log entries
[ndb10 run]$ ndb_restore -c $ndbc -n 6 -e -b 1 -r ./BACKUP/BACKUP-1/
Ndb version in backup files: Version 5.1.0
Connected to ndb!!
_____________________________________________________
Restoring data in table: atae/def/dcacache(9) fragment 1
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPE(8) fragment 1
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPES(7) fragment 1
_____________________________________________________
Restoring data in table: BANK/def/SYSTEM_VALUES(6) fragment 1
_____________________________________________________
Restoring data in table: BANK/def/TRANSACTION(5) fragment 1
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT(4) fragment 1
_____________________________________________________
Restoring data in table: BANK/def/GL(3) fragment 1
_____________________________________________________
Restoring data in table: cluster_replication/def/apply_status(2) fragment 1
_____________________________________________________
Restoring data in table: sys/def/NDB$EVENTS_0(1) fragment 1
_____________________________________________________
Restoring data in table: sys/def/SYSTAB_0(0) fragment 1
Restored 625023 tuples and 1618 log entries
[ndb10 run]$ ndb_restore -c $ndbc -n 7 -e -b 1 -r ./BACKUP/BACKUP-1/
Ndb version in backup files: Version 5.1.0
Connected to ndb!!
_____________________________________________________
Restoring data in table: atae/def/dcacache(9) fragment 4
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPE(8) fragment 4
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPES(7) fragment 4
_____________________________________________________
Restoring data in table: BANK/def/SYSTEM_VALUES(6) fragment 4
_____________________________________________________
Restoring data in table: BANK/def/TRANSACTION(5) fragment 4
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT(4) fragment 4
_____________________________________________________
Restoring data in table: BANK/def/GL(3) fragment 4
_____________________________________________________
Restoring data in table: cluster_replication/def/apply_status(2) fragment 4
_____________________________________________________
Restoring data in table: sys/def/NDB$EVENTS_0(1) fragment 4
_____________________________________________________
Restoring data in table: sys/def/SYSTAB_0(0) fragment 4
Restored 625722 tuples and 0 log entries
[ndb10 run]$ ndb_restore -c $ndbc -n 8 -e -b 1 -r ./BACKUP/BACKUP-1/
Ndb version in backup files: Version 5.1.0
Connected to ndb!!
_____________________________________________________
Restoring data in table: atae/def/dcacache(9) fragment 2
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPE(8) fragment 2
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPES(7) fragment 2
_____________________________________________________
Restoring data in table: BANK/def/SYSTEM_VALUES(6) fragment 2
_____________________________________________________
Restoring data in table: BANK/def/TRANSACTION(5) fragment 2
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT(4) fragment 2
_____________________________________________________
Restoring data in table: BANK/def/GL(3) fragment 2
_____________________________________________________
Restoring data in table: cluster_replication/def/apply_status(2) fragment 2
_____________________________________________________
Restoring data in table: sys/def/NDB$EVENTS_0(1) fragment 2
_____________________________________________________
Restoring data in table: sys/def/SYSTAB_0(0) fragment 2
Restored 1250569 tuples and 321 log entries
[ndb10 run]$ ndb_restore -c $ndbc -n 9 -e -b 1 -r ./BACKUP/BACKUP-1/
Ndb version in backup files: Version 5.1.0
Connected to ndb!!
_____________________________________________________
Restoring data in table: atae/def/dcacache(9) fragment 5
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPE(8) fragment 5
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT_TYPES(7) fragment 5
_____________________________________________________
Restoring data in table: BANK/def/SYSTEM_VALUES(6) fragment 5
_____________________________________________________
Restoring data in table: BANK/def/TRANSACTION(5) fragment 5
_____________________________________________________
Restoring data in table: BANK/def/ACCOUNT(4) fragment 5
_____________________________________________________
Restoring data in table: BANK/def/GL(3) fragment 5
_____________________________________________________
Restoring data in table: cluster_replication/def/apply_status(2) fragment 5
_____________________________________________________
Restoring data in table: sys/def/NDB$EVENTS_0(1) fragment 5
_____________________________________________________
Restoring data in table: sys/def/SYSTAB_0(0) fragment 5
Restored 624860 tuples and 595 log entries

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/internals/27464

Pushed into 5.0.11

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 bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Documented bugfix for 5.0.11.