Debian Codegraph @

mysql-test/suite/rpl/t/rpl_mdev6020.test

raw
1 # Test applies a large binlog, takes long under Valgrind with little benefit.
2 --source include/not_valgrind.inc
3 --source include/have_innodb.inc
4 --source include/have_partition.inc
5 --source include/have_binlog_format_mixed_or_row.inc
6 --source include/master-slave.inc
7 --connection master
8 --source include/test_db_charset_latin1.inc
9 --sync_slave_with_master
10 --connection slave
11 --source include/stop_slave.inc
12
13 --connection master
14 --let $datadir= `SELECT @@datadir`
15
16 --let $rpl_server_number= 1
17 --source include/rpl_stop_server.inc
18
19 --remove_file $datadir/master-bin.000001
20 --remove_file $datadir/master-bin.state
21 --copy_file $MYSQL_TEST_DIR/std_data/mdev6020-mysql-bin.000001 $datadir/master-bin.000001
22
23 --let $rpl_server_number= 1
24 --source include/rpl_start_server.inc
25
26 --source include/wait_until_connected_again.inc
27
28 --connection slave
29 SET SQL_LOG_BIN=0;
30 ALTER TABLE mysql.gtid_slave_pos ENGINE = InnoDB;
31 SET SQL_LOG_BIN=1;
32 SET @old_engine= @@GLOBAL.default_storage_engine;
33 SET GLOBAL default_storage_engine=InnoDB;
34 SET @old_parallel= @@GLOBAL.slave_parallel_threads;
35 SET GLOBAL slave_parallel_threads=12;
36 --replace_result $SERVER_MYPORT_1 SERVER_MYPORT_1
37 eval CHANGE MASTER TO master_host='127.0.0.1', master_port=$SERVER_MYPORT_1, master_user='root', master_log_file='master-bin.000001', master_log_pos=4, master_use_gtid=no;
38 --source include/start_slave.inc
39
40 --connection master
41 SET SQL_LOG_BIN=0;
42 ALTER TABLE mysql.gtid_slave_pos ENGINE = InnoDB;
43 SET SQL_LOG_BIN=1;
44 --save_master_pos
45
46 --connection slave
47 --sync_with_master
48
49 SELECT @@gtid_slave_pos;
50 CHECKSUM TABLE table0_int_autoinc, table0_key_pk_parts_2_int_autoinc, table100_int_autoinc, table100_key_pk_parts_2_int_autoinc, table10_int_autoinc, table10_key_pk_parts_2_int_autoinc, table1_int_autoinc, table1_key_pk_parts_2_int_autoinc, table2_int_autoinc, table2_key_pk_parts_2_int_autoinc;
51
52 --source include/stop_slave.inc
53
54
55 SET GLOBAL default_storage_engine= @old_engine;
56 SET GLOBAL slave_parallel_threads=@old_parallel;
57 SET sql_log_bin=0;
58 DROP TABLE table0_int_autoinc;
59 DROP TABLE table0_key_pk_parts_2_int_autoinc;
60 DROP TABLE table100_int_autoinc;
61 DROP TABLE table100_key_pk_parts_2_int_autoinc;
62 DROP TABLE table10_int_autoinc;
63 DROP TABLE table10_key_pk_parts_2_int_autoinc;
64 DROP TABLE table1_int_autoinc;
65 DROP TABLE table1_key_pk_parts_2_int_autoinc;
66 DROP TABLE table2_int_autoinc;
67 DROP TABLE table2_key_pk_parts_2_int_autoinc;
68 SET sql_log_bin=1;
69 --source include/test_db_charset_restore.inc
70 --source include/start_slave.inc
71
72 --connection master
73 --source include/test_db_charset_restore.inc
74
75 --source include/rpl_end.inc