Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection slave;
4 select master_pos_wait('master-bin.999999',0,2);
5 master_pos_wait('master-bin.999999',0,2)
6 -1
7 Warnings:
8 Note 1105 Timeout waiting for master-bin.999999:4. Current pos is master-bin.000001:329
9 explain extended select master_pos_wait('master-bin.999999',0,2);
10 id select_type table type possible_keys key key_len ref rows filtered Extra
11 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used
12 Warnings:
13 Note 1003 select master_pos_wait('master-bin.999999',0,2) AS `master_pos_wait('master-bin.999999',0,2)`
14 select master_pos_wait('master-bin.999999',0);
15 connection slave1;
16 stop slave sql_thread;
17 include/wait_for_slave_sql_to_stop.inc
18 connection slave;
19 master_pos_wait('master-bin.999999',0)
20 NULL
21 Warnings:
22 Note 1105 master_pos_wait() was aborted because slave is not running
23 connection master;
24 "*** must be empty ***"
25 show slave status;
26 "*** must be NULL ***"
27 select master_pos_wait('foo', 98);
28 master_pos_wait('foo', 98)
29 NULL
30 *** MDEV-7130: MASTER_POS_WAIT(log_name,log_pos,timeout,"connection_name") hangs, does not respect the timeout ***
31 connection slave;
32 include/stop_slave.inc
33 reset slave all;
34 change master 'my_slave' to master_port=MASTER_MYPORT, master_host='127.0.0.1', master_user='root', master_ssl_verify_server_cert=0;
35 set default_master_connection = 'my_slave';
36 include/start_slave.inc
37 # Call without connection name -- works (expected -1)
38 select master_pos_wait('master-bin.000001',1000000,1);
39 master_pos_wait('master-bin.000001',1000000,1)
40 -1
41 Warnings:
42 Note 1105 Timeout waiting for master-bin.000001:1000000. Current pos is master-bin.000001:329
43 set default_master_connection = '';
44 # Call for non-existing anonymous connection -- works (expected NULL)
45 select master_pos_wait('master-bin.000001',1000000,1);
46 master_pos_wait('master-bin.000001',1000000,1)
47 NULL
48 # Call with a valid connection name -- hangs before MDEV-7130 fix (expected -1)
49 select master_pos_wait('master-bin.000001',1000000,1,"my_slave");
50 master_pos_wait('master-bin.000001',1000000,1,"my_slave")
51 -1
52 Warnings:
53 Note 1105 Timeout waiting for master-bin.000001:1000000. Current pos is master-bin.000001:329
54 select master_pos_wait('master-bin.000001',1000000,1,"MY_SLAVE");
55 master_pos_wait('master-bin.000001',1000000,1,"MY_SLAVE")
56 -1
57 Warnings:
58 Note 1105 Timeout waiting for master-bin.000001:1000000. Current pos is master-bin.000001:329
59 STOP SLAVE 'my_slave';
60 RESET SLAVE 'my_slave' ALL;
61 change master to master_port=MASTER_MYPORT, master_host='127.0.0.1', master_user='root';
62 #
63 # Start of 10.3 tests
64 #
65 #
66 # MDEV-13965 Parameter data type control for Item_longlong_func
67 #
68 SELECT MASTER_POS_WAIT('x',1,ROW(1,1));
69 ERROR HY000: Illegal parameter data type row for operation 'master_pos_wait'
70 SELECT MASTER_POS_WAIT('x',1,1,ROW(1,1));
71 ERROR HY000: Illegal parameter data type row for operation 'master_pos_wait'
72 #
73 # End of 10.3 tests
74 #
75 include/rpl_end.inc