Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_stm_000001.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 CALL mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
7 call mtr.add_suppression("The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state");
8 create table t1 (word char(20) not null);
9 load data infile '../../std_data/words.dat' into table t1;
10 load data local infile 'MYSQL_TEST_DIR/std_data/words.dat' into table t1;
11 select * from t1 limit 10;
12 word
13 Aarhus
14 Aaron
15 Ababa
16 aback
17 abaft
18 abandon
19 abandoned
20 abandoning
21 abandonment
22 abandons
23 include/sync_slave_sql_with_master.inc
24 stop slave;
25 Warnings:
26 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
27 set password for root@"localhost" = 'foo';
28 start slave;
29 Warnings:
30 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
31 set password for root@"localhost" = '';
32 create table t3(n int);
33 insert into t3 values(1),(2);
34 include/sync_slave_sql_with_master.inc
35 select * from t3;
36 n
37 1
38 2
39 select sum(length(word)) from t1;
40 sum(length(word))
41 1022
42 drop table t1,t3;
43 include/sync_slave_sql_with_master.inc
44 create table t1 (n int) engine=myisam;
45 include/sync_slave_sql_with_master.inc
46 reset master;
47 stop slave;
48 Warnings:
49 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
50 reset slave;
51 Warnings:
52 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
53 include/assert.inc [We should have generated greater than 16 KB relay log]
54 lock tables t1 read;
55 start slave;
56 Warnings:
57 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
58 include/sync_slave_io_with_master.inc
59 unlock tables;
60 create table t2(id int);
61 insert into t2 values(connection_id());
62 create temporary table t3(n int);
63 insert into t3 select get_lock('crash_lock%20C', 1) from t2;
64 update t1 set n = n + if(n > 50, 1, get_lock('crash_lock%20C', 100));
65 select (@id := id) - id from t2;
66 (@id := id) - id
67 0
68 Warnings:
69 Warning 1287 Setting user variables within expressions is deprecated and will be removed in a future release. Consider alternatives: 'SET variable=expression, ...', or 'SELECT expression(s) INTO variables(s)'.
70 kill @id;
71 drop table t2;
72 drop temporary table if exists t3;
73 Got one of the listed errors
74 include/wait_for_slave_sql_error.inc [errno=3001]
75 SET GLOBAL SQL_REPLICA_SKIP_COUNTER=1;
76 include/start_slave.inc
77 select count(*) from t1;
78 count(*)
79 100
80 drop table t1;
81 create table t1 (n int);
82 insert into t1 values(3456);
83 create user 'blafasel2'@'10.10.10.%' identified by 'blafasel2';
84 select select_priv,user from mysql.user where user = _binary'blafasel2';
85 select_priv user
86 N blafasel2
87 update mysql.user set Select_priv = "Y" where User= _binary"blafasel2";
88 select select_priv,user from mysql.user where user = _binary'blafasel2';
89 select_priv user
90 Y blafasel2
91 include/sync_slave_sql_with_master.inc
92 select n from t1;
93 n
94 3456
95 select select_priv,user from mysql.user where user = _binary'blafasel2';
96 select_priv user
97 Y blafasel2
98 drop table t1;
99 delete from mysql.user where user="blafasel2";
100 # mysql.user table restored to original values.
101 include/sync_slave_sql_with_master.inc
102 include/rpl_end.inc