[MDEV-22953] main.flush_read_lock failed in buildbot with XAER_NOTA: Unknown XID Created: 2020-06-19  Updated: 2021-08-12  Resolved: 2021-04-22

Status: Closed
Project: MariaDB Server
Component/s: Tests, XA
Affects Version/s: 10.5
Fix Version/s: 10.5.10

Type: Bug Priority: Blocker
Reporter: Elena Stepanova Assignee: Sachin Setiya (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2/builds/23282

10.5 e341fb0dae1008b98d6fc96f8847e6f1

main.flush_read_lock 'innodb'            w4 [ fail ]
        Test ended at 2020-06-19 08:30:54
 
CURRENT_TEST: main.flush_read_lock
mysqltest: At line 1724: query 'reap' failed: 1397: XAER_NOTA: Unknown XID
 
The result from queries just before the failure was:
< snip >
# Switching to connection 'default'.
connection default;
# Send XA ROLLBACK 'test1'
xa rollback 'test1';
# Switching to connection 'con1'.
connection con1;
# Wait until XA ROLLBACK is blocked.
Timeout in wait_condition.inc for select count(*) = 1 from information_schema.processlist
where state = "Waiting for backup lock" and
info = "xa rollback 'test1'"
Id	User	Host	db	Command	Time	State	Info	Progress
268	root	localhost	test	Sleep	30		NULL	0.000
269	root	localhost	test	Query	0	starting	show full processlist	0.000
270	root	localhost	test	Sleep	30		NULL	0.000
271	root	localhost	test	Sleep	33		NULL	0.000
unlock tables;
flush tables with read lock;
# Switching to connection 'default'.
connection default;
# Reap XA ROLLBACK



 Comments   
Comment by Michael Widenius [ 2021-03-25 ]

I made this a blocker as this causes problems for protected branches

Comment by Sachin Setiya (Inactive) [ 2021-04-01 ]

Hi Elkin

Patch link https://github.com/MariaDB/server/commit/0ff367a96b6a5b2662d3dcc52c70dc7702ec69c8

Comment by Andrei Elkin [ 2021-04-20 ]

The changes look good to approve. Thanks!

Generated at Thu Feb 08 09:18:44 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.