Debian Codegraph @

mysql-test/suite/ndb_binlog/r/ndb_binlog_discover.result

raw
1 #
2 # Bug#14516 Restart of cluster can cause NDB API replication failure
3 # Unreported bug: Online altered table causes system restart to fail
4 #
5 # Setup
6 create table t2 (a int key) engine=ndb;
7 # Rename table to later verify that the system restart did not fail
8 alter table t2 rename t1;
9 # System restart
10 reset master;
11 # Wait for 'server1' to complete setup and get out of read-only mode
12 # Wait for 'server2' to complete setup and get out of read-only mode
13 # Insert data into t1
14 insert into t1 values(1);
15 # Check that data went in ok
16 select * from t1;
17 a
18 1
19 # Verify that the replication API is working properly.
20 # The binlog should have the insert event.
21 include/show_binlog_events.inc
22 Log_name Pos Event_type Server_id End_log_pos Info
23 binlog.000001 # Incident # # #1 (LOST_EVENTS)
24 binlog.000001 # Rotate # # binlog.000002;pos=POS
25 PURGE MASTER LOGS TO 'binlog.000002';
26 include/show_binlog_events.inc
27 Log_name Pos Event_type Server_id End_log_pos Info
28 binlog.000002 # Query # # BEGIN
29 binlog.000002 # Table_map # # table_id: # (test.t1)
30 binlog.000002 # Table_map # # table_id: # (mysql.ndb_apply_status)
31 binlog.000002 # Write_rows # # table_id: #
32 binlog.000002 # Write_rows # # table_id: # flags: STMT_END_F
33 binlog.000002 # Query # # COMMIT
34 # Cleanup
35 drop table t1;