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

sysschema.pr_ps_setup_show_enabled fails sporadically

    XMLWordPrintable

Details

    • Not for Release Notes

    Description

      Test failure:

      CURRENT_TEST: sysschema.pr_ps_setup_show_enabled
      --- 10.11/mysql-test/suite/sysschema/r/pr_ps_setup_show_enabled.result  2025-05-26 17:37:27.462974377 +0400
      +++ 10.11/mysql-test/suite/sysschema/r/pr_ps_setup_show_enabled.reject  2026-01-10 01:32:02.032189943 +0400
      @@ -207,6 +207,15 @@
       innodb/page_cleaner_thread     BACKGROUND
       mysys/statement_timer  BACKGROUND
       root@localhost FOREGROUND
      +root@localhost FOREGROUND
      +root@localhost FOREGROUND
      +root@localhost FOREGROUND
      +root@localhost FOREGROUND
      +root@localhost FOREGROUND
      +root@localhost FOREGROUND
      +root@localhost FOREGROUND
      +root@localhost FOREGROUND
      +root@localhost FOREGROUND
       sql/main       BACKGROUND
       sql/manager    BACKGROUND
       CALL sys.ps_setup_show_enabled(TRUE, TRUE);
      @@ -238,6 +247,15 @@
       innodb/page_cleaner_thread     BACKGROUND
       mysys/statement_timer  BACKGROUND
       root@localhost FOREGROUND
      +root@localhost FOREGROUND
      +root@localhost FOREGROUND
      +root@localhost FOREGROUND
      +root@localhost FOREGROUND
      +root@localhost FOREGROUND
      +root@localhost FOREGROUND
      +root@localhost FOREGROUND
      +root@localhost FOREGROUND
      +root@localhost FOREGROUND
       sql/main       BACKGROUND
       sql/manager    BACKGROUND
       enabled_instruments    timed
      

      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

              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.