Debian Codegraph @

mysql-test/suite/rpl/r/rpl_io_thd_wait_for_disk_space.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 CREATE TABLE t1(a INT);
7 INSERT INTO t1 VALUES(1);
8 include/sync_slave_sql_with_master.inc
9 CALL mtr.add_suppression("Disk is full writing");
10 CALL mtr.add_suppression("Retry in 60 secs");
11 CALL mtr.add_suppression("Relay log write failure");
12 CALL mtr.add_suppression("Recovery from source pos");
13 CALL mtr.add_suppression("Relay log recovery on channel with GTID_ONLY=1*");
14 CALL mtr.add_suppression("Waiting until I/O thread .* finish writing to disk before stopping");
15 #
16 # Step 1 - Monitor and kill I/O thread while waiting for disk space
17 #
18 # Adding debug point 'simulate_io_thd_wait_for_disk_space' to @@GLOBAL.debug
19 [connection master]
20 INSERT INTO t1 VALUES(2);
21 [connection slave]
22 include/wait_for_slave_param.inc [Slave_IO_State]
23 include/assert.inc [I/O thread PROCESSLIST_STATE should be Waiting for disk space at performance_schema.threads]
24 include/assert.inc [I/O thread STATE should be Waiting for disk space at information_schema.processlist]
25 [connection slave1]
26 STOP SLAVE IO_THREAD;
27 [connection slave]
28 SET DEBUG_SYNC="now WAIT_FOR reached_stopping_io_thread";
29 KILL IO_THREAD;
30 [connection slave1]
31 Warnings:
32 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
33 [connection slave]
34 include/wait_for_slave_io_error.inc [errno=13122]
35 # Removing debug point 'simulate_io_thd_wait_for_disk_space' from @@GLOBAL.debug
36 include/assert_grep.inc [Found the disk full error message on the slave]
37 include/assert_grep.inc [Found the relay log truncate message on the slave]
38 include/start_slave_io.inc
39 [connection master]
40 include/sync_slave_sql_with_master.inc
41 #
42 # Step 2 - Restart the slave server while I/O thread is waiting for disk space
43 #
44 # Adding debug point 'simulate_io_thd_wait_for_disk_space' to @@GLOBAL.debug
45 [connection master]
46 INSERT INTO t1 VALUES(3);
47 INSERT INTO t1 VALUES(4);
48 INSERT INTO t1 VALUES(5);
49 INSERT INTO t1 VALUES(6);
50 INSERT INTO t1 VALUES(7);
51 INSERT INTO t1 VALUES(8);
52 INSERT INTO t1 VALUES(9);
53 [connection slave]
54 include/wait_for_slave_param.inc [Slave_IO_State]
55 include/stop_slave_sql.inc
56 include/rpl_restart_server.inc [server_number=2]
57 include/start_slave.inc
58 include/assert_grep.inc [Found no warning messages about I/O thread waiting before stopping]
59 [connection master]
60 DROP TABLE t1;
61 include/sync_slave_sql_with_master.inc
62 include/rpl_end.inc