mirror of
https://github.com/MariaDB/server.git
synced 2025-11-07 14:26:16 +01:00
dd6f8d29c2
Affected binlog,main,rpl suites tests/results due to the empty XA's rollback optimization.
56 lines
1.5 KiB
Text
56 lines
1.5 KiB
Text
#
|
|
# MDEV-7793 - Race condition between XA COMMIT/ROLLBACK and disconnect
|
|
#
|
|
# Note that this test is meaningful only with valgrind.
|
|
connect con1, localhost, root;
|
|
connect con2, localhost, root;
|
|
connection con1;
|
|
XA START 'xatest';
|
|
XA END 'xatest';
|
|
XA PREPARE 'xatest';
|
|
Warnings:
|
|
Note 4226 Found to be read-only XA transaction is rolled back
|
|
connection con2;
|
|
SET debug_sync='xa_after_search SIGNAL parked WAIT_FOR go';
|
|
XA COMMIT 'xatest';
|
|
connection default;
|
|
SET debug_sync='now WAIT_FOR parked';
|
|
disconnect con1;
|
|
# Waiting for thread to get deleted
|
|
SET debug_sync='now SIGNAL go';
|
|
connection con2;
|
|
ERROR XAE04: XAER_NOTA: Unknown XID
|
|
*** Must not have 'xatest' in the list
|
|
XA RECOVER;
|
|
formatID gtrid_length bqual_length data
|
|
XA COMMIT 'xatest';
|
|
ERROR XAE04: XAER_NOTA: Unknown XID
|
|
disconnect con2;
|
|
connection default;
|
|
SET debug_sync='RESET';
|
|
connect con1, localhost, root;
|
|
connect con2, localhost, root;
|
|
connection con1;
|
|
XA START 'xatest';
|
|
XA END 'xatest';
|
|
XA PREPARE 'xatest';
|
|
Warnings:
|
|
Note 4226 Found to be read-only XA transaction is rolled back
|
|
connection con2;
|
|
SET debug_sync='xa_after_search SIGNAL parked WAIT_FOR go';
|
|
XA ROLLBACK 'xatest';
|
|
connection default;
|
|
SET debug_sync='now WAIT_FOR parked';
|
|
disconnect con1;
|
|
# Waiting for thread to get deleted
|
|
SET debug_sync='now SIGNAL go';
|
|
connection con2;
|
|
ERROR XAE04: XAER_NOTA: Unknown XID
|
|
*** Must not have 'xatest' in the list
|
|
XA RECOVER;
|
|
formatID gtrid_length bqual_length data
|
|
XA ROLLBACK 'xatest';
|
|
ERROR XAE04: XAER_NOTA: Unknown XID
|
|
disconnect con2;
|
|
connection default;
|
|
SET debug_sync='RESET';
|