EVOLUTION-MANAGER

Edit File: galera_sst_mariabackup_table_options.result

connection node_1; connection node_2; Performing State Transfer on a server that starts from a clean var directory This is accomplished by shutting down node #2 and removing its var directory before restarting it connection node_1; CREATE TABLE t1 (f1 CHAR(255)) ENGINE=InnoDB; CREATE TABLE t2 (f1 CHAR(255)) ENGINE=InnoDB PAGE_COMPRESSED=1; CREATE TABLE t3 (f1 CHAR(255)) ENGINE=InnoDB PAGE_COMPRESSED=1 ENCRYPTED=NO; CREATE TABLE t4 (f1 CHAR(255)) ENGINE=InnoDB PAGE_COMPRESSED=1 ENCRYPTED=YES; CREATE TABLE t5 (f1 CHAR(255)) ENGINE=InnoDB ROW_FORMAT=COMPRESSED; CREATE TABLE t6 (f1 CHAR(255)) ENGINE=InnoDB ROW_FORMAT=COMPRESSED ENCRYPTED=NO; CREATE TABLE t7 (f1 CHAR(255)) ENGINE=InnoDB ROW_FORMAT=COMPRESSED ENCRYPTED=YES; CREATE TABLE t8 (f1 CHAR(255)) ENGINE=InnoDB ENCRYPTED=NO; CREATE TABLE t9 (f1 CHAR(255)) ENGINE=InnoDB ENCRYPTED=YES; SET AUTOCOMMIT=OFF; START TRANSACTION; insert into t9 values ('node1_committed_before'); insert into t9 values ('node1_committed_before'); insert into t9 values ('node1_committed_before'); insert into t9 values ('node1_committed_before'); insert into t9 values ('node1_committed_before'); insert into t8 values ('node1_committed_before'); insert into t8 values ('node1_committed_before'); insert into t8 values ('node1_committed_before'); insert into t8 values ('node1_committed_before'); insert into t8 values ('node1_committed_before'); insert into t7 values ('node1_committed_before'); insert into t7 values ('node1_committed_before'); insert into t7 values ('node1_committed_before'); insert into t7 values ('node1_committed_before'); insert into t7 values ('node1_committed_before'); insert into t6 values ('node1_committed_before'); insert into t6 values ('node1_committed_before'); insert into t6 values ('node1_committed_before'); insert into t6 values ('node1_committed_before'); insert into t6 values ('node1_committed_before'); insert into t5 values ('node1_committed_before'); insert into t5 values ('node1_committed_before'); insert into t5 values ('node1_committed_before'); insert into t5 values ('node1_committed_before'); insert into t5 values ('node1_committed_before'); insert into t4 values ('node1_committed_before'); insert into t4 values ('node1_committed_before'); insert into t4 values ('node1_committed_before'); insert into t4 values ('node1_committed_before'); insert into t4 values ('node1_committed_before'); insert into t3 values ('node1_committed_before'); insert into t3 values ('node1_committed_before'); insert into t3 values ('node1_committed_before'); insert into t3 values ('node1_committed_before'); insert into t3 values ('node1_committed_before'); insert into t2 values ('node1_committed_before'); insert into t2 values ('node1_committed_before'); insert into t2 values ('node1_committed_before'); insert into t2 values ('node1_committed_before'); insert into t2 values ('node1_committed_before'); insert into t1 values ('node1_committed_before'); insert into t1 values ('node1_committed_before'); insert into t1 values ('node1_committed_before'); insert into t1 values ('node1_committed_before'); insert into t1 values ('node1_committed_before'); COMMIT; connection node_2; SET AUTOCOMMIT=OFF; START TRANSACTION; insert into t9 values ('node2_committed_before'); insert into t9 values ('node2_committed_before'); insert into t9 values ('node2_committed_before'); insert into t9 values ('node2_committed_before'); insert into t9 values ('node2_committed_before'); insert into t8 values ('node2_committed_before'); insert into t8 values ('node2_committed_before'); insert into t8 values ('node2_committed_before'); insert into t8 values ('node2_committed_before'); insert into t8 values ('node2_committed_before'); insert into t7 values ('node2_committed_before'); insert into t7 values ('node2_committed_before'); insert into t7 values ('node2_committed_before'); insert into t7 values ('node2_committed_before'); insert into t7 values ('node2_committed_before'); insert into t6 values ('node2_committed_before'); insert into t6 values ('node2_committed_before'); insert into t6 values ('node2_committed_before'); insert into t6 values ('node2_committed_before'); insert into t6 values ('node2_committed_before'); insert into t5 values ('node2_committed_before'); insert into t5 values ('node2_committed_before'); insert into t5 values ('node2_committed_before'); insert into t5 values ('node2_committed_before'); insert into t5 values ('node2_committed_before'); insert into t4 values ('node2_committed_before'); insert into t4 values ('node2_committed_before'); insert into t4 values ('node2_committed_before'); insert into t4 values ('node2_committed_before'); insert into t4 values ('node2_committed_before'); insert into t3 values ('node2_committed_before'); insert into t3 values ('node2_committed_before'); insert into t3 values ('node2_committed_before'); insert into t3 values ('node2_committed_before'); insert into t3 values ('node2_committed_before'); insert into t2 values ('node2_committed_before'); insert into t2 values ('node2_committed_before'); insert into t2 values ('node2_committed_before'); insert into t2 values ('node2_committed_before'); insert into t2 values ('node2_committed_before'); insert into t1 values ('node2_committed_before'); insert into t1 values ('node2_committed_before'); insert into t1 values ('node2_committed_before'); insert into t1 values ('node2_committed_before'); insert into t1 values ('node2_committed_before'); COMMIT; Shutting down server ... connection node_1; Cleaning var directory ... SET AUTOCOMMIT=OFF; START TRANSACTION; insert into t9 values ('node1_committed_during'); insert into t9 values ('node1_committed_during'); insert into t9 values ('node1_committed_during'); insert into t9 values ('node1_committed_during'); insert into t9 values ('node1_committed_during'); insert into t8 values ('node1_committed_during'); insert into t8 values ('node1_committed_during'); insert into t8 values ('node1_committed_during'); insert into t8 values ('node1_committed_during'); insert into t8 values ('node1_committed_during'); insert into t7 values ('node1_committed_during'); insert into t7 values ('node1_committed_during'); insert into t7 values ('node1_committed_during'); insert into t7 values ('node1_committed_during'); insert into t7 values ('node1_committed_during'); insert into t6 values ('node1_committed_during'); insert into t6 values ('node1_committed_during'); insert into t6 values ('node1_committed_during'); insert into t6 values ('node1_committed_during'); insert into t6 values ('node1_committed_during'); insert into t5 values ('node1_committed_during'); insert into t5 values ('node1_committed_during'); insert into t5 values ('node1_committed_during'); insert into t5 values ('node1_committed_during'); insert into t5 values ('node1_committed_during'); insert into t4 values ('node1_committed_during'); insert into t4 values ('node1_committed_during'); insert into t4 values ('node1_committed_during'); insert into t4 values ('node1_committed_during'); insert into t4 values ('node1_committed_during'); insert into t3 values ('node1_committed_during'); insert into t3 values ('node1_committed_during'); insert into t3 values ('node1_committed_during'); insert into t3 values ('node1_committed_during'); insert into t3 values ('node1_committed_during'); insert into t2 values ('node1_committed_during'); insert into t2 values ('node1_committed_during'); insert into t2 values ('node1_committed_during'); insert into t2 values ('node1_committed_during'); insert into t2 values ('node1_committed_during'); insert into t1 values ('node1_committed_during'); insert into t1 values ('node1_committed_during'); insert into t1 values ('node1_committed_during'); insert into t1 values ('node1_committed_during'); insert into t1 values ('node1_committed_during'); COMMIT; START TRANSACTION; insert into t9 values ('node1_to_be_committed_after'); insert into t9 values ('node1_to_be_committed_after'); insert into t9 values ('node1_to_be_committed_after'); insert into t9 values ('node1_to_be_committed_after'); insert into t9 values ('node1_to_be_committed_after'); insert into t8 values ('node1_to_be_committed_after'); insert into t8 values ('node1_to_be_committed_after'); insert into t8 values ('node1_to_be_committed_after'); insert into t8 values ('node1_to_be_committed_after'); insert into t8 values ('node1_to_be_committed_after'); insert into t7 values ('node1_to_be_committed_after'); insert into t7 values ('node1_to_be_committed_after'); insert into t7 values ('node1_to_be_committed_after'); insert into t7 values ('node1_to_be_committed_after'); insert into t7 values ('node1_to_be_committed_after'); insert into t6 values ('node1_to_be_committed_after'); insert into t6 values ('node1_to_be_committed_after'); insert into t6 values ('node1_to_be_committed_after'); insert into t6 values ('node1_to_be_committed_after'); insert into t6 values ('node1_to_be_committed_after'); insert into t5 values ('node1_to_be_committed_after'); insert into t5 values ('node1_to_be_committed_after'); insert into t5 values ('node1_to_be_committed_after'); insert into t5 values ('node1_to_be_committed_after'); insert into t5 values ('node1_to_be_committed_after'); insert into t4 values ('node1_to_be_committed_after'); insert into t4 values ('node1_to_be_committed_after'); insert into t4 values ('node1_to_be_committed_after'); insert into t4 values ('node1_to_be_committed_after'); insert into t4 values ('node1_to_be_committed_after'); insert into t3 values ('node1_to_be_committed_after'); insert into t3 values ('node1_to_be_committed_after'); insert into t3 values ('node1_to_be_committed_after'); insert into t3 values ('node1_to_be_committed_after'); insert into t3 values ('node1_to_be_committed_after'); insert into t2 values ('node1_to_be_committed_after'); insert into t2 values ('node1_to_be_committed_after'); insert into t2 values ('node1_to_be_committed_after'); insert into t2 values ('node1_to_be_committed_after'); insert into t2 values ('node1_to_be_committed_after'); insert into t1 values ('node1_to_be_committed_after'); insert into t1 values ('node1_to_be_committed_after'); insert into t1 values ('node1_to_be_committed_after'); insert into t1 values ('node1_to_be_committed_after'); insert into t1 values ('node1_to_be_committed_after'); connect node_1a_galera_st_clean_slave, 127.0.0.1, root, , test, $NODE_MYPORT_1; SET AUTOCOMMIT=OFF; START TRANSACTION; insert into t9 values ('node1_to_be_rollbacked_after'); insert into t9 values ('node1_to_be_rollbacked_after'); insert into t9 values ('node1_to_be_rollbacked_after'); insert into t9 values ('node1_to_be_rollbacked_after'); insert into t9 values ('node1_to_be_rollbacked_after'); insert into t8 values ('node1_to_be_rollbacked_after'); insert into t8 values ('node1_to_be_rollbacked_after'); insert into t8 values ('node1_to_be_rollbacked_after'); insert into t8 values ('node1_to_be_rollbacked_after'); insert into t8 values ('node1_to_be_rollbacked_after'); insert into t7 values ('node1_to_be_rollbacked_after'); insert into t7 values ('node1_to_be_rollbacked_after'); insert into t7 values ('node1_to_be_rollbacked_after'); insert into t7 values ('node1_to_be_rollbacked_after'); insert into t7 values ('node1_to_be_rollbacked_after'); insert into t6 values ('node1_to_be_rollbacked_after'); insert into t6 values ('node1_to_be_rollbacked_after'); insert into t6 values ('node1_to_be_rollbacked_after'); insert into t6 values ('node1_to_be_rollbacked_after'); insert into t6 values ('node1_to_be_rollbacked_after'); insert into t5 values ('node1_to_be_rollbacked_after'); insert into t5 values ('node1_to_be_rollbacked_after'); insert into t5 values ('node1_to_be_rollbacked_after'); insert into t5 values ('node1_to_be_rollbacked_after'); insert into t5 values ('node1_to_be_rollbacked_after'); insert into t4 values ('node1_to_be_rollbacked_after'); insert into t4 values ('node1_to_be_rollbacked_after'); insert into t4 values ('node1_to_be_rollbacked_after'); insert into t4 values ('node1_to_be_rollbacked_after'); insert into t4 values ('node1_to_be_rollbacked_after'); insert into t3 values ('node1_to_be_rollbacked_after'); insert into t3 values ('node1_to_be_rollbacked_after'); insert into t3 values ('node1_to_be_rollbacked_after'); insert into t3 values ('node1_to_be_rollbacked_after'); insert into t3 values ('node1_to_be_rollbacked_after'); insert into t2 values ('node1_to_be_rollbacked_after'); insert into t2 values ('node1_to_be_rollbacked_after'); insert into t2 values ('node1_to_be_rollbacked_after'); insert into t2 values ('node1_to_be_rollbacked_after'); insert into t2 values ('node1_to_be_rollbacked_after'); insert into t1 values ('node1_to_be_rollbacked_after'); insert into t1 values ('node1_to_be_rollbacked_after'); insert into t1 values ('node1_to_be_rollbacked_after'); insert into t1 values ('node1_to_be_rollbacked_after'); insert into t1 values ('node1_to_be_rollbacked_after'); connection node_2; Starting server ... SET AUTOCOMMIT=OFF; START TRANSACTION; COMMIT; connection node_1; insert into t9 values ('node1_to_be_committed_after'); insert into t9 values ('node1_to_be_committed_after'); insert into t9 values ('node1_to_be_committed_after'); insert into t9 values ('node1_to_be_committed_after'); insert into t9 values ('node1_to_be_committed_after'); insert into t8 values ('node1_to_be_committed_after'); insert into t8 values ('node1_to_be_committed_after'); insert into t8 values ('node1_to_be_committed_after'); insert into t8 values ('node1_to_be_committed_after'); insert into t8 values ('node1_to_be_committed_after'); insert into t7 values ('node1_to_be_committed_after'); insert into t7 values ('node1_to_be_committed_after'); insert into t7 values ('node1_to_be_committed_after'); insert into t7 values ('node1_to_be_committed_after'); insert into t7 values ('node1_to_be_committed_after'); insert into t6 values ('node1_to_be_committed_after'); insert into t6 values ('node1_to_be_committed_after'); insert into t6 values ('node1_to_be_committed_after'); insert into t6 values ('node1_to_be_committed_after'); insert into t6 values ('node1_to_be_committed_after'); insert into t5 values ('node1_to_be_committed_after'); insert into t5 values ('node1_to_be_committed_after'); insert into t5 values ('node1_to_be_committed_after'); insert into t5 values ('node1_to_be_committed_after'); insert into t5 values ('node1_to_be_committed_after'); insert into t4 values ('node1_to_be_committed_after'); insert into t4 values ('node1_to_be_committed_after'); insert into t4 values ('node1_to_be_committed_after'); insert into t4 values ('node1_to_be_committed_after'); insert into t4 values ('node1_to_be_committed_after'); insert into t3 values ('node1_to_be_committed_after'); insert into t3 values ('node1_to_be_committed_after'); insert into t3 values ('node1_to_be_committed_after'); insert into t3 values ('node1_to_be_committed_after'); insert into t3 values ('node1_to_be_committed_after'); insert into t2 values ('node1_to_be_committed_after'); insert into t2 values ('node1_to_be_committed_after'); insert into t2 values ('node1_to_be_committed_after'); insert into t2 values ('node1_to_be_committed_after'); insert into t2 values ('node1_to_be_committed_after'); insert into t1 values ('node1_to_be_committed_after'); insert into t1 values ('node1_to_be_committed_after'); insert into t1 values ('node1_to_be_committed_after'); insert into t1 values ('node1_to_be_committed_after'); insert into t1 values ('node1_to_be_committed_after'); COMMIT; SET AUTOCOMMIT=OFF; START TRANSACTION; insert into t9 values ('node1_committed_after'); insert into t9 values ('node1_committed_after'); insert into t9 values ('node1_committed_after'); insert into t9 values ('node1_committed_after'); insert into t9 values ('node1_committed_after'); insert into t8 values ('node1_committed_after'); insert into t8 values ('node1_committed_after'); insert into t8 values ('node1_committed_after'); insert into t8 values ('node1_committed_after'); insert into t8 values ('node1_committed_after'); insert into t7 values ('node1_committed_after'); insert into t7 values ('node1_committed_after'); insert into t7 values ('node1_committed_after'); insert into t7 values ('node1_committed_after'); insert into t7 values ('node1_committed_after'); insert into t6 values ('node1_committed_after'); insert into t6 values ('node1_committed_after'); insert into t6 values ('node1_committed_after'); insert into t6 values ('node1_committed_after'); insert into t6 values ('node1_committed_after'); insert into t5 values ('node1_committed_after'); insert into t5 values ('node1_committed_after'); insert into t5 values ('node1_committed_after'); insert into t5 values ('node1_committed_after'); insert into t5 values ('node1_committed_after'); insert into t4 values ('node1_committed_after'); insert into t4 values ('node1_committed_after'); insert into t4 values ('node1_committed_after'); insert into t4 values ('node1_committed_after'); insert into t4 values ('node1_committed_after'); insert into t3 values ('node1_committed_after'); insert into t3 values ('node1_committed_after'); insert into t3 values ('node1_committed_after'); insert into t3 values ('node1_committed_after'); insert into t3 values ('node1_committed_after'); insert into t2 values ('node1_committed_after'); insert into t2 values ('node1_committed_after'); insert into t2 values ('node1_committed_after'); insert into t2 values ('node1_committed_after'); insert into t2 values ('node1_committed_after'); insert into t1 values ('node1_committed_after'); insert into t1 values ('node1_committed_after'); insert into t1 values ('node1_committed_after'); insert into t1 values ('node1_committed_after'); insert into t1 values ('node1_committed_after'); COMMIT; connection node_1a_galera_st_clean_slave; ROLLBACK; SELECT COUNT(*) FROM t1; COUNT(*) 30 SELECT COUNT(*) FROM t2; COUNT(*) 30 SELECT COUNT(*) FROM t3; COUNT(*) 30 SELECT COUNT(*) FROM t4; COUNT(*) 30 SELECT COUNT(*) FROM t5; COUNT(*) 30 SELECT COUNT(*) FROM t6; COUNT(*) 30 SELECT COUNT(*) FROM t7; COUNT(*) 30 SELECT COUNT(*) FROM t8; COUNT(*) 30 SELECT COUNT(*) FROM t9; COUNT(*) 30 SELECT * FROM t1; f1 node1_committed_before node1_committed_before node1_committed_before node1_committed_before node1_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after SELECT * FROM t2; f1 node1_committed_before node1_committed_before node1_committed_before node1_committed_before node1_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after SELECT * FROM t3; f1 node1_committed_before node1_committed_before node1_committed_before node1_committed_before node1_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after SELECT * FROM t4; f1 node1_committed_before node1_committed_before node1_committed_before node1_committed_before node1_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after SELECT * FROM t5; f1 node1_committed_before node1_committed_before node1_committed_before node1_committed_before node1_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after SELECT * FROM t6; f1 node1_committed_before node1_committed_before node1_committed_before node1_committed_before node1_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after SELECT * FROM t7; f1 node1_committed_before node1_committed_before node1_committed_before node1_committed_before node1_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after SELECT * FROM t8; f1 node1_committed_before node1_committed_before node1_committed_before node1_committed_before node1_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after SELECT * FROM t9; f1 node1_committed_before node1_committed_before node1_committed_before node1_committed_before node1_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after COMMIT; SET AUTOCOMMIT=ON; connection node_1; SELECT COUNT(*) FROM t1; COUNT(*) 30 SELECT COUNT(*) FROM t2; COUNT(*) 30 SELECT COUNT(*) FROM t3; COUNT(*) 30 SELECT COUNT(*) FROM t4; COUNT(*) 30 SELECT COUNT(*) FROM t5; COUNT(*) 30 SELECT COUNT(*) FROM t6; COUNT(*) 30 SELECT COUNT(*) FROM t7; COUNT(*) 30 SELECT COUNT(*) FROM t8; COUNT(*) 30 SELECT COUNT(*) FROM t9; COUNT(*) 30 SELECT * FROM t1; f1 node1_committed_before node1_committed_before node1_committed_before node1_committed_before node1_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after SELECT * FROM t2; f1 node1_committed_before node1_committed_before node1_committed_before node1_committed_before node1_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after SELECT * FROM t3; f1 node1_committed_before node1_committed_before node1_committed_before node1_committed_before node1_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after SELECT * FROM t4; f1 node1_committed_before node1_committed_before node1_committed_before node1_committed_before node1_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after SELECT * FROM t5; f1 node1_committed_before node1_committed_before node1_committed_before node1_committed_before node1_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after SELECT * FROM t6; f1 node1_committed_before node1_committed_before node1_committed_before node1_committed_before node1_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after SELECT * FROM t7; f1 node1_committed_before node1_committed_before node1_committed_before node1_committed_before node1_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after SELECT * FROM t8; f1 node1_committed_before node1_committed_before node1_committed_before node1_committed_before node1_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after SELECT * FROM t9; f1 node1_committed_before node1_committed_before node1_committed_before node1_committed_before node1_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node2_committed_before node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_committed_during node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_to_be_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after node1_committed_after COMMIT; DROP TABLE t1,t2,t3,t4,t5,t6,t7,t8,t9; COMMIT; SET AUTOCOMMIT=ON; disconnect node_2; disconnect node_1;