Debian Codegraph @

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

raw
1 Create table with multiple Blob columns
2 create table t1 (a int primary key,
3 b0 text,
4 b1 text,
5 b2 text,
6 b3 text,
7 b4 text,
8 b5 text,
9 b6 text,
10 b7 text,
11 b8 text,
12 b9 text)
13 engine=ndb comment='NDB_TABLE=NOLOGGING=1';
14 CREATE DEFINER=`root`@`localhost` PROCEDURE `load1`()
15 begin
16 set @x=1;
17 repeat
18 update test.t1 set b0=repeat('SMT0', 1000),
19 b1=repeat('BML1', 1000),
20 b2=repeat('TMS2', 1000),
21 b3=repeat('LMN3', 500),
22 b4=repeat('LME4', 600),
23 b5=repeat('SMN5', 713),
24 b6=repeat('LMB6', 300),
25 b7=repeat('SMC7', 555),
26 b8=repeat('SML8', 313),
27 b9=repeat('TMS9', 453);
28 set @x=row_count();
29 until @x = 0
30 end repeat;
31 end%
32 Starting Blob load on server 1
33 call load1();
34 Cause cluster disconnections of server2
35 call mtr.add_suppression("incident event has been written to the binary log");
36 Disconnecting server 2
37 Sending dump signal with data:
38 0x00000384 0x00000010
39 Sending dump signal with data:
40 0x00000384 0x00000010
41
42 Disconnecting server 2
43 Sending dump signal with data:
44 0x00000384 0x00000010
45 Sending dump signal with data:
46 0x00000384 0x00000010
47
48 Disconnecting server 2
49 Sending dump signal with data:
50 0x00000384 0x00000010
51 Sending dump signal with data:
52 0x00000384 0x00000010
53
54 Disconnecting server 2
55 Sending dump signal with data:
56 0x00000384 0x00000010
57 Sending dump signal with data:
58 0x00000384 0x00000010
59
60 Disconnecting server 2
61 Sending dump signal with data:
62 0x00000384 0x00000010
63 Sending dump signal with data:
64 0x00000384 0x00000010
65
66 Disconnecting server 2
67 Sending dump signal with data:
68 0x00000384 0x00000010
69 Sending dump signal with data:
70 0x00000384 0x00000010
71
72 Loops done
73 Clear table
74 Returing to server1
75 drop procedure load1;
76 drop table t1;