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

main.grant_kill fails sporadically

    XMLWordPrintable

Details

    • Not for Release Notes

    Description

      Test failure flavours:

      CURRENT_TEST: main.grant_kill
      --- /home/buildbot/s390x-sles-1506/build/mysql-test/main/grant_kill.result	2025-09-04 15:12:55.000000000 +0000
      +++ /home/buildbot/s390x-sles-1506/build/mysql-test/main/grant_kill.reject	2025-09-06 07:39:32.195175558 +0000
      @@ -19,6 +19,7 @@
       bar
       foo
       root
      +root
       KILL ID;
       ERROR HY000: You are not owner of thread ID
       disconnect foo;
       
      Result length mismatch
      

      CURRENT_TEST: main.grant_kill
      --- /home/buildbot/amd64-debian-12/build/mysql-test/main/grant_kill.result	2025-10-29 18:10:26.000000000 +0000
      +++ /home/buildbot/amd64-debian-12/build/mysql-test/main/grant_kill.reject	2025-10-29 18:28:46.528294410 +0000
      @@ -38,6 +38,7 @@
       SELECT user FROM information_schema.processlist ORDER BY user;
       user
       bar
      +bar
       foo
       root
       KILL ID;
       
      Result length mismatch
      

      CURRENT_TEST: main.grant_kill
      --- /home/buildbot/amd64-centos-stream10/build/mysql-test/main/grant_kill.result	2025-10-21 01:27:14.000000000 +0000
      +++ /home/buildbot/amd64-centos-stream10/build/mysql-test/main/grant_kill.reject	2025-10-21 04:16:44.729303718 +0000
      @@ -39,6 +39,7 @@
       user
       bar
       foo
      +foo
       root
       KILL ID;
       connection default;
       
      Result length mismatch
      

      CURRENT_TEST: main.grant_kill
      --- /home/svoj/devel/maria/worktree/10.11/mysql-test/main/grant_kill.result	2025-05-26 17:37:26.390927707 +0400
      +++ /home/svoj/devel/maria/worktree/10.11/mysql-test/main/grant_kill.reject	2025-11-02 13:33:46.417482849 +0400
      @@ -19,6 +19,7 @@
       bar
       foo
       root
      +root
       KILL ID;
       ERROR HY000: You are not owner of thread ID
       disconnect foo;
      @@ -38,8 +39,11 @@
       SELECT user FROM information_schema.processlist ORDER BY user;
       user
       bar
      +bar
      +foo
       foo
       root
      +root
       KILL ID;
       connection default;
       disconnect foo;
      @@ -58,6 +62,7 @@
       SELECT user FROM information_schema.processlist ORDER BY user;
       user
       bar
      +bar
       foo
       root
       KILL ID;
       
      Result length mismatch
      

      Reliably reproducible with the following patch:

      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

              svoj Sergey Vojtovich
              svoj Sergey Vojtovich
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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