Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_stm_loaddata_concurrent.result

raw
1 RESET MASTER;
2 CREATE TABLE t1 (c1 char(50)) ENGINE=MyISAM;
3 LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE t1;
4 LOAD DATA CONCURRENT INFILE '../../std_data/words.dat' INTO TABLE t1;
5 include/show_binlog_events.inc
6 Log_name Pos Event_type Server_id End_log_pos Info
7 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (c1 char(50)) ENGINE=MyISAM
8 master-bin.000001 # Query # # BEGIN
9 master-bin.000001 # Begin_load_query # # ;file_id=#;block_len=#
10 master-bin.000001 # Execute_load_query # # use `test`; LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`c1`) ;file_id=#
11 master-bin.000001 # Query # # COMMIT
12 master-bin.000001 # Query # # BEGIN
13 master-bin.000001 # Begin_load_query # # ;file_id=#;block_len=#
14 master-bin.000001 # Execute_load_query # # use `test`; LOAD DATA CONCURRENT INFILE '../../std_data/words.dat' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`c1`) ;file_id=#
15 master-bin.000001 # Query # # COMMIT
16 DROP TABLE t1;
17 include/master-slave.inc
18 Warnings:
19 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
20 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.
21 [connection master]
22 select last_insert_id();
23 last_insert_id()
24 0
25 create table t1(a int not null auto_increment, b int, primary key(a) );
26 load data CONCURRENT infile '../../std_data/rpl_loaddata.dat' into table t1;
27 select last_insert_id();
28 last_insert_id()
29 1
30 create temporary table t2 (day date,id int(9),category enum('a','b','c'),name varchar(60));
31 Warnings:
32 Warning 1681 Integer display width is deprecated and will be removed in a future release.
33 load data CONCURRENT infile '../../std_data/rpl_loaddata2.dat' into table t2 fields terminated by ',' optionally enclosed by '%' escaped by '@' lines terminated by '\n##\n' starting by '>' ignore 1 lines;
34 create table t3 (day date,id int(9),category enum('a','b','c'),name varchar(60));
35 Warnings:
36 Warning 1681 Integer display width is deprecated and will be removed in a future release.
37 insert into t3 select * from t2;
38 include/sync_slave_sql_with_master.inc
39 select * from t1;
40 a b
41 1 10
42 2 15
43 select * from t3;
44 day id category name
45 2003-02-22 2461 b a a a @ %  ' " a
46 2003-03-22 2161 c asdf
47 2003-03-22 2416 a bbbbb
48 drop table t1;
49 drop table t2;
50 drop table t3;
51 create table t1(a int, b int, unique(b));
52 include/sync_slave_sql_with_master.inc
53 insert into t1 values(1,10);
54 load data CONCURRENT infile '../../std_data/rpl_loaddata.dat' into table t1;
55 call mtr.add_suppression("Replica SQL.*Error .Duplicate entry .10. for key .t1.b.. on query.* Error_code: MY-001062");
56 call mtr.add_suppression("Replica SQL.*Query caused different errors on source and replica.*Error on source:.*error code=1062.*Error on replica:.*Error_code: MY-013113");
57 call mtr.add_suppression("The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state");
58 include/wait_for_slave_sql_error_and_skip.inc [errno=1062]
59 include/check_slave_no_error.inc
60 set sql_log_bin=0;
61 delete from t1;
62 set sql_log_bin=1;
63 load data CONCURRENT infile '../../std_data/rpl_loaddata.dat' into table t1;
64 include/wait_for_slave_sql_error.inc [errno=1062]
65 include/stop_slave_io.inc
66 CHANGE REPLICATION SOURCE to SOURCE_USER='test';
67 Warnings:
68 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
69 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.
70 CHANGE REPLICATION SOURCE to SOURCE_USER='root';
71 Warnings:
72 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
73 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.
74 include/check_slave_no_error.inc
75 set global sql_replica_skip_counter=1;
76 start slave;
77 Warnings:
78 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
79 set sql_log_bin=0;
80 delete from t1;
81 set sql_log_bin=1;
82 load data CONCURRENT infile '../../std_data/rpl_loaddata.dat' into table t1;
83 include/wait_for_slave_sql_error.inc [errno=1062]
84 stop slave;
85 Warnings:
86 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
87 reset slave;
88 Warnings:
89 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
90 include/check_slave_no_error.inc
91 reset master;
92 create table t2 (day date,id int(9),category enum('a','b','c'),name varchar(60),
93 unique(day)) engine=MyISAM;
94 Warnings:
95 Warning 1681 Integer display width is deprecated and will be removed in a future release.
96 load data CONCURRENT infile '../../std_data/rpl_loaddata2.dat' into table t2 fields
97 terminated by ',' optionally enclosed by '%' escaped by '@' lines terminated by
98 '\n##\n' starting by '>' ignore 1 lines;
99 ERROR 23000: Duplicate entry '2003-03-22' for key 't2.day'
100 select * from t2;
101 day id category name
102 2003-02-22 2461 b a a a @ %  ' " a
103 2003-03-22 2161 c asdf
104 start slave;
105 Warnings:
106 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
107 select * from t2;
108 day id category name
109 2003-02-22 2461 b a a a @ %  ' " a
110 2003-03-22 2161 c asdf
111 alter table t2 drop key day;
112 delete from t2;
113 load data CONCURRENT infile '../../std_data/rpl_loaddata2.dat' into table t2 fields
114 terminated by ',' optionally enclosed by '%' escaped by '@' lines terminated by
115 '\n##\n' starting by '>' ignore 1 lines;
116 ERROR 23000: Duplicate entry '2003-03-22' for key 't2.day'
117 include/wait_for_slave_sql_error.inc [errno=13113]
118 drop table t1, t2;
119 drop table t1, t2;
120 include/stop_slave_io.inc
121 RESET REPLICA;
122 include/rpl_reset.inc
123 drop database if exists b48297_db1;
124 drop database if exists b42897_db2;
125 create database b48297_db1;
126 create database b42897_db2;
127 use b48297_db1;
128 CREATE TABLE t1 (c1 VARCHAR(256)) engine=MyISAM;;
129 use b42897_db2;
130 ### assertion: works with cross-referenced database
131 LOAD DATA CONCURRENT LOCAL INFILE 'MYSQLTEST_VARDIR/std_data/loaddata5.dat' INTO TABLE b48297_db1.t1;
132 use b48297_db1;
133 ### assertion: works with fully qualified name on current database
134 LOAD DATA CONCURRENT LOCAL INFILE 'MYSQLTEST_VARDIR/std_data/loaddata5.dat' INTO TABLE b48297_db1.t1;
135 ### assertion: works without fully qualified name on current database
136 LOAD DATA CONCURRENT LOCAL INFILE 'MYSQLTEST_VARDIR/std_data/loaddata5.dat' INTO TABLE t1;
137 ### create connection without default database
138 ### connect (conn2,localhost,root,,*NO-ONE*);
139 ### assertion: works without stating the default database
140 LOAD DATA CONCURRENT LOCAL INFILE 'MYSQLTEST_VARDIR/std_data/loaddata5.dat' INTO TABLE b48297_db1.t1;
141 ### disconnect and switch back to master connection
142 include/sync_slave_sql_with_master.inc
143 use b48297_db1;
144 include/diff_tables.inc [master:b48297_db1.t1, slave:b48297_db1.t1]
145 DROP DATABASE b48297_db1;
146 DROP DATABASE b42897_db2;
147 include/sync_slave_sql_with_master.inc
148 include/rpl_reset.inc
149 use test;
150 CREATE TABLE t1 (`key` TEXT, `text` TEXT);
151 LOAD DATA INFILE '../../std_data/loaddata2.dat' REPLACE INTO TABLE `t1` FIELDS TERMINATED BY ',';
152 SELECT * FROM t1;
153 key text
154 Field A 'Field B'
155 Field 1 'Field 2'
156 Field 3 'Field 4'
157 'Field 5' 'Field 6'
158 Field 6 'Field 7'
159 include/sync_slave_sql_with_master.inc
160 DROP TABLE t1;
161 include/rpl_end.inc