Debian Codegraph @

mysql-test/suite/rpl/r/rpl_innodb_info_tbl_slave_tmp_tbl_mismatch.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 TEMPORARY TABLE TEMP1 (a int);
7 include/sync_slave_sql_with_master.inc
8
9 # Verify that the innodb table and slave_open_temp_table both indicate
10 # that there is an open temp table at slave.
11
12 include/assert.inc [Both INNODB_TEMP_TABLE_INFO and REPLICA_OPEN_TEMP_TABLES should show a temp table exists.]
13
14 # Verify that after STOP SLAVE the innodb table and slave_open_temp_table
15 # both indicate that there is an open temp table at slave.
16
17 include/stop_slave.inc
18 Warnings:
19 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.
20 include/assert.inc [Both INNODB_TEMP_TABLE_INFO and REPLICA_OPEN_TEMP_TABLES should show a temp table exists.]
21
22 # Verify that after CHANGE MASTER the innodb table and slave_open_temp_table
23 # both indicate that there is an open temp table at slave.
24
25 CHANGE REPLICATION SOURCE TO SOURCE_PORT= MASTER_PORT;
26 Warnings:
27 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.
28 include/assert.inc [Both INNODB_TEMP_TABLE_INFO and REPLICA_OPEN_TEMP_TABLES should show a temp table exists.]
29 include/start_slave.inc
30
31 # This is where the mismatch was found in the bug.
32 # Verify that the bug is fixed and hence we have equal values here.
33
34 include/assert.inc [count(*) from INNODB_TEMP_TABLE_INFO and REPLICA_OPEN_TEMP_TABLES should match.]
35 DROP TEMPORARY TABLE IF EXISTS TEMP1;
36 include/rpl_end.inc