File: rpl_change_master_open_temp_tables.result

package info (click to toggle)
mysql-8.0 8.0.43-3
  • links: PTS, VCS
  • area: main
  • in suites: sid
  • size: 1,273,924 kB
  • sloc: cpp: 4,684,605; ansic: 412,450; pascal: 108,398; java: 83,641; perl: 30,221; cs: 27,067; sql: 26,594; sh: 24,181; python: 21,816; yacc: 17,169; php: 11,522; xml: 7,388; javascript: 7,076; makefile: 2,194; lex: 1,075; awk: 670; asm: 520; objc: 183; ruby: 97; lisp: 86
file content (65 lines) | stat: -rw-r--r-- 4,120 bytes parent folder | download
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
include/master-slave.inc
Warnings:
Note	####	Sending passwords in plain text without SSL/TLS is extremely insecure.
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.
[connection master]

# create a temporary table, replicate at slave for all the tests below.

CREATE TEMPORARY TABLE t1(a int);
include/sync_slave_sql_with_master.inc

# Make sure STOP SLAVE generates a warning.

STOP SLAVE;
Warnings:
Warning	1287	'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
Warning	3022	This operation may not be safe when the replica has temporary tables. The tables will be kept open until the server restarts or until the tables are deleted by any replicated DROP statement. Suggest to wait until replica_open_temp_tables = 0.
include/wait_for_slave_to_stop.inc

# Make sure STOP SLAVE SQL_THREAD generates a warning.

STOP SLAVE SQL_THREAD;
Warnings:
Warning	1287	'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
Note	3084	Replication thread(s) for channel '' are already stopped.
Warning	3022	This operation may not be safe when the replica has temporary tables. The tables will be kept open until the server restarts or until the tables are deleted by any replicated DROP statement. Suggest to wait until replica_open_temp_tables = 0.
include/wait_for_slave_sql_to_stop.inc

# Make sure STOP SLAVE IO_THREAD generates a warning.

STOP SLAVE IO_THREAD;
Warnings:
Warning	1287	'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
Note	3084	Replication thread(s) for channel '' are already stopped.
Warning	3022	This operation may not be safe when the replica has temporary tables. The tables will be kept open until the server restarts or until the tables are deleted by any replicated DROP statement. Suggest to wait until replica_open_temp_tables = 0.
include/wait_for_slave_io_to_stop.inc

# No warning here since we are changing a configuration parameter only.

CHANGE REPLICATION SOURCE TO SOURCE_HEARTBEAT_PERIOD= 10;

# Use of (master/relay)log_file/log_pos options should generate a warning.

CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= 0;
CHANGE REPLICATION SOURCE TO SOURCE_LOG_FILE= 'MASTER_LOG_FILE';
Warnings:
Warning	3022	This operation may not be safe when the replica has temporary tables. The tables will be kept open until the server restarts or until the tables are deleted by any replicated DROP statement. Suggest to wait until replica_open_temp_tables = 0.
Warning	3023	CHANGE REPLICATION SOURCE TO with a SOURCE_LOG_FILE clause but no SOURCE_LOG_POS clause may not be safe. The old position value may not be valid for the new binary log file.
CHANGE REPLICATION SOURCE TO SOURCE_LOG_POS= MASTER_LOG_POS;
Warnings:
Warning	3022	This operation may not be safe when the replica has temporary tables. The tables will be kept open until the server restarts or until the tables are deleted by any replicated DROP statement. Suggest to wait until replica_open_temp_tables = 0.
CHANGE REPLICATION SOURCE TO RELAY_LOG_FILE= 'RELAY_LOG_FILE';
Warnings:
Warning	3022	This operation may not be safe when the replica has temporary tables. The tables will be kept open until the server restarts or until the tables are deleted by any replicated DROP statement. Suggest to wait until replica_open_temp_tables = 0.
CHANGE REPLICATION SOURCE TO RELAY_LOG_POS= RELAY_LOG_POS;
SHOW WARNINGS;
Level	Code	Message
Warning	3022	This operation may not be safe when the replica has temporary tables. The tables will be kept open until the server restarts or until the tables are deleted by any replicated DROP statement. Suggest to wait until replica_open_temp_tables = 0.
CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= SAVE_AUTOPOSITION;

# cleanup

include/start_slave.inc
DROP TEMPORARY TABLE t1;
include/rpl_end.inc