[MDEV-11769] main.xa failed in buildbot Created: 2017-01-11  Updated: 2022-09-08

Status: Open
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.0
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-7069 Fix buildbot failures in main server ... Stalled

 Description   

http://buildbot.askmonty.org/buildbot/builders/xenial-amd64-valgrind/builds/270/steps/test/logs/stdio

main.xa 'xtradb'                         w9 [ fail ]
        Test ended at 2017-01-06 12:26:43
 
CURRENT_TEST: main.xa
mysqltest: At line 367: query 'reap' 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 >
DROP TABLE t1;
#
# Bug#12352846 - TRANS_XA_START(THD*):
#                ASSERTION THD->TRANSACTION.XID_STATE.XID.IS_NULL()
#                FAILED 
#
DROP TABLE IF EXISTS t1, t2;
CREATE TABLE t1 (a INT) ENGINE=InnoDB;
CREATE TABLE t2 (a INT) ENGINE=InnoDB;
START TRANSACTION;
INSERT INTO t1 VALUES (1);
# Connection con2
XA START 'xid1';
# Sending:
INSERT INTO t2 SELECT a FROM t1;
# Connection default
# Waiting until INSERT ... is blocked
DELETE FROM t1;
# Connection con2
# Reaping: INSERT INTO t2 SELECT a FROM t1


Generated at Thu Feb 08 07:52:31 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.