main.xa - drop table failed: ER_LOCK_WAIT_TIMEOUT

CURRENT_TEST: main.xa

mysqltest: At line 133: query 'drop table t1' failed: ER_LOCK_WAIT_TIMEOUT (1205): Lock wait timeout exceeded; try restarting transaction

The result from queries just before the failure was:

< snip >

xa end 'tr1#$', 'bq';

xa prepare 'tr1#$', 'bq';

xa recover format='SQL';

formatID	gtrid_length	bqual_length	data

1	5	2	X'7472312324',X'6271'

xa rollback 'tr1#$', 'bq';

xa start 'tr1#$', 'bq', 3;

insert t1 values (40);

xa end 'tr1#$', 'bq', 3;

xa prepare 'tr1#$', 'bq', 3;

xa recover format='RAW';

formatID	gtrid_length	bqual_length	data

3	5	2	tr1#$bq

xa recover format='PLAIN';

ERROR HY000: Unknown XA RECOVER format name: 'PLAIN'

xa recover format='SQL';

formatID	gtrid_length	bqual_length	data

3	5	2	X'7472312324',X'6271',3

xa rollback 'tr1#$', 'bq', 3;

drop table t1;

More results from queries before failure can be found in /home/buildbot/amd64-fedora-43/build/mysql-test/var/11/log/xa.log

       Test ended at 2026-04-05 03:04:48

CURRENT_TEST: main.xa

mysqltest: At line 826: query 'drop table t1,t2,t3' failed: ER_LOCK_WAIT_TIMEOUT (1205): Lock wait timeout exceeded; try restarting transaction

The result from queries just before the failure was:

< snip >

select * from t1 for update;

a

1

connect con2,localhost,root;

xa start 'c:baz';

update t2 set b=102;

update t1 set a=103;

connection default;

xa commit 'c:foo';

ERROR XAE09: XAER_OUTSIDE: Some work is done outside global transaction

select * from t2 for update;

Got one of the listed errors

xa commit 'c:foo';

ERROR XAE09: XAER_OUTSIDE: Some work is done outside global transaction

connection con2;

disconnect con2;

connection default;

xa rollback 'c:bar';

xa commit 'c:foo';

drop table t1,t2,t3;

More results from queries before failure can be found in /home/buildbot/ppc64le-ubuntu-2204/build/mysql-test/var/10/log/xa.log