Debian Codegraph @

mysql-test/suite/rpl/r/rpl_crash_safe_master_myisam.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 include/stop_slave.inc
7 RESET MASTER;
8 call mtr.add_suppression("Attempting backtrace");
9 call mtr.add_suppression("allocated tablespace *., old maximum was 0");
10 call mtr.add_suppression("Error in Log_event::read_log_event()");
11 call mtr.add_suppression("Buffered warning: Performance schema disabled");
12 # Test case4: Set DEBUG POINT in the middle of binlog to
13 # make the master crash for non-transaction.
14 CREATE TABLE t2(a LONGBLOB) ENGINE=MYISAM;
15 INSERT INTO t2 (a) VALUES (REPEAT('a',16384));
16 ERROR HY000: Lost connection to MySQL server during query
17 # Restart the master server
18 # Test the halfly binlogged non-transaction statement will be trimmed
19 # from the crashed binlog file
20 include/show_binlog_events.inc
21 Log_name Pos Event_type Server_id End_log_pos Info
22 master-bin.000001 # Query # # use `test`; CREATE TABLE t2(a LONGBLOB) ENGINE=MYISAM
23 # Test the data will not be recovered successfully
24 # after the master restart.
25 SELECT COUNT(*) FROM t2;
26 COUNT(*)
27 0
28 DROP TABLE t2;
29 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= 0;