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

main.xa fails sporadically

    XMLWordPrintable

Details

    • Bug
    • Status: In Review (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.11, 11.4, 12.1(EOL), 11.8
    • 10.11
    • Tests
    • None

    Description

      Test failures:

                           main.xa                                  w1 [ fail ]
              Test ended at 2025-11-24 10:19:39
       
      CURRENT_TEST: main.xa
      mysqltest: At line 733: query 'xa rollback '4'' failed with wrong errno ER_XAER_NOTA (1397): 'XAER_NOTA: Unknown XID', instead of ER_XA_RBROLLBACK (1402)...
      

                            main.xa                                  w14 [ fail ]
              Test ended at 2025-11-24 19:54:52
       
      CURRENT_TEST: main.xa
      mysqltest: At line 721: query 'xa commit '3'' failed with wrong errno ER_XAER_NOTA (1397): 'XAER_NOTA: Unknown XID', instead of ER_XA_RBROLLBACK (1402)...
      

                            main.xa                                  w19 [ fail ]
              Test ended at 2025-11-24 10:08:48
       
      CURRENT_TEST: main.xa
      mysqltest: At line 78: query 'xa rollback 'testb',0x2030405060,11' failed: ER_XAER_NOTA (1397): XAER_NOTA: Unknown XID
      

                            main.xa                                  w12 [ fail ]
              Test ended at 2025-11-17 21:26:02
       
      CURRENT_TEST: main.xa
      mysqltest: At line 833: query 'xa commit 'c:foo'' failed: ER_XAER_NOTA (1397): XAER_NOTA: Unknown XID
      
      

      Reproducible with:

      diff --git a/sql/sql_connect.cc b/sql/sql_connect.cc
      index c279f2663c8..c227fee943e 100644
      --- a/sql/sql_connect.cc
      +++ b/sql/sql_connect.cc
      @@ -1483,6 +1483,7 @@ void do_handle_one_connection(CONNECT *connect, bool put_in_cache)
           if (thd->userstat_running)
             update_global_user_stats(thd, create_user, time(NULL));
       
      +    sleep(1);
           unlink_thd(thd);
           if (IF_WSREP(thd->wsrep_applier, false) || !put_in_cache ||
               !(connect= thread_cache.park()))
      

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              svoj Sergey Vojtovich
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.