--- xa_recovery.result 2013-01-22 22:05:05.246633000 +0400 +++ xa_recovery.reject 2013-01-23 03:22:43.247571090 +0400 @@ -1,3 +1,9 @@ +# -- WARNING ---------------------------------------------------------------- +# According to I_S.ENGINES, MRG_MYISAM does not support XA. +# If it is true, the test will most likely fail; you can +# either create an rdiff file, or add the test to disabled.def. +# If XA should be supported, check the data in Information Schema. +# --------------------------------------------------------------------------- call mtr.add_suppression("Found 2 prepared XA transactions"); FLUSH TABLES; DROP TABLE IF EXISTS t1; @@ -18,12 +24,18 @@ connection default; XA RECOVER; formatID gtrid_length bqual_length data -1 3 0 xa1 -1 3 0 xa2 XA ROLLBACK 'xa1'; +ERROR XAE04: XAER_NOTA: Unknown XID XA COMMIT 'xa2'; +ERROR XAE04: XAER_NOTA: Unknown XID SELECT a FROM t1; a +1 +2 3 4 +Warnings: +Error 145 Table './mrg/t1' is marked as crashed and should be repaired +Error 1194 Table 't1' is marked as crashed and should be repaired +Error 1034 1 client is using or hasn't closed the table properly DROP TABLE t1;