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

perfschema.statement_digest_consumers2 fails sporadically

    XMLWordPrintable

Details

    • Not for Release Notes

    Description

      Test failure:

                            perfschema.statement_digest_consumers2   w4 [ fail ]
              Test ended at 2024-09-15 07:25:26
       
      CURRENT_TEST: perfschema.statement_digest_consumers2
      --- /home/buildbot/s390x-ubuntu-2004/build/mysql-test/suite/perfschema/r/statement_digest_consumers2.result	2024-09-15 06:43:14.000000000 +0000
      +++ /home/buildbot/s390x-ubuntu-2004/build/mysql-test/suite/perfschema/r/statement_digest_consumers2.reject	2024-09-15 07:25:25.946589103 +0000
      @@ -131,6 +131,7 @@
       SELECT digest, digest_text FROM performance_schema.events_statements_current;
       digest	digest_text
       NULL	NULL
      +NULL	NULL
       ####################################
       # CLEANUP
       ####################################
       
      Result length mismatch
       
       - saving '/home/buildbot/s390x-ubuntu-2004/build/mysql-test/var/4/log/perfschema.statement_digest_consumers2/' to '/home/buildbot/s390x-ubuntu-2004/build/mysql-test/var/log/perfschema.statement_digest_consumers2/'
       
      Retrying test perfschema.statement_digest_consumers2, attempt(2/3)...
      

      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()))
      
      

      The failure itself is infrequent, however if we ever decide to create "sleepy" builder, it will have to be fixed.

      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.