Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_async_conn_failover_reset_udf.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
7 ############################################################
8 # 1. Create a replication channel ch1 to replicate from
9 # server2 to server1.
10 [connection slave]
11 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_USER='root', SOURCE_AUTO_POSITION=1, SOURCE_PORT=SERVER_1_PORT, SOURCE_CONNECT_RETRY=1, SOURCE_RETRY_COUNT=1, SOURCE_CONNECTION_AUTO_FAILOVER=1 FOR CHANNEL 'ch1';
12 Warnings:
13 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
14 Note 1760 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.
15 include/start_slave.inc [FOR CHANNEL 'ch1']
16
17 ############################################################
18 # 2. Try to reset asynchronous reconnection configuration with
19 # invalid parameters.
20 # It will not be allowed.
21 SELECT asynchronous_connection_failover_reset(1);
22 ERROR HY000: Can't initialize function 'asynchronous_connection_failover_reset'; Wrong arguments: The function takes no arguments.
23 SELECT asynchronous_connection_failover_reset("");
24 ERROR HY000: Can't initialize function 'asynchronous_connection_failover_reset'; Wrong arguments: The function takes no arguments.
25
26 ############################################################
27 # 3. Try to reset asynchronous reconnection configuration while
28 # channels are running.
29 # It will not be allowed.
30 SELECT asynchronous_connection_failover_reset();
31 ERROR HY000: Can't initialize function 'asynchronous_connection_failover_reset'; Can't execute the given operation while Replication channels configured with SOURCE_CONNECTION_AUTO_FAILOVER are running.
32 include/stop_slave_sql.inc [FOR CHANNEL 'ch1']
33 include/assert.inc [Verify replica_monitor thread is running]
34 SELECT asynchronous_connection_failover_reset();
35 ERROR HY000: Can't initialize function 'asynchronous_connection_failover_reset'; Can't execute the given operation while Replication channels configured with SOURCE_CONNECTION_AUTO_FAILOVER are running.
36
37 ############################################################
38 # 4. Reset asynchronous reconnection configuration while
39 # channels are stopped.
40 # It will be allowed.
41 include/stop_slave_io.inc [FOR CHANNEL 'ch1']
42 include/assert.inc [Verify replica_monitor thread is not running]
43 SELECT asynchronous_connection_failover_reset();
44 asynchronous_connection_failover_reset()
45 The UDF asynchronous_connection_failover_reset() executed successfully.
46 SELECT asynchronous_connection_failover_add_source('ch1', '127.0.0.1', 3100);
47 asynchronous_connection_failover_add_source('ch1', '127.0.0.1', 3100)
48 The UDF asynchronous_connection_failover_add_source() executed successfully.
49 include/assert.inc ['There is one row in performance_schema.replication_asynchronous_connection_failover']
50 SELECT asynchronous_connection_failover_reset();
51 asynchronous_connection_failover_reset()
52 The UDF asynchronous_connection_failover_reset() executed successfully.
53 include/assert.inc ['There are 0 rows in performance_schema.replication_asynchronous_connection_failover']
54
55 ############################################################
56 # 5. Reset asynchronous reconnection configuration while
57 # channels are stopped for managed source.
58 # It will be allowed.
59 SELECT asynchronous_connection_failover_add_managed('ch1', 'GroupReplication', "UUID_VAL", '127.0.0.1', 3100, '', 80, 60);
60 asynchronous_connection_failover_add_managed('ch1', 'GroupReplication', "UUID_VAL", '127.0.0.1', 3100, '', 80, 60)
61 The UDF asynchronous_connection_failover_add_managed() executed successfully.
62 include/assert.inc ['There is one row in performance_schema.replication_asynchronous_connection_failover_managed']
63 include/assert.inc ['There is one row in performance_schema.replication_asynchronous_connection_failover']
64 SELECT asynchronous_connection_failover_reset();
65 asynchronous_connection_failover_reset()
66 The UDF asynchronous_connection_failover_reset() executed successfully.
67 include/assert.inc ['There are 0 rows in performance_schema.replication_asynchronous_connection_failover_managed']
68 include/assert.inc ['There are 0 rows in performance_schema.replication_asynchronous_connection_failover']
69
70 ############################################################
71 # 6. Clean up.
72 include/rpl_reset_slave.inc
73 include/rpl_end.inc
74 Warnings:
75 Note 3084 Replication thread(s) for channel '' are already stopped.