Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Won't Fix
-
10.0(EOL), 10.1(EOL)
-
None
Description
http://buildbot.askmonty.org/buildbot/builders/kvm-deb-yakkety-amd64/builds/365
tokudb_bugs.xa w1 [ fail ]
|
Test ended at 2017-01-09 04:10:19
|
|
|
CURRENT_TEST: tokudb_bugs.xa
|
mysqltest: At line 204: 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 rollback 'a';
|
xa start 'a';
|
xa end 'a';
|
xa rollback 'a';
|
xa start 'a';
|
xa end 'a';
|
xa prepare 'a';
|
xa commit 'a';
|
xa start 'a';
|
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;
|
Happened two times on 10.1, both times on yakkety.
Attachments
Issue Links
- relates to
-
MDEV-7069 Fix buildbot failures in main server trees
-
- Stalled
-
Also on 10.0:
http://buildbot.askmonty.org/buildbot/builders/kvm-deb-yakkety-amd64/builds/594/steps/mtr/logs/stdio
tokudb_bugs.xa w1 [ fail ]Test ended at 2017-02-28 11:22:32CURRENT_TEST: tokudb_bugs.xamysqltest: 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 transactionROLLBACK;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)...