Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_mts_debug.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 DATABASE db_1;
7 CREATE DATABASE db_2;
8 CREATE TABLE db_1.test_1 (id INTEGER) engine=Innodb;
9 CREATE TABLE db_2.test_1 (id INTEGER) engine=Innodb;
10 include/sync_slave_sql_with_master.inc
11 include/stop_slave.inc
12 set @save.replica_parallel_workers= @@global.replica_parallel_workers;
13 set @save.debug= @@global.debug;
14 SET @@global.replica_parallel_workers= 2;
15 ALTER TABLE mysql.slave_relay_log_info ENGINE= Innodb;
16 ALTER TABLE mysql.slave_worker_info ENGINE= Innodb;
17 include/start_slave.inc
18 INSERT INTO db_1.test_1 VALUES(0);
19 include/sync_slave_sql_with_master.inc
20 SET GLOBAL debug="+d,mta_debug_concurrent_access";
21 BEGIN;
22 INSERT INTO db_1.test_1 VALUES(1);
23 BEGIN;
24 INSERT INTO db_2.test_1 VALUES(1);
25 COMMIT;
26 COMMIT;
27 DROP DATABASE db_1;
28 DROP DATABASE db_2;
29 include/sync_slave_sql_with_master.inc
30 include/stop_slave.inc
31 SET @@global.replica_parallel_workers= @save.replica_parallel_workers;
32 SET @@global.debug= @save.debug;
33 include/start_slave.inc
34 call mtr.add_suppression('Error reading replica worker configuration');
35 call mtr.add_suppression('Failed during replica workers initialization');
36 call mtr.add_suppression('Failed during replica worker thread creation for channel ''');
37 include/stop_slave.inc
38 set @save.replica_checkpoint_group= @@global.replica_checkpoint_group;
39 set @save.replica_parallel_workers= @@global.replica_parallel_workers;
40 set @save.debug= @@global.debug;
41 SET @@global.debug= "+d,mta_worker_thread_fails";
42 set @@global.replica_parallel_workers= 2;
43 start slave sql_thread;
44 Warnings:
45 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
46 include/wait_for_slave_sql_error.inc [errno=13117]
47 set @@global.replica_checkpoint_group= @save.replica_checkpoint_group;
48 set @@global.replica_parallel_workers= @save.replica_parallel_workers;
49 set @@global.debug= @save.debug;
50 include/assert.inc [Verified that their is no orphaned SQL worker thread]
51 include/start_slave.inc
52 include/rpl_reset.inc
53 include/stop_slave.inc
54 call mtr.add_suppression("option 'replica_checkpoint_group': unsigned value 524281 adjusted to 524280");
55 call mtr.add_suppression("Failed during replica worker thread create");
56 call mtr.add_suppression("Replica SQL for channel '': Failed during replica workers initialization, Error_code: MY-13117");
57 call mtr.add_suppression("Mismatch between the number of bytes configured to store checkpoint information and the previously stored information");
58 set @save.replica_checkpoint_group= @@global.replica_checkpoint_group;
59 set @save.replica_parallel_workers= @@global.replica_parallel_workers;
60 SET @@global.replica_parallel_workers= 2;
61 SET @@global.replica_checkpoint_group=524281;
62 Warnings:
63 Warning 1292 Truncated incorrect replica_checkpoint_group value: '524281'
64 include/start_slave.inc
65 include/assert.inc [Assert that replica_checkpoint_group was truncated to a valid value.]
66 include/check_slave_is_running.inc
67 include/rpl_reset.inc
68 include/stop_slave.inc
69 SET @@global.debug= "+d,inject_init_worker_init_info_fault";
70 START SLAVE SQL_THREAD;
71 Warnings:
72 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
73 include/wait_for_slave_sql_error.inc [errno=13117]
74 SET @@global.debug= @save.debug;
75 set @@global.replica_checkpoint_group= @save.replica_checkpoint_group;
76 set @@global.replica_parallel_workers= @save.replica_parallel_workers;
77 call mtr.add_suppression("Could not delete from Replica Workers info repository.");
78 include/stop_slave.inc
79 Warnings:
80 Note 3084 Replication thread(s) for channel '' are already stopped.
81 set @save.replica_parallel_workers= @@global.replica_parallel_workers;
82 set @@global.replica_parallel_workers= 2;
83 include/start_slave.inc
84 include/stop_slave.inc
85 set @@global.debug= "+d,mta_debug_reset_workers_fails";
86 CHANGE REPLICATION SOURCE to RELAY_LOG_FILE=FILE, RELAY_LOG_POS= POS;
87 ERROR HY000: Cannot clean up worker info tables. Additional error messages can be found in the MySQL error log.
88 set @@global.debug= "-d,mta_debug_reset_workers_fails";
89 set @@global.debug= "+d,mta_debug_recovery_reset_fails";
90 start slave sql_thread;
91 Warnings:
92 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
93 include/wait_for_slave_sql_error.inc [errno=13117]
94 set @@global.debug= @save.debug;
95 set @@global.replica_parallel_workers= 2;
96 include/start_slave.inc
97 include/stop_slave.inc
98 call mtr.add_suppression("Error creating applier metadata: Failed to initialize the worker info structure.");
99 set @@global.debug= "+d,mta_replica_worker_init_at_gaps_fails";
100 start slave sql_thread;
101 ERROR HY000: Could not initialize connection metadata structure; more error messages can be found in the MySQL error log
102 set @@global.debug= "-d,mta_replica_worker_init_at_gaps_fails";
103 set @@global.replica_parallel_workers= @save.replica_parallel_workers;
104 include/start_slave.inc
105 include/rpl_reset.inc
106 include/rpl_end.inc