| 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 |