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
|
#
# Bug#14516 Restart of cluster can cause NDB API replication failure
# Unreported bug: Online altered table causes system restart to fail
#
# Setup
create table t2 (a int key) engine=ndb;
# Rename table to later verify that the system restart did not fail
alter table t2 rename t1;
# System restart
reset master;
# Wait for 'server1' to complete setup and get out of read-only mode
# Wait for 'server2' to complete setup and get out of read-only mode
# Insert data into t1
insert into t1 values(1);
# Check that data went in ok
select * from t1;
a
1
# Verify that the replication API is working properly.
# The binlog should have the insert event.
include/show_binlog_events.inc
Log_name Pos Event_type Server_id End_log_pos Info
binlog.000001 # Incident # # #1 (LOST_EVENTS)
binlog.000001 # Rotate # # binlog.000002;pos=POS
PURGE MASTER LOGS TO 'binlog.000002';
include/show_binlog_events.inc
Log_name Pos Event_type Server_id End_log_pos Info
binlog.000002 # Query # # BEGIN
binlog.000002 # Table_map # # table_id: # (test.t1)
binlog.000002 # Table_map # # table_id: # (mysql.ndb_apply_status)
binlog.000002 # Write_rows # # table_id: #
binlog.000002 # Write_rows # # table_id: # flags: STMT_END_F
binlog.000002 # Query # # COMMIT
# Cleanup
drop table t1;
|
