Spider XA Failures | ERROR 1440 (XAE08): XAER_DUPID: The XID already exists | Got error 1440 when reading table on SELECT after XA START | mysql_ha_read: Got error 1440

INSTALL PLUGIN Spider SONAME 'ha_spider.so';

CREATE USER Spider@localhost IDENTIFIED BY 'PWD1';

CREATE SERVER srv FOREIGN DATA WRAPPER MYSQL OPTIONS (SOCKET '../socket.sock',DATABASE 'test',user 'Spider',PASSWORD 'PWD1');

CREATE TABLE t (c INT);

CREATE TABLE t1 (f INT,f2 DATE,f3 DATE,KEY(f,f3,f2)) ENGINE=Spider COMMENT='WRAPPER "mysql",srv "srv",TABLE "t"';

XA START 'xid1';

SELECT COUNT(*)=1 FROM t1;

10.11.0-opt>SELECT COUNT(*)=1 FROM t1;

ERROR 1440 (XAE08): XAER_DUPID: The XID already exists

2022-09-03 10:02:13 4 [ERROR] Got error 1440 when reading table './test/t1'

SELECT COUNT(*)=1 FROM t1;