Debian Codegraph @

mysql-test/suite/rpl/r/rpl_terminology_use_previous_logs.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 #### Initialize ####
7 SET @save_log_output = @@global.log_output;
8 SET @@global.log_output = 'TABLE';
9 SET @save_long_query_time = @@global.long_query_time;
10 SET @@global.long_query_time = 1;
11 SET @save_terminology_use_previous = @@global.terminology_use_previous;
12 Warnings:
13 Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release.
14 #### Test terminology_use_previous = 0 ####
15 * Set option
16 SET @@global.terminology_use_previous = 0;
17 Warnings:
18 Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release.
19 SELECT @@global.terminology_use_previous;
20 @@global.terminology_use_previous
21 NONE
22 Warnings:
23 Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release.
24 * Clear log tables
25 TRUNCATE mysql.slow_log;
26 * Pause source during REGISTER REPLICA to make it go to slow log
27 [connection slave]
28 include/stop_slave_io.inc
29 # Adding debug point 'syncpoint_begin_register_replica' to @@GLOBAL.debug
30 START REPLICA IO_THREAD;
31 SET @@session.debug_sync = "now WAIT_FOR reached_begin_register_replica";
32 * Sleep 2 seconds
33 * Allow REGISTER REPLICA to finish
34 SET @@session.debug_sync = "now SIGNAL continue_begin_register_replica";
35 include/wait_for_slave_io_to_start.inc
36 * Verify the logs contain the correct term, and not the incorrect one
37 include/assert.inc [Slow log should contain "Register Replica"]
38 include/assert.inc [Slow log should not contain "no_Register Replica"]
39 #### Test terminology_use_previous = 1 ####
40 * Set option
41 SET @@global.terminology_use_previous = 1;
42 Warnings:
43 Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release.
44 SELECT @@global.terminology_use_previous;
45 @@global.terminology_use_previous
46 BEFORE_8_0_26
47 Warnings:
48 Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release.
49 * Clear log tables
50 TRUNCATE mysql.slow_log;
51 * Pause source during REGISTER REPLICA to make it go to slow log
52 [connection slave]
53 include/stop_slave_io.inc
54 # Adding debug point 'syncpoint_begin_register_replica' to @@GLOBAL.debug
55 START REPLICA IO_THREAD;
56 SET @@session.debug_sync = "now WAIT_FOR reached_begin_register_replica";
57 * Sleep 2 seconds
58 * Allow REGISTER REPLICA to finish
59 SET @@session.debug_sync = "now SIGNAL continue_begin_register_replica";
60 include/wait_for_slave_io_to_start.inc
61 * Verify the logs contain the correct term, and not the incorrect one
62 include/assert.inc [Slow log should contain "Register Slave"]
63 include/assert.inc [Slow log should not contain "no_Register Slave"]
64 #### Clean up ####
65 [connection master]
66 SET @@global.log_output = @save_log_output;
67 TRUNCATE TABLE mysql.general_log;
68 TRUNCATE TABLE mysql.slow_log;
69 SET @@global.long_query_time = @save_long_query_time;
70 SET @@global.terminology_use_previous = @save_terminology_use_previous;
71 Warnings:
72 Warning 1287 '@@terminology_use_previous' is deprecated and will be removed in a future release.
73 # Removing debug point 'syncpoint_begin_register_replica' from @@GLOBAL.debug
74 include/rpl_end.inc