tokudb_bugs.xa                           w1 [ fail ]

        Test ended at 2017-02-28 11:22:32

CURRENT_TEST: tokudb_bugs.xa

mysqltest: At line 228: query 'UPDATE t1 SET a=5 WHERE a=1' failed with wrong errno 1205: 'Lock wait timeout exceeded; try restarting transaction', instead of 1213...

The result from queries just before the failure was:

< snip >

xa end 'a';

xa prepare 'a';

xa commit 'a';

CREATE TABLE t1(a INT, KEY(a)) ENGINE=TokuDB;

INSERT INTO t1 VALUES(1),(2);

BEGIN;

UPDATE t1 SET a=3 WHERE a=1;

BEGIN;

UPDATE t1 SET a=4 WHERE a=2;

UPDATE t1 SET a=5 WHERE a=2;

UPDATE t1 SET a=5 WHERE a=1;

ERROR 40001: Deadlock found when trying to get lock; try restarting transaction

ROLLBACK;

ROLLBACK;

BEGIN;

UPDATE t1 SET a=3 WHERE a=1;

XA START 'xid1';

UPDATE t1 SET a=4 WHERE a=2;

UPDATE t1 SET a=5 WHERE a=2;

UPDATE t1 SET a=5 WHERE a=1;

More results from queries before failure can be found in /dev/shm/var/1/log/xa.log

 - saving '/dev/shm/var/1/log/tokudb_bugs.xa/' to '/dev/shm/var/log/tokudb_bugs.xa/'

Retrying test tokudb_bugs.xa, attempt(2/3)...