1call mtr.add_suppression("Found 50 prepared XA transactions");
2create table t1 (a int) engine=innodb;
3insert into t1 values(1);
4connect  con$trial, localhost, root,,;
5xa start 'test50';
6insert into t1 values(1);
7xa end 'test50';
8xa prepare 'test50';
9connect  con$trial, localhost, root,,;
10xa start 'test49';
11insert into t1 values(1);
12xa end 'test49';
13xa prepare 'test49';
14connect  con$trial, localhost, root,,;
15xa start 'test48';
16insert into t1 values(1);
17xa end 'test48';
18xa prepare 'test48';
19connect  con$trial, localhost, root,,;
20xa start 'test47';
21insert into t1 values(1);
22xa end 'test47';
23xa prepare 'test47';
24connect  con$trial, localhost, root,,;
25xa start 'test46';
26insert into t1 values(1);
27xa end 'test46';
28xa prepare 'test46';
29connect  con$trial, localhost, root,,;
30xa start 'test45';
31insert into t1 values(1);
32xa end 'test45';
33xa prepare 'test45';
34connect  con$trial, localhost, root,,;
35xa start 'test44';
36insert into t1 values(1);
37xa end 'test44';
38xa prepare 'test44';
39connect  con$trial, localhost, root,,;
40xa start 'test43';
41insert into t1 values(1);
42xa end 'test43';
43xa prepare 'test43';
44connect  con$trial, localhost, root,,;
45xa start 'test42';
46insert into t1 values(1);
47xa end 'test42';
48xa prepare 'test42';
49connect  con$trial, localhost, root,,;
50xa start 'test41';
51insert into t1 values(1);
52xa end 'test41';
53xa prepare 'test41';
54connect  con$trial, localhost, root,,;
55xa start 'test40';
56insert into t1 values(1);
57xa end 'test40';
58xa prepare 'test40';
59connect  con$trial, localhost, root,,;
60xa start 'test39';
61insert into t1 values(1);
62xa end 'test39';
63xa prepare 'test39';
64connect  con$trial, localhost, root,,;
65xa start 'test38';
66insert into t1 values(1);
67xa end 'test38';
68xa prepare 'test38';
69connect  con$trial, localhost, root,,;
70xa start 'test37';
71insert into t1 values(1);
72xa end 'test37';
73xa prepare 'test37';
74connect  con$trial, localhost, root,,;
75xa start 'test36';
76insert into t1 values(1);
77xa end 'test36';
78xa prepare 'test36';
79connect  con$trial, localhost, root,,;
80xa start 'test35';
81insert into t1 values(1);
82xa end 'test35';
83xa prepare 'test35';
84connect  con$trial, localhost, root,,;
85xa start 'test34';
86insert into t1 values(1);
87xa end 'test34';
88xa prepare 'test34';
89connect  con$trial, localhost, root,,;
90xa start 'test33';
91insert into t1 values(1);
92xa end 'test33';
93xa prepare 'test33';
94connect  con$trial, localhost, root,,;
95xa start 'test32';
96insert into t1 values(1);
97xa end 'test32';
98xa prepare 'test32';
99connect  con$trial, localhost, root,,;
100xa start 'test31';
101insert into t1 values(1);
102xa end 'test31';
103xa prepare 'test31';
104connect  con$trial, localhost, root,,;
105xa start 'test30';
106insert into t1 values(1);
107xa end 'test30';
108xa prepare 'test30';
109connect  con$trial, localhost, root,,;
110xa start 'test29';
111insert into t1 values(1);
112xa end 'test29';
113xa prepare 'test29';
114connect  con$trial, localhost, root,,;
115xa start 'test28';
116insert into t1 values(1);
117xa end 'test28';
118xa prepare 'test28';
119connect  con$trial, localhost, root,,;
120xa start 'test27';
121insert into t1 values(1);
122xa end 'test27';
123xa prepare 'test27';
124connect  con$trial, localhost, root,,;
125xa start 'test26';
126insert into t1 values(1);
127xa end 'test26';
128xa prepare 'test26';
129connect  con$trial, localhost, root,,;
130xa start 'test25';
131insert into t1 values(1);
132xa end 'test25';
133xa prepare 'test25';
134connect  con$trial, localhost, root,,;
135xa start 'test24';
136insert into t1 values(1);
137xa end 'test24';
138xa prepare 'test24';
139connect  con$trial, localhost, root,,;
140xa start 'test23';
141insert into t1 values(1);
142xa end 'test23';
143xa prepare 'test23';
144connect  con$trial, localhost, root,,;
145xa start 'test22';
146insert into t1 values(1);
147xa end 'test22';
148xa prepare 'test22';
149connect  con$trial, localhost, root,,;
150xa start 'test21';
151insert into t1 values(1);
152xa end 'test21';
153xa prepare 'test21';
154connect  con$trial, localhost, root,,;
155xa start 'test20';
156insert into t1 values(1);
157xa end 'test20';
158xa prepare 'test20';
159connect  con$trial, localhost, root,,;
160xa start 'test19';
161insert into t1 values(1);
162xa end 'test19';
163xa prepare 'test19';
164connect  con$trial, localhost, root,,;
165xa start 'test18';
166insert into t1 values(1);
167xa end 'test18';
168xa prepare 'test18';
169connect  con$trial, localhost, root,,;
170xa start 'test17';
171insert into t1 values(1);
172xa end 'test17';
173xa prepare 'test17';
174connect  con$trial, localhost, root,,;
175xa start 'test16';
176insert into t1 values(1);
177xa end 'test16';
178xa prepare 'test16';
179connect  con$trial, localhost, root,,;
180xa start 'test15';
181insert into t1 values(1);
182xa end 'test15';
183xa prepare 'test15';
184connect  con$trial, localhost, root,,;
185xa start 'test14';
186insert into t1 values(1);
187xa end 'test14';
188xa prepare 'test14';
189connect  con$trial, localhost, root,,;
190xa start 'test13';
191insert into t1 values(1);
192xa end 'test13';
193xa prepare 'test13';
194connect  con$trial, localhost, root,,;
195xa start 'test12';
196insert into t1 values(1);
197xa end 'test12';
198xa prepare 'test12';
199connect  con$trial, localhost, root,,;
200xa start 'test11';
201insert into t1 values(1);
202xa end 'test11';
203xa prepare 'test11';
204connect  con$trial, localhost, root,,;
205xa start 'test10';
206insert into t1 values(1);
207xa end 'test10';
208xa prepare 'test10';
209connect  con$trial, localhost, root,,;
210xa start 'test9';
211insert into t1 values(1);
212xa end 'test9';
213xa prepare 'test9';
214connect  con$trial, localhost, root,,;
215xa start 'test8';
216insert into t1 values(1);
217xa end 'test8';
218xa prepare 'test8';
219connect  con$trial, localhost, root,,;
220xa start 'test7';
221insert into t1 values(1);
222xa end 'test7';
223xa prepare 'test7';
224connect  con$trial, localhost, root,,;
225xa start 'test6';
226insert into t1 values(1);
227xa end 'test6';
228xa prepare 'test6';
229connect  con$trial, localhost, root,,;
230xa start 'test5';
231insert into t1 values(1);
232xa end 'test5';
233xa prepare 'test5';
234connect  con$trial, localhost, root,,;
235xa start 'test4';
236insert into t1 values(1);
237xa end 'test4';
238xa prepare 'test4';
239connect  con$trial, localhost, root,,;
240xa start 'test3';
241insert into t1 values(1);
242xa end 'test3';
243xa prepare 'test3';
244connect  con$trial, localhost, root,,;
245xa start 'test2';
246insert into t1 values(1);
247xa end 'test2';
248xa prepare 'test2';
249connect  con$trial, localhost, root,,;
250xa start 'test1';
251insert into t1 values(1);
252xa end 'test1';
253xa prepare 'test1';
254connection default;
255FLUSH TABLES;
256xa recover;
257formatID	gtrid_length	bqual_length	data
2581	5	0	test1
2591	5	0	test2
2601	5	0	test3
2611	5	0	test4
2621	5	0	test5
2631	5	0	test6
2641	5	0	test7
2651	5	0	test8
2661	5	0	test9
2671	6	0	test10
2681	6	0	test11
2691	6	0	test12
2701	6	0	test13
2711	6	0	test14
2721	6	0	test15
2731	6	0	test16
2741	6	0	test17
2751	6	0	test18
2761	6	0	test19
2771	6	0	test20
2781	6	0	test21
2791	6	0	test22
2801	6	0	test23
2811	6	0	test24
2821	6	0	test25
2831	6	0	test26
2841	6	0	test27
2851	6	0	test28
2861	6	0	test29
2871	6	0	test30
2881	6	0	test31
2891	6	0	test32
2901	6	0	test33
2911	6	0	test34
2921	6	0	test35
2931	6	0	test36
2941	6	0	test37
2951	6	0	test38
2961	6	0	test39
2971	6	0	test40
2981	6	0	test41
2991	6	0	test42
3001	6	0	test43
3011	6	0	test44
3021	6	0	test45
3031	6	0	test46
3041	6	0	test47
3051	6	0	test48
3061	6	0	test49
3071	6	0	test50
308xa recover;
309formatID	gtrid_length	bqual_length	data
3101	5	0	test1
3111	5	0	test2
3121	5	0	test3
3131	5	0	test4
3141	5	0	test5
3151	5	0	test6
3161	5	0	test7
3171	5	0	test8
3181	5	0	test9
3191	6	0	test10
3201	6	0	test11
3211	6	0	test12
3221	6	0	test13
3231	6	0	test14
3241	6	0	test15
3251	6	0	test16
3261	6	0	test17
3271	6	0	test18
3281	6	0	test19
3291	6	0	test20
3301	6	0	test21
3311	6	0	test22
3321	6	0	test23
3331	6	0	test24
3341	6	0	test25
3351	6	0	test26
3361	6	0	test27
3371	6	0	test28
3381	6	0	test29
3391	6	0	test30
3401	6	0	test31
3411	6	0	test32
3421	6	0	test33
3431	6	0	test34
3441	6	0	test35
3451	6	0	test36
3461	6	0	test37
3471	6	0	test38
3481	6	0	test39
3491	6	0	test40
3501	6	0	test41
3511	6	0	test42
3521	6	0	test43
3531	6	0	test44
3541	6	0	test45
3551	6	0	test46
3561	6	0	test47
3571	6	0	test48
3581	6	0	test49
3591	6	0	test50
360xa recover;
361formatID	gtrid_length	bqual_length	data
362drop table t1;
363