MySQL Bugs: #11674: epoch may not be applied correctly on slave from ndb

Bug #11674	epoch may not be applied correctly on slave from ndb_restore
Submitted:	30 Jun 2005 17:22	Modified:	1 Jul 2005 13:05
Reporter:	Jonathan Miller	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S2 (Serious)
Version:	5.1.0-wl2325-wl1354-new	OS:	Linux (Linux)
Assigned to:	Martin Skold	CPU Architecture:	Any

Description:
I noticed that my data from the slave did not match the data on the master from my slave failure testing yesterday. 
I wanted to ensure that the data would match if I did not have a slave failure during the catch-up phase after completeing a restore on the slave from a master backup, so I cleaned up all the cluster and mysqld file systems to start from scratch. 
I started the BANK application against the master and let it run while I cleaned up the slave system. Once the slave was cleaned and up, I did a ndb_mgm -e "start backup" on the master. Copied and applied the backup to the slave. I did not start the slave process for another 5 minutes. I then stopped the BANK application and started the slave process to let it catchup with the master.
Once the slave was finish processing the masters bin log, I mysqldump both the master and slave and compared. There where records in one that was not the other. I decided to drop the database on the slave, restore and try to let it reprocess again to ensure that I recieved the same issue. 
When I ran the resetslave.pl script I recieved:
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.

Seeing that the epoch was 457 instead of 387 I select all the records from apply_status:

mysql> select * from cluster_replication.apply_status
    -> ;
+-----------+-------+
| server_id | epoch |
+-----------+-------+
|         0 |   387 |
|         1 |   457 |
+-----------+-------+

I am guessing that the first epoch should have a server id of 1 so that we don't have issues.

How to repeat:
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);

NDB10:
[ndbdev@ndb10 run]$ mysql -u root Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9 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, 5 rows affected (1.21 sec)

mysql> create database BANK;
Query OK, 1 row affected (0.00 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.

This one was my fault for not resetting the slave as stated in the document. Sorry.