Debian Codegraph @

mysql-test/suite/rpl_gtid/t/rpl_gtid_huge_gtid_set.test

raw
1 # ==== Purpose ====
2 #
3 # This test will validate that huge GTID_EXECUTED values are properly
4 # handled on asynchronous replication.
5 #
6 # ==== Related Bugs and Worklogs ====
7 #
8 # BUG#22369630 GTID_SET TO_STRING MALLOC ISSUE FOR LARGE SETS
9 #
10 --source include/big_test.inc
11 --source include/master-slave.inc
12
13 --echo
14 --echo ################################################################
15 --echo # 1. Generate a huge GTID_EXECUTED with 70043 characters length.
16 --echo # It will be like:
17 --echo # aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:10000:10002:...:120000
18 --disable_query_log
19 --let $gno= 99998
20 --let $gno_number= 10001
21 while ($gno_number > 0)
22 {
23 --let $gno= `SELECT $gno + 2`
24 --eval SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:$gno'
25 BEGIN;
26 COMMIT;
27 --dec $gno_number
28 }
29 SET GTID_NEXT = 'AUTOMATIC';
30 --enable_query_log
31
32 --let $assert_text= GTID_EXECUTED must contain all 70043 characters
33 --let $assert_cond= [SELECT CHAR_LENGTH(@@GLOBAL.GTID_EXECUTED)] = 70043
34 --source include/assert.inc
35
36
37 --echo
38 --echo ################################################################
39 --echo # 2. Sync slave.
40 # In valgrind sync a large workload might take long when MTS is enabled
41 --let $slave_timeout= 1200
42 --let $use_gtids= 1
43 --source include/sync_slave_sql_with_master.inc
44
45 --let $assert_text= GTID_EXECUTED must contain all 70043 characters
46 --let $assert_cond= [SELECT CHAR_LENGTH(@@GLOBAL.GTID_EXECUTED)] = 70043
47 --source include/assert.inc
48
49
50 --echo
51 --echo ################################################################
52 --echo # 3. Execute some transactions and check that nothing bad happens.
53 --echo # Validate that data is delivered to both servers.
54 --source include/rpl_connection_master.inc
55 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
56 INSERT INTO t1 VALUES (1);
57 --source include/rpl_sync.inc
58
59 --source include/rpl_connection_master.inc
60 --let $assert_text= 'There is a value 1 in table t1'
61 --let $assert_cond= [SELECT COUNT(*) AS count FROM t1 WHERE t1.c1 = 1, count, 1] = 1
62 --source include/assert.inc
63
64 --source include/rpl_connection_slave.inc
65 --let $assert_text= 'There is a value 1 in table t1'
66 --let $assert_cond= [SELECT COUNT(*) AS count FROM t1 WHERE t1.c1 = 1, count, 1] = 1
67 --source include/assert.inc
68
69
70 --echo
71 --echo ################################################################
72 --echo # 4. Check that Retrieved transaction set it is equal to
73 --echo # GTID_EXECUTED.
74 --let $assert_text= 'Transactions_committed_all_members must be equal to GTID_EXECUTED'
75 --let $assert_cond= "[SELECT @@GLOBAL.GTID_EXECUTED]" = "[SELECT Received_Transaction_Set from performance_schema.replication_connection_status]"
76 --source include/assert.inc
77
78
79 --echo
80 --echo ############################################################
81 --echo # 5. Clean up.
82 --let $rpl_connection_name= master
83 --source include/rpl_connection_master.inc
84 DROP TABLE t1;
85 --source include/rpl_end.inc