← Back to branch summary

~ubuntu-branches/ubuntu/natty/mysql-5.1/natty-proposed

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl/t/rpl_flushlog_loop.test

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 08:30:45 UTC
  • mfrom: (1.4.1)
  • Revision ID: package-import@ubuntu.com-20120222083045-2rd53r4bnyx7qus4
Tags: 5.1.61-0ubuntu0.11.04.1
https://launchpad.net/bugs/937869
* SECURITY UPDATE: Update to 5.1.61 to fix multiple security issues
  (LP: #937869)
  - http://www.oracle.com/technetwork/topics/security/cpujan2012-366304.html
  - CVE-2011-2262
  - CVE-2012-0075
  - CVE-2012-0112
  - CVE-2012-0113
  - CVE-2012-0114
  - CVE-2012-0115
  - CVE-2012-0116
  - CVE-2012-0117
  - CVE-2012-0118
  - CVE-2012-0119
  - CVE-2012-0120
  - CVE-2012-0484
  - CVE-2012-0485
  - CVE-2012-0486
  - CVE-2012-0487
  - CVE-2012-0488
  - CVE-2012-0489
  - CVE-2012-0490
  - CVE-2012-0491
  - CVE-2012-0492
  - CVE-2012-0493
  - CVE-2012-0494
  - CVE-2012-0495
  - CVE-2012-0496

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/rpl/t/rpl_flushlog_loop.test
1
1
# Testing if "flush logs" command bouncing resulting in logs created in a loop 
2
2
# in case of bi-directional replication
 
3
--let $rpl_topology= 1->2->1
 
4
--source include/rpl_init.inc
3
5
 
4
6
let $MYSQLD_DATADIR= `select @@datadir`;
5
7
--replace_result $MYSQLD_DATADIR MYSQLD_DATADIR/
6
8
show variables like 'relay_log%';
7
9
 
8
 
connection slave;
9
 
--disable_warnings
10
 
stop slave;
11
 
--enable_warnings
12
 
--replace_result $MASTER_MYPORT MASTER_PORT
13
 
eval change master to master_host='127.0.0.1',master_user='root',
14
 
 master_password='',master_port=$MASTER_MYPORT;
15
 
start slave;
16
 
 
17
 
#
18
 
#  Start replication slave -> master
19
 
#
20
 
connection master;
21
 
--disable_warnings
22
 
stop slave;
23
 
--enable_warnings
24
 
--replace_result $SLAVE_MYPORT SLAVE_PORT
25
 
eval change master to master_host='127.0.0.1',master_user='root',
26
 
 master_password='',master_port=$SLAVE_MYPORT;
27
 
 
28
 
source include/start_slave.inc;
29
 
 
30
10
#
31
11
#  Flush logs of slave
32
12
#
39
18
CREATE TABLE t1 (a INT KEY) ENGINE= MyISAM;
40
19
let $wait_binlog_event= CREATE TABLE t1;
41
20
--source include/wait_for_binlog_event.inc
42
 
sync_slave_with_master;
 
21
sync_slave_with_master server_2;
43
22
 
44
 
connection master;
 
23
connection server_1;
45
24
INSERT INTO t1 VALUE(1);
46
25
FLUSH LOGS;
47
 
sync_slave_with_master;
 
26
sync_slave_with_master server_2;
48
27
 
49
28
INSERT INTO t1 VALUE(2);
50
29
let $slave_param_value= query_get_value(SHOW MASTER STATUS, Position, 1);
51
 
sync_slave_with_master master;
 
30
sync_slave_with_master server_1;
52
31
 
53
32
#
54
33
# Check that the master server's slave threads are still running and show
59
38
--source include/show_slave_status.inc
60
39
 
61
40
--disable_query_log
62
 
connection master;
 
41
connection server_1;
63
42
DROP TABLE t1;
64
 
sync_slave_with_master;
 
43
sync_slave_with_master server_2;
65
44
--enable_query_log
 
45
 
 
46
--source include/rpl_end.inc