Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-34113

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

    XMLWordPrintable

Details

    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

          Activity

            People

              ycp Yuchen Pei
              ycp Yuchen Pei
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.