Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.1(EOL), 11.2(EOL), 11.4, 11.5(EOL), 11.6(EOL)
Description
Consider this case, placed under the spider/bugfix suite
--disable_query_log |
--disable_result_log |
--source ../../t/test_init.inc |
--enable_result_log |
--enable_query_log |
set spider_same_server_link= 1; |
evalp CREATE SERVER srv FOREIGN DATA WRAPPER mysql |
OPTIONS (SOCKET "$MASTER_1_MYSOCK", DATABASE 'test',user 'root'); |
CREATE TABLE t1(a int) ENGINE=Spider COMMENT='WRAPPER "mysql",srv "srv",TABLE "t"'; |
XA START 'xid2'; |
BINLOG ' O1ZVRw8BAAAAZgAAAGoAAAAAAAQANS4xLjIzLXJjLWRlYnVnLWxvZwAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAA7VlVHEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC '; |
BINLOG 'wlZOTxMBAAAAKgAAADwCAAAAACkAAAAAAAEABHRlc3QAAnQxAAIDAwAC wlZOTxcBAAAAJgAAAGICAAAAACkAAAAAAAEAAv/8AgAAAAgAAAA='; |
drop server srv; |
--disable_query_log |
--disable_result_log |
--source ../../t/test_deinit.inc |
--enable_result_log |
--enable_query_log |
|
leads to ERROR 1440 (XAE08): XAER_DUPID: The XID already exists
If we change Spider to INNODB then we get the following instead:
query 'drop server srv' failed: ER_XAER_RMFAIL (1399): XAER_RMFAIL: The command cannot be executed when global transaction is in the ACTIVE state
Attachments
Issue Links
- is caused by
-
MDEV-7487 Semi-join optimization for single-table update/delete statements
- Closed