diff options
Diffstat (limited to '')
| -rw-r--r-- | storage/rocksdb/mysql-test/rocksdb_rpl/r/rpl_gtid_crash_safe_wal_corrupt.result | 140 |
1 files changed, 140 insertions, 0 deletions
diff --git a/storage/rocksdb/mysql-test/rocksdb_rpl/r/rpl_gtid_crash_safe_wal_corrupt.result b/storage/rocksdb/mysql-test/rocksdb_rpl/r/rpl_gtid_crash_safe_wal_corrupt.result new file mode 100644 index 00000000..e765e338 --- /dev/null +++ b/storage/rocksdb/mysql-test/rocksdb_rpl/r/rpl_gtid_crash_safe_wal_corrupt.result @@ -0,0 +1,140 @@ +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 master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. +[connection master] +drop table if exists x; +select @@binlog_format; +@@binlog_format +ROW +create table x (id int primary key, value int, value2 int, index(value)) engine=rocksdb; +insert into x values (1,1,1); +insert into x values (2,1,1); +insert into x values (3,1,1); +insert into x values (4,1,1); +insert into x values (5,1,1); +select @@global.gtid_executed; +@@global.gtid_executed +uuid:1-7 + +--- slave state before crash --- +select * from x; +id value value2 +1 1 1 +2 1 1 +3 1 1 +4 1 1 +5 1 1 +select @@global.gtid_executed; +@@global.gtid_executed +uuid:1-7 +select * from mysql.slave_gtid_info; +Id Database_name Last_gtid +1 test uuid:7 +include/rpl_start_server.inc [server_number=2] + +--- slave state after crash recovery, slave stop, one transaction recovered--- +select * from x; +id value value2 +1 1 1 +2 1 1 +3 1 1 +4 1 1 +select @@global.gtid_executed; +@@global.gtid_executed +uuid:1-6 +select * from mysql.slave_gtid_info; +Id Database_name Last_gtid +1 test uuid:6 + +--- slave state after restart, slave start --- +include/start_slave.inc +select * from x; +id value value2 +1 1 1 +2 1 1 +3 1 1 +4 1 1 +5 1 1 +select @@global.gtid_executed; +@@global.gtid_executed +uuid:1-7 +select * from mysql.slave_gtid_info; +Id Database_name Last_gtid +1 test uuid:7 +insert into x values (6,1,1); +select * from x; +id value value2 +1 1 1 +2 1 1 +3 1 1 +4 1 1 +5 1 1 +6 1 1 +select @@global.gtid_executed; +@@global.gtid_executed +uuid:1-8 +select * from mysql.slave_gtid_info; +Id Database_name Last_gtid +1 test uuid:8 +insert into x values (7,1,1); +insert into x values (8,1,1); +insert into x values (9,1,1); +insert into x values (10,1,1); +insert into x values (11,1,1); +insert into x values (12,1,1); +select * from x; +id value value2 +1 1 1 +2 1 1 +3 1 1 +4 1 1 +5 1 1 +6 1 1 +7 1 1 +8 1 1 +9 1 1 +10 1 1 +11 1 1 +12 1 1 +select @@global.gtid_executed; +@@global.gtid_executed +uuid:1-14 +include/rpl_start_server.inc [server_number=2] + +--- slave state after crash recovery, slave stop, WAL was corrupted, point in time recovery with wal_recovery_mode=2 --- +select * from x; +id value value2 +1 1 1 +2 1 1 +3 1 1 +4 1 1 +5 1 1 +6 1 1 +7 1 1 +8 1 1 +9 1 1 +include/start_slave.inc +select * from x; +id value value2 +1 1 1 +2 1 1 +3 1 1 +4 1 1 +5 1 1 +6 1 1 +7 1 1 +8 1 1 +9 1 1 +10 1 1 +11 1 1 +12 1 1 +select @@global.gtid_executed; +@@global.gtid_executed +uuid:1-14 +select * from mysql.slave_gtid_info; +Id Database_name Last_gtid +1 test uuid:14 +drop table x; +include/rpl_end.inc +Binlog Info Found |