Debian Codegraph @

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

raw
1 reset master;
2 Disconnect mysqld from all datanodes
3 Wait for binlog rotate to indicate disconnect
4 Wait to get out of read-only mode
5
6 Check that the binlog was rotated:
7 There should be a 'LOST EVENT', then 'Rotate ... binlog.000002'
8 include/show_binlog_events.inc
9 Log_name Pos Event_type Server_id End_log_pos Info
10 binlog.000001 # Incident # # #1 (LOST_EVENTS)
11 binlog.000001 # Rotate # # binlog.000002;pos=POS
12
13 Testing for Bug#22204186: Stuck in Readonly if slow failure handling
14 ====================================================================
15 reset master;
16 Disconnect mysqld from all datanodes
17 Wait for binlog rotate to indicate disconnect
18 Wait to get out of read-only mode
19
20 Check that the binlog was rotated:
21 There should be a 'LOST EVENT', then 'Rotate ... binlog.000002'
22 include/show_binlog_events.inc
23 Log_name Pos Event_type Server_id End_log_pos Info
24 binlog.000001 # Incident # # #1 (LOST_EVENTS)
25 binlog.000001 # Rotate # # binlog.000002;pos=POS
26
27 Testcase1 for Bug#22494024 Slow binlog-setup -> MDL deadlock (Meta Data Lock)
28 ndb_binlog_setup() fails to fully complete and does not clean up
29 its partial setup binlog subscriptions on exit
30 =============================================================================
31 Prepare mysqld 'server2' to not entirely complete binlog_setup
32 Disconnect both mysqld servers from all datanodes -> binlog restarts
33 Wait for 'server1' binlog rotate to indicate disconnect
34 Wait for 'server2' binlog rotate to indicate disconnect
35 Wait for 'server1' to complete setup and get out of read-only mode
36 Give 'server2' some time to start, and fail, a binlog_setup
37 Create table operation on 'server1' grab MDL lock while waiting for
38 schema change distribution to all subscribing mysqld.
39 create table t1 (a int primary key) engine=ndb;
40 drop table t1;
41 Wait for 'server2' to complete setup and get out of read-only mode
42
43 Testcase2 for Bug#22494024 Slow binlog-setup -> MDL deadlock (Meta Data Lock)
44 Table 'ndb_schema' is accessed from a SQL query. Causing it to be opened
45 and a SUBSCRIBE-event sent to other mysqld.
46 =============================================================================
47 Prepare mysqld 'server2' to do slow binlog_setup upon restart
48 Disconnect both mysqld servers from all datanodes -> binlog restarts
49 Wait for 'server1' binlog rotate to indicate disconnect
50 Wait for 'server2' binlog rotate to indicate disconnect
51 Wait for (fast) 'server1' to complete setup and get out of read-only mode
52 Create table operation on 'server1' grab MDL lock while waiting for
53 schema distribution to all subscribing mysqld -> stuck on 'server2'
54 create table t1 (a int primary key) engine=ndb;
55 drop table t1;
56 Wait for 'server2' to complete setup and get out of read-only mode